Installing Mysql Workbench 5.2.11 from source on Debian 6.0 Squeeze
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/193Es sind keine Trackbacks vorhanden.
You liked it ? Link it on your homepage or blog:
Benjamin Steininger ist Webentwickler auf der Suche nach einem neuen Job und
photographiert sehr gerne. Er beschäftigt sich viel mit dem Internet, PHP, Symfony, Testing und hat einen
Kommentare (11)
Many thanks. This also helped me on ubuntu 9.10
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.
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
It seems you have the wrong command for the OpenGL package. Otherwise nice walkthrough.
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.
That's right, probably too much copy&paste while creating the article, will have to retest it soon with a blank Squeeze
@yureg Which ones did you have to install ?
Probably I had some already installed for other things.
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
As which user do you try to run it ?
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?
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.