Robbert van Andel wrote:
Our MySql server is an established server that I can successfully connect to
from other web servers. When I run my php script I see no attempt made to
connect to the mysql server but do see the attempt and subsequent activity
when connecting via the command line.
-----Original Message-----
From: Mark Bomgardner [mailto:mbomgardner@xxxxxxxxx]
Sent: Wednesday, September 10, 2008 2:46 PM
To: 'Robbert van Andel'
Subject: RE: New Server Install
Ok, then a couple of things to check. Even though you can login through the
command line, when you set up MySQL is your host name the same as the host
you are trying to connect from. When you log in through the command line,
you may be logging in from the "localhost" whereas when you login from your
webpage, you are trying to login from your web server host name. This may
be something you want to check.
Log in to your mysql server from the command line, switch to the Mysql
datasbase and run SELECT * FROM user\G this will give you a readable print
of your users.
markb
-----Original Message-----
From: Robbert van Andel [mailto:robbert@xxxxxxxxx]
Sent: Wednesday, September 10, 2008 4:40 PM
To: mbomgardner@xxxxxxxxx
Subject: RE: New Server Install
That didn't work :(. Thanks though.
Robbert
-----Original Message-----
From: Mark Bomgardner [mailto:mbomgardner@xxxxxxxxx]
Sent: Wednesday, September 10, 2008 2:19 PM
To: 'Robbert van Andel'
Subject: RE: New Server Install
Robbert:
I have had the same thing happen, but it gets fixed with a computer reboot.
Not sure why, but I have had this happen on a couple of boxes.
markb
-----Original Message-----
From: Robbert van Andel [mailto:robbert@xxxxxxxxx]
Sent: Wednesday, September 10, 2008 4:13 PM
To: php-general@xxxxxxxxxxxxx
Subject: New Server Install
I am working on a new webserver running Fedora 9. I installed php-mysql and
php-mssql via yum. When I try to connect to our mysql server using php, I
get the following error: Can't connect to MySQL server on 'mysqlservername'
(13)
Here's the weird part, I can connect to the mysql database server just fine
from the web server's command line so I'm pretty confident that it's not a
firewall issue. While trying to connect using PHP, I see no packets leaving
the webserver.
Any thoughts?
Thanks,
Robbert
i hate to say such basics; but looks like you have the server defined in
a config.php or the like as something similar to:
$db['server'] = 'mysqlservername';
and it needs changed to local host..
have you tried just doing a very very basic mysql_connect()
also check php.ini ; you may ahve the defaults set up in there incorrectly..
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
