Re: mod_log_sql 1.100 Problems

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]

_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFEY+ZTvwMxRUUct20RAqnrAKCRKBcXGqx27qDXmPaf/eFNEzgp9wCdFjC+
P1bEjjP16puRltQWjPHnxpE=
=VWCO
-----END PGP SIGNATURE-----