Re: Help debugging 1.95 on OS X 10.3.2 please

OK..Thanks for the bug reports..
The next release will have docbook documentation instead of lyx.
Are you using MassVirtualHosting?

First off to fix the preserve_file, on line 1269 change
set_global_string_slot to set_server_string_slot.

And for the create tables issue.
yup. It's bug. Here's a temporary fix until the next release is out.
on line 891 add the following 6 lines
cls->transfer_table_name = transfer_tablename;
cls->notes_table_name = notes_tablename;
cls->hout_table_name = hout_tablename;
cls->hin_table_name = hin_tablename;
cls->cookie_table_name = cookie_tablename;

And that will fix that issue.

On Wed, 2004-02-11 at 17:10, ian wrote:
> 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,
-- 
Edward Rudd <[email protected]>
Website http://outoforder.cc/