MySQL Bugs: #26120: Migration Toolkit fails dependency on RHEL4

Bug #26120	Migration Toolkit fails dependency on RHEL4
Submitted:	6 Feb 2007 17:30	Modified:	15 Oct 2009 7:53
Reporter:	Michael Reeves	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	5.0r9, 5.0r10, 5.0r11	OS:	Linux (RHEL 4)
Assigned to:		CPU Architecture:	Any
Tags:	CHECKED, gui tools, Migration Toolkit, qc, RHEL 4

Description:
I'm installing the GUI Tools on RHEL 4.  I've installed all the tools successfully, except the Migration Toolkit.  When installing the RPM I get a failed dependency message.

error Failed dependencies:
    ld-linux.so.2(GLIBC_PRIVATE) is needed by mysql-migration-toolkit-5.0r9-1rhel4.i386

We're using RHEL 4 update 2.  This CANNOT be upgraded.

How to repeat:
Download GUI Tools 5.0r9

Extract files

Install gui-tools rpm
    rpm -Uvh mysql-gui-tools-5.0r9-1rhel.i386.rpm

Install mysql query browser
    rpm -Uvh mysql-query-browser-5.0r9-1rhel.i386.rpm

Install mysql administrator
    rpm -Uvh mysql-administrator-5.0r9-1rhel.i386.rpm

Install mysql workbench
    rpm -Uvh mysql-workbench-5.0r9-1rhel.i386.rpm

Install mysql migration toolkit
    rpm -Uvh mysql-migration-toolkit-5.0r9-1rhel.i386.rpm

error Failed dependencies:
    ld-linux.so.2(GLIBC_PRIVATE) is needed by mysql-migration-toolkit-5.0r9-1rhel4.i386

i have the same problem to update 1.2.8 to 1.2.10 mysql-gui-tool
but 
try install ptt-beta2.i386.rpm
and after the update is correctly.

sorry, by my bad english

As of 5.0r11, I am unable to load ANY of the GUI tools due to lib dependency failures.

Starting with 5.0r10, I had to run rpm with --no-deps to get the GUI Tools rpm to install.  This is because it was conflicting with pieces of 5.0r9 on my system.

Now with 5.0r11, I get a complete failure to load the GUI tools rpm.  I get the following error
# rpm -Uvh mysql-gui-tools-5.0r11-1hrel4.i386.rpm
error: Failed dependencies:
        ld-linux.so.2(GLIBC_PRIVATE) is needed by mysql-gui-tools-5.0r11-1hrel4.i386
        libjvm.so is needed by mysql-gui-tools-5.0r11-1hrel4.i386
        libjvm.so(SUNWprivate_1.1) is needed by mysql-gui-tools-5.0r11-1hrel4.i386
        mysql-gui-tools = 5.0r10 is needed by (installed) mysql-query-browser-5.0r10-1hrel4.i386
        mysql-gui-tools = 5.0r10 is needed by (installed) mysql-administrator-5.0r10-1hrel4.i386
        mysql-gui-tools = 5.0r10 is needed by (installed) mysql-workbench-5.0r10-1hrel4.i386

The last three error messages were the same thing I was getting going from version r9 to r10, but I bypassed it with --no-deps.

Michael: 

You need to upgrade all tools packages at the same time, e.g:
rpm -Uvh *r11*rpm

The only strange thing is that it seems libjvm.so has crept in as a
dependency for the mysql-gui-tools package, which should only be
a requirement when migration tool is installed. 

Please report if you can install the other tools with the above command,
I'll investigate the libjvm.so problem

Thanks for report.

Is that documented someplace?  I've not seen that way of installing things before.

Anyway, I still get failed dependencies
>rpm -Uvh *r11*rpm
error: Failed dependencies:
    ld-linux.so.2(GLIBC_PRIVATE) is needed by mysql-gui-tools-5.0r11-1hrel4.i386
    libjvm.so is needed by mysql-gui-tools-5.0r11-1hrel4.i386
    libjvm.so(SUNWprivate_1.1) is needed by mysql-gui-tools-5.0r11-1hrel4.i386
    ld-linux.so.2(GLIBC_PRIVATE) is needed by mysql-migration-toolkit-5.0r11-1hrel4.i386
    libjvm.so is needed by mysql-migration-toolkit-5.0r11-1hrel4.i386
    libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r11-1hrel4.i386
    mysql-gui-tools = 5.0r10 is needed by (installed) mysql-workbench-5.0r10-1hrel4.i386

Do I need to get rid of the migration-toolkit rpm before I try this?

i am getting the same problem, did any one solve this?

[root@HOST bla]# rpm -Uvh *r11*rpm
error: Failed dependencies:
        ld-linux.so.2(GLIBC_PRIVATE) is needed by mysql-gui-tools-5.0r11-1rhel4.i386
        libjvm.so is needed by mysql-gui-tools-5.0r11-1rhel4.i386
        libjvm.so(SUNWprivate_1.1) is needed by mysql-gui-tools-5.0r11-1rhel4.i386
        libmysqlclient_r.so.15 is needed by mysql-gui-tools-5.0r11-1rhel4.i386
        libmysqlclient_r.so.15(libmysqlclient_15) is needed by mysql-gui-tools-5.0r11-1rhel4.i386
        ld-linux.so.2(GLIBC_PRIVATE) is needed by mysql-migration-toolkit-5.0r11-1rhel4.i386
        libjvm.so is needed by mysql-migration-toolkit-5.0r11-1rhel4.i386
        libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r11-1rhel4.i386
        libmysqlclient_r.so.15 is needed by mysql-migration-toolkit-5.0r11-1rhel4.i386
        libmysqlclient_r.so.15(libmysqlclient_15) is needed by mysql-migration-toolkit-5.0r11-1rhel4.i386

