Bug #72664 Error mysql utilities 1.4.2 requires: mysql-connector-python >= 1.2.1
Submitted: 16 May 2014 6:20 Modified: 16 Jul 2014 0:36
Reporter: Shahriyar Rzayev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Utilities Severity:S1 (Critical)
Version:1.4.2 OS:Linux (CentOS 6.5)
Assigned to: CPU Architecture:Any

[16 May 2014 6:20] Shahriyar Rzayev
Description:
Dear all,
On CentOS 6.5 i tried to run "yum update" but update was broken by:

Error: Package: mysql-utilities-1.4.2-1.el6.noarch (installed)
           Requires: mysql-connector-python >= 1.2.1
           Removing: mysql-connector-python-1.1.6-1.el6.noarch (installed)
               mysql-connector-python
               mysql-connector-python = 1.1.6
               mysql-connector-python = 1.1.6-1.el6
           Updated By: mysql-connector-python-1.1.7-1.el6.noarch (mysql-connectors-community)
               mysql-connector-python = 1.1.7-1.el6
           Available: mysql-connector-python-1.1.4-1.el6.noarch (mysql-connectors-community)
               mysql-connector-python = 1.1.4-1.el6
           Available: mysql-connector-python-1.1.5-1.el6.noarch (mysql-connectors-community)
               mysql-connector-python = 1.1.5-1.el6
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

NOTE: Oracle official repo is enabled.

As error states there is 1.1.7-1.el6 version of connector provided from mysql-community package and it will upgrade 1.1.6-1.el6.

But mysql-utilities package argues for version >= 1.2.1.

So further examination shows following:

When i install 1.1.6-1.el6 from .rpm as i did before, the utilities is installed well:

[root@linuxsrv3 ~]# rpm -ivh mysql-connector-python-1.1.6-1.el6.noarch.rpm
Preparing...                ########################################### [100%]
   1:mysql-connector-python ########################################### [100%]
[root@linuxsrv3 ~]# rpm -ivh mysql-utilities-1.4.2-1.el6.noarch.rpm
Preparing...                ########################################### [100%]
   1:mysql-utilities        ########################################### [100%]

But when i want to install mysql-connector from repo:

[root@linuxsrv3 ~]# yum remove  mysql-connector-python-1.1.6
.
.
Removed:
  mysql-connector-python.noarch 0:1.1.6-1.el6                                                                                                   

Dependency Removed:
  mysql-utilities.noarch 0:1.4.2-1.el6                                                                                                          

Complete!

Then:
[root@linuxsrv3 ~]# yum install mysql-connector-python

Running Transaction
  Installing : mysql-connector-python-1.1.7-1.el6.noarch                                                                                    1/1 
  Verifying  : mysql-connector-python-1.1.7-1.el6.noarch                                                                                    1/1 

Installed:
  mysql-connector-python.noarch 0:1.1.7-1.el6                                                                                                   

Complete!

So the new version 1.1.7-1.el6 was installed successfully.

Again tried to install mysql-utilities but get dependency error:

[root@linuxsrv3 ~]# rpm -ivh mysql-utilities-1.4.2-1.el6.noarch.rpm
error: Failed dependencies:
	mysql-connector-python >= 1.2.1 is needed by mysql-utilities-1.4.2-1.el6.noarch

As documentation states:

"MySQL Utilities requires MySQL Connector/Python GA release (version > 1.0.8) for connecting to MySQL"

How to repeat:
1. Enable Oracle's official yum repo.
2. Install mysql-connector 1.1.6 from rpm:
rpm -ivh mysql-connector-python-1.1.6-1.el6.noarch.rpm

3. Install mysql-utilities-1.4.2-1 from rpm:
rpm -ivh mysql-utilities-1.4.2-1.el6.noarch.rpm

You will see no dependency error.

Then try to update system or to upgrade from repo to see unclear dependency error which is against documentation.

Suggested fix:
No idea.
[16 May 2014 9:48] MySQL Verification Team
Hello Shahriyar,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[17 May 2014 7:13] Terje Røsten
Hi Shahriyar,

repo includes mysql-connector-python-1.1.7 and mysql-utilities-1.3.6,
these work together.

If you want to use mysql-utilities-1.4.2 rpm (available from direct download), 
you also need mysql-connector-python-1.2.1. Both these are development releases (rc at the moment). You can download mysql-connector-python-1.2.1 rpm here:

 http://dev.mysql.com/downloads/connector/python/

Choose the "Development Releases" tab.

Install/Update mysql-connector-python first:

 rpm -Uvh mysql-connector-python-1.2.1-1.el6.noarch.rpm

and then mysql-utilities:

 rpm -Uvh  mysql-utilities-1.4.2-1.el6.noarch
 
When done please verify "yum update" works without error for you.
[17 May 2014 7:30] Shahriyar Rzayev
Dear  Terje Røsten ,

As i described in description section, although 1.4.2 is RC, it is working fine with previous 1.1.6 GA mysql-connector-python.
And it is only now argues with 1.1.7 and wants mysql-connector-python >= 1.2.1 when want to run "yum update".

And as documentation for 1.4 version of mysql utilities states it must work with MySQL Connector/Python GA release (version > 1.0.8). 1.1.7 is greater than 1.0.8

[root@linuxsrv3 ~]# rpm -ivh mysql-connector-python-1.2.1-1.el6.noarch.rpm
Preparing...                                                           ########################################### [100%]
   1:mysql-connector-python                                            ########################################### [100%]
[root@linuxsrv3 ~]# rpm -ivh mysql-utilities-1.4.2-1.el6.noarch.rpm
Preparing...                                                           ########################################### [100%]
   1:mysql-utilities                                                   ########################################### [100%]
[root@linuxsrv3 ~]# yum update
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
 * base: centos.datacenter.az
 * extras: centos.datacenter.az
 * updates: centos.datacenter.az
Setting up Update Process
No Packages marked for Update.
[16 Jul 2014 0:36] Philip Olson
Fixed as of the upcoming MySQL Utilities/Fabric 1.4.4 release, and here's the changelog entry:

The minimum required Connector/Python version in the source code was
defined as 1.0.9 instead of 1.2.1.

Thank you for the bug report.