<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Edward Rudd wrote:<br>
<blockquote cite="mid4463BAC3.1020903@outoforder.cc" type="cite">
<pre wrap=""><!---->
Would you post your apache configuration where you are configuration
mod_log_sql (including loading the modules).
</pre>
</blockquote>
LoadModule log_sql_module /usr/lib/apache2/modules/mod_log_sql.so<br>
LoadModule log_sql_mysql_module
/usr/lib/apache2/modules/mod_log_sql_mysql.so<br>
<br>
LogSQLLoginInfo mysql://logger:l0gger@localhost/apache2logs<br>
LogSQLCreateTables On<br>
LogSQLMassVirtualHosting On<br>
LogSQLForcePreserve On<br>
LogSQLPreserveFile /www/sql-logs-preserve-missed.sql<br>
LogSQLTransferLogFormat AabcHhIMmPpRrSsTtUuv<br>
<br>
<blockquote cite="mid4463BAC3.1020903@outoforder.cc" type="cite">
<pre wrap=""></pre>
<pre wrap="">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
</pre>
</blockquote>
I have the debug enabled. However, I never see any MySQL connect or
failure information. After a reload, this is what I see:<br>
<br>
<blockquote><tt>[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<br>
[Thu May 11 15:32:15 2006] [info] Server built: Sep 5 2005 11:15:09<br>
[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)<br>
[Thu May 11 15:32:15 2006] [debug] mod_log_sql.c(447): mod_log_sql:
open_logdb_link said that preservation is forced<br>
[Thu May 11 15:32:15 2006] [debug] mod_log_sql.c(447): mod_log_sql:
open_logdb_link said that preservation is forced<br>
[Thu May 11 16:31:04 2006] [debug] mod_log_sql.c(447): mod_log_sql:
open_logdb_link said that preservation is forced<br>
[Thu May 11 16:33:43 2006] [debug] functions.h(184): watching for
cookie 'PHPSESSID'<br>
[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')<br>
[Thu May 11 16:33:43 2006] [debug] mod_log_sql.c(1038): mod_log_sql:
preservation forced<br>
[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</tt><br>
<br>
</blockquote>
Is there anything else I can provide?<br>
</body>
</html>