[Mod_log_sql] mod_log_sql 1.100 Problems

[Dave Hahn]

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
LogSQLPreserveFile /www/sql-logs-preserve-missed.sql
LogSQLTransferLogFormat AabcHhIMmPpRrSsTtUuv

> Add the directive
>
> LogLevel debug
>
> to your apache configuration and restart apache, then mod_log_sql will
> give you more debugging information in the error_log
>
>   
I have the debug enabled.  However, I never see any MySQL connect or 
failure information.  After a reload, this is what I see:

    [Thu May 11 15:32:15 2006] [notice] Apache/2.0.54 (Debian GNU/Linux)
    PHP/4.3.10-16 mod_ssl/2.0.54 OpenSSL/0.9.7e configured -- resuming
    normal operations
    [Thu May 11 15:32:15 2006] [info] Server built: Sep  5 2005 11:15:09
    [Thu May 11 15:32:15 2006] [debug]
    /home/adconrad/build/apache2/security/sarge/apache2-2.0.54/build-tree/apache2/server/mpm/prefork/prefork.c(956):
    AcceptMutex: sysvsem (default: sysvsem)
    [Thu May 11 15:32:15 2006] [debug] mod_log_sql.c(447): mod_log_sql:
    open_logdb_link said that preservation is forced
    [Thu May 11 15:32:15 2006] [debug] mod_log_sql.c(447): mod_log_sql:
    open_logdb_link said that preservation is forced
    [Thu May 11 16:31:04 2006] [debug] mod_log_sql.c(447): mod_log_sql:
    open_logdb_link said that preservation is forced
    [Thu May 11 16:33:43 2006] [debug] functions.h(184): watching for
    cookie 'PHPSESSID'
    [Thu May 11 16:33:43 2006] [debug] mod_log_sql.c(1032): mod_log_sql:
    access string: insert  into access_gibbons
    (agent,request_args,bytes_sent,cookie,request_protocol,remote_host,id,machine_id,request_method,child_pid,server_port,referer,request_line,time_stamp,status,request_duration,request_time,request_uri,remote_user,virtual_host)
    values
    ('-',NULL,'206','-','HTTP/0.9','208.254.45.254','0Aux2X8AAAEAACZ4CDkAAAAp','gibbons','\x80@\x01\x03','9848','80','-','\x80@\x01\x03','1147386823','501','0','[11/May/2006:16:33:43
    -0600]','/','-','gibbons')
    [Thu May 11 16:33:43 2006] [debug] mod_log_sql.c(1038): mod_log_sql:
    preservation forced
    [Thu May 11 16:33:43 2006] [debug] mod_log_sql.c(214): mod_log_sql:
    entry preserved in /www/sql-logs-preserve-missed.sql

Is there anything else I can provide?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20060511/3126c701/attachment.html