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

And this is how the utilities work after the install…
-------------------------------------------
deeden@td5:~$ /usr/local/bin/mysqlindexcheck 
Traceback (most recent call last):
  File "/usr/local/bin/mysqlindexcheck", line 30, in <module>
    from mysql.utilities import VERSION_FRM
ImportError: No module named mysql.utilities
-------------------------------------------

Regards,

Daniël

On Wed, 15 Dec 2010 08:54:48 +0000, Daniël van Eeden
<Daniel.van.Eeden@stripped> wrote:
> 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