Bug #67918 Error Calling Python module function DbMySQLFE.connect (code 2003)
Submitted: 16 Dec 2012 19:16 Modified: 22 Apr 2013 20:24
Reporter: Malte Meier Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:5.2.44 OS:Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[16 Dec 2012 19:16] Malte Meier
Description:
I'm trying to migrate a SQLExpress-Database to mysql. This Error comes up during "Check target DBMS connection" in the fetch Schemata list dialog.
The MySQL Server is on a RaspberryPi and i'm connecting to it via ssh.
Simply connecting and querying through MySQL Workbench is working fine.

How to repeat:
Try to migrate to a MySQL database conenction through ssh.
[16 Dec 2012 19:17] Malte Meier
Heres the Error-Log as displayed in the message log window:

Starting...

Connect to source DBMS...

- Connecting to source...

Connecting to Mssql@MSSQL10...

Opening ODBC connection to DSN=MSSQL10;DATABASE=;UID=sa;PWD=XXXX...

Connected

Connect to source DBMS done

Check target DBMS connection...

- Connecting to target...

Connecting to Mysql@127.0.0.1:3306@192.168.178.34:22...

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\modules\db_mysql_fe_grt.py", line 137, in connect

    con.connect()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\workbench\db_utils.py", line 169, 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@127.0.0.1:3306@192.168.178.34:22...

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\modules\db_mysql_fe_grt.py", line 137, in connect

    con.connect()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\workbench\db_utils.py", line 169, 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:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\workbench\wizard_progress_page_widget.py", line 65, in run

    self.func()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\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

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\workbench\wizard_progress_page_widget.py", line 543, in update_status

    task.run()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\workbench\wizard_progress_page_widget.py", line 80, in run

    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: 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
[22 Mar 2013 20:24] Armando Lopez Valencia
Hello.
Can you please provide more details about your Raspberry pi environment?
Something Like:
OS:
MySQl Server Version:
Thanks.
[23 Apr 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[8 Mar 2017 4:38] Hayden Radovich
hw

Attachment: Sc4x_GA_screwy_db (3).sql (application/octet-stream, text), 1.04 MiB.