[Mod_log_sql] mod_log_sql 1.100 Problems

[Edward Rudd]

Dave Hahn wrote:
> Edward Rudd wrote:
>>
>> Would you post your apache configuration where you are configuration
>> mod_log_sql (including loading the modules).
>>
>>   
> LoadModule log_sql_module /usr/lib/apache2/modules/mod_log_sql.so
> LoadModule log_sql_mysql_module
> /usr/lib/apache2/modules/mod_log_sql_mysql.so
> 
> LogSQLLoginInfo mysql://logger:l0gger@localhost/apache2logs
> LogSQLCreateTables On
> LogSQLMassVirtualHosting On
> LogSQLForcePreserve On

See this line ^^^^^^^   That is why nothing is being logged into the
database..
From the documentation
http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/?chapter=/3/6/

LogSQLForcePreserve  flag
Example: LogForcePreserve On
Default: Off
Context: main server config

You may need to perform debugging on your database and
specifically want mod_log_sql to make no attempts to log
to it. This directive instructs the module to send all
its log entries directly to the preserve file and to
make no database INSERT attempts.

This is presumably a directive for temporary use only;
it could be dangerous if you set it and forget it, as
all your entries will simply pile up in the preserve
file.

> LogSQLPreserveFile /www/sql-logs-preserve-missed.sql
> LogSQLTransferLogFormat AabcHhIMmPpRrSsTtUuv

[snip]



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 251 bytes
Desc: OpenPGP digital signature
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20060511/648b0d15/attachment.bin