Re: Help debugging 1.95 on OS X 10.3.2 please

On 11 Feb 2004, at 21:45, Edward Rudd wrote:

> Ok.. this is a quick one.
> Change your LoadModule and AddModule lines so that is references
> log_sql_module instead of sql_log_module... I did rename that when I
> started the port/updates as it is more consistent with all other apache
> modules..
>
Doh !  Thank you *very* much for that - I simply left the 1.18 stuff in  
the config file and the lyx to html converter I used made such a mess  
of things I didn't read much of the docs.

I do still have one outstanding issue that may be related to the fact  
that I'm trying to set everything once in the main section of the  
httpd.conf file with a few specific VirtualHost overrides, in that the  
access table name doesn't seem to be created although the module does  
understand the VHost.  This is in the error_log:

[Wed Feb 11 23:01:14 2004] [error] mod_log_sql: db reconnect successful
[Wed Feb 11 23:01:15 2004] [error] mod_log_sql: second attempt failed,  
API said: error 1103, "Incorrect table name ''" -- preserving
[Wed Feb 11 23:01:15 2004] [debug] mod_log_sql.c(283): mod_log_sql:  
entry preserved in /tmp/sql-preserve
[Wed Feb 11 23:01:15 2004] [error] mod_log_sql: failed to create access  
table

and the preserved file has this to say:

create table if not exists `;
insert  into `access_beta_adlib_org_uk`  
(agent,bytes_sent,request_protocol,remote_host,request_method,referer,ti 
me_stamp,status,request_duration,request_uri,request_args,remote_user,vi 
rtual_host) values ('Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en)  
AppleWebKit/124 (KHTML, like Gecko)  
Safari/125',24588,'HTTP/1.1','172.22.1.3','GET','-',1076540474,200,1,'/ 
','','-','beta.adlib.org.uk');

This is odd, as the VirtualHost is set at the end of the INSERT, and  
the automatic table name is correct at the start of the INSERT, and  
from my limited reading of the code, both the CREATE and INSERT use the  
same 'safe sql' routine and basic data structure, yet the CREATE fails  
to get the name right.

It also appears that the default /tmp/sql-preserve isn't over-ridden,  
but that's not really much of a problem at the moment, and I do need to  
go back and spellcheck the directives.  I did see one post saying that  
the AutoCreate statement needed to be all caps for one user (a few  
releases ago) rather than Camel, but that doesn't appear to help here.

Again, I'm very happy to add a few extra lines of code in, or be  
pointed to the area I should be investigating, if this is a local  
config issue.

Thanks again,
-- 
ian.
GPG Fingerprint: D170 35A3 C858 6E85 9B5B  1557 4CD5 6F6F E176 2D0A