List:GUI Tools« Previous MessageNext Message »
From:Daniël van Eeden Date:December 15 2010 8:54am
Subject:mysql-utilities
View as plain text  
Hi Mats,

As you saw I tried to give mysql-utilities a spin but I couldn't get the
code as the repository was not available yet. Google Alerts was able to
alert me of the reaction you posted about the code being available. So I
tried it again, but it failed.

This is what happened:
--------------------------------------------------------------
deeden@td5:~/dev$ bzr branch lp:mysql-utilities
Branched 118 revision(s).                                                 
                                                                          
                           
deeden@td5:~/dev$ cd mysql-utilities/
deeden@td5:~/dev/mysql-utilities$ python setup.py install

Installed /home/deeden/dev/mysql-utilities/Sphinx-1.0.5-py2.6.egg
Searching for docutils>=0.5
Reading http://pypi.python.org/simple/docutils/
Reading http://docutils.sourceforge.net/
Best match: docutils 0.7
Downloading
http://prdownloads.sourceforge.net/docutils/docutils-0.7.tar.gz?download
Processing docutils-0.7.tar.gz
Running docutils-0.7/setup.py -q bdist_egg --dist-dir
/tmp/easy_install-PcT_Fh/docutils-0.7/egg-dist-tmp-C4fFfp
warning: no files found matching 'MANIFEST'
warning: no previously-included files matching '.cvsignore' found under
directory '*'
warning: no previously-included files matching '*.pyc' found under
directory '*'
warning: no previously-included files matching '*~' found under directory
'*'
warning: no previously-included files matching '.DS_Store' found under
directory '*'
zip_safe flag not set; analyzing archive contents...
docutils.writers.s5_html.__init__: module references __file__
docutils.writers.newlatex2e.__init__: module references __file__
docutils.writers.pep_html.__init__: module references __file__
docutils.writers.odf_odt.__init__: module references __file__
docutils.writers.html4css1.__init__: module references __file__
docutils.writers.latex2e.__init__: module references __file__
docutils.parsers.rst.directives.misc: module references __file__

Installed /home/deeden/dev/mysql-utilities/docutils-0.7-py2.6.egg
Searching for Jinja2>=2.2
Reading http://pypi.python.org/simple/Jinja2/
Reading http://jinja.pocoo.org/
Best match: Jinja2 2.5.5
Downloading
http://pypi.python.org/packages/source/J/Jinja2/Jinja2-2.5.5.tar.gz#md5=83b20c1eeb31f49d8e6392efae91b7d5
Processing Jinja2-2.5.5.tar.gz
Running Jinja2-2.5.5/setup.py -q bdist_egg --dist-dir
/tmp/easy_install-XvT4dA/Jinja2-2.5.5/egg-dist-tmp-MHu6_x
warning: no previously-included files matching '*' found under directory
'docs/_build'
warning: no previously-included files matching '*.pyc' found under
directory 'jinja2'
warning: no previously-included files matching '*.pyc' found under
directory 'docs'
warning: no previously-included files matching '*.pyo' found under
directory 'jinja2'
warning: no previously-included files matching '*.pyo' found under
directory 'docs'

