[Mod_log_sql] problem with mod_log_sql + frontpage

[Edward Rudd]

On Wed, 2004-08-25 at 19:14, Brad Schuetz wrote:
> Frontpage version is 2002 SR1.2
> URL: http://www.rtr.com/fpsupport/fp2002sr1_download.htm
> Or: http://www.omnis.com/~brad/mod_log_sql/fp50.linux.tar.gz
> 
> > This may be a problem with the front page server extensions, and I may
> > not be able to fix it.. But I will look into the issue and figure out if
> > it is my module.
> > 		
It looks as though it's front page or one of your other modules.  Some
other module is altering the servername that I use in mod_log_sql.
Around line 800 in the mod_log_sql.c source file, there is a line that
says

/* Determint the hostname and convert it to all lower-case; */
char *servername = apr_pstrdup(orig->pool,(char 
*)ap_get_server_name(orig));

Add this line right after after that.

log_error(APLOG_MARK, APLOG_ERR, 0, orig->server,
	"incoming Server name '%s'",servername);

This will log what the servername that mod_log_sql retrieved from apache
is.. when you run across one of these "boken SQL queries" the error_log
should contain the whole mess that was in the query as well, if it does
then I'm sure it's something else screwing things up.  Make sure you
have ErrorLog log/somelogfile set inside of the virtualhost you are
using for the frontpage site that's causing the problems.

I will be taking a quick look through the fp code when I get a chance
next week, but you may want to contact the authors of that module about
the issue, as it looks most likely in their code where the problem lies.
> 
> One suggestion, even if this isn't a problem with your module, and I 
> wouldn't doubt that it's some apache+frontpage voodoo, would be to test 
> the validity of the table name before attempting to create it or insert 
> data into it.  I wouldn't mind that data just being dropped since it's 
> useless to me.
> 
> Thanks for looking into it.
-- 
Edward Rudd <urkle at outoforder.cc>
Website http://www.outoforder.cc/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20040827/91a8f4a4/attachment.bin