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

Thanks for the feedback.

On 12/15/2010 10:00 AM, Daniël van Eeden wrote:
> 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
> -------------------------------------------

This is because it does not find the module correctly, which is
installed in /usr/local/ while python does not look there. I've got
another report of problems, so need to look at it. I have problems
reproducing it on my machine.

For the problems below, I'll look through your other mail and reply to
that after I've tried to reproduce it.

Best wishes,
Mats Kindahl

> 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
Re: mysql-utilitiesMats Kindahl15 Dec