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 Switch Between Ubuntu, Kubuntu, and Xubuntu

For you who have installed Ubuntu / Kubuntu / Xubuntu, you can switch between desktop environment easily. Here are the desktop environments used by each distro: – Ubuntu defaults use Gnome – Kubuntu defaults use KDE – Xubuntu defaults use XFCE Just open Adept or Synaptic package manager, and search for: ubuntu-desktop or kubuntu-desktop or xubuntu-desktop Or…

Read More