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

[Jonathan Schwartz]

Thanks David,

Fact is, it's not just FileMaker that could be 
down: IIS, Windows, the Machine, the AC power, 
the inside network, the Internet 
connection....all of which have gone down from 
time to time.  That is why I am using external 
MySQL db at the WWW web hosting site to act as 
the "always available" resource to control 
traffic to remote servers.

I'm at the point where I need to be able for the 
remote server (hosted at exit445.com)to talk to 
the mySQL db at the main WWW site.

The question is: Why is my server ignoring the 
host address for the mysql host and inserting the 
local (exit445.com) one?

Jonathan

At 1:05 PM -0400 6/7/10, David Ness wrote:
>Content-class: urn:content-classes:message
>Content-Type: multipart/alternative;
>	boundary="----_=_NextPart_001_01CB0663.92CD7A6A"
>
>  >> 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
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 
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/bd4f1fef/attachment-0001.html