MySQL Forums
Forum List  »  Federated Storage Engine

Unable to connect to foreign data source
Posted by: Juan Nino
Date: December 06, 2012 06:58PM

I have set the federated table successfully however when I try to query the federated table I have the following error

select i_account from Accounts;
ERROR 1429 (HY000): Unable to connect to foreign data source: Can't connect to MySQL server on '203.160.8.116' (13)

I have checked the auth details and they are correct. I have actually connected to the remote server using
mysql -u`user` -p`password `database` -h `host` -P`port`
from the linux console to confirm I have the right details
I have put a tcpdump in the local server to see if it sends any packet to the remote server when I execute the select query and it does not.

I have tried setting up the federated table using the full string in the connection attribute of the table and also with the create server command, both have the same unsuccessful result. do you have any ideas on what can I try next?

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to connect to foreign data source
5875
December 06, 2012 06:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.