MySQL Forums
Forum List  »  Federated Storage Engine

Server accepting remote connections but not from federated tables (1429)
Posted by: Pedro Ten
Date: October 27, 2010 09:04AM

Hello,

ERROR 1429 (HY000): Unable to connect to foreign data source: Can't connect to MySQL server on 'remotehost' (13)


I'm getting this error when trying to select data from a federated table.
The local server connects successfully to other federated tables on different servers, but this one is not working.

I can successfully connect from the local server to the remote server via

mysql -u myuser -p -h remotehost -P 33306 (Yes, that's the port I'm using)

The ENGINE statement on the CREATE TABLE looks like this:
ENGINE=FEDERATED
CONNECTION='mysql://myuser:mypass@remotehost:33306/remotedb/remotetable'

Any clue? looks like accepts connections but not from federated tables...

Thanks in advance!

Options: ReplyQuote


Subject
Views
Written By
Posted
Server accepting remote connections but not from federated tables (1429)
6771
October 27, 2010 09:04AM


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.