Thread: BUG #5015: MySQL migration wizard does not start

BUG #5015: MySQL migration wizard does not start

From
"Ken Smith"
Date:
The following bug has been logged online:

Bug reference:      5015
Logged by:          Ken Smith
Email address:      kensmith@adobe.com
PostgreSQL version: 8.4
Operating system:   Windows
Description:        MySQL migration wizard does not start
Details:

I have downloaded and installed PostgreSQL 8.4 and installed the mysql
migration wizard.  I click the shortcut and nothing happens.  I also noted
that if I try to run from the commandline that you use '/' in some of the
program paths causing the OS to say it cannot find the file - "C:/Program
Files/Java/jdk1.5.0_16/jre/bin/java.exe".  Additionally the whole command is
too long for the shortcut properties and is cut off.

If I setup a shorter path using 8.3 notation, I still get nothing.

Re: BUG #5015: MySQL migration wizard does not start

From
Jaime Casanova
Date:
On Wed, Aug 26, 2009 at 9:55 AM, Ken Smith<kensmith@adobe.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A05015
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Ken Smith
> Email address: =C2=A0 =C2=A0 =C2=A0kensmith@adobe.com
> PostgreSQL version: 8.4
> Operating system: =C2=A0 Windows
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0MySQL migration wizard does not s=
tart
> Details:
>
> I have downloaded and installed PostgreSQL 8.4 and installed the mysql
> migration wizard.

