commad line history


poweroff
fdisk -l
/sbin/fdisk -l
exit
/sbin/fdisk -l
cat /proc/mdstat
cd /root/
cd /boot/
ls
cd grub/
ls
cat grub.conf
mdadm -A -R /dev/md2 /dev/sdb1
/sbin/mdadm -A -R /dev/md2 /dev/sdb1
cd /etc/
ls
cd ..
ls
pvdisplay
/sbin/pvdisplay
locate pvdsiplay
lvdisplay
locate pvdisplay
/usr/sbin/pvdisplay
/usr/sbin/lvdisplay
mysql -uroot -pdevel123
ssh pc@192.168.0.3
exit
chmod -R /home/
chmod -R 777 /home/
mysql -uroot -p
time mysql -uroot -pdevel123 pc < /home/pc_live_08112010.sql
time mysql -uroot -pdevel123 pc < /home/pc_live_08112010.sql
cd /
cd /etc/my.cnf
nano /etc/my.cnf
nano /etc/mysql
cd etc/
ls
cd ls -la
ls -la
nano /etc/my.cnf
cd /etc/my.cnfcd /
time mysql -uroot -pdevel123 pc < /home/pc_live_08112010.sql
nano /etc/my.cnf
cd /
cd /home/
ls
~
cd ~
ls
cd /
ls
cd home/

