MySQL Forums
Forum List  »  Federated Storage Engine

Federated Table issue
Posted by: zaeem sherazi
Date: May 25, 2010 08:18AM

Dear All,

I am using MySQL 5.1.46 and I have created following server and federated table,

CREATE SERVER s1
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'root', PASSWORD 'root123',HOST '192.178.0.187', PORT 3306, DATABASE 'test');



drop table if exists test_table;
CREATE TABLE test_table (
id INT(20) NOT NULL AUTO_INCREMENT,
name VARCHAR(32) NOT NULL DEFAULT '',
other INT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
INDEX name (name),
INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='s1/test_table';


Now when I am going to insert data into test_table I got error "[Err] 1429 - Unable to connect to foreign data source: Can't connect to MySQL server on '192.178.0.187' (113)". The table is created on host 192.168.0.187 and federated table is created on Host: 192.168.0.122 and I can easily connect to mysql running .187 server from .122 server.

Please let me know what I am doing wrong which causing this error? Is there anything wrong with create server command.

Any help would be greatly appreciated.

Regards,

Shirazi

Options: ReplyQuote


Subject
Views
Written By
Posted
Federated Table issue
6556
May 25, 2010 08:18AM


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.