Installing Mysql Workbench 5.2.11 from source on Debian 6.0 Squeeze

Flattr this
Tweet this: Installing Mysql Workbench 5.2.11 from source on Debian 6.0 Squeeze
Dent this: Installing Mysql Workbench 5.2.11 from source on Debian 6.0 Squeeze
Datum: 09.01.2010 02:25:45

Steps are simple:

Download the sources ~ 14 MB
extract it
install ~ 30mb of packages via apt-get
run autogen
make && make install
start it

But it may some time, at least on my slow notebook (p4 mobile 1,73 ghz) autogen took 10 minutes, make took about 60 minutes and make install another 4 minutes, but if you ever compiled mysql-server yourself you now ... mysql may take some time :)

So here in Detail, almost copy & paste-ready:
 

 wget ftp://ftp.gwdg.de/pub/misc/mysql/Downloads/MySQLGUITools/mysql-workbench-oss-5.2.11.tar.gz
  tar -xzf mysql-workbench-oss-5.2.11.tar.gz
  cd mysql-workbench-oss-5.2.11
  apt-get install libzip-dev libzip1 libxml2-dev libsigc++-2.0-dev libcairomm-1.0-dev libglibmm-2.4-dev libpangomm-1.4-dev libglade2-dev libaudiofile-dev libavahi-client-dev libavahi-common-dev libavahi-glib-dev libbonobo2-dev libdbus-1-dev libesd0-dev libgconf2-dev libgcrypt11-dev libgnomevfs2-dev libgnutls-dev libgpg-error-dev libpopt-dev libselinux1-dev libsepol1-dev libtasn1-3-dev libsqlite3-dev libboost1.40-dev  libmysqlclient-dev libmysqld-dev uuid-dev liblua5.1-0-dev libncurses5-dev libreadline-dev libreadline6-dev libfribidi-dev libgl1-mesa-dev libglc-dev libglc0 libglu1-mesa-dev mesa-common-dev libpcre3-dev libpcrecpp0 python-paramiko
  ./autogen.sh --prefix=/path/where/you/want/to/install/it
  make
  make install
  /path/where/you/did/install/it/bin/mysql-workbench

For those guys who already tried it and got errors for missing packages, a python-error for missing import or a seg-faults, here my list of errors and the packages/action required to install/run:

No package 'libzip' found

checking for ZIP... configure: error: Package requirements (libzip) were not met:

No package 'libzip' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables ZIP_CFLAGS
and ZIP_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

libzip dev package is missing install it via apt-get:

apt-get install libzip-dev libzip1

No package 'libxml-2.0' found

checking for GLIB... configure: error: Package requirements (glib-2.0 gthread-2.0 gmodule-2.0 libxml-2.0 >= 2.6.2) were not met:

No package 'libxml-2.0' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables GLIB_CFLAGS
and GLIB_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

libxml dev package is missing install it via apt-get:

apt-get install libxml2-dev

No package 'sigc++-2.0' found

checking for SIGC... configure: error: Package requirements (sigc++-2.0) were not met:

No package 'sigc++-2.0' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables SIGC_CFLAGS
and SIGC_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

sigc++2.0 dev package is missing install it via apt-get:

apt-get install libsigc++-2.0-dev

No package 'libglade-2.0' found / No package 'gtkmm-2.4' found/h3>

checking for GNOME... configure: error: Package requirements (libglade-2.0 gtkmm-2.4) were not met:

No package 'libglade-2.0' found
No package 'gtkmm-2.4' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables GNOME_CFLAGS
and GNOME_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

libglade2 dev and libgtkmm 2 dev packages are missing install them via apt-get:

apt-get install libcairomm-1.0-dev libglibmm-2.4-dev libpangomm-1.4-dev libglade2-dev libaudiofile-dev libavahi-client-dev libavahi-common-dev libavahi-glib-dev libbonobo2-dev libdbus-1-dev libesd0-dev libgconf2-dev libgcrypt11-dev libgnomevfs2-dev libgnutls-dev libgpg-error-dev libpopt-dev libselinux1-dev libsepol1-dev libtasn1-3-dev

No package 'libgnome-2.0' found

checking for LIBGNOME... configure: error: Package requirements (libgnome-2.0) were not met:

No package 'libgnome-2.0' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables LIBGNOME_CFLAGS
and LIBGNOME_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

libgnome dev package is missing install it via apt-get:

apt-get install libgnome2-dev

No package 'sqlite3' found

checking for SQLITE3... configure: error: Package requirements (sqlite3) were not met:

No package 'sqlite3' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables SQLITE3_CFLAGS
and SQLITE3_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

libsql3 dev package is missing install it via apt-get:

apt-get install libsqlite3-dev

configure: error: "BOOST library is missing"

checking for boost/foreach.hpp... no
configure: error: "BOOST library is missing"

libboost dev package is missing install it via apt-get:

apt-get install libboost1.40-dev

