[Mod_log_sql] Problems compiling on suse 9.1

[mark.ridley at adeptscience.co.uk]

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.

LoadModule access_module /usr/lib/apache2-prefork/mod_access.so
LoadModule actions_module /usr/lib/apache2-prefork/mod_actions.so
LoadModule alias_module /usr/lib/apache2-prefork/mod_alias.so
LoadModule auth_module /usr/lib/apache2-prefork/mod_auth.so
LoadModule auth_dbm_module /usr/lib/apache2-prefork/mod_auth_dbm.so
LoadModule autoindex_module /usr/lib/apache2-prefork/mod_autoindex.so
LoadModule cgi_module /usr/lib/apache2-prefork/mod_cgi.so
LoadModule dir_module /usr/lib/apache2-prefork/mod_dir.so
LoadModule env_module /usr/lib/apache2-prefork/mod_env.so
LoadModule expires_module /usr/lib/apache2-prefork/mod_expires.so
LoadModule include_module /usr/lib/apache2-prefork/mod_include.so
LoadModule log_config_module /usr/lib/apache2-prefork/mod_log_config.so
LoadModule mime_module /usr/lib/apache2-prefork/mod_mime.so
LoadModule negotiation_module /usr/lib/apache2-prefork/mod_negotiation.so
LoadModule setenvif_module /usr/lib/apache2-prefork/mod_setenvif.so
LoadModule ssl_module /usr/lib/apache2-prefork/mod_ssl.so
LoadModule suexec_module /usr/lib/apache2-prefork/mod_suexec.so
LoadModule userdir_module /usr/lib/apache2-prefork/mod_userdir.so
LoadModule usertrack_module /usr/lib/apache2-prefork/mod_usertrack.so
LoadModule rewrite_module /usr/lib/apache2-prefork/mod_rewrite.so
LoadModule jk_module                      /usr/lib/apache2/mod_jk.so
LoadModule perl_module                    /usr/lib/apache2/mod_perl.so
LoadModule log_sql_module /usr/lib/apache2-prefork/mod_log_sql.so

If i load the module with no further configuration then I understandably 
just get the following in the error log, but after that apache works ok

[Wed Jul 07 16:08:09 2004] [notice] suEXEC mechanism enabled (wrapper: 
/usr/sbin/suexec2)
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: insufficient configuration 
info to establi
sh database link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: child spawned but unable 
to open database 
link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: insufficient configuration 
info to establi
sh database link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: child spawned but unable 
to open database 
link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: insufficient configuration 
info to establi
sh database link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: child spawned but unable 
to open database 
link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: insufficient configuration 
info to establi
sh database link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: child spawned but unable 
to open database 
link
[Wed Jul 07 16:08:09 2004] [notice] Apache/2.0.49 (Linux/SuSE) configured 
-- resuming norm
al operations
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: insufficient configuration 
info to establi
sh database link
[Wed Jul 07 16:08:09 2004] [error] mod_log_sql: child spawned but unable 
to open database 
link

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

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 --------------
An embedded and charset-unspecified text was scrubbed...
Name: signature.asc
Url: http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20040707/6cec34f4/attachment.asc