jnojr Posted July 7, 2009 Share Posted July 7, 2009 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. Link to comment https://forums.phpfreaks.com/topic/165099-magic-sauce-to-talk-to-non-local-database/ Share on other sites More sharing options...
fenway Posted July 15, 2009 Share Posted July 15, 2009 You need to make sure "skip-networking" isn't on... and that you're listening & connnecting on the right port, etc. Link to comment https://forums.phpfreaks.com/topic/165099-magic-sauce-to-talk-to-non-local-database/#findComment-875976 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.