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
> -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

[PHP] PHP On Solaris 9 - MySQL Problem

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