Installed /home/deeden/dev/mysql-utilities/Jinja2-2.5.5-py2.6.egg
running install
running build
running build_py
creating build
creating build/lib.linux-i686-2.6
creating build/lib.linux-i686-2.6/mysql
copying mysql/__init__.py -> build/lib.linux-i686-2.6/mysql
creating build/lib.linux-i686-2.6/mysql/utilities
copying mysql/utilities/__init__.py ->
build/lib.linux-i686-2.6/mysql/utilities
copying mysql/utilities/exception.py ->
build/lib.linux-i686-2.6/mysql/utilities
creating build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/indexcheck.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/userclone.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/serverclone.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/__init__.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/dbcopy.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/dbimport.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/rpl.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/dbexport.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/grep.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/proc.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
creating build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/user.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/options.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/format.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/tools.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/rpl.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/__init__.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/table.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/database.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/server.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
running build_scripts
copying scripts/mysqlindexcheck.py -> scripts/mysqlindexcheck
copying scripts/mysqlprocgrep.py -> scripts/mysqlprocgrep
copying scripts/mysqlreplicate.py -> scripts/mysqlreplicate
copying scripts/mysqluserclone.py -> scripts/mysqluserclone
copying scripts/mysqldbimport.py -> scripts/mysqldbimport
copying scripts/mysqlserverclone.py -> scripts/mysqlserverclone
copying scripts/mysqlmetagrep.py -> scripts/mysqlmetagrep
copying scripts/mysqldbcopy.py -> scripts/mysqldbcopy
copying scripts/mysqldbexport.py -> scripts/mysqldbexport
creating build/scripts-2.6
copying and adjusting scripts/mysqlindexcheck -> build/scripts-2.6
copying and adjusting scripts/mysqlprocgrep -> build/scripts-2.6
copying and adjusting scripts/mysqlreplicate -> build/scripts-2.6
copying and adjusting scripts/mysqluserclone -> build/scripts-2.6
copying and adjusting scripts/mysqldbimport -> build/scripts-2.6
copying and adjusting scripts/mysqlserverclone -> build/scripts-2.6
copying and adjusting scripts/mysqlmetagrep -> build/scripts-2.6
copying and adjusting scripts/mysqldbcopy -> build/scripts-2.6
copying and adjusting scripts/mysqldbexport -> build/scripts-2.6
changing mode of build/scripts-2.6/mysqlindexcheck from 600 to 755
changing mode of build/scripts-2.6/mysqlprocgrep from 600 to 755
changing mode of build/scripts-2.6/mysqlreplicate from 600 to 755
changing mode of build/scripts-2.6/mysqluserclone from 600 to 755
changing mode of build/scripts-2.6/mysqldbimport from 600 to 755
changing mode of build/scripts-2.6/mysqlserverclone from 600 to 755
changing mode of build/scripts-2.6/mysqlmetagrep from 600 to 755
changing mode of build/scripts-2.6/mysqldbcopy from 600 to 755
changing mode of build/scripts-2.6/mysqldbexport from 600 to 755
running build_data
error: invalid command 'build_data'
deeden@td5:~/dev/mysql-utilities$ dpkg -l python python-setuptools
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                                    Version                       
        Description
+++-=======================================-=======================================-==============================================================================================
ii  python                                  2.6.5-0ubuntu1                
        An interactive high-level object-oriented language (default
version)
ii  python-setuptools                       0.6.10-4ubuntu1               
        Python Distutils Enhancements (setuptools compatibility)
deeden@td5:~/dev/mysql-utilities$ lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 10.04.1 LTS
Release:	10.04
Codename:	lucid
--------------------------------------------------------------

My second try after installing python-docutils and python-jinja2:
--------------------------------------------------------------
deeden@td5:~/dev$ bzr branch lp:mysql-utilities
Branched 118 revision(s).                                                 
                                                                          
                           
deeden@td5:~/dev$ cd mysql-utilities
deeden@td5:~/dev/mysql-utilities$ python setup.py install

