[FX.php List] Trouble connecting to remote mySQL DB

[David Ness]

>> I previously did this in FileMaker, but if FileMaker is down, it can
not report on itself.

 

Actually, I do this on may pages:

 

 

// Check to see if the FileMaker server is up and running

if( !fsockopen ($serverIP, 80, $errno, $errstr, 2) )        {

                $serverUp = false;

} else {

                $serverUp = true;

}

 

 

if( $serverUp == true ) {...

 

 

David Allen Ness

Database Systems Administrator

Web Applications Developer

 

 

________________________________

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jonathan
Schwartz
Sent: Monday, June 07, 2010 12:21 PM
To: fx.php_list at mail.iviking.org
Subject: [FX.php List] Trouble connecting to remote mySQL DB

 

Sorry for the off topic post.

 

Some background...This is my one foray into mysql, where I'm using a
mysql db on a client's primary website as a way to control web traffic
to two other servers, where FileMaker Web Publihsing is running.  In
short, the mysql db has just 10 records, providing location and status
of the various processes offered on the FieMaker servers.  We use it to
put up "We'll be right back" signs when maintenance is being performed,
among other things.

 

I previously did this in FileMaker, but if Fileaker is down, it can not
report on itself.

 

To the problem.  While I can perform mysql_connect from a php page on
the www site, I can not connect up  to mysql from a php page located on
the remote server.  I get the following error:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for
user '[USER]'@'exit445.com' (using password: YES) in
/Library/WebServer/Documents/..........opendb.php on line 4

Error connecting to mysql

 

 

This is being run from my server (exit445.com), attempting to talk to
the remote server.  You can see that php is actually trying to talk to
the host "exit445.com" instead. even though the the mysqlconnect command
explicitly identifies the remote server as host (not exit445.com) . No
matter what I do, the mysqlconnect command attempts to talk to
exit445.com.

 

I did check with the www host and there is no restriction from accepting
remote quieries.

 

Assuming I understand what is happening, how do I convince php/OS X
Server to talk with the remote server instead of the localhost?

 

Thx

 

Jonathan

-- 

Jonathan Schwartz

Exit 445 Group

jonathan at exit445.com

http://www.exit445.com

415-370-5011

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100607/dce5b2d9/attachment.html