FEDERATED Table over SSL Connection
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.
Subject
Views
Written By
Posted
FEDERATED Table over SSL Connection
8993
November 15, 2006 02:07PM
4801
January 28, 2009 07:48PM
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.