[Mod_log_sql] Problems compiling on suse 9.1

[Edward Rudd]

On Wed, 2004-07-07 at 10:14, mark.ridley at adeptscience.co.uk wrote:
> Edward,
> 
> I have disabled php and I still get the same result.  Can it clash with 
> anything else? - I have already tried disabling mod_jk and mod_perl - 
> Please find a list of other loaded modules.
> 
[snip]
> 
> As soon as I add the following line to the configuration I get the seg 
> faults.
> 
> LogSQLLoginInfo mysql://username:password@server.domain.co.uk/aw_logs
> 
Can you try putting

logLevel debug

in your httpd.conf file and then send the relevant portions from the
log?

I'm going to check what bugs I have fixed in my Dev version to see if
any may fix the issue you are having. and if so, I'll tar ball it and
release it.

> Kind regards,
> 
> Mark
> 
> 
> 
> 
> 
> 
> Edward Rudd <urkle at outoforder.cc> 
> 06/07/04 09:43 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 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/20040707/d04d9c70/attachment.bin