mysql -uroot -pdevel123
mysql -uroot -pdevel123 pc < /home/pc_module_02112010.sql
exit
svn update /var/data_share/PC/
exit
svn update /var/data_share/PC/
/usr/local/subversion/bin/svn update /var/data_share/PC/
exit
ls
pwd
mkdir master
mkdir master/backup
mkdir /var/data_share
ls
ls /var/data_share/
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.orig
yum install mysql
yum install mysql-server
/etc/init.d/mysqld start
/usr/bin/mysql_secure_installation
cd /var/lib/mysql/
cd mysql
cd ..
cd /root/master/
rm -r httpd-2.2.14
rm -rf httpd-2.2.14
rm -rf php-5.3.1
yum install libtool-ltdl-devel libjpeg-devel libpng-devel mysql-devel freetype-devel libmcrypt-devel
tar -zxvf httpd-2.2.14.tar.gz
cd httpd-2.2.14
./configure --prefix=/usr/local/apache --enable-so --enable-rewrite=shared --enable-dav --enable-dav-fs --enable-dav-lock
make
make install
cd ..
mv /etc/init.d/httpd /etc/init.d/httpd.orig
mv ./httpd /etc/init.d/
vi httpd.conf
mv /usr/local/apache/conf/httpd.conf /usr/local/apache/conf/httpd.conf.orig
mv httpd.conf /usr/local/apache/conf/
cp /usr/local/apache/conf/httpd.conf ./
cp /etc/init.d/httpd ./
ls
mv /usr/local/apache/conf/extra/httpd-vhosts.conf /usr/local/apache/conf/extra/httpd-vhosts.conf.orig
cp httpd-vhosts.conf /usr/local/apache/conf/extra/
vi httpd.conf
cp subversion.conf /usr/local/apache/conf/extra/
ls
mv /etc/my.cnf /etc/my.cnf.orig
cp my.cnf /etc/
tar -zxvf php-5.3.1.tar.gz
cd php-5.3.1
./configure --prefix=/usr/local/php --with-apxs2=/usr/local/apache/bin/apxs --enable-sigchild --with-config-file-path=/usr/local/php --with-mysql=/usr --with-mysqli=/usr/bin/mysql_config --with-libdir=/lib64 --with-gd --with-zlib --enable-soap --with-jpeg-dir=/usr/lib64 --with-freetype-dir=/usr/include/freetype2/freetype/ --enable-gd-native-ttf -enable-gd-imgstrttf --with-mcrypt
make
make install
cd ../
vi httpd.conf
ls
/etc/init.d/httpd stop
/etc/init.d/httpd start
vi httpd.conf
cp php.ini /usr/local/php/
/etc/init.d/httpd start
ls
vi subversion.conf
yum install subversion
locate mod_dav_svn.so
yum install mod_dav_svn
/etc/init.d/httpd start
locate mod_dav_svn.so
find / -print | grep mod_dav_svn.so
cp /usr/lib64/httpd/modules/mod_dav_svn.so /usr/local/apache/modules/
cp /usr/lib64/httpd/modules/mod_authz_svn.so /usr/local/apache/modules/
/etc/init.d/httpd start
ls
find / -print | grep subversion.conf
find / -print | grep subversion.conf
/etc/init.d/httpd start
yum install subversion-server
ls
ldd
find / -print | grep libsvn_fs_base-1.so
ls
cd svndump/
ls
cd ..
yum remove mod_dav_svn
yum remove subversion
yum remove subversion-server
wget http://subversion.tigris.org/downloads/subversion-1.6.13.tar.gz
wget http://subversion.tigris.org/downloads/subversion-deps-1.6.13.tar.gz
ls
vi subversion.conf
cp svnuser.pwd /usr/local/apache/conf/
cd /usr/local/apache/conf/
ls
cd ..
cd ./conf/extra/
ls
/etc/init.d/httpd start
yum install subversion-devel
yum install subversion
yum install mod_dav_svn
/etc/init.d/httpd start
yum install bdb
yum install subversion bdb
yum install subversion-bdb
yum install db
yum install berkeleydb
yum install db4
/etc/init.d/httpd start
yum remove db4
yum remove subversion
cd /root/master/
ls
tar -zxvf subversion-1.6.13.tar.gz
tar -zxvf subversion-deps-1.6.13.tar.gz
cd subversion-1.6.13
./configure --prefix=/usr/local/subversion --with-apr=/usr/local/apache --with-apr-util=/usr/local/apache --with-apxs2=/usr/local/apache/bin/apxs
./configure --prefix=/usr/local/subversion --with-apr=/usr/local/apache --with-apr-util=/usr/local/apache --with-apxs=/usr/local/apache/bin/apxs
find / -print | grep mod_dav_svn
make
find / -print | grep mod_dav_svn.so
find / -print | grep mod_dav_svn.so
ls /root/master/subversion-1.6.13/subversion/
find / -print | grep mod_authz_svn.so
find / -print | grep mod_dav_svn
find / -print | grep mod_dav_svn.so
find / -print | grep mod_authz_svn.so
cp /root/master/subversion-1.6.13/subversion/mod_dav_svn/.libs/mod_dav_svn.so /usr/local/apache/modules/
cp /root/master/subversion-1.6.13/subversion/mod_authz_svn/.libs/mod_authz_svn.so /usr/local/apache/modules/
make install
subversion
svn
/etc/init.d/httpd start
/etc/init.d/httpd stop
svn
/usr/local/subversion/bin/svn
cd
ls
cd master/
ls
/usr/local/subversion/bin/svnadmin dump /root/master/backup/svnrepo/utoko/ > /root/svnutoko.dump
ls
mkdir svndump/old
mv ./svndump/* ./svndump/old/
mv /root/svnutoko.dump ./svndump/utoko.dump
/usr/local/subversion/bin/svnadmin dump /root/master/backup/svnrepo/fbis/ > ./svndump/fbis.dump
/usr/local/subversion/bin/svnadmin dump /root/master/backup/svnrepo/kds > ./svndump/kds.dump
/usr/local/subversion/bin/svnadmin dump /root/master/backup/svnrepo/kds-fin > ./svndump/kds-fin.dump
/usr/local/subversion/bin/svnadmin dump /root/master/backup/svnrepo/kds-reg > ./svndump/kds-reg.dump
/usr/local/subversion/bin/svnadmin dump /root/master/backup/svnrepo/pc > ./svndump/pc.dump
mkdir /var/data_share/svnrepo
ls
/usr/local/subversion/bin/svnadmin create /var/data_share/utoko
/usr/local/subversion/bin/svnadmin load /var/data_share/utoko < ./svndump/utoko.dump
/etc/init.d/httpd restart
/etc/init.d/httpd restart
cd /var/data_share/
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/utoko < ./svndump/utoko.dump
cd /root/master/
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/utoko < ./svndump/utoko.dump
/usr/local/subversion/bin/svnadmin create /var/data_share/svnrepo/utoko
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/utoko < ./svndump/utoko.dump
find / -print | grep subversion.conf
vi /usr/local/apache/conf/extra/subversion.conf
vi /usr/local/apache/conf/extra/subversion.conf
/etc/init.d/httpd restart
/usr/local/subversion/bin/svnadmin create /var/data_share/svnrepo/pc
/usr/local/subversion/bin/svnadmin create /var/data_share/svnrepo/kds-reg
/usr/local/subversion/bin/svnadmin create /var/data_share/svnrepo/kds-fin
/usr/local/subversion/bin/svnadmin create /var/data_share/svnrepo/kds
/usr/local/subversion/bin/svnadmin create /var/data_share/svnrepo/fbis
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/pc < ./svndump/pc.dump
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/fbis < ./svndump/fbis.dump
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/kds < ./svndump/kds.dump
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/kds-fin < ./svndump/kds-fin.dump
/usr/local/subversion/bin/svnadmin load /var/data_share/svnrepo/kds-reg < ./svndump/kds-reg.dump
cd /var/data_share/
mkdir PC
ls
rm -rf ./utoko/
/usr/local/subversion/bin/svn co http://192.168.0.10/svn/pc/ /var/data_share/PC/
vi /var/data_share/PC/application/config/database.php
history | grep mysql
/usr/bin/mysql_secure_installation
ls
tar -zxvf redmine-1.0.0.tar.gz
chkconfig httpd on
chkconfig mysqld on
chown daemon.daemon /var/data_share/
cd /var/data_share/
ls
ls -al
ls -al svnrepo
chown -R daemon.daemon /var/data_share/svnrepo/pc/
chown -R daemon.daemon /var/data_share/svnrepo/
cd /root/master/
ls
ruby
yum install ruby
ruby
ruby
ls
cd backup/
ls
ls
ls -al /var/lib/mysql/
ls -al /var/lib/mysql/redmine/
cp -R /root/master/backup/redmine/* /var/lib/mysql/redmine/
cd /var/lib/mysql/
ls -al
cd redmine/
ls -al
chown mysql.mysql *
ls -al
ls -al ../mysql
ls -al
chmod 660 *
ls -al
cd /var/data_share/
ls
ls
cd redmine
ls
cd config/
ls
vi database.yml
ruby script/server webrick -e production
cd /var/data_share/redmine
ls
ruby script/server webrick -e production
ls -al /root/master/
gem
yum install ruygems
yum install rubygems
ruby /var/data_share/redmine/script/server webrick -e production
cd /root/master/
tar -zxvf rubygems-1.3.5.tgz
cd rubygems-1.3.5
ruby setup.rb
yum install -y ruby-devel ruby-docs ruby-ri ruby-irb ruby-rdoc
yum install ruby-gems
yum install rubygems
ruby /var/data_share/redmine/script/server webrick -e production
gem install rack -v=1.0.1
ruby /var/data_share/redmine/script/server webrick -e production &
gem install mysql
cd ..
wget http://www.tmtm.org/en/ruby/mysql/ruby-mysql-0.2.6.tar.gz
tar -zxvf ruby-mysql-0.2.6.tar.gz
cd ruby-mysql-0.2.6
ls
ruby ./setup.rb
ruby ./install.rb
ruby /var/data_share/redmine/script/server webrick -e production
mysql -uroot -pdevel123
ruby /var/data_share/redmine/script/server webrick -e production
mysql redmine -uroot -pdevel123
ruby /var/data_share/redmine/script/server webrick -e production
mysql -uroot -pdevel123
/etc/init.d/mysqld restart
mysql -uroot -pdevel123
cd /var/lib/mysql/
ls -al
cd redmine/
ls -al
chmod 760 *
mysql -uroot -pdevel123 redmine
mysql -uroot -pdevel123
mysql -uroot -pdevel123 redmine
pwd
ls -al
mysql -uroot -pdevel123 redmine
ls -al
cd /usr/local/apache/conf/
ls
cat svnuser.pwd
vi svnuser.pwd
htpasswd -m svnuser.pwd taufik
vi svnuser.pwd
htpasswd -m svnuser.pwd iwang
mysql
mysql -uroot -pCentos2010
echo $PATH
vi /etc/profile
svn
cd /var/data_share/PC/
ls
ls -al
vi .htaccess
ifconfig
/sbin/ifconfig
reboot
svn update /var/data_share/PC/
user/lo
user/
ls user/
user/ ls
/usr/local/svn update /var/data_share/PC/
/usr/local/subversion/bin/svn update /var/data_share/PC/
exit
svn update /var/data_share/PC/
svn update /var/data_share/PC/
/usr/local/subversion/bin/svn update /var/data_share/PC/
exit
svn
vi /etc/profile
/usr/local/subversion/bin/svn
cd /usr/sbin/
ls
ln -s svn /usr/local/subversion/bin/svn
ln -s /usr/local/subversion/bin/svn svn
cd /
svn
lvs
rm ./sbin/svn
cd sbin/
ls
ls -al svn *
pwd
cd/ /usr/sbin/
vi /etc/profile
cd /usr/sbin/
ls
lssvn
ls svn
ls -al svn
rm svn
cd /usr/bin/
ls
ln -s /usr/local/subversion/bin/svn svn
svn
cd /
svn
cd /usr/bin/
ln -s /usr/local/subversion/bin/svnadmin svnadmin
cd /var/lib/mysql/
ls
cd ..
ls
/etc/init.d/mysqld stop
mv mysql/ mysqlorig
ls -al
ls -al ./mysql
/etc/init.d/mysqld start
mysqldump redmine -uroot -pdevel123 > /root/master/backup/redmine.sql
ls -al /root/master/backup/
/etc/init.d/mysqld stop
mv mysql mysqlold
mv mysqlorig/ mysql
/etc/init.d/mysqld start
mysql redmine -uroot -pdevel123
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
mysql redmine -uroot -pdevel123
mysql redmine -uroot -pdevel123 < /root/master/backup/redmine.sql
mysql redmine -uroot -pdevel123
history | grep ruby
ruby /var/data_share/redmine/script/server webrick -e production
yum install mysql-client
yum install mysqlclient
/etc/init.d/mysqld stop
mv mysql mysqlorig
mv mysqlold/ mysql
/etc/init.d/mysqld start
ruby /var/data_share/redmine/script/server webrick -e production
ruby /var/data_share/redmine/script/server webrick -e production &
locate ruby
ls -al /usr/bin/r*
ls -al /usr/bin/rub*
vi /etc/rc.local
mysql -uroot -pdevel123
mysql -uroot -pdevel123 pc < /home/pc_module_02112010.sql
mysql -uroot -pdevel123 pc < /home/pc_module_02112010.sql
exit
history | grep svnadmin
vi /usr/local/php/php.ini
/etc/init.d/httpd restart
vi /root/.bash_history
/sbin/fdisk -l /dev/sdb
/sbin/mdadm --manage /dev/md2 --fail /dev/sdb1
/sbin/mdadm --manage /dev/md2 --remove /dev/sdb1
/sbin/partprobe
/sbin/mdadm --manage /dev/md2 --remove /dev/sdb1
/sbin/mdadm --stop /dev/md2
/sbin/mdadm --remove /dev/md2
cat /proc/mdstat
/sbin/partprobe
/sbin/sfdisk -d /dev/sda | /sbin/sfdisk /dev/sdb
cat /proc/mdstat
/sbin/fdisk -l /dev/sdb
/sbin/mdadm --manage /dev/md0 --add /dev/sdb1
/sbin/mdadm --manage /dev/md1 --add /dev/sdb2
yum install tomcat5
/sbin/chkconfig --level 2345 tomcat5 on
/usr/sbin/alternatives --config java
rpm -e --nodeps java-1.6.0-openjdk java-1.6.0-openjdk-devel
/usr/sbin/alternatives --config java
cd /root/
ls -la
cd master/
ls -la
cd java/
ls -la
./jdk-6u20-linux-x64-rpm.bin
/usr/sbin/alternatives --config java
cd /usr/src/redhat/
l s-la
ls -la
cd SOURCES/
ls -la
cd /root/master/java/
ls -la
rpm -ivh java-1.6.0-sun-compat-1.6.0.06-1jpp.src.rpm
cd /usr/src/redhat/SPECS/
ls -la
vi java-1.6.0-sun-compat.spec
rpmbuild -bb java-1.6.0-sun-compat.spec
vi java-1.6.0-sun-compat.spec
rpmbuild -bb java-1.6.0-sun-compat.spec
cd /usr/src/redhat/RPMS/x86_64/
ls -la
rpm -Uvh java-1.6.0-sun-compat-1.6.0.20-1jpp.x86_64.rpm
java -version
/usr/sbin/alternatives --config java
vi /etc/sysconfig/tomcat5
/etc/init.d/tomcat5 restart
cd /root/master/java/
ls -la
cp ./mysql-connector-java-5.1.12/mysql-connector-java-5.1.12-bin.jar /usr/share/java
cd /usr/share/java
ls -la
exit
cat /etc/rc.local
/usr/bin/ruby /var/data_share/redmine/script/server webrick -e production &
ps ax | grep ruby
kill -9 14351
ps ax | grep ruby
/usr/bin/ruby /var/data_share/redmine/script/server webrick -e production &
exit
ps ax | grep ruby
cd /var/data_share/redmine
ls -al
cd ..
ls -al
ps ax | grep ruby
kill -9 14416
/usr/bin/ruby /var/data_share/redmine/script/server webrick -e production
/usr/bin/ruby /var/data_share/redmine/script/server webrick -d -e production
vi /etc/rc.local
exit


Tips zimbra mencari email yg belum terbaca di Inbox

Ada user yang nanya mas gimana cara nyari 1 email yang belum terbaca di inbox ini ya....???
ehh setelah saya lihat email di Inbox ada 1732 dan yang unread cuma satu. Kalo di cari manual satu-satu perpage bisa gempor nihh..he he ...setelah googling nemu link ini

ternyata simple commandnya ketik di kotak search In:Inbox is:unread

Satu ilmu sederhana yang sangat bermanfaat

Thank my user
Thank forum zimbra
Thank my uncle Google

HD yg tidak ke detect karena Stabilizer .....aneh memangg

Kejadian itu saya alami 3 hari lalu yaitu sebuah pc user yang tidak ke detect HD nya setelah pindahan tempat tetapi BIOS normal menunjukan memory dan Processor yang sesuai. Masalah itu hingga menghabiskan 2 hari lebih sampai mendapatkan solved dari hal yang sangat remeh temeh.

Hal yang telah saya lakukan adalah :
1.Coba test dengan PC lain ternyata HD ke detect
2.HD lain di pasang di PC ini ternyata HD lain tidak ke detect juga
3.Coba memory, HD, PS, Processor ke CPU lain ga masalah semua normal akhirnya mengambil satu kesimpulan order Mainboard baru karena semua sudah di coba di mainboard lain dan bisa.
4.Setelah mainboard baru di pasang ehh..ternyata ga ke detect juga ahh...kesimpulan yang salah..
5.Setelah tambah mumet karena tidak nemu solusi akhirnya coba listrik langsung ke power tanpa pake stabilizer...dan ternyata ke detect ....aha...masalahnya ternyata di stabilizer...

satu pelajaran penting mungkin yang dapat saya ambil:
1.Urut satu demi satu semua pheriferal
2.Perhatikan alat/benda sekecil apapun yang nyambung ke cpu kita.


Tips menampilkan button Minimize dan maximize di openOffice yang Hilang

Beberapa hari yang lalu saya mendapatkan masalah yaitu tiba-tiba,entah mengapa, seketika itu juga, ujug-ujug button Minimize dan Maximize di openoffice 3.0 di ubuntu hardy user saya lenyap entah kemana.saya sudah mencoba beberapa jurus ternyata masih belum membuahkan hasil. Jurus-jurus itu antara lain:

1. Restart PC (ini mah ga sekolah juga bisa pak) he he...sapa tahu aja
2. Install ulang OpenOffice 3.0.1
3. Install ulang dengan OpenOffice 3.1.0
4. Install ulang dengan OpenOffice 3.2.0
5. Otak-atik menu View (barangkali ada yg nyuri buttonnya)

Setelah Mumet tapi gak sampai muntah-muntah he he (mang ngidam apa..) akhirnya baca link ini simple hanya mengubah folder user menjadi nama laini misal userold di directory /home/user/.openoffice/user setelah itu install lagi openofficenya kerena sebelumnya sudah saya remove terlebih dahulu. dan Alhamdulillah...button itu muncul kembali seperti sediakala....

Mount Partisi LVM di ubuntu karmic

Kemarin malam saya terpaksa buka puasa di kantor karena harus menginstall Server Development yang sudah di belikan 2 hard disk baru dengan kapasitas yang lebih besar. Server sebelumnya hanya menggunakan 1 hard disk 80 Gb (kecil banget yahh).Hard disk yang baru 250 Gb lumayan lahh.
Proses instalasi standar dengan RAID 1 dan LVM agar suatu saat bisa di Resize jika punya Hard disk lagi.
Sebenernya yang jadi masalah adalah ketika saya sudah selesai install dan akan mencopy data di server lama.Hard disk ketika saya mount ke ubuntu karmic kesayangan saya tidak serta merta bisa di mount.Nih error pertama kali yang saya dapatkan ketika mount hard disk tersebut
/mnt# mount /dev/sdb2 /mnt/devel/
mount: unknown filesystem type 'LVM2_member'

Setelah tanya mbah google ternyata File system LVM butuh perlakuan khusus di ubuntu :
1.Deteksi keberadaan Volume Group dengan mengetikan perintah berikut:
/mnt# pvscan
The program 'pvscan' is currently not installed. You can install it by typing:
apt-get install lvm2
pvscan: command not found
Jika ternyata muncul error seperti di atas maka install terlebih dahulu lvm2
2. /mnt# apt-get install lvm2
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
watershed
The following NEW packages will be installed:
lvm2 watershed
0 upgraded, 2 newly installed, 0 to remove and 8 not upgraded.
3. lalu scan Volume Group dengan perintah:
/mnt# pvscan
PV /dev/sdb2 VG VolGroup00 lvm2 [74.41 GB / 0 free]
Total: 1 [74.41 GB] / in use: 1 [74.41 GB] / in no VG: 0 [0 ]
Terlihat di situ LVM berada di VolGroup00.
4. Mount Partisi LVM ke tempat yang sudah di tentukan. Di tempat saya di letakan di /mnt/devel/
/mnt# mount /dev/VolGroup00/LogVol00 /mnt/devel/
mount: special device /dev/VolGroup00/LogVol00 does not exist
5. Jika muncul message seperti di atas berarti Volume belum aktif. Aktifkan dengan perintah
/mnt#sudo vgchange -ay
2 logical volume(s) in volume group "VolGroup00" now active
6. Lakukan perintah untuk mount mount seperti langkah 4.
/dev/mapper/VolGroup00-LogVol00 looks like swapspace - not mounted
mount: you must specify the filesystem type
jika muncul error seperti diatas maka mungkin kita salah mendeteksi LogVolnya lihat dengan perintah :
# lvdisplay
--- Logical volume ---
LV Name /dev/VolGroup00/LogVol01
VG Name VolGroup00
LV UUID uYMV2O-KpoN-RXGc-a0Bz-yRcJ-Q8eK-NCyWhn
LV Write Access read/write
LV Status available
# open 0
LV Size 70.41 GB
Current LE 2253
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 252:0

--- Logical volume ---
LV Name /dev/VolGroup00/LogVol00
VG Name VolGroup00
LV UUID JH25po-Jawk-RaGu-0six-j9HA-fBXV-pSRtka
LV Write Access read/write
LV Status available
# open 0
LV Size 4.00 GB
Current LE 128
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 252:1

7. Terlihat bahwa LogVolnya 01 bukan 00 sehingga mountnya menjadi :

# mount /dev/VolGroup00/LogVol01 /mnt/devel/

Jika tidak ada error maka partisi LVM sudah termount dan tinggal copy datanya saja.

Selamat mencoba semoga sukses...he he he...

Tips mysql menampilkan Nomor

Bagi anda yang menggunakan mysql tentunya sering di minta menampilkan data. Data-data yang di tampilkan banyak jumlahnya dah harus di cantumkan Nomor urutnya.Berikut trik kecil yang bisa di gunakan untuk menampilkan Nomor.

Contoh anda ingin menampilkan Nomor dan Nama dari table kelas:
SELECT @rownum:=@rownum+1 'No',name As Nama from tblkelas (SELECT @rownum:=0) Nomor where limit=100;

upgrade Open Office 2.4 ke 3.02 di ubuntu hardy

Sebenernya tulisan ini sudah banyak di posting dan terkesan basi. Cuma karena blog ini juga sebagai referensi pribadi maka ga da salahnya saya tulis lagi langkah-langkah ketika saya upgrade dari OO 2.4 ke OO 3.02. Kelebihan dari OO 3.02 adalah bisa membuka file docx yaitu format yang di miliki MS Office 2007. Berikut langkah-langkahnya;

1.Download OO terbaru di sini sesuai dengan type linux anda.
2.Hapus OO yang lama : sudo apt-get remove openoffice *.*
jika ada pertanyaan untuk menghapus open office sebelumnya seperti ini:
aspell aspell-en dictionaries-common gnome-spell iamerican ibritish ispell
language-support-en language-support-translations-en
language-support-writing-en myspell-en-gb myspell-en-us myspell-en-za
openoffice.org-base-core openoffice.org-calc openoffice.org-common
openoffice.org-core openoffice.org-draw openoffice.org-gnome
openoffice.org-gtk openoffice.org-help-en-gb openoffice.org-help-en-us
openoffice.org-hyphenation openoffice.org-hyphenation-en-us
openoffice.org-impress openoffice.org-l10n-common openoffice.org-l10n-en-gb
openoffice.org-l10n-en-za openoffice.org-style-human
openoffice.org-thesaurus-en-au openoffice.org-thesaurus-en-us
openoffice.org-writer python-uno thunderbird-locale-en-gb wamerican wbritish
0 upgraded, 0 newly installed, 36 to remove and 0 not upgraded.
After this operation, 352MB disk space will be freed.
Do you want to continue [Y/n]? y
3. Extrak souce OO 3.02 tar.gz
sudo tar -xzvf OOo_3.2.0_LinuxX86-64_install_en-US_deb.tar.gz
4. masuk ke directory DEBS di Open Office
cd /home/tiva/Desktop/OOO320_m12_native_packed-1_en-US.9483/DEBS/
5. Install file deb Open Officenya
sudo dpkg -i *.*
Selecting previously deselected package ooobasis3.2-base.
(Reading database ... 92535 files and directories currently installed.)
Unpacking ooobasis3.2-base (from ooobasis3.2-base_3.2.0-12_amd64.deb) ...
Selecting previously deselected package ooobasis3.2-binfilter.
Unpacking ooobasis3.2-binfilter (from ooobasis3.2-binfilter_3.2.0-12_amd64.deb) ...
Selecting previously deselected package ooobasis3.2-calc.
Unpacking ooobasis3.2-calc (from ooobasis3.2-calc_3.2.0-12_amd64.deb) ...
Selecting previously deselected package ooobasis3.2-core01.
Unpacking ooobasis3.2-core01 (from ooobasis3.2-core01_3.2.0-12_amd64.deb) ...
Selecting previously deselected package ooobasis3.2-core02.
Unpacking ooobasis3.2-core02 (from ooobasis3.2-core02_3.2.0-12_amd64.deb) ...
Selecting previously deselected package ooobasis3.2-core03.
Unpacking ooobasis3.2-core03 (from ooobasis3.2-core03_3.2.0-12_amd64.deb) ...

6. Tampilakn shorcut di menu dengan terlebih dulu masuk ke directory desktop integration.
cd desktop-integration/
sudo dpkg -i openoffice.org3.2-debian-menus_3.2-9472_all.deb
Selecting previously deselected package openoffice.org-debian-menus.
(Reading database ... 97142 files and directories currently installed.)
Unpacking openoffice.org-debian-menus (from openoffice.org3.2-debian-menus_3.2-9472_all.deb) ...
Setting up openoffice.org-debian-menus (3.2-9472) ...

Selamat mengupgrade Open Office anda.