| Bug #15278 | Such tool seemed like based on conector/J. | ||
|---|---|---|---|
| Submitted: | 28 Nov 2005 2:14 | Modified: | 10 Jan 2006 11:29 |
| Reporter: | xi xin | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Migration Toolkit | Severity: | S3 (Non-critical) |
| Version: | 1.0.20rc | OS: | Windows (Microsoft Windows Server 2003SP1) |
| Assigned to: | CPU Architecture: | Any | |
[28 Nov 2005 2:14]
xi xin
[28 Nov 2005 5:05]
Jorge del Conde
Hi! Can you tell me exactly how you reproduced this bug ? Thanks
[1 Dec 2005 11:53]
Valeriy Kravchuk
Bug #15278 was marked as a duplicate of this one. Coming back to your real problem, can you, please, try to connect to your SQL Server using the same user and password as in your connection string: jdbc:jtds:sqlserver://192.168.3.100:1433/masterwork;user=sa;password=sa but with some MS SQL tool? Are you sure your MS SQL user has enough permissions to select all the schema names?
[1 Dec 2005 11:54]
Valeriy Kravchuk
Sorry, bug #15279 marked as a duplicate of this one.
[2 Dec 2005 1:38]
xi xin
In fact, I less using fake SQLSERVER2000. Recently, I put all my notice to mysql_server and MAXDB, to find a real solution to tade DB, cheap and safe. So, how to use SQLSERVER in high standard, there puzzle me most.
[2 Dec 2005 7:46]
Valeriy Kravchuk
Please, describe exactly what shell I do to repeat the problem you described, if any. It is nice to know that you are using MySQL and MaxDB, but in frames of this bug report we need a repeatable sequence of steps taht leads to the situation that looks like a "bug" to you. I do not understand anything about these steps from your bug report. Do you really want MySQL to fix something? Then describe, what should be fixed.
[9 Dec 2005 8:19]
xi xin
How to decrib the steps. The situations like following: There is a DB in SQLServer_v8.0(2000), name is 'masterwork', I had to trasfer it to mysqlserver, so had to using [MySQL Migration Toolkit 1.0.20rc], I do the steps like the flash at [http://www.mysql.com/products/tools/migration-toolkit/tutorials/migrate-sql-server.html], so the error occupented as #15278.
[9 Dec 2005 10:25]
Aleksey Kishkin
xi xin, sorry, didn't catch, why did you change the category to DBD::mysql? dbd::mysql is a perl module for access to mysql from perl. Do you use perl?
[10 Dec 2005 2:40]
xi xin
I think this BUG occupted at Migration Toolkit. And in fact, I need it, and it seemed like a quit wouldful tool for migrating Database form other DB to MysqlServer. The processure seemed like this: There is an OA system based on SQLServer2000, and if updating to SQLServer2005, the fee is not permitted.The fouce is at MySQLServrer, and I could not find another solution could beyond it, and Migration Toolkit seemed like a such excellent tool for migrating DB from SQLServer to MySQLserver. I download one and operating step and step as the trainning flash, but the resolutes is as #15278. Just soso, nothing else, I still not find another way to transfer DB smoothly without such a tool. That is all I could say.
[10 Dec 2005 5:50]
xi xin
It seemed quit strange, The error ocuppent at such step message changed. -------------------------------------------------------------------------------- Connecting to source database and retrieve schemata names. Initializing JDBC driver ... Driver class MS SQL JDBC Driver Opening connection ... Connection jdbc:jtds:sqlserver://192.168.3.10:1433/masterwork;user=sa;password=sa Fetching schemata list. SELECT TABLE_SCHEMA AS SCHEMANAME, max(TABLE_CATALOG) AS CATALOGNAME FROM INFORMATION_SCHEMA.TABLES GROUP BY TABLE_SCHEMA UNION SELECT ROUTINE_SCHEMA AS SCHEMANAME, max(ROUTINE_CATALOG) AS CATALOGNAME FROM INFORMATION_SCHEMA.ROUTINES GROUP BY ROUTINE_SCHEMA Return schemata list. Schemata names retrieved successfully. Initializing JDBC driver ... Driver class MySQL JDBC Driver 3.1 Opening connection ... Connection jdbc:mysql://192.168.3.10:3306/?user=root&password=toor&useServerPrepStmts=false The connection to the target database could not be established (error: 0). ReverseEngineeringMysqlJdbc.getVersion :null, message from server: "Host 'yinghui-u4zhgqb' is not allowed to connect to this MySQL server" Details: com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:990) com.mysql.jdbc.Connection.createNewIO(Connection.java:2544) com.mysql.jdbc.Connection.<init>(Connection.java:1474) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264) java.sql.DriverManager.getConnection(Unknown Source) java.sql.DriverManager.getConnection(Unknown Source) com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source) com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(Unknown Source) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) com.mysql.grt.Grt.callModuleFunction(Unknown Source) -------------------------------------------------------------------------------- Good save me, give me a hand.
[10 Dec 2005 5:59]
xi xin
Dear sir: The Administrator_1.0.22a is based on API, Why such tool seemed like based on conector/J.I think such application tool must depend on API, would be efficiently, powerful, safely, executing sooner. Such way must be efficient at development or suitable for RAD???
[10 Dec 2005 11:29]
Valeriy Kravchuk
Now your problem with migration is clearly described in the error message: "Host 'yinghui-u4zhgqb' is not allowed to connect to this MySQL server". You have to grant permissions to the root user when connecting from yinghui-u4zhgqb host. Please, do it and try to perform your migration once more. As for your ideas about how tools should be implemented (using Java, or using C API etc.), you may add a separate feature request and describe any tool you want. Our Migration Tollkit now works just as it works. It uses Java.
[11 Jan 2006 0: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".
[13 Jun 2006 3:03]
Mags Ingval
Well, I'm getting the same thing out of an Access DB... posted in forums...but this is the closest thing I've seen approaching help. Connecting to source database and retrieve schemata names. Create a dummy schema list because Access only has one schema for each file. Return schemata list. Schemata names retrieved successfully. Initializing JDBC driver ... Driver class MySQL JDBC Driver 3.1 Opening connection ... Connection jdbc:mysql://127.0.0.1:3306/?user=root&password=obtusepw&useServerPrepStmts=false The connection to the target database could not be established (error: 0). ReverseEngineeringMysqlJdbc.getVersion :URLDecoder: Incomplete trailing escape (%) pattern Details: java.net.URLDecoder.decode(Unknown Source) com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:479) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:261) java.sql.DriverManager.getConnection(Unknown Source) java.sql.DriverManager.getConnection(Unknown Source) com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source) com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(Unknown Source) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) com.mysql.grt.Grt.callModuleFunction(Unknown Source)
[13 Nov 2006 19:41]
Cory Sougstad
To get this error I am going from a local mssql 2000 db to a godaddy linux mysql server. I have a feeling it has something to do with permissions, but I'm using my root login (as far as I can tell). Simple passwords dosent help. Same problem with any of my godaddy hosting databases.
[23 Feb 2007 4:38]
brooke riggio
I had this same error, but it was corrected when i removed the '%' from my password. I had to create a new user (copied existing with new name, new pass, and localhost permissions), and completely restart the migration process. hope that helps!
[15 Jun 2007 14:55]
Daniel Emord
I am having this problem as well on Windows XP SP2. I installed XAMPP Lite 1.6.2 (from Apache Friends) which contains MySQL version 5.0.41-community-nt server. I then installed JDK 6u1 and tried to use the MySQL migration tool zip, and I get the same error (shown below). I have changed root to require password and to log in from any host (even though it's on the local host). I can log in with other utilities (including mysql query browser), but this tool just refuses. It's not permissions. If any more information is needed, please let me know. Thanks. Error: Connecting to source database and retrieve schemata names. Create a dummy schema list because Access only has one schema for each file. Return schemata list. Schemata names retrieved successfully. Initializing JDBC driver ... Driver class MySQL JDBC Driver 5.0 Opening connection ... Connection jdbc:mysql://localhost:3306/?user=root&password=censored&useServerPrepStmts=false&characterEncoding=UTF-8 The connection to the target database could not be established (error: 0). ReverseEngineeringMysqlJdbc.getVersion :Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property. Details: com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345) com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913) com.mysql.jdbc.Connection.createNewIO(Connection.java:2683) com.mysql.jdbc.Connection.<init>(Connection.java:1531) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) java.sql.DriverManager.getConnection(Unknown Source) java.sql.DriverManager.getConnection(Unknown Source) com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141) com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(ReverseEngineeringGeneric.java:161) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) com.mysql.grt.Grt.callModuleFunction(Unknown Source)
