Jim & Sara Feldman wrote:
Hi:
I have recently upgraded from a Mac G4 running OS 10.3.9 to a G5
running OS 10.4. I ported a working PHP app and upgraded from PHP 4.3.4
to 4.3.10 and MySQL 4.0.17 to 4.1.11. I am having a problem connecting
to MySQL from PHP.
I can connect to the datab
On Tue, May 24, 2005 2:14 pm, Jim & Sara Feldman said:
> $result = mysql_pconnect("localhost", "api_user", "97533");
if (!$result) die(mysql_error());
Try it without the 'p' in pconnect, which you probably aren't using in the
other connections in your testing.
--
Like Music?
http://l-i-e.
> I would think the mysqlclient library would be backwards
> compatible, but it's possible I guess. I'm kind of out of
> ideas, as the can't connect error without something like a
> bad username or password message, seems to indicate a TCP/IP
> communication failure.
Well, after thinking more
I would think the mysqlclient library would be backwards compatible, but
it's possible I guess. I'm kind of out of ideas, as the can't connect
error without something like a bad username or password message, seems
to indicate a TCP/IP communication failure.
On Wed, 2004-03-17 at 15:26, Cameron B.
> What does your MySQL error log say on your production database server?
> It should be in the "var" directory named something ".err".
These are SunFire 210 Solaris boxes. The MySQL is installed from binary. It
doesn't write a log by default as best I can tell, but I did find something.
The MySQ
What does your MySQL error log say on your production database server?
It should be in the "var" directory named something ".err".
On Wed, 2004-03-17 at 15:16, Cameron B. Prince wrote:
> > Change your server address, to leave off the port number.
> >
> > Any different?
>
> $DBhost = "192.168.1.
> Change your server address, to leave off the port number.
>
> Any different?
$DBhost = "192.168.1.44";
$DBuser = "web";
$DBpwd = "user";
$DBreg = "registration";
$DBconf = "config";
# setup database handle and load configuration data
$dbh = mysql_connect($DBhost, $DBuser, $DBpwd)
or die(
Change your server address, to leave off the port number.
Any different?
On Wed, 2004-03-17 at 15:07, Cameron B. Prince wrote:
> > So what error prints out when you try and connect from PHP?
>
> Could not connect : Can't connect to MySQL server on '192.168.1.44' (2)
>
> Not very helpful huh?
>
> So what error prints out when you try and connect from PHP?
Could not connect : Can't connect to MySQL server on '192.168.1.44' (2)
Not very helpful huh?
Any ideas?
Cameron
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
So what error prints out when you try and connect from PHP?
On Wed, 2004-03-17 at 15:03, Cameron B. Prince wrote:
> Hi Adam,
>
> > What happens when you try to use the "mysql" client on the
> > web machine, to connect to the production database server?
>
> It works:
>
> bash-2.05# pwd
> /usr
Hi Adam,
> What happens when you try to use the "mysql" client on the
> web machine, to connect to the production database server?
It works:
bash-2.05# pwd
/usr/local/mysql/bin
bash-2.05# ./mysql -h 192.168.1.44 -u web -P 3306 -p
Enter password:
Welcome to the MySQL monitor. Commands end wit
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
12 matches
Mail list logo
