How to Install Memcached on Debian / Ubuntu

Memcached is free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load. First of all, install memcached dan php5-memcached packages: and then make sure memcached is running with this command: Restart apache web server: Check php5-memcached module using…

Read More

How to Fix MySQL Error “Stopping MySQL database server : mysqld failed!” on Debian Squeeze

This problem happens when you modify user table in mysql database. In Debian system, there is a user named debian-sys-maint. We can’t restart mysql daemon if the password is not correct. We have to update the password for that user. First, we check the password: Login to mysql shell as root Now use the following…

Read More

How to Save Apache Access Log into MySQL Database Using libapache2-mod-log-sql on Debian Squeeze

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:…

Read More

How to Install Fail2ban on Debian Squeeze

Fail2ban is an important software for system administrator. It scans log files (e.g. /var/log/auth.log) and bans IPs that show malicious signs, something like too many password failures and looking for exploits. To install fail2ban, execute this command: Open the configuration file to activate some rules: Find following line to set email destination for notification: Find…

Read More

How to Upgrade EHCP 0.30.4 to 0.30.6

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,…

Read More