[Mod_log_sql] Setting up mod_log_sql

[Edward Rudd]

On Tue, 2005-06-21 at 01:46, Chris Boler wrote:
> Hello Craig,
> Thanks for the speedy response
> 
> I used the apache packages from debian.org (or apt-get in Debian) and all
> modules were installed the same way, except for the ones I got from
> outoforder.cc
> 
> The problem only happens when SQL logging mod DSOs are enabled...

Odds are your compiled mod_log_sql modules are compiled against a
different version of mysql than say, the PHP mysql extension.

Try disabling the PHP module (or more specifically the mysql extension)
and see if it loads fine.

I had similar issues when I had PHP linked to Mysql 4.0 libs and
mod_log_sql linked to mysql 3.23 libs.   And make sure the debian mysql
library is linked to the mysql libs and not using the packaged mysql lib
that comes with the PHP source.

> --Chris
> Craig Webster <craig at xeriom.net> wrote:
> 
> > Hi Chris,
> > On 19 Jun 2005, at 09:18 you wrote:
> > 
> > > here is further output from error logs in debug level:
> > [snip]
> > > [Sun Jun 19 19:32:13 2005] [notice] Embperl/2.0rc3 Apache/2.0.54  
> > > (Debian
> > > GNU/Linux) mod_auth_kerb/5.0-rc6 DAV/2 SVN/1.1.4 mod_jk2/2.0.4
> > > mod_ldap_userdir/1.1.7 mod_python/3.1.3 Python/2.3.5 PHP/4.3.10-15
> > > proxy_html/2.4 mod_dbi_pool/0.1.0 mod_vhost_dbi/0.1.0 mod_perl/ 
> > > 1.999.21
> > [/snip]
> > 
> > Have you upgraded Apache recently? I had this problem when one of my  
> > modules was compiled against a previous version of Apache.
> > 
> > You can easily find out which one by turning off each of the above  
> > modules in turn and restarting Apache, watching for the segfaults.  
> > Quite a lot of people have the problem with PHP - if this is the  
> > problem module then make sure you delete the php module dir and the  
> > old version of libphp before recompiling.
> > 
> > Simply recompiling the offending module stopped it for me.
> > 
> > Thanks,
> > Craig
> > --
> > Craig Webster   | e: craig at xeriom.net  | t: +44 (0)2078 710 745
> > Xeriom Networks | w: http://xeriom.net | Web hosting for the UK
> > 
> > _______________________________________________
> > 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
> > 
> 
> 
> 
> _______________________________________________
> 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
-- 
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/20050621/756b4295/attachment.bin