Bug #61300 MySQL Utilities won't work on Ubuntu 11.04
| Submitted: | 26 May 2011 8:31 | Modified: | 25 Apr 2013 21:47 |
|---|---|---|---|
| Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Utilities | Severity: | S1 (Critical) |
| Version: | 5.2.34-1ubu1010 | OS: | Linux (Ubuntu 11.04) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | python | ||
[26 May 2011 13:15]
Alfredo Kojima
How are you starting the utilities? From a normal external shell or from the Plugins -> Utilities Shell menu / starter icon?
[26 May 2011 13:52]
Daniël van Eeden
I've tried both an external shell and a wb utilities shell.
[31 May 2011 8:50]
Valeriy Kravchuk
Not repeatable on Ubuntu 10.04, so looks like Python version really matters.
[31 May 2011 10:04]
Daniël van Eeden
$ dpkg-query -S /usr/bin/python* python-minimal: /usr/bin/python python2.6-minimal: /usr/bin/python2.6 python2.7-minimal: /usr/bin/python2.7 $ lsb_release -d Description: Ubuntu 11.04
[28 Sep 2011 10:43]
Daniël van Eeden
It seems to be fixed in 5.2.35-1ubu1104, as that version uses python 2.7 on Ubuntu 11.04. The previous version used python 2.6 on Ubuntu 11.04 $ dpkg -L mysql-workbench-gpl | grep '__init__.py' | xargs ls -l -rw-r--r-- 1 root root 2290 2011-09-21 02:50 /usr/lib/python2.7/dist-packages/mysql/connector/__init__.py -rw-r--r-- 1 root root 1455 2011-09-21 03:54 /usr/lib/python2.7/dist-packages/mysql/connector/__init__.pyc -rw-r--r-- 1 root root 0 2011-09-21 02:51 /usr/lib/python2.7/dist-packages/mysql/__init__.py -rw-r--r-- 1 root root 137 2011-09-21 03:54 /usr/lib/python2.7/dist-packages/mysql/__init__.pyc -rw-r--r-- 1 root root 0 2011-09-21 02:50 /usr/lib/python2.7/dist-packages/mysql/utilities/command/__init__.py -rw-r--r-- 1 root root 155 2011-09-21 03:54 /usr/lib/python2.7/dist-packages/mysql/utilities/command/__init__.pyc -rw-r--r-- 1 root root 0 2011-09-21 02:50 /usr/lib/python2.7/dist-packages/mysql/utilities/common/__init__.py -rw-r--r-- 1 root root 154 2011-09-21 03:54 /usr/lib/python2.7/dist-packages/mysql/utilities/common/__init__.pyc -rw-r--r-- 1 root root 566 2011-09-21 02:50 /usr/lib/python2.7/dist-packages/mysql/utilities/__init__.py -rw-r--r-- 1 root root 730 2011-09-21 03:54 /usr/lib/python2.7/dist-packages/mysql/utilities/__init__.pyc $ dpkg -l mysql-workbench-gpl Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Description +++-======================================-======================================-============================================================================================ ii mysql-workbench-gpl 5.2.35-1ubu1104 MySQL Workbench
[25 Apr 2013 21:47]
Alfredo Kojima
Please try the standalone MySQL Utilities packages from http://dev.mysql.com/downloads/tools/utilities/#downloads
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: The mysqlutilities won't work as it uses the default python, which is python2.7 on Ubuntu 11.04 and the shipped modules are installed under a python2.6 dir. $ mysqlserverinfo Traceback (most recent call last): File "/usr/bin/mysqlserverinfo", line 28, in <module> from mysql.utilities import VERSION_FRM ImportError: No module named mysql.utilities $ lsb_release -d Description: Ubuntu 11.04 $ python2.6 /usr/bin/mysqlserverinfo Usage: mysqlserverinfo --server=user:pass@host:port:socket -f GRID mysqlserverinfo: error: You must specify at least one server. $ dpkg -L mysql-workbench-gpl | grep '__init__.py' | xargs ls -l -rw-r--r-- 1 root root 2290 2011-05-24 16:12 /usr/lib/python2.6/dist-packages/mysql/connector/__init__.py -rw-r--r-- 1 root root 1455 2011-05-24 16:34 /usr/lib/python2.6/dist-packages/mysql/connector/__init__.pyc -rw-r--r-- 1 root root 0 2011-05-24 16:12 /usr/lib/python2.6/dist-packages/mysql/__init__.py -rw-r--r-- 1 root root 137 2011-05-24 16:34 /usr/lib/python2.6/dist-packages/mysql/__init__.pyc -rw-r--r-- 1 root root 0 2011-05-24 16:12 /usr/lib/python2.6/dist-packages/mysql/utilities/command/__init__.py -rw-r--r-- 1 root root 155 2011-05-24 16:34 /usr/lib/python2.6/dist-packages/mysql/utilities/command/__init__.pyc -rw-r--r-- 1 root root 0 2011-05-24 16:12 /usr/lib/python2.6/dist-packages/mysql/utilities/common/__init__.py -rw-r--r-- 1 root root 154 2011-05-24 16:34 /usr/lib/python2.6/dist-packages/mysql/utilities/common/__init__.pyc -rw-r--r-- 1 root root 566 2011-05-24 16:12 /usr/lib/python2.6/dist-packages/mysql/utilities/__init__.py -rw-r--r-- 1 root root 730 2011-05-24 16:34 /usr/lib/python2.6/dist-packages/mysql/utilities/__init__.pyc $ dpkg -L python-openssl | grep '__init__.py' | xargs ls -l lrwxrwxrwx 1 root root 46 2011-05-13 21:19 /usr/lib/python2.6/dist-packages/OpenSSL/__init__.py -> ../../../../share/pyshared/OpenSSL/__init__.py lrwxrwxrwx 1 root root 54 2011-05-13 21:19 /usr/lib/python2.6/dist-packages/OpenSSL/test/__init__.py -> ../../../../../share/pyshared/OpenSSL/test/__init__.py lrwxrwxrwx 1 root root 46 2011-05-13 21:19 /usr/lib/python2.7/dist-packages/OpenSSL/__init__.py -> ../../../../share/pyshared/OpenSSL/__init__.py lrwxrwxrwx 1 root root 54 2011-05-13 21:19 /usr/lib/python2.7/dist-packages/OpenSSL/test/__init__.py -> ../../../../../share/pyshared/OpenSSL/test/__init__.py -rw-r--r-- 1 root root 260 2009-11-13 16:36 /usr/share/pyshared/OpenSSL/__init__.py -rw-r--r-- 1 root root 117 2009-11-13 16:36 /usr/share/pyshared/OpenSSL/test/__init__.py How to repeat: Try to run mysqlserverinfo on an Ubuntu 11.04 system. Suggested fix: 1. Use a hardcoded version (work-around) http://www.debian.org/doc/packaging-manuals/python-policy/ch-programs.html#s-version_dep_p... 2. Use pycentral to manage the modules (best option) http://www.debian.org/doc/packaging-manuals/python-policy/ap-packaging_tools.html#s-pycent... Ubuntu 11.04 is not (yet) listed as an officialy supported distribution, but the list with officialy supported distributions is not very clear at this time (See Bug #61299).