Re: mysql_select_db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 20 Oct 2008, at 13:03, Stan wrote:
UBUNTU Server v8.04
On a web page:

CODE:
require_once 'frames_includes/navigationDB.inc';
$navigation_connection = mysql_connect($navigation_hostName,
                                      $navigation_userName,
                                      $navigation_passWord)
 or
die("Failed to connect to MySQL on the nasServer ... call Stan");
mysql_select_db($navigation_databaseName,$navigation_connection)
 or
die("Selection of 'navigation' database failed ... call Stan");
$navigation_data = mysql_query("SELECT * FROM " .
                       $navigation_databaseName . ".navigate " .
                       "ORDER BY navigateHandle",
                       $navigation_connection)
 or
die("SELECT * FROM navigate table failed ... call Stan");
END CODE:

works when the UBUNTU server is attached to the same subnet as the MySQL
server.

If I move the UBUNTU server to a different subnet (through an ipCop
machine), making appropriate adjustments to network configuration, including punching a hole in the firewall for port 3306 from the UBUNTU server to the
MySQL server and authorizing the user at the new IP to MySQL, the
mysql_connect works but the mysql_select_db fails.

I need help debugging this, please?

MySQL permissions are tied to IP or hostname as well as username and password. Sounds like the user you're connecting as has different permissions when it comes from a different subnet. Check the MySQL manual for detailed info on permissions.

-Stut

--
http://stut.net/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux