tag:blogger.com,1999:blog-196350153979634712024-03-14T01:00:44.350+08:00Digital Life and Some OthersCars, Bikes, Computers, Gadgets!Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-19635015397963471.post-37591709928505763272010-04-13T12:19:00.004+08:002010-04-13T12:30:15.366+08:00Mysql - flush-hostsMy organization's mysql server always needed to execute mysqladmin -flush-hosts command (1 week interval). I don't want to do that everytime our web server could't contact its database server. So what am I to do? Well, I tried using cron but the mysql server need to be authenticate to run mysqladmin command. At last, I found one solution. EXPECT! How?<br /><br />Make sure you install expect in your mysql server (Centos Linux). Just issue command<br /><br /><span style="font-weight: bold;">yum install expect<br /><br /></span>Then, make a script file like this:<br /><br /><span style="font-weight: bold;">#!/usr/bin/expect</span><br /><span style="font-weight: bold;">set timeout 20</span><br /><span style="font-weight: bold;">spawn /usr/bin/mysqladmin -p flush-hosts</span><br /><br /><span style="font-weight: bold;">expect "Enter password: "</span><br /><span style="font-weight: bold;">send "yourmysqlrootpasswd\r\n"<br /><br /></span>save this script and add this script to run in cronjob.<br /><br />That's it. Done. You might want to chmod this script to 700 first. <span style="font-weight: bold;"><br /></span>Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com1tag:blogger.com,1999:blog-19635015397963471.post-17222893786477811672010-04-13T12:09:00.002+08:002010-04-13T12:16:20.313+08:00Zimbra - List all Members in Distribution ListSomebody asked me how to list all members in a distribution list and put it in a text file. Well, you can't do it in web interface of course, but you can do it using command line. Login as root to your zimbra server and issue this command<br /><br /><b>zmprov gdl youlist@yourdomain.com</b><span style="font-weight: bold;"> > yourtextfile.txt<br /><br /></span>simple isn't it. Transfer the text file you just created using any secure file transfer software (i.e winscp, filezilla). Then import it to your Excel using delimited to seperate email and non-email column, delete unused column and walllahhhhhhhh...Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com0tag:blogger.com,1999:blog-19635015397963471.post-38067367049979874862008-09-18T23:02:00.008+08:002008-09-18T23:14:16.556+08:00Macross Frontiers Again and BleachDah tengok Macross Frontiers sampai episode 23. Getting better and better.. arrrgghhh .. pe lambat sangat Lunar keluarkan episode 24 (bukan salah Lunar pun, dah cite tu tak tayang lagi kat TV, camna depa nak translate.)<br /><br />Bleach dah masuk episode 188. Still filler lagi.. Cite filler nie pasal Captain Amagai yang nak balas dendam sebab Yamamoto bunuh bapak dia dulu. Next episode habis la kot. Boleh sambung balik kisah Ichigo pi ke Hueco Mondo.. yeahhhhhhh...Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com2tag:blogger.com,1999:blog-19635015397963471.post-6878992489824093452008-09-18T23:02:00.003+08:002008-09-18T23:08:09.406+08:00Linux Command - lsArahan linux yang selalu diguna pakai ialah ls. ls nie kalau tanya man, ini dia jawab :<br /><br />ls - list directory contents<br /><br />so, kerja dia ialah menyenaraikan kandungan direktori. Opsyen juga boleh digunakan:<br /><br />ls -a -> senarai semua termasuk fail tersembunyi.<br />ls -l -> senarai file menggunakan format yang panjang.<br /><br />opsyen ini buleh digabungkan. Contoh:<br /><br />ls -al -> senarai semua fail menggunakan format yang panjang.Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com0tag:blogger.com,1999:blog-19635015397963471.post-58140487775753036142008-08-13T10:52:00.001+08:002008-08-13T10:54:07.740+08:00Uncle's DeathAL-FATIHAH to my uncle who passed away yesterday afternoon. I went back to Penang to show my last respect to him.Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com0tag:blogger.com,1999:blog-19635015397963471.post-79218797082324901592008-07-20T12:54:00.003+08:002008-07-20T13:04:59.230+08:00WISE KuLupa lak nak cerita, WISE merah kesayangan aku tu masuk bengkel. Memula aku hantar tu sebab ada leaking minyak hitam. Aku hantar kat Bengkel Loy kat Ulu Bernam. Sekali tokey dia, Tan call, cakap piston ring ada problem, minyak itam masuk ke kebuk pembakaran. Sebab tu minyak kereta aku 2 minggu je tahan. Dia tanya mau buat, aku pun ok la.. dah cuci semua, tukaq minyak itam semi sintetik, itu ini. Sekali bila dah siap, Tan call aku, dia cakap cost semua dalam rm1800. Pehhhh.. cam nak pengsan aa... tapi tak pengsan la. Dah ambik, bawak seminggu, ekzos lak bising. Pi tukaq la.. sekali berlubang la tabung ekzos aku tu, patutla bising. So jumlah keseluruhan ialah RM2160. Lepas tu, tayar pun dah botak 4-4. Untuk menjimatkan duit, aku tukaq la tayar Silverstone Evol8 (RM240 sebijik). Dulu aku pakai Bridgestone My01 (rm280 sebijik). Habis duit aku. Waaaaa..... Kalau aku jumpa resit baiki semua nie, aku list down apa aku tukaq.Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com2tag:blogger.com,1999:blog-19635015397963471.post-50152580308018452242008-07-20T12:51:00.002+08:002008-07-20T12:54:29.152+08:00Macross FrontiersWaaaaaaaaahhhh.. Best aa tgk anime Macross Frontiers. Although takdak kesinambungan karektor dari Robotech, anime nie memang best. Tapi baru ep 14 aa... tak habis lagi. Tak sure lak sampai berapa ep. Jgn jadi cam Bleach dah la.. dah ep 180.Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com0tag:blogger.com,1999:blog-19635015397963471.post-69702524516869446082008-07-19T13:21:00.004+08:002008-09-18T23:13:48.509+08:00RobotechJust finished watching old anime, Robotech Macross. Aku rasa first time tgk anime nie, masa darjah 4 atau 5 (1984 - 1985). Lukisan agak kasar. Ye la.. dulu mana ada CGI nak buat cecanggih kan. But i've watched all 36 episodes. Lupa dah jalan cite dia. Sebab tu cari tu cite nie. Rasa terkenang zaman bebudak dulu lak bila tgk cite nie. Sekali my officer kat opis pun minat Anime yg ada robot-robot nie. Some other Anime/Animation yg ada bertemakan robot nie ialah Gundam Series, Vanguard (never watch) dan satu lagi.. hmm.. sekali aku tak ingat la.. oh ye.. Gun X Sword. The best ialah Macross series la..Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com1tag:blogger.com,1999:blog-19635015397963471.post-62166419803057664542008-07-04T12:00:00.003+08:002008-07-04T12:06:14.933+08:0080's ToonsSembang ngan member, sekali dia bring up pasal cerita kartun yg kita tgk masa sekolah rendah dulu... Peh ... gamat opis dgn gelak bila teringat kartun lama nie... Remember these?<br /><br />1. Robotech Macros (aku tgh tgk nie.. ada 36 Episode kot... Mau?)<br />2. Spiral Zone<br />3. Saber Rider<br />4. Thunder.. Thunder.. ThunderCats<br />5. He Man<br />6. Bravestarr (betul ke ejaan nie?)<br />7. Thundar the Babarian<br />8. Toriton (err... ada sesapa ingat tak?)<br />9. Moby Dick<br />10. Voltron<br /><br />Top 10 kartun yg aku tgk masa kecik..Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com3tag:blogger.com,1999:blog-19635015397963471.post-75484801315601758292008-07-04T00:37:00.001+08:002008-07-04T00:47:49.603+08:00Komputerku KondemSetelah 5 tahun aku pakai comp aku, akhirnya dia pun mengalirkan elektrik terakhirnya. SALUTE! Bayangkan 5 tahun tu. Nie spec lama vs spec baru computer aku.<br /><br />Baru vs Lama<br />AMD Athlon 1.8Ghz <span style="color: rgb(255, 0, 0);">vs</span> Intel Core 2 Duo E4600 2.4Ghz<br />MSI MBB <span style="color: rgb(255, 0, 0);">vs</span> Gigabyte MBB<br />512Mb DDR Apacer <span style="color: rgb(255, 0, 0);">vs</span> 1Gb DDR2 Kingston (better buy another 1Gb huh!)<br />80Gb Maxtor HDD <span style="color: rgb(255, 0, 0);">vs</span> 320Gb Seagate HDD<br />Asus Nvidia FX5700 <span style="color: rgb(255, 0, 0);">vs</span> Saphire Ati HD 3450 (sorry nvidia.. those were the good old times)<br /><br />that's about it. Aku masih guna DVDRW Phillips yg aku baru beli tahun lepas and CoolerMaster Wave Casing yg aku beli dari member.Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com1tag:blogger.com,1999:blog-19635015397963471.post-67395940764490056852008-07-04T00:33:00.000+08:002008-07-04T00:37:12.748+08:00First PostWelll... aku pun secara tetiba teringin nak terjun ke bidang blog nie. My Wife pun dah buat blog utk resepi2 dia.. and I thought.. what about me? aku pun kena buat blog jugak ke? To blog or not to blog? Well.. at the very least, aku tak la ketinggalan keretapi dalam bidang blog nie..Zaimiehttp://www.blogger.com/profile/03870716882492260323noreply@blogger.com2