MySQL migration wizard is a tool from EnterpriseDB
(http://www.enterprisedb.com), you should go ask them...

--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Re: BUG #5015: MySQL migration wizard does not start

From
Sam Mason
Date:
On Wed, Aug 26, 2009 at 02:55:37PM +0000, Ken Smith wrote:
> I also noted
> that if I try to run from the commandline that you use '/' in some of the
> program paths causing the OS to say it cannot find the file - "C:/Program
> Files/Java/jdk1.5.0_16/jre/bin/java.exe".

I'm pretty sure that Windows has known about forward slashes being path
delimiters since Windows 95 and the start of Win32.  I know I normally
use forward slashes in XP when I'm at work!

--
  Sam  http://samason.me.uk/

Re: BUG #5015: MySQL migration wizard does not start

From
John R Pierce
Date:
Sam Mason wrote:
> On Wed, Aug 26, 2009 at 02:55:37PM +0000, Ken Smith wrote:
>
>> I also noted
>> that if I try to run from the commandline that you use '/' in some of the
>> program paths causing the OS to say it cannot find the file - "C:/Program
>> Files/Java/jdk1.5.0_16/jre/bin/java.exe".
>>
>
> I'm pretty sure that Windows has known about forward slashes being path
> delimiters since Windows 95 and the start of Win32.  I know I normally
> use forward slashes in XP when I'm at work!
>


they work in the APIs but not in the CMD command line shell, as it
expects / to be the command option seperrator (much as - is used in
Unix-like systems)

Re: BUG #5015: MySQL migration wizard does not start

From
Craig Ringer
Date:
On Wed, 2009-08-26 at 12:52 -0700, John R Pierce wrote:
> Sam Mason wrote:
> > On Wed, Aug 26, 2009 at 02:55:37PM +0000, Ken Smith wrote:
> >
> >> I also noted
> >> that if I try to run from the commandline that you use '/' in some of the
> >> program paths causing the OS to say it cannot find the file - "C:/Program
> >> Files/Java/jdk1.5.0_16/jre/bin/java.exe".
> >>
> >
> > I'm pretty sure that Windows has known about forward slashes being path
> > delimiters since Windows 95 and the start of Win32.  I know I normally
> > use forward slashes in XP when I'm at work!
> >
>
>
> they work in the APIs but not in the CMD command line shell, as it
> expects / to be the command option seperrator (much as - is used in
> Unix-like systems)

That's very program specific - it's part of the program's command line
parsing and argument processing, not cmd.exe / CreateProcess(...)'s
handling of the command line arguments.

Most Windows utilities, including command-line tools, handle
forward-slash paths quite fine. It's just a few nasty old DOS-like ones
that're a problem ... but that does include many of the basic cmd.exe
built-in commands :-(

--
Craig Ringer

Re: BUG #5015: MySQL migration wizard does not start

From
Ashesh Vashi
Date:
Hi Ken Smith,

We found that - the jar files, we packaged with the installers are
corrupted.
Please find the set of jar files as a zip @
http://uploads.enterprisedb.com/download.php?file=86fb5b8e777761f63c7d27525d2616f6.

Replace them with existing MigrationWizard.jar and lib folder found
under installation directory.

Hope this helps you.

--
Thanks & Regards,
Ashesh Vashi

EnterpriseDB INDIA - www.enterprisedb.com <http://www.enterprisedb.com>

Ken Smith wrote:
> The following bug has been logged online:
>
> Bug reference:      5015
> Logged by:          Ken Smith
> Email address:      kensmith@adobe.com
> PostgreSQL version: 8.4
> Operating system:   Windows
> Description:        MySQL migration wizard does not start
> Details:
>
> I have downloaded and installed PostgreSQL 8.4 and installed the mysql
> migration wizard.  I click the shortcut and nothing happens.  I also noted
> that if I try to run from the commandline that you use '/' in some of the
> program paths causing the OS to say it cannot find the file - "C:/Program
> Files/Java/jdk1.5.0_16/jre/bin/java.exe".  Additionally the whole command is
> too long for the shortcut properties and is cut off.
>
> If I setup a shorter path using 8.3 notation, I still get nothing.
>

Re: BUG #5015: MySQL migration wizard does not start

From
Ken Smith
Date:
QXNoZXNoLA0KVGhlIHVwZGF0ZSBmaWxlcyB3b3JrZWQuICBJIHVuemlwcGVk
IHRoZSBkb3dubG9hZCBpbnRvIHRoZSBFbnRlcnByaXNlREItTWlncmF0aW9u
V2l6YXJkIHJlcGxhY2luZyB0aGUgZXhpc3RpbmcgamFycyBpbiBFbnRlcnBy
aXNlREItTWlncmF0aW9uV2l6YXJkIGFuZCB0aGUgbGliIGRpcmVjdG9yeS4N
Cg0KVGhlIGV4aXN0aW5nIGNvbW1hbmQgZGlkIHdvcmsgc28gaXQgd2FzIG5v
dCBhIG1hdHRlciBvZiBiYWNrc2xhc2hlcyB2cy4gZm9yd2FyZCBzbGFzaGVz
Lg0KDQpUaGFua3MsDQoNCktlblMuDQoNCkZyb206IEFzaGVzaCBWYXNoaSBb
bWFpbHRvOmFzaGVzaC52YXNoaUBlbnRlcnByaXNlZGIuY29tXQ0KU2VudDog
VGh1cnNkYXksIEF1Z3VzdCAyNywgMjAwOSA3OjMxIEFNDQpUbzogS2VuIFNt
aXRoDQpDYzogcGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDog
UmU6IFtCVUdTXSBCVUcgIzUwMTU6IE15U1FMIG1pZ3JhdGlvbiB3aXphcmQg
ZG9lcyBub3Qgc3RhcnQNCg0KSGkgS2VuIFNtaXRoLA0KDQpXZSBmb3VuZCB0
aGF0IC0gdGhlIGphciBmaWxlcywgd2UgcGFja2FnZWQgd2l0aCB0aGUgaW5z
dGFsbGVycyBhcmUgY29ycnVwdGVkLg0KUGxlYXNlIGZpbmQgdGhlIHNldCBv
ZiBqYXIgZmlsZXMgYXMgYSB6aXAgQCBodHRwOi8vdXBsb2Fkcy5lbnRlcnBy
aXNlZGIuY29tL2Rvd25sb2FkLnBocD9maWxlPTg2ZmI1YjhlNzc3NzYxZjYz
YzdkMjc1MjVkMjYxNmY2Lg0KDQpSZXBsYWNlIHRoZW0gd2l0aCBleGlzdGlu
ZyBNaWdyYXRpb25XaXphcmQuamFyIGFuZCBsaWIgZm9sZGVyIGZvdW5kIHVu
ZGVyIGluc3RhbGxhdGlvbiBkaXJlY3RvcnkuDQoNCkhvcGUgdGhpcyBoZWxw
cyB5b3UuDQoNCi0tDQpUaGFua3MgJiBSZWdhcmRzLA0KQXNoZXNoIFZhc2hp
DQoNCkVudGVycHJpc2VEQiBJTkRJQSAtIHd3dy5lbnRlcnByaXNlZGIuY29t
PGh0dHA6Ly93d3cuZW50ZXJwcmlzZWRiLmNvbT4NCg0KS2VuIFNtaXRoIHdy
b3RlOg0KDQpUaGUgZm9sbG93aW5nIGJ1ZyBoYXMgYmVlbiBsb2dnZWQgb25s
aW5lOg0KDQoNCg0KQnVnIHJlZmVyZW5jZTogICAgICA1MDE1DQoNCkxvZ2dl
ZCBieTogICAgICAgICAgS2VuIFNtaXRoDQoNCkVtYWlsIGFkZHJlc3M6ICAg
ICAga2Vuc21pdGhAYWRvYmUuY29tPG1haWx0bzprZW5zbWl0aEBhZG9iZS5j
b20+DQoNClBvc3RncmVTUUwgdmVyc2lvbjogOC40DQoNCk9wZXJhdGluZyBz
eXN0ZW06ICAgV2luZG93cw0KDQpEZXNjcmlwdGlvbjogICAgICAgIE15U1FM
IG1pZ3JhdGlvbiB3aXphcmQgZG9lcyBub3Qgc3RhcnQNCg0KRGV0YWlsczoN
Cg0KDQoNCkkgaGF2ZSBkb3dubG9hZGVkIGFuZCBpbnN0YWxsZWQgUG9zdGdy
ZVNRTCA4LjQgYW5kIGluc3RhbGxlZCB0aGUgbXlzcWwNCg0KbWlncmF0aW9u
IHdpemFyZC4gIEkgY2xpY2sgdGhlIHNob3J0Y3V0IGFuZCBub3RoaW5nIGhh
cHBlbnMuICBJIGFsc28gbm90ZWQNCg0KdGhhdCBpZiBJIHRyeSB0byBydW4g
ZnJvbSB0aGUgY29tbWFuZGxpbmUgdGhhdCB5b3UgdXNlICcvJyBpbiBzb21l
IG9mIHRoZQ0KDQpwcm9ncmFtIHBhdGhzIGNhdXNpbmcgdGhlIE9TIHRvIHNh
eSBpdCBjYW5ub3QgZmluZCB0aGUgZmlsZSAtICJDOi9Qcm9ncmFtDQoNCkZp
bGVzL0phdmEvamRrMS41LjBfMTYvanJlL2Jpbi9qYXZhLmV4ZSIuICBBZGRp
dGlvbmFsbHkgdGhlIHdob2xlIGNvbW1hbmQgaXMNCg0KdG9vIGxvbmcgZm9y
IHRoZSBzaG9ydGN1dCBwcm9wZXJ0aWVzIGFuZCBpcyBjdXQgb2ZmLg0KDQoN
Cg0KSWYgSSBzZXR1cCBhIHNob3J0ZXIgcGF0aCB1c2luZyA4LjMgbm90YXRp
b24sIEkgc3RpbGwgZ2V0IG5vdGhpbmcuDQoNCg0K

Re: BUG #5015: MySQL migration wizard does not start

From
Aris Setyawan
Date:
I didn't update the MigrationWizard.jar file, because download link was
error. In my command prompt, I change dir to "EnterpriseDB-MigrationWizard"
directory then change some full path file to relative path file. In my
environment, i change directory to "C:\Program
Files\PostgreSQL\EnterpriseDB-MigrationWizard" then i replace
C:\Windows\system32\wscript.exe //NoLogo "C:\Program
Files\PostgreSQL\EnterpriseDB-MigrationWizard\scripts\launchMigrationWizard.vbs"
"" "C:/Program Files/Java/jdk1.5.0_06/jre/bin/java.exe" "-jar
MigrationWizard.jar" "C:\Program
Files\PostgreSQL\EnterpriseDB-MigrationWizard" command with
C:\Windows\system32\wscript.exe //NoLogo "scripts\launchMigrationWizard.vbs"
"" "java.exe" "-jar MigrationWizard.jar" "", and worked.

Re: BUG #5015: MySQL migration wizard does not start

From
Robert Haas
Date:
On Fri, Feb 19, 2010 at 5:51 PM, Aris Setyawan <aris.sety@gmail.com> wrote:
> I didn't update the MigrationWizard.jar file, because download link was
> error. In my command prompt, I change dir to "EnterpriseDB-MigrationWizard"
> directory then change some full path file to relative path file. In my
> environment, i change directory to "C:\Program
> Files\PostgreSQL\EnterpriseDB-MigrationWizard" then i replace
> C:\Windows\system32\wscript.exe //NoLogo "C:\Program
> Files\PostgreSQL\EnterpriseDB-MigrationWizard\scripts\launchMigrationWizard.vbs"
> "" "C:/Program Files/Java/jdk1.5.0_06/jre/bin/java.exe" "-jar
> MigrationWizard.jar" "C:\Program
> Files\PostgreSQL\EnterpriseDB-MigrationWizard" command with
> C:\Windows\system32\wscript.exe //NoLogo "scripts\launchMigrationWizard.vbs"
> "" "java.exe" "-jar MigrationWizard.jar" "", and worked.

This is not a PostgreSQL bug.  Sounds like you need to contact
EnterpriseDB.  To quote from the bug reporting form:

"This bug report form should only be used for reporting bugs and
problems with the PostgreSQL database. Problems with database
connectors such as ODBC and JDBC, graphical administration tools such
as pgAdmin or other external projects should not be reported here;
please report to those projects directly. For products closely
connected with PostgreSQL, there may be an appropriate mailing list
available."

....Robert