[Issues] [mod_log_sql 0000032]: Apache2 using MySQL 4.1.7 trouble
using the 'a' flag for LogSQLTransferLogFormat
issues at outoforder.cc
issues at outoforder.cc
Wed Apr 13 16:14:09 EST 2005
The following issue has been SUBMITTED.
======================================================================
<http://bugs.outoforder.cc/view.php?id=32>
======================================================================
Reported By: kibble
Assigned To:
======================================================================
Project: mod_log_sql
Issue ID: 32
Category: Database Issue
Reproducibility: always
Severity: block
Priority: normal
Status: new
Apache Version: 2.0.XX
======================================================================
Date Submitted: 04-13-2005 16:14 EST
Last Modified: 04-13-2005 16:14 EST
======================================================================
Summary: Apache2 using MySQL 4.1.7 trouble using the 'a' flag
for LogSQLTransferLogFormat
Description:
When using this:
LogSQLTransferLogFormat a
in my httpd.conf it will fill my '/var/www/logs/mod_log_sql-preserve' with
these:
insert into www_access_log
(agent,request_args,bytes_sent,request_file,request_protocol,remote_host,request_method,referer,request_line,time_stamp,status,request_duration,request_time,request_uri,remote_user,virtual_host)
values ('Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)',,'50332','/home/www/domain.com/www/phpinfo.php','HTTP/1.1','62.245.38.169','GET','-','GET
/phpinfo.php HTTP/1.1','1113425347','200','0','[13/Apr/2005:20:49:07
+0000]','/phpinfo.php','-','domain.com')
Running it through mysql manually the error is in the SQL statement here:
...1.4322)',,'50332','/home/www...
Where there is a double ',,' if this read ', NULL,', then things would be
fine, or if the insert statement looked a little more like this:
insert into www_access_log
(agent,request_args,bytes_sent,request_file,request_protocol,remote_host,request_method,referer,request_line,time_stamp,status,request_duration,request_time,request_uri,remote_user,virtual_host)
values ('Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)',NULL,'50332','/home/www/domain.com/www/phpinfo.php','HTTP/1.1','62.245.38.169','GET','-','GET
/phpinfo.php HTTP/1.1','1113425347','200','0','[13/Apr/2005:20:49:07
+0000]','/phpinfo.php','-','domain.com')
So that the 'request_args' field would have some value there.
======================================================================
Issue History
Date Modified Username Field Change
======================================================================
04-13-05 16:14 kibble New Issue
04-13-05 16:14 kibble Apache Version => 2.0.XX
======================================================================
More information about the Issues
mailing list