MySQL Forums
Forum List  »  Federated Storage Engine

FEDERATED Table over SSL Connection
Posted by: Bruce Cohen
Date: November 15, 2006 02:07PM

Using MySQL 5.0.19. Trying to create a FEDERATED table to implement a MediaWiki extension. The create fails with the message:
ERROR 1429 (HY000): Unable to connect to foreign data source: database: 'test' username: 'root' hostname: 'server2'

The CREATE TABLE commands look like: CREATE TABLE test.fed_test (col1 varchar(255) not null, col2 varchar(255) not null) ENGINE=MyISAM;

On server1, the FEDERATED table CREATE looks like: CREATE TABLE test.fed_test (col1 varchar(255) not null, col2 varchar(255) not null) ENGINE=FEDERATED CONNECTION = 'mysql://root@server1/test/fed_test'

root has full privileges on the database on both servers.

The only thought I've had is that the two systems require SSL to talk to each other. Is this possibly interfering? And if so, how does one get around this?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
FEDERATED Table over SSL Connection
8993
November 15, 2006 02:07PM


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.