[Mod_log_sql] Newbie needs assistance with mod_log_sql

[Britt A. Green]

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: 
>>log_sql_module
>>
>>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?

Britt