[Mod_log_sql] Problems compiling on suse 9.1

[Tristan Woerth]

Mark, Edward,

The config snippet seems to indicate it's the case already, but it may 
be worth double checking...

I had a similar problem on FreeBSD, and solved it by putting the 
LoadModule lines related to mod_log_sql after the line related to PHP.

I've only tested it on FreeBSD, but loading mod_log_sql before PHP 
results in Apache dumping a core.

Tristan

Edward Rudd wrote:

>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,
>>>
>>>      
>>>
>>>------------------------------------------------------------------------
>>>
>>>_______________________________________________
>>>Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
>>>
>>>To unsubscribe send an e-mail to 
>>>mod_log_sql-unsubscribe at lists.outoforder.cc
>>>      
>>>