Tips and Tricks

The purpose of saving Apache access log into MySQL database is to make it easier to parse website’s visitor information. First of all, we do repository update: Install libapache2-mod-log-sql Create apachelogs and scoreboard table: Modify /etc/apache2/sites-available/default: If you have other virtual hosts, you can put LogSQLTransferLogTable directive into each virtual host tag. Create mod_log_sql-preserve file:…

Download version 0.30.6 from this link. # cd /root # wget http://sourceforge.net/projects/ehcp/files/ehcp_yeni.tgz/download Extract the file Backup current EHCP # copy -R /var/www/new/ehcp /root/backup_ehcp Copy new EHCP # copy -R /root/ehcp /var/www/new/ Copy config.php from backup # cp /root/backup_ehcp/config.php /var/www/new/ehcp Open browser and go to http://your_ip and login to EHCP. If you have logged in already,…