PHP apps unable to contact non-local database?

jnojr · 07-07-2009, 03:36 PM

I'm dealing with a site built on a RHEL5 server, MySQL 5.0.22 (yeah, I know it's old, tell Red Hat) php 5.1.6-23, Drupal 6.4

I built a VM, dumped the database from the original server, rsynced the entire /var/www/html/ from the old server to the new server, restored the database... and it worked just fine.

Now, I need to replicate this site again, but on two VMs... one for the web server, one for the database server. I thought it would be pretty straightforward to add a MySQL user on the db host that's allowed to connect from the IP of the web host, but it just... will... not... work! I can, from the shell of the web server, connect to MySQL on the remote server just fine. Both Drupal and phpMyAdmin just will not connect... phpMyAdmin says "#2003 - The server is not responding" and Drupal tells me the site is off-line. When I try to access the install.php, it says:

Failed to connect to your MySQL database server. MySQL reports the following message: Can't connect to MySQL server on '172.16.1.1' (13).

Please keep in mind, though, that I absolutely can connect with the 'mysql' command at the shell. It seems like there's some magic sauce that PHP is missing. I do have php-mysql installed on the web server.

eth1 · 07-07-2009, 06:36 PM

The only thing that comes to mind right now is whether the MySQL Drupal connection string/settings is correct ? Apart from that, if the MySQL server at the remote location is accepting connections over TCP/IP and you have the correct MySQL credentials, then all should be good.

This may seem odd, but do you see any anomalies in the web server or PHP error_log ?

jnojr · 07-08-2009, 01:38 PM

Quote:

Originally Posted by eth1

The only thing that comes to mind right now is whether the MySQL Drupal connection string/settings is correct ? Apart from that, if the MySQL server at the remote location is accepting connections over TCP/IP and you have the correct MySQL credentials, then all should be good.

I agree. All should be good. But it isn't.

Quote:

This may seem odd, but do you see any anomalies in the web server or PHP error_log ?

Of course not. Why would anyone want to log useful information that might help someone troubleshoot a problem?

All I know is, it doesn't work, and complete silence. Nobody has the faintest idea why.

I really hate computers sometimes.

ricstirato · 07-13-2009, 03:44 PM

Is there a line like "skip-networking" or "listen 127.0.0.1" in /etc/mysql/my.cnf ?

Try to comment it out and restart mysql

jnojr · 07-13-2009, 06:06 PM

Quote:

Originally Posted by ricstirato

Is there a line like "skip-networking" or "listen 127.0.0.1" in /etc/mysql/my.cnf ?

No.

The problem turned out to be something I should have gone for right off the bat...

Always
Blame
SELinux