Seputar Personal Computer: 2011

Repair FileSystem

Permasalahan ini timbul pada saat ane curiga nih ama server koq backup otomatis nggak normal berhenti di tanggal tertentu trus nggak jalan lagi. ane cuba pake printah manual dump keluar pesan "Read-Only File System". bikin folder pake printah mkdir keluar pesan "Read-Only File System" setelah konsultasi ama master diminta restart, eh abiz restart nggak ngangkat. master bilang install ulang servernya. waduh... alamat makan waktu nih, ane tenang n akhirnya dapet juga petunjuk dari masternya para master yaitu mbah google. kata si mbah lihat dulu pesannya,...

Problem : repair filesystem

solusi dari si mbah :
1. masuk dulu sebagai root kalo emang dipassword
2. ketik "fsck.ext3 /dev/sda1 (tergantung partisinya).
3. reboot ,...

jreng...... server ON kembali.......

Automatis backup database di MySQL

Seru juga nih dapet tugas dari suhu master tuk bikin automatic backup database operasional. ok,... laksanakan dengan semboyan ikhlas dan ridho insya4JJ1 tuh akan jadi ilmu dan ane tuangin di blog sebagai wadahnya. karena ane masih cupu maka ane selalu ditemani prof google tuk berkelana dan hasilnya :
1. Download AutoMySQLBackup ada di sini source nya -->

root@pc-it:/opt# wget wget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5
--2011-08-15 13:05:34-- http://wget/
Resolving wget... failed: Name or service not known.
wget: unable to resolve host address `wget'
--2011-08-15 13:05:35-- http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5
Resolving downloads.sourceforge.net... 216.34.181.59
Connecting to downloads.sourceforge.net|216.34.181.59|:80... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: http://nchc.dl.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5 [following]
--2011-08-15 13:05:36-- http://nchc.dl.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5
Resolving nchc.dl.sourceforge.net... 211.79.60.17, 2001:e10:ffff:1f02::17
Connecting to nchc.dl.sourceforge.net|211.79.60.17|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 25316 (25K) [application/x-sh]
Saving to: `automysqlbackup.sh.2.5.1'

100%[=======================================================================================================================================>] 25,316 8.88K/s in 2.8s

