NYCPHP Meetup

[Russell Aronson]

I had the same problem about a week ago. i could connect to the mysql 
server through php but when i pulled data, the apache process would 
segfault. I had also compiled the php5 and mysql 4.1.12 packages from 
source. i took a look at phpinfo from within a browser and also from the 
command line. i realized that the mysql client api version was 3.23 
(which was different to the mysql server version i was running) in the 
browser but not on the command line. i had both 3.23 and 4.1 mysql 
client libraries installed because perl-DBI and mod_auth_mysql required 
the older version...

The problem is something like this. mod_auth_mysql loaded the 
mysqlclient10-3.23 libraries into the apache process which overwrote the 
other mysql client libraries that php loaded. when php uses a mysql 
function, it goes through a module compiled for mysql 4.1 libraries, but 
in this case, it links to a library compiled for mysql 3.23 because of 
mod_auth_mysql.

To fix the problem, just remove any apache module that uses the 
mysqlclient10-3.23 libraries, ie. mod_auth_mysql.

-- 
Russell Aronson, Web Development & System Administration
Barrett Consulting Group Pty Ltd
Phone: +61 3 9532 7677, Fax: +61 3 9532 7388
http://www.barrett.com.au