11
Feb

Webalizer stats for multiple websites

Samuel L. JacksonWebalizer 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). There are a couple of ways to make this trouble disappear, but I'll explain only one which is, in my opinion, one of the easiest and applicable in most scenarios.

Although I'm using CentOS 6, this tutorial isn't CentOS-specific. So, if you're using another distro you'll notice that there are some differences, but you'll get there in the end.

22
Jan

MySQL hot backup with XtraBackup on CentOS

Dwight SchruteIf 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. XtraBackup also supports MyISAM backups, although not without table locks.

XtraBackup consists of three tools - innobackupex, xtrabackup and tar4ibd.

Innobackupex is a wrapper script written in Perl that allows you to backup a complete MySQL instance with InnoDB, MyISAM and XtraDB tables. XtraBackup is a tool compiled in C which main job is to copy only InnoDB and XtraDB data. Of course, there is tar4ibd - a tool that safely stores InnoDB data in tar archive.

4
Jan

Fine tuning cPanel autoresponder interval

Y u no answer email?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.

21
Dec

Are your emails being automatically deleted from trash folder on cPanel server?

TrashIf you happen to run Courier IMAP server that comes with cPanel, then you are probably experiencing a rather unpleasant feature . By default, Courier will regularly delete every single email from trash folder that is more than 7 days old.

Considering that most people use IMAP protocol to keep their messages safe and always available on the server, this default option can cause a lot of frustration. Luckily, fixing this issue is rather easy and quick (it takes less than a minute).

12
Oct

Changing (forgotten) PostgreSQL password

PostgreSQLWhether 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.4 server that runs on CentOS 5.7, but I've thrown in some tips to help you out if you're using Debian or Ubuntu Linux distro.

Pages