What happens when you try to use the "mysql" client on the web machine, to connect to the production database server? Does it work? If yes, what lines are you using to connect to your DB with PHP?
On Wed, 2004-03-17 at 14:54, Cameron B. Prince wrote: > Hey guys, > > I've been developing my site on a dev server with MySQL locally installed. > I've now moved the site to the production webserver and setup my databases > on the production dbserver, which are two different machines. > > I have begin updating my connection variables and now I find I can't connect > to the database from within PHP. MySQL is installed on the webserver, but > not running as a daemon. If I run the mysql client and use the -h option, I > can connect to the database with no problems from the webserver. > > I've tried manually specifying the port, tried hostname and ip address, made > sure safe_mode is off and I'm not having any luck. > > I've checked in the phpinfo function and confirmed MySQL support is compiled > in: > > MySQL Support enabled > Active Persistent Links 0 > Active Links 0 > Client API version 4.0.16 > MYSQL_MODULE_TYPE external > MYSQL_SOCKET /tmp/mysql.sock > MYSQL_INCLUDE -I/usr/local/mysql/include > MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient > > Directive Local Value Master Value > mysql.allow_persistent On On > mysql.connect_timeout 60 60 > mysql.default_host no value no value > mysql.default_password no value no value > mysql.default_port no value no value > mysql.default_socket no value no value > mysql.default_user no value no value > mysql.max_links Unlimited Unlimited > mysql.max_persistent Unlimited Unlimited > mysql.trace_mode Off Off > > Can anyone give me ideas to get this working? I must admit, I'm stumped. > > Here's the mysql_error: Can't connect to MySQL server on '192.168.1.44' > > >From the webserver error log: > > php4_execute reports: PHP Warning: mysql_connect(): Can't connect to MySQL > server on '192.168.1.44' (2) > > > > Thanks, > Cameron -- Adam Voigt [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
