[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:
>>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
More information about the Mod_log_sql
mailing list