RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-19 Thread trlists
On 18 Mar 2004 Cameron B. Prince wrote: > I'm saying I can't connect to another machine running 3.x or 4.x from PHP, > but I can connect to either via the v4.x mysql command line client that's > installed on the webserver with PHP. OK, I get it. It certainly sounds like it could be a problem wit

RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-18 Thread Cameron B. Prince
> > I just finished doing that on a third machine that didn't have a > > previous MySQL installation. I installed the same version that the > > webserver has. I had the same results. > > I'm losing track here -- are you saying you can't connect to > another machine running MySQL 3.x from PHP b

RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-18 Thread trlists
On 18 Mar 2004 Cameron B. Prince wrote: > I just finished doing that on a third machine that didn't have a previous > MySQL installation. I installed the same version that the webserver has. I > had the same results. I'm losing track here -- are you saying you can't connect to another machine ru

RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-18 Thread Cameron B. Prince
Hi Tom, > > Ah, that's good. Then it is just a problem of MySQL. > > Have you tried accessing a remote machine running MySQL 3.2x > instead of 4.0? That seems like an obvious potential culprit. I just finished doing that on a third machine that didn't have a previous MySQL installation. I in

RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-18 Thread trlists
On 18 Mar 2004 Cameron B. Prince wrote: > I'm sure this is good to know because it proves at least part of PHP can > reach the other machine... Which hopefully rules out a TCP/IP problem. I'm > going to enable debugging on the MySQL server and see if that tells me > anything. Ah, that's good. Th

RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-18 Thread Cameron B. Prince
Hi Tom, This was a good idea... > You might try an fsockopen() to port 3306 on the dbserver and > see if it works. If not, you get a reasonably descriptive error. > > I just tried a couple of known servers and bogus addresses with this > code: > > $ipaddr = "localhost"; # substitute the IP

RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-17 Thread trlists
You might try an fsockopen() to port 3306 on the dbserver and see if it works. If not, you get a reasonably descriptive error. I just tried a couple of known servers and bogus addresses with this code: A server listening on that port produces: resource(4) of type (stream) string(0)

RE: [PHP] PHP On Solaris 9 - MySQL Problem

2004-03-17 Thread Cameron B. Prince
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' Exa