Re: Setting up mod_log_sql

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 <[email protected]> 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: [email protected]  | 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
> > 
> 
> 
> 
> _______________________________________________
> 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
-- 
Edward Rudd <[email protected]>
Website http://www.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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQBCuOF+vwMxRUUct20RAiYUAJwLOm5wp4dnnNIc92W6KEJf2GpSlQCgk47v
W9EwAMzxm4AzHEzD1dJ1JQs=
=XOcJ
-----END PGP SIGNATURE-----