2011-08-15 13:05:40 (8.88 KB/s) - `automysqlbackup.sh.2.5.1' saved [25316/25316]

FINISHED --2011-08-15 13:05:40--
Downloaded: 1 files, 25K in 2.8s (8.88 KB/s)

2. biar asyik bikin deh folder backup di var caranya :

$mkdir /var/backup;
$chmod -R 777 /var/backup

3. mulai deh hajar tuh script,... nih sedikit obok-obokannya :

# Username to access the MySQL server e.g. dbuser
USERNAME=[isi dengan user] ==> Saran Ane mendingan buat user sendiri buat backup
# Username to access the MySQL server e.g. password
PASSWORD=[isi dengan password] ==> Saran Ane mendingan buat password sendiri dengan user diatas
# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost ==> nah ini yang bikin puyeng karena ane rencana backup database di komputer server alias pake IP tapi dh ketemu sih tutorial menyusul
# List of DBNAMES for Daily/Weekly Backup e.g. “DB1 DB2 DB3″
DBNAMES=”[nama database]″
# Backup directory location e.g /backups
BACKUPDIR="/var/backup"
# Buat LOG FILEnya
echo “Log backup: $(date)” >> /var/backup/testing.log

4. selanjutnya jalanin deh perintah $ crontab -e ENTER kalo ada pilihan biasanya ane milih yang ada tulisan NANO itu maksudnya qt mau edit pake editor apaan.

5. isi deh dalam crontab :

3 3 * * * sh /home/[nama user]/automysqlbackup.sh.2.5

maksudnya tuh crontab akan jalanin file automysqlbackup.sh.2.5 di folder tersebut pada jam 3 lewat 3 menit di pagi hari setiap harinya. selesai....

semoga bermanfaat bagi ane dan para pembaca,.. AMIN

Perintah Linux

.....Semoga Bermanfaat bagi diriku dan yang membaca.....

$ top -d 2 = melihat proses shift+?
$ who = Show who is logged on
$ w = Show who is logged on and what they are doing
$ dmesg = print message system
$ cfdisk = tool tabel manipulator for linux
$ killall sshd = mengkill proses ssh
$ arp -ne = cek arp tabel
$ pstree = melihat proses secara pohon kebutuhan
$ lspci -v = cek hardware via konsole
$ lshw -C processor = cek hardware processor
$ sudo pmi action sleep = menjalankan fungsi sleep
$ sudo pmi action suspend = menjalankan fungsi suspend
$ dig 192.168.1.1 = dns lookup utility
$ cat /proc/net/arp = cek arp
$ sudo gedit /etc/fstab = file konfigurasi mount hardisk
$ scp test.log root@192.168.0.1 = transfer file via LAN ke home direktori
$ iwlist eth1 scanning = scanning access point
$ sudo ifconfig eth1 hw ether 0013022e91c7 = mengganti mac address
$ sudo apt-get -d source avant-window-navigator-bzr = download paket only, not install
$ sudo dpkg-reconfigure xserver-xorg = reconfigure ulang xserver
$ sudo /etc/init.d/gdm stop = mematikan service gdm stop
$ sudo iwconfig eth1 essid “pptik01″ = mendaftarkan name access point
$ sudo dhclient = auto dhcp
$ chown oniichan:oniichan /media/data = mengubah owner folder
$ sudo adduser nama_user nama_group = menambah user
$ usermod -G namagroup namauser = memasukkan user ke group
$ cat /etc/group = cek group user
$ smbclient -U% -L localhost = cek samba di local
$ cat /proc/version = cek version linux header
$ mtr www.google.com = gabungan ping dan traceroute
$ ls var/cache/apt/archives/ = data paket apt
$ ls /etc/rc2.d/ = list service
$ sudo update-rc.d -f rsync remove = meremove service rsync
$ sudo update-rc.d rsync defaults = mengadd service menjadi default service
$ ls -h = list human readeable
$ sudo apt-get install -f = fix dependency broken
$ cat /proc/acpi/acer/wireless = melihat penggunaan button
$ sudo tail -f /var/log/cups/error_log = melihat error pada service cups
$ lshal = melihat hal daemon usb
$ sudo hald = mengaktifkan hald daemon
$ sudo /etc/init.d/dbus start = service dbus daemon
$ nmap -sP 192.168.1.10-30 = checking ip up or not
$ watch lsusb = execute a program periodically
$ speaker-test 1.0.12 = test sound
$ wget http://www.google.com/0011001100.avi -O xxx_01.avi = download dan me-rename file
$ wget -c -t inf http://www.google.com/1100110011.avi = download dengan opsi continous, try infinite jika gagal
$ wget -i download.txt = download dengan opsi membaca url dari file download.txt
$ wget –limit-rate=10k = download dengan opsi bandwith hanya 10 kilobytes/s
$ displayconfig-gtk = screen and grafik configurations
$ md5sum LinuxMint-5-Fluxbox.iso > md5sums = creating md5sum dari file iso
$ md5sum -c md5sums = checking md5sum dengan file iso
$ aplay -l = playing file
$ lsb_release -a = cek ubuntu version
$ lpinfo -v = cek printer
$ id = Print user and group information for the specified USERNAME
$ ps ax | grep screenlets | awk ‘{print$1}’ | xargs kill -9 = kill spesifik berdasarkan nama proses
$ file nama_file = Determine file type of FILEs
$ for i in {1..10}; do echo $i; done = ngurut nomer
$ update-manager -d = Check if upgrading to the latest devel release is possible
$ cat /etc/passwd | grep 1000 | awk -F: ‘{ print $1 }’ = menampilkan user dengan UID 1000
$ find debian/ -iname ‘*’ -print0 | xargs -0 md5sum > md5sum = creating md5sum
$ espeak -s 80 “I love you” = text to speech
$ apt-cache policy ubuntu-desktop = print policy settings
$ sudo ip route replace default nexthop via 192.168.0.1 dev eth0 weight 3 nexthop 192.168.1.1 dev eth1 weight 2 = load balancing
$ sudo Xorg -configure :1 = print konfigurasi xorg.conf
$ for FILE in cd*.bin ; do bchunk $FILE ${FILE%.*}.cue ${FILE%.*} ; done = mengubah file bin menjadi cue
$ rm cd[1-5].@(bin|cue) = menghapus secara spesifik
$ ls -l | awk ‘{print $8}’ = print secara list index
$ split -b 200MB avatar.avi avatar.avi. = split file into separate file
$ cat avatar.avi.* > avatar.avi = merge into 1 file
$ sudo ifup eth0 = Stop a network interface
$ sudo ifdown eth0 = Start a network interface up
$ wc -ml /etc/apt/sources.list = Print byte, word, and line counts
$ history = Command History
$ netstat = Networking information
$ grep “license” readme.txt = mencari kata “license” dalam file readme.txt
$ df –h = disk free
$ du -h –max-depth=100 = estimate file usage
$ du /media/data/ –max-depth=1 -B M | sort –g = melihat penggunaan space pada folder
$ du -sh /media/data/ = melihat besaran (MB) folder
$ sudo fdisk -l = show partition table
$ free = melihat free RAM
$ cat /etc/fstab = static file system information
$ cat /proc/cpuinfo = info cpu
$ cat /proc/meminfo = info memory
$ cat /proc/partitions = info partition
$ cat /etc/rc.d/rc.s = startup
$ find / -name “namafile” = search nama file
$ find /media/data/ -name “Thumbs.db” -print0 | xargs -0 rm -vr = menghapus hasil pencarian
$ find /home/user -size +30M = mencari file dengan ukuran diatas 30M
$ alias lihat=’ls -l’ = memberikan alias perintah
$ cal 2010 = show calender
$ clear = clear the terminal screen
$ sudo shutdown -h now = menshutdown pc sekarang
$ sudo shutdown -h +2 = menshutdown pc
$ init 0 = halt
$ init 6 = reboot