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
WLANAutoConfig

How to Fix Disabled Wireless Device in Windows 7

I had this problem in Windows 7 where wireless device always show disabled. I opened Control Panel\Network and Internet\Network Connections and then right click on disabled Wireless Network Connection, and choose Enable. After that status window appeared show ‘Enabling..’ message, but the device was still disabled. To fix this problem, I opened Control Panel\Administrative Tools\Services,…

Read More

Setup Squid MRTG on Ubuntu 10.10

Update Feb 23: to install only MRTG and SNMP please read this article.   Install MRTG, Apache2, Squid and SNMP $ sudo apt-get install apache2 snmpd mrtg snmp-mibs-downloader squid Configure SNMP Backup /etc/snmp/snmpd.conf $ sudo mv /etc/snmp/snmpd.conf /etc/snmp/snmpd.conf.bak Create new /etc/snmp/snmpd.conf $ sudo nano /etc/snmp/snmpd.conf and key in these lines: rocommunity  public syslocation  “Bukit Batok”…

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

How to Create Bandwidth Usage Script on Linux

Using a tool called iftop we can monitor bandwidth usage via command line on Linux. But here we will create our own shell script to monitor bandwidth usage. The idea is to read rx_bytes and tx_bytes files inside /sys/class/net/[interface]/statistics/ folder. Create netspeed script in /usr/local/bin/ and copy and paste below script. Script content: Exit nano…

Read More
mstscax.dll

How to Fix RDCMan Problem: “Incompatible version of mstscax.dll”

This problem happens when you are using Remote Desktop Connection Manager (RDCMan) with not updated Terminal Service Client. To fix this problem you have to download and install the latest Terminal Service Client 6.1 from below website. For Windows XP: http://www.microsoft.com/download/en/details.aspx?id=7208 For Windows Server 2003: http://www.microsoft.com/download/en/details.aspx?id=21296

Read More