[Mod_log_sql] mod_log_sql 1.100 Problems

[Dave Hahn]

Thanks!

Too many chefs in the stew on this one - the other admin set this while 
we were having problems and I didn't look that carefully.

Shame on me.

-d

Edward Rudd wrote:
> 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 at lists.outoforder.cc
>   


-- 
Dave Hahn
Technical Development Manager
Sales and Marketing LLC
303.777.9200 x3
dhahn at salesandmarketingllc.com
www.salesandmarketingllc.com