MySQL Forums
Forum List  »  PostgreSQL

Re: Postgresql -> MySql: Empty Schema Selection
Posted by: Daniel Roß
Date: March 07, 2013 05:10AM

Hi Sergio,

1) MySQL Workbench 5.2.47 CE

2) Full privileges

3)


12:02:41 [ERR][ Workbench]: Console redirection failed.
12:02:41 [INF][ WBContext]: Parsing application arguments.
12:02:41 [INF][ WBContext]: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\MySQLWorkbench.exe
12:02:41 [INF][ Workbench]: Starting up Workbench
12:02:41 [INF][ Workbench]: Current environment:
Command line: "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\MySQLWorkbench.exe"
CurrentDirectory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
HasShutdownStarted: False
OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
SystemDirectory: C:\Windows\system32
TickCount: 3147734
UserInteractive: True
Version: 4.0.30319.296
WorkingSet: 29196288
12:02:41 [INF][ Workbench]: Environment variables:
Path = C:\Program Files (x86)\MiKTeX 2.9\miktex\bin;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Graphviz 2.28\bin
TEMP = C:\Users\daniel\AppData\Local\Temp
SESSIONNAME = Console
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
USERDOMAIN = daniel-PC
PROCESSOR_ARCHITECTURE = x86
ProgramW6432 = C:\Program Files
APPDATA = C:\Users\daniel\AppData\Roaming
windir = C:\Windows
LOCALAPPDATA = C:\Users\daniel\AppData\Local
CommonProgramW6432 = C:\Program Files\Common Files
windows_tracing_flags = 3
windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
TMP = C:\Users\daniel\AppData\Local\Temp
USERPROFILE = C:\Users\daniel
ProgramFiles = C:\Program Files (x86)
CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
FP_NO_HOST_CHECK = NO
HOMEPATH = \Users\daniel
COMPUTERNAME = DANIEL-PC
ProgramData = C:\ProgramData
PROCESSOR_ARCHITEW6432 = AMD64
USERNAME = daniel
NUMBER_OF_PROCESSORS = 8
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 30 Stepping 5, GenuineIntel
SystemRoot = C:\Windows
ComSpec = C:\Windows\system32\cmd.exe
LOGONSERVER = \\DANIEL-PC
ProgramFiles(x86) = C:\Program Files (x86)
SystemDrive = C:
CommonProgramFiles = C:\Program Files (x86)\Common Files
PROCESSOR_LEVEL = 6
PROCESSOR_REVISION = 1e05
PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
ALLUSERSPROFILE = C:\ProgramData
PUBLIC = C:\Users\Public
OS = Windows_NT
HOMEDRIVE = C:
12:02:41 [INF][ Workbench]: Current version given by meta info is: 5.2.47
12:02:41 [INF][ Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files (x86)\MiKTeX 2.9\miktex\bin;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Graphviz 2.28\bin
12:02:41 [INF][ mforms managed]: Initializing mforms wrapper
12:02:42 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
plugin path: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
struct path:
module path: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules
library path: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
user data dir: C:\Users\daniel\AppData\Roaming\MySQL\Workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
12:02:42 [INF][ WBContext]: WbContext::init
12:02:42 [INF][ grt]: Scanning module directory C:\Users\daniel\AppData\Roaming\MySQL\Workbench\modules.
12:02:42 [INF][ grt]: Scanning module directory ..
12:02:42 [INF][ ]: Trying to load module '.\db.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\db.mysql.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\db.mysql.query.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\db.mysql.sqlide.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\db.mysql.sqlparser.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\forms.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\wb.model.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\wb.mysql.import.grt.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module '.\wb.utils.native.grt.dll' (cpp)
12:02:42 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules.
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\catalog_utils.grt.lua' (lua)
12:02:42 [INF][ ]: Initialized Lua module C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\catalog_utils.grt.lua (WbUtils)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\code_utils_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_copy_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_generic_migration_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_generic_re_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_mssql_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_mssql_migration_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_mysql_fe_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_mysql_migration_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_mysql_re_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_postgresql_migration_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_postgresql_re_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_sql92_migration_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_sql92_re_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_sybase_migration_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\db_sybase_re_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\migration_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\sqlide_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\table_utils_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\text_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\wb_admin_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\wb_bug_report_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\wb_dev_utils_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\wb_doclib_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\wb_query_analysis_grt.py' (python)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/modules\wb_utils_grt.py' (python)
12:02:42 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE.
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\db.mysql.diff.reporting.wbp.dll' (cpp)
12:02:42 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\db.mysql.editors.wbp.be.dll' (cpp)
12:02:43 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\db.mysql.wbp.dll' (cpp)
12:02:43 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\wb.model.editors.wbp.be.dll' (cpp)
12:02:43 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\wb.model.snippets.wbp.dll' (cpp)
12:02:43 [INF][ ]: Trying to load module 'C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\wb.printing.wbp.be.dll' (cpp)
12:02:43 [INF][ WBContext]: System info:
MySQL Workbench CE for Windows version 5.2.47 revision 10398
Configuration Directory: C:\Users\daniel\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit
CPU: 8x Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz, 8.0 GiB RAM
Active video adapter NVIDIA GeForce GTX 470
Installed video RAM: 1280 MB
Current video mode: 1680 x 1050 x 4294967296 Farben
Used bit depth: 32
Driver version: 9.18.13.1070
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: Deutsch (Deutschland)

12:02:43 [INF][ Workbench]: UI is up
12:02:43 [INF][ Workbench]: Running the application
12:05:16 [INF][ grt]: Connecting to postgresql@DRIVER=PostgreSQL Unicode;SERVER=<hereip>;PORT=5432...
12:05:16 [INF][ grt]: Opening ODBC connection to DRIVER=PostgreSQL Unicode;SERVER=<hereip>;PORT=5432;DATABASE=pmsdb;UID=postgres...
12:05:16 [ERR][ python]: error calling DbPostgresqlRE.connectTraceback (most recent call last):
12:05:16 [ERR][ python]: File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_postgresql_re_grt.py", line 282, in connect
12:05:16 [ERR][ python]: return PostgresqlReverseEngineering.connect(connection, password)
12:05:16 [ERR][ python]: File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_postgresql_re_grt.py", line 38, in connect
12:05:16 [ERR][ python]: r = super(PostgresqlReverseEngineering, cls).connect(connection, password)
12:05:16 [ERR][ python]: File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 122, in connect
12:05:16 [ERR][ python]: con = db_driver.connect(connection, password)
12:05:16 [ERR][ python]: File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\workbench\db_driver.py", line 91, in connect
12:05:16 [ERR][ python]: connection = library.connect(connection_string, password=password)
12:05:16 [ERR][ python]: pyodbc.Error: ('HY000', '[HY000] A password is required for this connection. (112) (SQLDriverConnect)')
12:05:16 [INF][ grt]: Connecting to postgresql@DRIVER=PostgreSQL Unicode;SERVER=<hereip>;PORT=5432...
12:05:16 [INF][ grt]: Opening ODBC connection to DRIVER=PostgreSQL Unicode;SERVER=<hereip>;PORT=5432;DATABASE=pmsdb;UID=postgres...
12:05:16 [INF][ grt]: Connected
12:05:16 [INF][ PostgreSQL RE]: Connected to , PostgreSQL 8.4.16 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bitConnected to , PostgreSQL 8.4.16 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bitExecute 'Connect to source DBMS'
12:05:37 [INF][ PostgreSQL RE]: Connected to , PostgreSQL 8.4.16 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bitExecute 'Check target DBMS connection'
12:05:37 [INF][ grt]: Connecting to Mysql@<hereip>:3306...
12:05:37 [INF][ grt]: Connecting to Mysql@<hereip>:3306...
12:05:38 [INF][ grt]: Connected
12:05:38 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source'
12:05:38 [INF][ PostgreSQL RE]: Connected to , PostgreSQL 8.4.16 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bit



Thank you for helping! :)

Best Regards,
Daniel

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Postgresql -> MySql: Empty Schema Selection
1118
March 07, 2013 05:10AM


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.