I updated my die message on failure to connect to print the mysql_error and mysql_errorno output:
Could not connect : Can't connect to MySQL server on '192.168.1.44' (0) - 2003 Neither is very helpful... ERROR code 2000 to 2999 can be found in the MySQL source code file: `include/errmsg.h' Example: 2003 - Can't connect to MySQL server on 'xxx.example.com' (10060) #define CR_CONN_HOST_ERROR 2003 Any ideas on what to do next? This works as both root and webservd (the user the webserver runs as) : ./mysql -h 192.168.1.44 -u web -p Thanks, Cameron > -----Original Message----- > From: Cameron B. Prince [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 17, 2004 4:55 PM > To: [EMAIL PROTECTED] > Subject: [PHP] PHP On Solaris 9 - MySQL Problem > > Hey guys, > > I'm back again after trying many more things to solve this > problem. If you weren't following the previous thread with > Adam, I moved my site from a single development machine to > the production environment which consists of a separate > webserver and dbserver. At that point, PHP could no longer > connect to MySQL. > > I've started up MySQL on the webserver now and PHP can connect to it. > Something is preventing PHP from connecting to MySQL on the > dbserver though and I have no clue what. I've connected to it > via the mysql client as both root and the webserver user from > the webserver. I've reinstalled the MySQL libraries and > recompiled PHP on the webserver, but no matter what, it still > won't connect to the MySQL on the dbserver. > > Is there some security function in PHP preventing this? > Safe_mode is off, but could there be something else? > > Thanks, > Cameron > > -- > PHP General Mailing List (http://www.php.net/) To > unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
