Bugzilla Bug 159957

Similar to bug 131383, but I do not wish to clutter that one as this is
slightly different.  I have taken the current portage ebuild for
mysql-gui-tools and modified it so that MySQL workbench compiles and runs fine
on my system.  I have only tested it briefly.

Download the ebuild and patch into an overlay and emerge with
USE='workbench-alpha' set.

Some notes:

- Installed using x86, I do not believe that there are extra unstable package
requirements other than those that mysql-gui-tools might need on its own

- The RDEPEND probably does not include everything that is really needed (and
perhaps some of them should only be DEPEND).  It includes everything I needed
that was not installed on my system already, plus the opengl virtual.  I am
unsure if including virtual/opengl is the correct way to require opengl and I
have not tried compiling without it installed.  Please comment if it does not
build because it is missing a dependency.

I took the list of depends from "extra requirements" at
http://forge.mysql.com/wiki/Building_MySQL_GUI_Tools_on_Linux, only I found
uuid (so far) to not be needed.

- Similar to bug 131383, I found that it tries to link against -ltermcap. 
However this is only one small part of the common library that doesn't appear
to use termcap (it uses slang.h from sys-libs/slang) and it links fine without.
 A patch is included that removes this from the configure scripts.

- The other two patches needed by bug 131383 do not appear to be needed on my
system.

- The ebuild syntax may be wrong in places, my apologies for this.  Please
submit corrections :)

- Perhaps the USE flag is a bad idea or wrongly named.

Lastly, I hope that this hasn't been done elsewhere already and I am
duplicating effort.  b.g.o search is slow today and whilst I've looked, I've
not found.

My emerge --info:

Portage 2.1.1-r2 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.4-r4,
2.6.17-gentoo-r4 i686)
=================================================================
System uname: 2.6.17-gentoo-r4 i686 Intel(R) Xeon(TM) CPU 3.00GHz
Gentoo Base System version 1.12.6
Last Sync: Thu, 04 Jan 2007 03:00:01 +0000
ccache version 2.4 [enabled]
app-admin/eselect-compiler: [Not Present]
dev-java/java-config: 1.3.7, 2.0.30
dev-lang/python:     2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r6
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.14
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=nocona -O2 -fomit-frame-pointer -mmmx -msse2 -mfpmath=sse -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /var/bind
/var/qmail/alias /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf
/etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-march=nocona -O2 -fomit-frame-pointer -mmmx -msse2 -mfpmath=sse
-pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig ccache distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://gentoo.blueyonder.co.uk/"
LINGUAS="en_GB"
MAKEOPTS="-j5"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress
--force --whole-file --delete --delete-after --stats --timeout=180
--exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage /usr/portage/local/layman/vmware"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 X alsa alsa_cards_ali5451 alsa_cards_als4000 alsa_cards_atiixp
alsa_cards_atiixp-modem alsa_cards_bt87x alsa_cards_ca0106 alsa_cards_cmipci
alsa_cards_emu10k1x alsa_cards_ens1370 alsa_cards_ens1371 alsa_cards_es1938
alsa_cards_es1968 alsa_cards_fm801 alsa_cards_hda-intel alsa_cards_intel8x0
alsa_cards_intel8x0m alsa_cards_maestro3 alsa_cards_trident
alsa_cards_usb-audio alsa_cards_via82xx alsa_cards_via82xx-modem
alsa_cards_ymfpci alsa_pcm_plugins_adpcm alsa_pcm_plugins_alaw
alsa_pcm_plugins_asym alsa_pcm_plugins_copy alsa_pcm_plugins_dmix
alsa_pcm_plugins_dshare alsa_pcm_plugins_dsnoop alsa_pcm_plugins_empty
alsa_pcm_plugins_extplug alsa_pcm_plugins_file alsa_pcm_plugins_hooks
alsa_pcm_plugins_iec958 alsa_pcm_plugins_ioplug alsa_pcm_plugins_ladspa
alsa_pcm_plugins_lfloat alsa_pcm_plugins_linear alsa_pcm_plugins_meter
alsa_pcm_plugins_mulaw alsa_pcm_plugins_multi alsa_pcm_plugins_null
alsa_pcm_plugins_plug alsa_pcm_plugins_rate alsa_pcm_plugins_route
alsa_pcm_plugins_share alsa_pcm_plugins_shm alsa_pcm_plugins_softvol apache2
arts bash-completion berkdb bitmap-fonts bjam bzip2 cairo cdr cgi cgii cli
cracklib crypt ctype cups dba dbus dlloader dri dvd dvdr eds elibc_glibc emboss
encode esd fam fastcgi firefox fortran ftp gdbm gif gpm gstreamer gtk2 hal
iconv input_devices_keyboard input_devices_mouse ipv6 isdnlog java jpeg kde
kernel_linux ldap libg++ linguas_en_GB mad mikmod mmx mp3 mpeg mysql ncurses
nls nptl nptlonly nsplugin nvidia ogg opengl oss pam pcre pdf perl php png ppds
pppd pyste python qt3 qt4 quicktime readline reflection ruby samba sdl session
spell spl sqlite sse sse2 ssl tcpd truetype truetype-fonts type1-fonts udev
unicode userland_GNU vhosts video_cards_nv video_cards_nvidia video_cards_vesa
vorbis win32codecs xcomposite xine xinerama xml xorg xscreensaver xv zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
PORTAGE_RSYNC_EXTRA_OPTS

Created an attachment (id=105371) [details]
ebuild that enables MySQL workbench

Created an attachment (id=105374) [details]
mysql-gui-tools-5.0_p8-termcap-fix.patch - disable the requirement for
-ltermcap