configure: error: Could not find mysql_config script. Make sure the mysql client libraries are installed

checking for mysql headers and libraries... ./configure: line 16478: mysql_config: command not found
./configure: line 16479: mysql_config: command not found
configure: error: Could not find mysql_config script. Make sure the mysql client libraries are installed

libmysqlclient and libmysqld dev packages are missing install them apt-get:

apt-get install libmysqlclient-dev libmysqld-dev

No package 'uuid' found

checking for UUID... configure: error: Package requirements (uuid) were not met:

No package 'uuid' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables UUID_CFLAGS
and UUID_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

uuid dev package is missing install it via apt-get:

apt-get install uuid-dev

No package 'lua' found

checking for LUA... configure: error: Package requirements (lua >= 5.1) were not met:

No package 'lua' found

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables LUA_CFLAGS
and LUA_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.

liblua5.1 dev package is missing install it via apt-get:

apt-get install liblua5.1-0-dev libncurses5-dev libreadline-dev libreadline6-dev

configure: error: OpenGL headers not found

checking for GL/gl.h... no
configure: error: OpenGL headers not found

opengl dev packages are missing install them via apt-get:

apt-get install liblua5.1-0-dev libncurses5-dev libreadline-dev libreadline6-dev

configure: error: Could not find pcre-config script. Make sure the pcre libraries are installed

checking for pcre-config... no
configure: error: Could not find pcre-config script. Make sure the pcre libraries are installed

libprce dev and libpcrecpp package are missing install them via apt-get:

apt-get install libpcre3-dev libpcrecpp0

ImportError: No module named paramiko

Traceback (most recent call last):
  File "/opt/wb/share/mysql-workbench/sshtunnel.py", line 10, in <module>
    import paramiko
ImportError: No module named paramiko
terminate called after throwing an instance of 'std::runtime_error'
  what():  Error starting tunnel manager: 
Aborted</module>

python-paramiko is missing install it via apt-get:


              

segmentation fault ./mysql-workbench-bin

[2]    20800 segmentation fault  ./mysql-workbench-bin

Dont start mysql-workbench-bin, use mysql-workbench instead


Trackbacks (0)

Trackbackurl: http://www.robo47.net/trackback/blogentry/193

Es sind keine Trackbacks vorhanden.


Kommentare (11)

  • Kommentar von Jason am 10.01.2010 18:04:47
    Gravatar Jason

    Many thanks. This also helped me on ubuntu 9.10


  • Kommentar von Andrew am 12.06.2010 19:44:14
    Gravatar Andrew

    Hey, thanks a lot for this post. Helped me a lot. Whoever wrote the MySQL GUI client should really learn Java.

    What a pain this thing is.


  • Kommentar von Peace76 am 02.09.2010 21:40:41
    Gravatar Peace76

    A very big thanks. It was very important for me to install mysql-workbench. You guide made it quite easy. keep the good work up. / Peace76


  • Kommentar von audunms am 30.11.2010 09:25:52
    Gravatar audunms

    It seems you have the wrong command for the OpenGL package. Otherwise nice walkthrough.


  • Kommentar von yureg am 06.12.2010 21:51:35
    Gravatar yureg

    Nice manual, Benjamin. Works as described. Except I've installed some additional gnome libraries.

    My conf is Debian Squeeze amd64, Workbench 5.2.30

    Thank you.


  • Kommentar von robo47 am 12.12.2010 21:01:55
    Gravatar robo47

    That's right, probably too much copy&paste while creating the article, will have to retest it soon with a blank Squeeze


  • Kommentar von robo47 am 12.12.2010 21:04:43
    Gravatar robo47

    @yureg Which ones did you have to install ?

    Probably I had some already installed for other things.


  • Kommentar von umapathi am 20.12.2010 12:11:59
    Gravatar umapathi

    hi ,

    i am getting this error when running this command after installing according to the above instructions.

    debian:/usr/local/src/mysql-workbench-oss-5.2.11# /usr/local/src/bin/mysql-workbench

    (mysql-workbench-bin:18886): Gtk-WARNING **: cannot open display:

    - Umapathi


  • Kommentar von robo47 am 20.12.2010 21:19:02
    Gravatar robo47

    As which user do you try to run it ?


  • Kommentar von chris am 21.12.2010 10:33:22
    Gravatar chris

    im having trouble with libgnome2-dev... im getting:

    Package libgnome2-dev is not available, but is referred to by another package.
    This may mean that the package is missing, has been obsoleted, or
    is only available from another source
    E: Package libgnome2-dev has no installation candidate

    i tried to change mirrow, error wont disappear. any idea?


  • Kommentar von rama! am 12.01.2011 21:57:52
    Gravatar rama!

    Hi! congratulation from Argentina for the post. I have got running MySQL Workbench from .deb's on Debian 6.

    Bye!


Die Kommentare zu diesem Beitrag sind gesperrt.

You liked it ? Link it on your homepage or blog: