[Mod_log_sql] Problems compiling on suse 9.1
mark.ridley at adeptscience.co.uk
mark.ridley at adeptscience.co.uk
Wed Jul 7 10:14:19 EST 2004
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
More information about the Mod_log_sql
mailing list