{ Berbagi, Menulis, Dan Mengajar } Ilmu…

with 4 comments For all you Ubuntu/MySQL developers out there, have you ever seen the following? neo@thematrix:~$ sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [fail] * Starting MySQL database server mysqld [ OK ] /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' So, what is this “debian-sys-maint” user?  Well, this MySQL user is created for the Ubuntu to be able to start/stop the database and to carry out other maintenance operations. Sounds well enough, but then why do I keep running into the “access denied” problem for this user?  Well, the issue is that with each update to MySQL, the user’s password in the database is overwritten.  Ubuntu seems to go to the file /etc/mysql/debian.cnf in order to find this user’s password, but obviously … Read entire article »

History is a common command for shell to list out all the executed commands. It is very useful when it comes to investigation on what commands was executed that tear down the server. With the help of last command, you be able to track the login time of particular user as well as the the duration of the time he/she stays login. last ... mysurface tty7 :0 Mon Oct 6 20:07 - down (00:00) reboot system boot 2.6.24.4-64.fc8 Mon Oct 6 20:06 (00:00) mysurface pts/8 … Read entire article »

Laporan Harian kas bank isi dot php // QRY = Pengeluaran kambek penerimaan Line 182, 207 YLL $sisaJumlah = $inJmlYbl – $outJmlYbl ; //SDHI lihat dibawahnya … Read entire article »

You can use ‘\!’ instead of ‘system’. Should work in triggers and SPs. Example: CREATE TRIGGER tg1 BEFORE UPDATE ON alarms FOR EACH ROW BEGIN \! echo “I am message from a system call.”; END $$ — Hello, This is my example. It’s right! Please, use mysql shell on linux command line (On Windows throw an syntax error): DELIMITER $$ CREATE TRIGGER tg1 AFTER INSERT ON `your_table` FOR EACH ROW BEGIN \! echo “php algun_script_php.php” >> /log/yourlog.txt END $$ DELIMITER ; Please, check rigth permissions for write the file yourlog.txt. Regards! Marco  … Read entire article »

root@ide-makarya:~# cat /etc/wvdial.conf [Dialer internet] init1 = ATZ init2 = AT+CRM=1 Stupid Mode = 1 Phone = #777 SetVolume = 0 FlowControl = Hardware (CRTSTCS) Inhents = Modem0 Modem = /dev/ttyUSB0 Username = hxjf3mbc@free Password = telkom Dial Command = ATDT Baud = 460800 … Read entire article »

DDR 128mb PC2100 Samsung = Rp 28.000 DDR 256mb PC2100 = Rp 55.000 DDR 256mb PC2700 = Rp 60.000 DDR 256mb PC3200 = Rp 65.000 (Samsung, Hynix, mt) DDR 512mb PC2100 = Rp 130.000 DDR 512mb PC2700 = Rp 135.000 DDR 512mb PC3200 = Rp 140.000 (Samsung, nanya, Mt) DDR 256mb PC2100 Visipro = Rp 75.000 DDR 512mb PC3200 Visipro = Rp 170.000 *DDR 256/512mb Qty hrg Khusus.. HUb: 031-5914886 / 77812249 081 938 121 123 YM: s3_acc … Read entire article »

Not shown: 1668 closed ports PORT     STATE    SERVICE 22/tcp   open     ssh 53/tcp   open     domain 80/tcp   open     http 111/tcp  filtered rpcbind 113/tcp  filtered auth 139/tcp  filtered netbios-ssn 143/tcp  open     imap 826/tcp  filtered unknown 993/tcp  open     imaps 1723/tcp filtered pptp 2049/tcp filtered nfs 3306/tcp open     mysql … Read entire article »

1. Squid 2. nmap 3. mysql 4. snmpd 5. openssh-server 6. iftop 7. apache2 8. php5 9. mysql 10. Script Firewall … Read entire article »