Webalizer stats for multiple websites

Webalizer is a web log analysis software licensed under GPL. It’s written in C and it’s super fast in processing access log files. Configuring Webalizer is very easy, especially if your Apache web server combines all access logs into one log file, but I noticed that many people have trouble configuring Webalizer for multiple websites (virtualhosts).

MySQL hot backup with XtraBackup on CentOS

If you are in a need for hot backup solution for MySQL RDBMS, you should try out Percona’s XtraBackup. Now, as you can read on the official website, XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.

Fine tuning cPanel autoresponder interval

If you enabled autoresponder in your cPanel, then you probably noticed that, by default, the sender gets only one autoreponder message every 8 hours. There is nothing wrong with that. In fact, the purpose of this interval setting is to prevent sending a bunch of emails to the sender who sends more then one email to the user who has enabled autoresponder.

Changing (forgotten) PostgreSQL password

Whether you lost password for postgres user or you’d just like to change it, the process is very simple. Unlike resetting lost password for MySQL’s root user, resetting postgres’ password is pretty straightforward and you’ll not experience any kind of downtime. This article explains how to change/reset password for postgres user in PostgreSQL 8.