Description:
Hi,
I'm trying to migrate from Oracle to MySQL using MySQL Workbench. Configuration:
- Oracle g11 on windows Server 2003 R2 Standard Edition Service Pack 2
- Mysql on OpenSUSE 11.
I have installed MySQL Workbench on Windows machine.
The test connections are successful.
In step "Fetch Schemata List", "Connect to source DBMS" is ok, but "Check target DBMS connection" returns the following error:
Starting...
Connect to source DBMS...
- Connecting to source...
Connection to generic@DRIVER=Oracle;/censured by me/ apparently lost, reconnecting...
Connecting to generic@DRIVER=Oracle;/.../...
Opening ODBC connection to DRIVER=Oracle;/censured by me/;PWD=XXXX...
Connected
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Connecting to Mysql@localhost:3306@/censured by me/:22...
Traceback (most recent call last):
File "C:\Programmi\MySQL\MySQL Workbench 5.2 CE\modules\db_mysql_fe_grt.py", line 137, in connect
con.connect()
File "C:\Programmi\MySQL\MySQL Workbench 5.2 CE\workbench\db_utils.py", line 168, in connect
raise MySQLError(modules.DbMySQLQuery.lastError(), modules.DbMySQLQuery.lastErrorCode(), "%s@%s" % (self.connect_info.parameterValues["userName"], self.connect_info.parameterValues["hostName"]))
workbench.db_utils.MySQLError: Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003)
Connecting to Mysql@localhost:3306@/censured by me/:22...
Traceback (most recent call last):
File "C:\Programmi\MySQL\MySQL Workbench 5.2 CE\modules\db_mysql_fe_grt.py", line 137, in connect
con.connect()
File "C:\Programmi\MySQL\MySQL Workbench 5.2 CE\workbench\db_utils.py", line 168, in connect
raise MySQLError(modules.DbMySQLQuery.lastError(), modules.DbMySQLQuery.lastErrorCode(), "%s@%s" % (self.connect_info.parameterValues["userName"], self.connect_info.parameterValues["hostName"]))
workbench.db_utils.MySQLError: Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003)
Traceback (most recent call last):
File "C:\Programmi\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 66, in run
self.func()
File "C:\Programmi\MySQL\MySQL Workbench 5.2 CE\modules\migration_source_selection.py", line 450, in task_test_target
raise e
SystemError: MySQLError("Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003)"): error calling Python module function DbMySQLFE.connect
ERROR: Error during Check target DBMS connection: MySQLError("Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003)"): error calling Python module function DbMySQLFE.connect
ERROR: Exception in task 'Check target DBMS connection': SystemError('MySQLError("Can\'t connect to MySQL server on \'127.0.0.1\' (10061) (code 2003)"): error calling Python module function DbMySQLFE.connect',)
Failed
Can you help me??
thanks.
How to repeat:
Migrate from Oracle to MySQL using MySQL Workbench. Configuration:
- Oracle g11 on windows Server 2003 R2 Standard Edition Service Pack 2
- Mysql on OpenSUSE 11.