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

[Steve Winter]

I think the point Jonathan is trying to make is the it's not supposed to connect to the exit445 server but to another one...!

Jonathan, it's late here, but I have a funny feeling that my.cnf might have something to do with this...??...

Cheers
Steve


On 7 Jun 2010, at 22:25, Dale Bengston wrote:

> Yes, it's making the connection, and the MySQL server is denying access for that username at exit445.com, presumably because there is no such user defined at exit445.com.
> 
> What tool are you using to manage MySQL on the two servers? If you pop up the user management for each, I think this will make more sense. The exit445.com MySQL has a user set up to make connections to itself from its own IP, but it does not have a user set up to accept connections from another external server.
> 
> Am I making this worse? It's been a long day. I stopped making sense a couple hours ago.
> 
> Dale
> 
> On Jun 7, 2010, at 3:52 PM, Jonathan Schwartz wrote:
> 
>> Thanks, Dale.
>> 
>> This assumes that the query is actually hitting the remote server and failing.
>> 
>> The error message suggests that the query is being directed to the local server, not the remote server.
>> 
>> Still scratching my head.
>> 
>> Jonathan
>> 
>> 
>> 
>>> Hi Jonathan,
>>> 
>>> There has to be a MySql user on the live site that will accept requests from your IP address or domain. Generally, this is pretty locked-down and you have to add the proper user account.
>>> 
>>> Hope this helps,
>>> Dale
>>> 
>>> 
>>> 
>>> On Jun 7, 2010, at 11:20 AM, Jonathan Schwartz wrote:
>>> 
>>>> 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
>>> 
>>> 
>>> _______________________________________________
>>> 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
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

Steve Winter
steve at bluecrocodile.co.nz
m: +44 77 7852 4776
3 Calshot Court, Channel Way
Ocean Village, Southampton SO14 3GR

I ran the London Marathon to raise money for UK Youth. You can still sponsor me here.

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