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
