Red Hat Bugzilla – Bug 60542
failure on php to connect to mysql after updating php.
Last modified: 2007-04-18 12:40:41 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.8) Gecko/20020205
Description of problem:
Error shown in web page is something like "php cannot connect to mysql through
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. make sure /etc/php.ini has no value for mysql.default_socket
2. latest php, mysql, apache (php-4.0.6-12.i386.rpm)
3. run a mysql_connect
Actual Results: error message like: "php cannot connect to mysql through
Expected Results: Connection success. The applied rpms for the php security
fix caused this.
This doesn't cause a crash, but it does take down the web server fuctionality of
php+mysql enabled sites when apache gets a HUP (after logrotate). I suppose I
would have found the problem earlier if I restarted apache manually after the
upgrade, but I didn't want to do that. My production site was down for 6 hours.
Untill they get this fixed you can create a symlink from
/var/lib/mysql/mysql.sock to /tmp/mysql.sock. that got me back up and running.
Is there a config file to fix this or is it compiled into a binary?
Created attachment 47282 [details]
one line patch to change default mysql.sock location in configure script
of course - that means you have to apply that patch before rebuilding that RPM
:) But the softlink from /tmp/mysql.sock works just as well.
*** This bug has been marked as a duplicate of 60515 ***