[Mod_log_sql] Problems compiling on suse 9.1

[Edward Rudd]

On Tue, 2004-07-06 at 10:41, mark.ridley at adeptscience.co.uk wrote:
> Edward,
> 
> I have now managed to compile mod_log_sql 1.98 thanks to your advice.  I 
> have tried to configure it within apache in the same way that I used to on 
> our old server (red hat 9) and although apache (v 2.049) starts up without 
> reporting any errors it does not respond and the error log quickly fills 
> up with the following statements until i stop it.
> 
> [Tue Jul 06 16:27:40 2004] [notice] child pid 1233 exit signal 
> Segmentation fault (11)
[snip]

> The configuration is as follows:-
> 
> LoadModule log_sql_module   /usr/lib/apache2-prefork/mod_log_sql.so
> LogSQLCreateTables On
> LogSQLDatabase aw_logs
> LogSQLLoginInfo hostname username password
> LogSQLMachineID machineID
> LogSQLTCPPort 3306
> 
> I have not yet configured any virtual hosts.
> 
> The server is a standard Suse 9.1 and the apache configuration is also 
> standard and was not compiled by myself.

Do you have PHP enabled?  try temporarily disabling php (put a # in
front of the LoadModule line for libphp4.so).  and see if apache starts
up and works..

there are issues if PHP is compiled with PHP's built-in mysql client
library instead of the system library (read the FAQ in the documentation
for mod_log_sql)

> Thanks,
> 
> Mark
> 
> 
> 
> 
> Edward Rudd <urkle at outoforder.cc> 
> 05/07/04 05:09 pm
> 
> To
> mark.ridley at adeptscience.co.uk
> cc
> mod_log_sql at lists.outoforder.cc
> Subject
> Re: [Mod_log_sql] Problems compiling on suse 9.1
> 
> 
> 
> 
> 
> 
> On Mon, 2004-07-05 at 04:53, mark.ridley at adeptscience.co.uk wrote:
> > Hello,
> > 
> > I am having trouble compiling on suse 9.1.  Configure is fine - i ran 
> with 
> > the following: 
> 
> > Any suggestions?
> 
> First, what version of mod_log_sql are you using?
> 2nd, is this a custom build of apache or the distribution provided?
> 
> This is an error when using an apache build with debug info on, I did
> fix this in mod_log_sql 1.98. (but only tested on apache 2.0.49)
> 
> Your build has debug mode enabled ( which is much slower for a
> production server). Debug mode compiles in several functions that can be
> traced into while debugging instead of using faster Macros. I'd suggest
> you recompile apache w/o the AP_DEBUG macro defined. (pass
> --disable-debug to ./configure of Apache's build)
> 
> You can edit the Makefile.in file and remove the -Wc,-Werror parameter
> on CFLAGS at the top and re-run ./config.status
> then make and things will compile  (still the warnings, but it won't
> error out on the warnings)
> 
> > Thanks in advance,
> > 
-- 
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/20040706/8b1eb8bb/attachment.bin