Installed /home/deeden/dev/mysql-utilities/Sphinx-1.0.5-py2.6.egg
running install
running build
running build_py
creating build
creating build/lib.linux-i686-2.6
creating build/lib.linux-i686-2.6/mysql
copying mysql/__init__.py -> build/lib.linux-i686-2.6/mysql
creating build/lib.linux-i686-2.6/mysql/utilities
copying mysql/utilities/__init__.py ->
build/lib.linux-i686-2.6/mysql/utilities
copying mysql/utilities/exception.py ->
build/lib.linux-i686-2.6/mysql/utilities
creating build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/indexcheck.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/userclone.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/serverclone.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/__init__.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/dbcopy.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/dbimport.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/rpl.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/dbexport.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/grep.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
copying mysql/utilities/command/proc.py ->
build/lib.linux-i686-2.6/mysql/utilities/command
creating build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/user.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/options.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/format.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/tools.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/rpl.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/__init__.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/table.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/database.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
copying mysql/utilities/common/server.py ->
build/lib.linux-i686-2.6/mysql/utilities/common
running build_scripts
copying scripts/mysqlindexcheck.py -> scripts/mysqlindexcheck
copying scripts/mysqlprocgrep.py -> scripts/mysqlprocgrep
copying scripts/mysqlreplicate.py -> scripts/mysqlreplicate
copying scripts/mysqluserclone.py -> scripts/mysqluserclone
copying scripts/mysqldbimport.py -> scripts/mysqldbimport
copying scripts/mysqlserverclone.py -> scripts/mysqlserverclone
copying scripts/mysqlmetagrep.py -> scripts/mysqlmetagrep
copying scripts/mysqldbcopy.py -> scripts/mysqldbcopy
copying scripts/mysqldbexport.py -> scripts/mysqldbexport
creating build/scripts-2.6
copying and adjusting scripts/mysqlindexcheck -> build/scripts-2.6
copying and adjusting scripts/mysqlprocgrep -> build/scripts-2.6
copying and adjusting scripts/mysqlreplicate -> build/scripts-2.6
copying and adjusting scripts/mysqluserclone -> build/scripts-2.6
copying and adjusting scripts/mysqldbimport -> build/scripts-2.6
copying and adjusting scripts/mysqlserverclone -> build/scripts-2.6
copying and adjusting scripts/mysqlmetagrep -> build/scripts-2.6
copying and adjusting scripts/mysqldbcopy -> build/scripts-2.6
copying and adjusting scripts/mysqldbexport -> build/scripts-2.6
changing mode of build/scripts-2.6/mysqlindexcheck from 600 to 755
changing mode of build/scripts-2.6/mysqlprocgrep from 600 to 755
changing mode of build/scripts-2.6/mysqlreplicate from 600 to 755
changing mode of build/scripts-2.6/mysqluserclone from 600 to 755
changing mode of build/scripts-2.6/mysqldbimport from 600 to 755
changing mode of build/scripts-2.6/mysqlserverclone from 600 to 755
changing mode of build/scripts-2.6/mysqlmetagrep from 600 to 755
changing mode of build/scripts-2.6/mysqldbcopy from 600 to 755
changing mode of build/scripts-2.6/mysqldbexport from 600 to 755
running install_lib
creating /usr/local/lib/python2.6/dist-packages/mysql
error: could not create '/usr/local/lib/python2.6/dist-packages/mysql':
Permission denied
deeden@td5:~/dev/mysql-utilities$ dpkg -l python python-docutils
python-setuptools python-jinja2
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                                    Version                       
        Description
+++-=======================================-=======================================-==============================================================================================
ii  python                                  2.6.5-0ubuntu1                
        An interactive high-level object-oriented language (default
version)
ii  python-docutils                         0.6-3                         
        utilities for the documentation of Python modules
ii  python-jinja2                           2.3.1-1                       
        small but fast and easy to use stand-alone template engine
ii  python-setuptools                       0.6.10-4ubuntu1               
        Python Distutils Enhancements (setuptools compatibility)
deeden@td5:~/dev/mysql-utilities$
--------------------------------------------------------------

It seems like it tries to create
/usr/local/lib/python2.6/dist-packages/mysql for which root or sudo
privileges are needed. The README.txt does not say anything about whether
or not it must be installed as root. 

This is what I did to successfully install the utilities:
$ cd /tmp; bzr branch lp:mysql-utilities; cd mysql-utilities; sudo python
setup.py install

On Ubuntu the following packages must be installed to use mysql-utilities
on host without outside network:
* python
* python-docutils
* python-setuptools
* python-jinja2
Maybe these prerequisites should be listed in the README.txt?

Why is the bugs section on launchpad not used? There is no description in
the README.txt about where to report bugs. Luckily 'python setup.py
--contact-email' did work and your contact details are listed on LP.

It will install in /usr/local/bin which on Ubuntu is not included in the
$PATH variable by default. This can be fixed by creating a script called
/etc/profile.d/usr-local-bin.sh wich will add /usr/local/bin to the $PATH.

Maybe python setup.py --help and python setup.py --help-commands should
also be listed in the README.txt

And a deb (and rpm) packages would be nice:
http://ghantoos.org/2008/10/19/creating-a-deb-package-from-a-python-setuppy/

And maybe the workbench and mysql-utilities packages could be added to the
Oracle APT and YUM repositories?
http://oss.oracle.com/debian/
http://public-yum.oracle.com/

Will the mysql-utilities become available on https://edelivery.oracle.com
?

Regards,

Daniël van Eeden
Thread
mysql-utilitiesDaniël van Eeden15 Dec
  • Re: mysql-utilitiesDaniël van Eeden15 Dec