Installing MySQL Workbench 5.2.15b on Gentoo Linux
written on 8/2/10 by ohcibi
Today I installed Mysql Workbench (http://dev.mysql.com/downloads/workbench/5.2.html)
on Gentoo Linux. I basically followed this guide: http://coalface.mcslp.com/2008/11/10/compiling-mysql-workbench-on-gentoo/
but with a few differences, since this guide is about 1 year old now.
So the guide told me to install necessary packages like this:
# USE="svg" emerge libzip libxml2 libsigc++ \
libglade libgtksourceviewmm media-libs/glut mysql lua \
ossp-uuid libpcre libgnome gtk+ pango cairo
I omitted the USE="svg" since its already activated on my machine. Also afaik using temporary USE-flags is only good for testing purposes. So if you dont want to enable the svg-flag in general, I recommend you to add proper lines to your /etc/portage/package.use. Otherwise the USE-changes get lost during the next update.
I also did the installation of ctemplate by the same time because there is ctemplate-0.95 available in portage now. I had to unmask it though.
The next problem I encountered was during the following sequence:
# cd mysql-workbench-5.1.4alpha
# ./autogen.sh
# make
# make install
After autogen.sh everything looked fine. But when I ran make I got the following error: /usr/lib64/python2.6/config/libpython2.6.a: No such file or directory. After googleing a bit I found out, that this problem is especially related to gentoo. Nobody seems to knows why this error is only happening on gentoo. But this comment: http://wb.mysql.com/?p=279#comment-517 helped. So I did
# locate libpython2.6.a
/usr/lib64/libpython2.6.a
# ln -s /usr/lib64/libpython2.6.a /usr/lib64/python2.6/config/libpython2.6.a
ran make again and it builds fine.
WooHooo I was happy to use this candy piece of software now without Windows (yeah I admit: for finishing this task for university I was booting windows several times to use MySQL workbench).
But Wait! Whats with my ssh-tunnel connections. I kept getting a strange error that some "TunnelManager" was not able to start. After googling once more I realised that this is, again, related to python. I read the word "paramiko" several times in the search results and thought: "Hey lets see what portage has to offer.".
# eix paramiko
* dev-python/paramiko
Available versions: 1.7.5 1.7.6 {doc examples}
Homepage: http://www.lag.net/paramiko/ http://pypi.python.org/pypi/paramiko
Description: SSH2 protocol library
I read something about a tunnel in the first link and was not sure. So I tried to emerge -av paramiko to see what deps it needs. Because there were only two packages that should be emerged (one was paramiko itself) I just emerged it and afterwards I was able to use a mysql connection through a ssh tunnel.
Since its a beta it sometimes crashes unexpectedly. But this happens with the Windows version as well and its not happening very often.
One thing that I didn't experienced with the windows-version yet was that it crashs when I try to forward engineer an EER-model. When I tried it the first time I had errors in the sql script generated caused by some senseless table definitions (NOT NULL DEFAULT NULL). I corrected the schema and now after entering the passphrase for my id_rsa the GUI freezes and Workbench crashs. I'll write an update when I find out why this is and how to fix this.