OK, so Im running
Fedora Core 3, apache 2.0.52, php 5.0.4 and mysql 3.23.58 (standard installed from RPM’s with Fedora.
I installed php myself over the standard Fedora install.
Apache and PHP all run fine. I have several other sites that i virtual host on this machine so all is ok with that. I DO NOT use mysql for anything else (yet)
I can “mysql -u chrisb -p” and enter the password (which is “password”) all ok. I created the database “chrisb_blog”
I granted the user “chrisb” ALL priviledges. and can access it fine.
I CAN NOT get past the installation error “Error establishing a database connection”.
Can someone please enlighten me. or at least give me some pointers I’m a little stumped….. at this point.
And yes i have searched thru some of the other posts and im still very stumped.
Is the PHP talking to the mySQL ?
This
extension=msql.so in php.ini
is reported as useful here:
http://wordpress.org/support/topic/11594
Just a thought,
I note that the mysql RPM’s from the standard Fedora core list a package php-mysql-4.3.9-3. I am using PHP 5. could this be causing a connection problem?
However i note from the apache server-info that “mod_auth_mysql.c” is being used. Not sure if this is helpful or not. Perhaps someone out there knows whats going on.
Well, i checked that out and according to the config file, extentions are loaded into the /etc/php.d directory are loaded automagically when PHP starts so there should be no need to include the “extention=mysql.so” line into /etc/php.ini.
Still hunting…..
Right i have found the issue, now i just gotta solve it.
As everyone else has probably found out the problem for me is PHP talking to MySQL.
I enabled PHP logging (done in php.ini) and found that
… PHP Startup: Unable to load dynamic library ‘/usr/lib/php4/mysql.so’…
So i need to solve that first…..
Good news I solved the problem today!!!!! Yippee and finally got WordPress working.
How I did it. (Witch hunt begins here).
Removed PHP5 (I download and installed this by hand). Reinstalled PHP from the FC3 distro (4.3.9 in my case). Startup apache. No Go. Enabled logging in PHP to see what the problem was. See nothing.
Its a connection problem (right?) im sure from PHP to MySQL.
Have a look at the mysql logs? Nothing. No connection, no nothing.
hunt some more. So i created a small test.php to do a connect and select from mysql. When i ran this i got an error complaining about Could not connec to MySQL server socket ‘/var/lib/mysql/mysql.sock’ (13). Right a little more visibiliy of the problem now.
Perhaps its a permission issues? Checkout a the mysql.sock file. Its ok.
Now i remember that i problems with getting just my initial test pages to even show with apache and it turned out to be SELinux permissions problem. That was solved with the “chcon” command to grant the httpd persmissions to the DOCUMENT ROOT directory and that fixed that. With that in mind i found this little gem http://opendeveloper.org/node/view/191.
We’re getting somewhere now. I modified the /etc/selinux/config file and set SELINUX=disabled.
Reboot the box, and when it all came up, presto. Away it all went. problem solved – kinda. I dont know that globally turning off SELinux support is a good idea. Im sure there is a property that i should set on the …sock.. file for httpd to access it and that would solve the problem. I’ll investigate that and repost my findings.
ANyway, hope that helps anyone out
