Comments on Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch)

Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch) This guide shows how you can write the Apache2 access log to a MySQL database instead of a file. To achieve this, I use the Apache2 module mod_log_sql. I'm using a Debian Etch server in this tutorial.

5 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By:

As usual, a very nice tutorial Falko, cheers.

Please note however that if the MySQL server is down or unavailable, Apache will display timeouts and may not even serve websites at all.

For high performance websites, this might be a consideration. You may want to provide redundant MySQL logging servers or agressive availability monitoring on either Apache and MySQL.

By:

For those who don't want to mess with their Etch apt config:

wget http://ftp.at.debian.org/debian/pool/main/t/tzdata/tzdata_2008e-3_all.deb
wget http://ftp.at.debian.org/debian/pool/main/g/glibc/libc6_2.7-13_i386.deb
wget http://ftp.at.debian.org/debian/pool/main/liba/libapache-mod-log-sql/libapache2-mod-log-sql_1.100-13_i386.deb

dpkg -i tzdata_2008e-3_all.deb
dpkg -i libc6_2.7-13_i386.deb
dpkg -i libapache2-mod-log-sql_1.100-13_i386.deb

By: Anonymous
By: Colin

When was this tutorial written? Is it from that time when nobody realized the internet would soon be full of old stuff?

By: Tom

The date of a tutorial does not matter as long as the tutorial is written for a specific software version and communicates it clearly, in this case even in the headline of the guide. I could write a tutorial today on ancient software, so it has today's date, does it help you with today's software versions? No, it doesn't. What matters for a tutorial is for which software version / Linux distribution version it is made. This tutorial says it is for Debian Etch, this means it works now for Debian Etch and it will work in the exact same way on Debian Etch in 10 years. Are you using Debian Etch? Then the guide is the right one for you. If you don't use it, which is quite likely as Debian Etch (also known as Debian 4.0) is not the current Debian release, which is Debian 11, then this guide is not for you.