[Mod_log_sql] Newbie needs assistance with mod_log_sql

Britt A. Green milo at limecat.org
Tue Jun 15 12:10:16 EST 2004

Edward Rudd wrote:

>Quoting "Britt A. Green" <milo at limecat.org>:
>>Hello all,
>>I just downloaded and installed the debian file of mod_log_sql 1.18. My 
>>Debian box is running Apache 1.3.
>>I'm having some errors after my installation. When I run apachectl 
>>configtest, I get the following error message:
>>Can't locate API module structure `log_sql_module' in file 
>>/usr/lib/apache/1.3/mod_log_sql.so: /usr/sbin/apache: undefined symbol: 
>>The relevant portions of my httpd.conf file are below:
>>LoadModule log_sql_module /usr/lib/apache/1.3/mod_log_sql.so
>>LoadModule log_sql_mysql_module /usr/lib/apache/1.3/mod_log_sql_mysql.so
>Use the line 
>LoadModule sql_log_module /usr/lib/apache/1.3/mod_log_sql.so
>Only the 1.9x (2.0 branch) uses los_sql_module and has the separated database
>module. (log_sql_mysql_module). Read the Documentation for 1.18 as the two
>releases are slightly different.

Thanks. That seems to have worked. I'm almost there!

Right now nothing is getting logged, unfortunately. No tables in the 
database are being created. I have the following lines at the end of my 
httpd.conf file:

LogSQLLoginInfo localhost apache foobar
LogSQLDatabase apachelogs
LogSQLCreateTables on
LogSQLSocketFile /var/run/mysqld/mysqld.sock
LogSQLPreserveFile          apache_queries.sql

When I check my MySQL log files, this is the only entry I see, which is 
logged right after i restart Apache:

040615 12:47:56       3 Connect     apache at localhost on apachelogs
                      4 Connect     apache at localhost on apachelogs
                      5 Connect     apache at localhost on apachelogs
                      6 Connect     apache at localhost on apachelogs
                      7 Connect     apache at localhost on apachelogs

According to the FAQ, I should be seeing INSERT statements, which I'm 
most definitely not seeing. Unfortunately the FAQ doesn't explalin how 
to rectify this! ;)

Could someone point me in the right direction on this?


More information about the Mod_log_sql mailing list