Reseting wordpress admin password with adminer

Reseting wordpress admin password with adminer

Reseting wordpress admin password with adminer. So today i have been given a task to manage a wordpress-based website. unfortunately, the admin username and password is unkown. I have ftp access to the hosting server, and by reading the confing file, i know how to access the database (IP address, username, password). this article will be talking about reseting wordpress admin password with adminer. Why use adminer? because adminer is lightweight application. only one file, with less than 1MB size. compared to phpmyadmin, its a massive difference. (more…)...
Read More
Tuning apache MPM-event parameters to serve high traffic website

Tuning apache MPM-event parameters to serve high traffic website

Tuning apache MPM-event parameters. This article is about tuning apache MPM-event parameters to serve high traffic website. So today, we got an issue from users that are accessing our webserver. Some details: We host an e-learning application which has feature to do online quiz where all students accessing server simultaneously Total user that accessing web server simultaneously is around 400-500 the application is a web-based and users accessing it either from their laptop or mobile devices The application is using PHP language and we use apache as the web server. Apache module that we use here is mpm_event. (more…)...
Read More
Longest server uptime i ever seen… 820 days

Longest server uptime i ever seen… 820 days

Longest server uptime i ever seen. Ladies and gentlemen, may i introduce you the longest server uptime that is ever recorded by me, 820 days (around 2.2 years) and still counting. This screenshot was taken from one of Linux machine during my project here in Dakar, Senegal, West Africa. Well, it seems like the machine is never been rebooted since its installed for the first time. Here is the spec of the machine: Hardware: Sun Microsystem X86 CPU: several core (i forgot how many core it has, looks like more than 6 cores) RAM: 24GB ECC Harddisk: RAID 1 SCSI for OS and data NIC: multiple gigabit interfaces, configured with linux-bonding Software: OS: Linux SUSE enterprise 10 Main application: customised database software for telecommunication that is working with a cluster of 3 node. This server is one of the node. This database is the replacement of Oracle database on earlier version of the system. the database is not using the traditional relational database (like oracle...
Read More
konversi KVM image dari raw ke vmdk

konversi KVM image dari raw ke vmdk

konversi KVM image dari raw ke vmdk. Hari ini dilakukan migrasi mesin-mesin virtual dari mesin yang lama (menggunakan ubuntu + kvm + lxc) ke server baru yang menggunakan proxmox 2.2. Salah satu pekerjaan yang perlu dilakukan adalah convert image harddisk dari VM yang lama. proxmox sendiri mensupport 3 format image harddisk yaitu: raw, qcow2, dan vmdk. pilihan saya jatuh pada format vmdk. kenapa? karena format vmdk itu fleksible, punya fitur kompresi, dan ketika di copy ke tempat lain besarnya tidak berubah. (more…)...
Read More
troubleshoot: no console access on openvz container

troubleshoot: no console access on openvz container

Hari ini server virtualisasi yang baru telah selesai disetup. beberapa template openvz pun sudah didownload. sekarang kita bisa buat container openvz yang baru. Sayangnya, setelah setup container, start vm, kemudian klik tombol console, saya tidak dapat mengakses consolenya. ya, di console ada muncul output seperti normalnya komputer booting namun tidak ada prompt input username & password. Selidik punya selidik, ternyata ini dikarenakan template vm yang tidak mensupport ini, sehingga kita perlu masuk vm tersebut dari host OS kemudian mengubah beberapa file disana. jika guest OS menggunakan debian: masuk container: # vzctl enter 101 edit /etc/inittab. add line: 1:2345:respawn:/sbin/getty 38400 tty1 restart container jika guest OS menggunakan ubuntu 12.04: masuk container: # vzctl enter 101 edit /etc/init/tty1.conf. add line: # tty1 – getty # This service maintains a getty on tty1 from the point the system is # started until it is shut down again. start on stopped rc RUNLEVEL=[2345] stop on runlevel [!2345] respawn exec /sbin/getty -8 38400 tty1 restart container jika guest OS menggunakan centos 5: masuk container: # vzctl enter 101 edit /etc/inittab. add line: 1:2345:respawn:/sbin/agetty tty1 38400...
Read More
error after mysqlcheck optimize

error after mysqlcheck optimize

error after mysqlcheck. hari ini ada error yang aneh sekali dimana saya tidak dapat login ke aplikasi php saya yang berbasis mysql. Action maintenance terakhir yang dilakukan adalah menjalankan mysqlcheck untuk mengecek database mysql (menggunakan opsi –check) & melakukan optimasi (menggunakan –optimize) database yang ada disana. dari penggalian symptom, didapat bahwa aplikasi dapat connect ke database,  namun tidak dapat melakukan operasi update. pantesan websitenya bisa dibuka (operasi read), tapi ngak bisa login. karena operasi login akan menulis log ke database alias melakukan operasi update/insert. error after mysqlcheck investigasi dilanjutkan. ternyata penyebab error ini adalah database yang crash: warning : Table is marked as crashed and last repair failed warning : Size of datafile is: 845784 Should be: 802008 error : Record at: 3664 Can’t find key for index: 1 Got error: 144: Table ‘./dbtest/wp_commentmeta’ is marked as crashed and last (automatic?) repair failed when using LOCK TABLES dan error permission: [ERROR] bdb: /var/lib/mysql/mysqlXXX: Permission denied dbtest.wp_options optimize error 9 when updating keyfile dbtest.wp_options optimize Error Can’t change ownership of the file ‘/var/lib/mysql… dbtest.wp_options optimize...
Read More
Troubleshoot: slow squid, All redirector processes are busy

Troubleshoot: slow squid, All redirector processes are busy

Troubleshoot: slow squid. Suatu hari ketika troubleshooting jaringan di kantor, saya mendapat symptoms berikut: user merasa lambat ketika browsing saya mendapat warning pada cache.log squid: 2012/04/26 08:32:38| WARNING: All redirector processes are busy. 2012/04/26 08:32:38| WARNING: 5 pending requests queued 2012/04/26 08:37:37| WARNING: All redirector processes are busy. 2012/04/26 08:37:37| WARNING: 5 pending requests queued 2012/04/26 08:39:24| WARNING: All redirector processes are busy. 2012/04/26 08:39:24| WARNING: 5 pending requests queued 2012/04/26 08:48:50| WARNING: redirector #5 (FD 15) exited 2012/04/26 08:48:50| WARNING: redirector #1 (FD 7) exited 2012/04/26 08:48:50| WARNING: redirector #4 (FD 13) exited 2012/04/26 08:48:50| WARNING: redirector #2 (FD 9) exited 2012/04/26 08:48:50| WARNING: redirector #3 (FD 11) exited 2012/04/26 08:49:44| WARNING: All redirector processes are busy. 2012/04/26 08:49:44| WARNING: 5 pending requests queued 2012/04/26 08:52:56| WARNING: All redirector processes are busy. 2012/04/26 08:52:56| WARNING: 5 pending requests queued 2012/04/26 09:00:07| WARNING: redirector #4 (FD 13) exited 2012/04/26 09:00:07| WARNING: redirector #2 (FD 9) exited 2012/04/26 09:00:07| WARNING: redirector #3 (FD 11) exited 2012/04/26 09:00:07|...
Read More