Friday, March 4, 2011

MySQL Workbench on RHEL6

Yesterday I blogged about some issues with MySQL Workbench. The problem was that CentOS 5.5 is not supported.

So I installed RHEL6, one of the best known Enterprise Linux distributions. It's a 30 day evaluation, but that should be sufficient.

After some minor issues with VirtualBox I had a working installation. So I tried to install MySQL Workbench again. I used 'sudo yum localinstall mysql-workbench-gpl-5.2.31a-2el6.x86_64.rpm' which failed because of 2 unmet dependencies: pexpect and libzip.so.1

There is already a bug report in RHEL for the missing pexpect: #652659
I used the RHEL6 installation DVD to install pexpect.

There is a closed/wont-fix bug (#54403) for the libzip.so.1 dependency. It turns out that libzip is in the "RHEL Server Optional" channel. RHN should be used to enable more channels, but apparently the optional channel is not part of the evaluation license, so I used the web interface to download and install the libzip RPM.

The workbench installation finaly completed after complaining that the workbench rpm is not signed (use --nogpgcheck).

So I started MySQL Workbench (There is a launcher in the menu). And then I clicked the "MySQL Doc Library" and Workbench responded with an error about a missing package: pysqlite2/python-sqlite2. I could find a python-sqite for RHEL5 on RHN... but nothing for RHEL6. So I filed Bug #60336

5 comments:

  1. I tried mysql-workbench on centos6.

    yum --nogpgcheck localinstall mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm

    resolved the dependencies automatically and installed it. ofcourse my rpmfusion & epel repo's were already configured earlier.

    ReplyDelete
  2. An update - successful install -

    RHEL 6.2 -

    1. Download from MYSQL - http://www.mysql.com/downloads/mirror.php?id=406532#mirrors
    2. Download the libzip file: http://hany.sk/~hany/RPM/f-15-x86_64/libzip-0.9.3-3.fc15.x86_64.html
    3. Install with yum localinstall mysql-workbench-gpl-5.2.38-1el6.x86_64.rpm as the su

    Doc library seems to work for me!

    ReplyDelete
    Replies
    1. Add remicollet's repo and just use:

      yum install mysql-workbench

      Delete
    2. Wrong. That results in all of these errors:

      Error: Package: mysql-workbench-5.2.45-1.el6.remi.i686 (remi)
      Requires: libiodbcinst.so.2
      Error: Package: php-gd-5.4.10-1.el6.remi.i686 (remi)
      Requires: libt1.so.5
      Error: Package: mysql-workbench-5.2.45-1.el6.remi.i686 (remi)
      Requires: python-sqlite2
      Error: Package: mysql-workbench-5.2.45-1.el6.remi.i686 (remi)
      Requires: pyodbc(x86-32)
      Error: Package: mysql-workbench-5.2.45-1.el6.remi.i686 (remi)
      Requires: libtinyxml.so.0
      Error: Package: mysql-workbench-5.2.45-1.el6.remi.i686 (remi)
      Requires: libzip.so.1
      Error: Package: mysql-workbench-5.2.45-1.el6.remi.i686 (remi)
      Requires: pexpect
      Error: Package: mysql-workbench-5.2.45-1.el6.remi.i686 (remi)
      Requires: libiodbc.so.2

      Delete
  3. you can get the RPM for RHEL 6.0 off of the mysql site with all the dependancies included here:http://www.mysql.com/downloads/mirror.php?id=412158

    ReplyDelete