I'm probably not getting the same messages about libmysqlclient* as SaP rOuZy, because I only install my server and client from the TAR files, not through the RPM.

I tried installing all at the same time, now I get a problem with a java virtual machine dependancy.

yum localinstall mysql-administrator-5.0r11-1fc5.i386.rpm mysql-gui-tools-5.0r11-1fc5.i386.rpm mysql-migration-toolkit-5.0r11-1fc5.i386.rpm mysql-query-browser-5.0r11-1fc5.i386.rpm

.... stuff cut out for brevity's sake ---

--> Processing Dependency: libjvm.so for package: mysql-gui-tools
--> Finished Dependency Resolution
Error: Missing Dependency: libjvm.so is needed by package mysql-migration-toolkit
Error: Missing Dependency: mysql-gui-tools = 5.0r10 is needed by package mysql-workbench
Error: Missing Dependency: libjvm.so(SUNWprivate_1.1) is needed by package mysql-gui-tools
Error: Missing Dependency: libjvm.so(SUNWprivate_1.1) is needed by package mysql-migration-toolkit
Error: Missing Dependency: libjvm.so is needed by package mysql-gui-tools

any progress on this bug?

Oops, in the previous statement.  I meant to do yum localupdate instead of yum localinstall.  Same error happens either way.

I am really interested in using the Workbench program of the gui tools, but have not had success in installing it.  I have tried yum, rpm, and compiling an svn copy.  I have hit a block in each case for trying to use workbench.  Any help would be very appreciated.

Thank you.

What I have tried:

yum:
Using yum to install the query browser and admin tool works great, but it does not include the workbench. I am most interested in the workbench, although the other tools are nice.
A full yum update also did resolve this either.

rpms:
rpm -Uvh *r11*rpm
error: Failed dependencies:
libjvm.so is needed by mysql-gui-tools-5.0r11-1fc5.i386
libjvm.so(SUNWprivate_1.1) is needed by mysql-gui-tools-5.0r11-1fc5.i386
libjvm.so is needed by mysql-migration-toolkit-5.0r11-1fc5.i386
libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r11-1fc5.i386
I removed the mysql-gui-tools using yum and this did not resolve the libjvm issue.

following [forge.mysql.com]:

In file included from myx_query.cpp:21:
../include/myx_query.h:72:8: warning: extra tokens at end of #endif directive
myx_query.cpp: In destructor 'PCRE_sub_string::~PCRE_sub_string()':
myx_query.cpp:353: error: cannot convert 'const char*' to 'const char**' for argument '1' to 'void pcre_free_substring(const char**)'
myx_query.cpp: In member function 'PCRE_sub_string& PCRE_sub_string::operator=(const char*)':
myx_query.cpp:359: error: cannot convert 'const char*' to 'const char**' for argument '1' to 'void pcre_free_substring(const char**)'
myx_query.cpp: In function 'Query* s_query_get_query_tables(MYSQL*, Query*, MYX_Q_CLAUSE_TYPE)':
myx_query.cpp:1192: error: cannot convert 'const char*' to 'const char**' for argument '1' to 'void pcre_free_substring(const char**)'
myx_query.cpp:1194: error: cannot convert 'const char*' to 'const char**' for argument '1' to 'void pcre_free_substring(const char**)'
myx_query.cpp: In function 'MYX_STRINGLIST* myx_check_table_relationship(MYSQL*, const char*, const char*, const char*, const char*, const char*)':
myx_query.cpp:3114: error: cannot convert 'const char*' to 'const char**' for argument '1' to 'void pcre_free_substring(const char**)'
myx_query.cpp:3115: error: cannot convert 'const char*' to 'const char**' for argument '1' to 'void pcre_free_substring(const char**)'
myx_query.cpp:3116: error: cannot convert 'const char*' to 'const char**' for argument '1' to 'void pcre_free_substring(const char**)'
myx_query.cpp: In function 'int myx_kill_query(MYSQL*, MYSQL*)':
myx_query.cpp:3232: warning: format '%d' expects type 'int', but argument 3 has type 'long unsigned int'

I just tried this out with 5.0r12

I still get a problem with the migration toolkit
mysql-migration-toolkit-5.0r12-1rhel4.i386
        libjvm.so is needed by mysql-migration-toolkit-5.0r12-1rhel4.i386
        libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r12-1rhel4.i386

When I tried to install manually, I still got the error that the old versions of Administrator, QB and Workbench needed the old GUI Tools.  I noticed that Workbench is no longer included in the package. ???  Anyway, still had to bypass it by adding the --nodeps flag to the gui-tools.  

But at least I got the new versions installed this time.  Stil the migration toolkit would be handy to have.

Hii All....
use the command
 rpm -ivh mysql-migration-toolkit-5.0r12-1rhel3.i386.rpm --nodeps

it works perfectly...

Workaround here is upgrading to actual Red Hat version.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Migration tool into MySQL Workbench.

Unfortunately you are using a platform that is not supported from our development anymore. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/