Edits configure.in and configure.am for one part of the GUI tools package to
disable linking against -ltermcap, which seems unnecessary.

I still run into this X error bug when starting mysql-workbench:
http://bugs.mysql.com/bug.php?id=21907

What USE flags do you use? Especially for X...

> I still run into this X error bug when starting mysql-workbench:
> http://bugs.mysql.com/bug.php?id=21907

This is interesting.  Google shows that a number of people have had similar
errors with Firefox (due to the Flash plugin) and vnc.  Can you run
mysql-workbench under strace to see where the error occurs?  Like the error
report says, you might need to use --sync in order to see the proper place it
crashes.  Feel free to mail me if you want a hand with this.

Another bug report suggests exporting an environment var before running the
app:

export XLIB_SKIP_ARGB_VISUALS=1

Try that also to see if it works for you.

> What USE flags do you use? Especially for X...

I pasted the output of emerge --info so people could see this, it should all be
up above.  I use modular xorg v7.1.

Created an attachment (id=107555) [details]
strace output

Don't know much about strace. Just ran 'strace mysql-workbench'. Hope, that's
ok. If you need other info, just ask.

I also modified the mysql-gui-tools-5.0_p9.ebuild and it Mysql workbench works
on amd64. Here are the lines I modified
52c52
<       gnome2_src_compile $(use_enable nls i18n)
---
>       gnome2_src_compile $(use_enable nls i18n) --enable-grt --enable-canvas
60,61c60,61
< #     cd "${S}"/mysql-workbench
< #     gnome2_src_compile
---
>       cd "${S}"/mysql-workbench
>       gnome2_src_compile
74,75c74,75
< #     cd "${S}"/mysql-workbench
< #     gnome2_src_install
---
>       cd "${S}"/mysql-workbench
>       gnome2_src_install

resuming, adding "--enable-grt --enable-canvas" to the following line:
        gnome2_src_compile $(use_enable nls i18n) --enable-grt --enable-canvas

and uncommenting the lines related to mysql-workbench

Created an attachment (id=112518) [details]
mysql-gui-tools-5.0_p10.ebuild

An updated mysql-gui-tools-5.0_p10.ebuild

Have posted the full ebuild rather than a diff. as there are many additions and
changes.

Incorporates David's -ltermcap fix as a sed strip instead of a patch.
Libtermcap now being deprecated in favour of -lncurses which mysql-gui-tools
links against anyway (see bug #103105).

Includes two required dependencies:
virtual/opengl
dev-lang/lua

Also includes the '-nls' USE flag fix as discussed in bug #167867

Just an idea, but perhaps we could scrap the following ebuilds...
dev-db/mysql-administrator
dev-db/mysql-query-browser
...and roll them all into the one mysql-gui-tools ebuild with the USE flags
'nls administrator browser migrate'

The mysql-migration-tool being the only tool as part of mysql-gui-tools not
covered by an ebuild.

Lets not forget 'workbench' from the proposed USE flags :)
USE flags 'nls administrator browser migrate workbench'

Created an attachment (id=112550) [details]
Fixes the nls problem

The new ebuild dies if the nls USE flag is set.  This patch fixes this.

> Incorporates David's -ltermcap fix as a sed strip instead of a patch.
> Libtermcap now being deprecated in favour of -lncurses which mysql-gui-tools
> links against anyway (see bug #103105).

Oops, this one doesn't seem to work properly for me:

/usr/lib/ccache/bin/g++ -march=nocona -O2 -fomit-frame-pointer -mmmx -msse2
-mfpmath=sse -pipe -fexceptions -Wall -o grtsh grtsh-grtshell.o -pthread 
../../library/grt-modules/source/.libs/libgrtmods.a
../../library/mysql-resultset/source/.libs/libgrtsqlrs.a
../../library/mysql-resultset/source/.libs/libsqlrs.a
../../library/sql-parser/source/.libs/libsqlparser.a
../../library/generic-runtime/source/.libs/libgrt.a
../../library/base-library/source/.libs/libmysqlx.a
../../library/utilities/source/.libs/libguiutil.a /usr/lib/libgthread-2.0.so
/usr/lib/libglib-2.0.so -lrt /usr/lib/libxml2.so -L/usr/lib/mysql
/usr/lib/mysql/libmysqlclient_r.so -L/usr/lib -lz -lcrypt -lnsl -lm -lpthread
-lssl -lcrypto /usr/lib/libpcre.so -llua -llualib /usr/lib/libexpat.so -luuid
../../library/generic-runtime/source/.libs/libgrttextui.a
../../library/generic-runtime/newt/libmnewt.a -lslang-utf8 -ltermcap -lncurses
-ldl -lstdc++ -Wl,--rpath -Wl,/usr/lib/mysql -Wl,--rpath -Wl,/usr/lib/mysql
/usr/lib/gcc/i686-pc-linux-gnu/4.1.1/../../../../i686-pc-linux-gnu/bin/ld:
cannot find -ltermcap

If I get time I will try and fix this, but for now it seems that my termcap
patch was broken when moving it to a sed strip.

This should be fixed with dev-db/mysql-gui-tools-5.0_p10-r1, thanks for
reporting!

There is the same error with mysql-gui-tools-5.0_p12-r2.ebuild.

USE="-administrator -query-browser workbench" emerge dev-db/mysql-gui-tools -v

says:

 * Please activate at least one of the following USE flags:
 * - administrator for MySQL Administrator
 * - query-browser for MySQL Query Browser
 * - workbench for MySQL Workbench