Re: Setting up mod_log_sql

On Sun, 2005-06-26 at 02:27, Chris Boler wrote:
> Okay so far what I have done is remove the debian packages and compile
> everything from source. The same error still comes into effect:
> 
> [Sun Jun 26 18:42:09 2005] [notice] child pid 24681 exit signal Segmentation
> fault (11)
> [Sun Jun 26 18:42:09 2005] [debug] mod_log_sql_mysql.c(54): HOST: '10.0.0.10'
> PORT: '3306' DB: 'apachelogs' USER: 'apache' SOCKET:
> '/var/lib/mysql/mysql.sock'
> [Sun Jun 26 18:42:09 2005] [debug] mod_log_sql.c(443): mod_log_sql:
> open_logdb_link successful
> 
> The only mods loaded are mod_dbi_pool, mod_log_sql, mod_vhost_dbi.

AHHH

you need to check what version of mysql libdbi is linked to. As that's
probably where the root cause of the issue is. And what MPM module are
you using with apache (ie. prefork or worker)

> One works when the other is disabled - e.g. when mod_vhost_dbi is not enabled,
> it will log fine. When mod_log_sql is not enabled, the vhosts work fine. I
> have a feeling it doesnt like that it has to get the vhost from the database
> because of mod_vhost_dbi... Any suggestions anyone?
> 
> Thanks,
> --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)

iD8DBQBCwd6mvwMxRUUct20RAm//AJ9S8LVJRfW5oNw5Cifr6N26k/elfACcDgUJ
TXXwaxmlbnpWUfcI5lObdnU=
=0yEl
-----END PGP SIGNATURE-----