[Mod_log_sql] Segfault in 1.99 with CGI Args

[Douglas E. Warner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 13 August 2004 20:21, Douglas E. Warner wrote:
> I should add that I don't have libDBI compiled in, and do have MySQL and
> SSL compiled in.

Trying to help track down what's going on, I ran my config (which I'll include 
below) with 'LogLevel debug' in my httpd.conf.  Here's the pertinent info:

[Wed Aug 18 10:34:25 2004] [debug] functions.h(180): watching for cookie 
'PHPSESSID'
[Wed Aug 18 10:34:25 2004] [debug] functions.h(206): Cookie: 
[netmrgDevTree[monitor]=a%253A0%253A%257B%257D; 
netmrgDevTree[subdevice]=a%253A0%253A%257B%257D; 
netmrgDevTree[device]=a%253A0%253A%257B%257D; 
netmrgDevTree[group]=a%253A1%253A%257Bi%253A0%253Bs%253A1%253A%25222%2522%253B%257D; 
PHPSESSID=3e16f04ec7b00756111f69eb2f742790]
[Wed Aug 18 10:34:25 2004] [debug] mod_log_sql_ssl.c(74): SSL_CIPHER:
[Wed Aug 18 10:34:25 2004] [debug] mod_log_sql_ssl.c(42): SSL_KEYSIZE:
[Wed Aug 18 10:34:25 2004] [debug] mod_log_sql_ssl.c(58): SSL_ALGKEYSIZE:
[Wed Aug 18 10:34:25 2004] [debug] mod_log_sql.c(1036): mod_log_sql: access 
string: insert  into access_log 
(agent,request_args,bytes_sent,cookie,request_protocol,remote_host,id,machine_id,request_method,referer,time_stamp,status,request_duration,request_uri,remote_user,virtual_host,ssl_cipher,ssl_keysize,ssl_maxkeysize) 
values ('Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040612 
Firefox/0.8',,'2007','3e16f04ec7b00756111f69eb2f742790','HTTP/1.1','127.0.0.1','kBUHHX8AAAEAAFATyYwAAAAA','web0','GET','-','1092839665','200','0','/netmrg/login.php','-','localhost','0','0','0')
[Wed Aug 18 10:34:26 2004] [notice] child pid 20499 exit signal Segmentation 
fault (11)

Looks like 'request_args' is having an escaping problem (notice the two commas 
right beside each other w/o any quotes).
My config looks like this:

LogSQLTransferLogTable access_log
LogSQLTransferLogFormat AabcHhIMmRSsTUuvzqQ
LogSQLMachineID web0
LogSQLWhichCookie PHPSESSID

- -Doug
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBI2nJJV36su0A0xIRAhZGAJ9q0nbwEURrUeYE1UcAtHIY6ZSkngCg0inG
D0UF02PHTEB28UfKw+gVc0w=
=KtE1
-----END PGP SIGNATURE-----