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

Connect to Wireless Network (WPA) in Ubuntu 11.04 using Command Line

Install wpa supplicant package: $ sudo apt-get install wpasupplicant Configure network ESSID and passphrase. In this example I use ESSID ‘yantoknuk-singtel’ and passphrase ‘ngumbahkucing’. $ wpa_passphrase yantoknuk-singtel # reading passphrase from stdin After that, type in your passphrase right below the text ‘# reading passphrase from stdin’. # reading passphrase from stdin ngumbahkucing network={ ssid=”yantoknuk-singtel”…

Read More
ehcp

How to Install Easy Hosting Control Panel (EHCP) on Ubuntu

EHCP is a free and open source web hosting control panel. This guide will show you how to install it on Ubuntu server.           Check /etc/apt/sources.list. It should have the following line (replace oneiric with your version). deb http://archive.ubuntu.com/ubuntu/ oneiric main restricted deb-src http://archive.ubuntu.com/ubuntu/ oneiric main restricted deb http://archive.ubuntu.com/ubuntu/ oneiric-updates main…

Read More