[Mod_log_sql] mod_log_sql help confgiuring on debian etch

Chris chris at mp3crib.com
Sat Oct 27 13:11:52 EDT 2007

I'm trying to setup mod_log_sql to log my apache access log entries in a
mysql 5 database. I have installed mod_log_sql version 1.100 from sid using
aptitude install libapache2-mod-log-sql. 

I then created the tables using a SQL file created by the developer of the
package to create them for me. The documentation, unfortunately, it is not
debian centric and is asking me to put things in my httpd.conf file such as:


Example: Use the MySQL database called "apachelogs" running on
"dbmachine.foo.com". Use username "loguser" and password "l0gg3r" to
authenticate to the database. Permit the module create tables for us. 

LogSQLLoginInfo dbmachine.foo.com loguser l0gg3r 

LogSQLDatabase apachelogs 

LogSQLCreateTables on 

If your database resides on localhost instead of another host, specify the
MySQL server's socket file as follows: 

LogSQLSocketFile /your/path/to/mysql.sock 

If your database is listening on a port other than 3306, specify the correct
TCP port as follows: 

LogSQLTCPPort 1234


There is no area to do this in httpd.conf really, in fact it is a blank file
since I am on apache2. Do I just add these directives in myself? Please
advise, I am using the documentation located here:
and my server is Etch based running MySQL 5 Apache 2 and yes, I did install
the mod_log_sql from the unstable repo sid. Also I did verify the modules is
in /etc/mods-enabled/ and did restart apache, but I guess I still need to
configure the module so it knows where to insert records. I am a developer,
not a sys admin, sorry, but thanks for your help in advance.  I tried just
adding the parameters to httpd.conf and restarting apache, it restarts with
no errors, but I get timeouts when attempting to access my page.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20071027/dd150f09/attachment.html 

More information about the Mod_log_sql mailing list