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 attachment 105371 [details] mysql-gui-tools-5.0_p8.ebuild
Created attachment 105374 [details, diff] 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 attachment 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 attachment 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 attachment 112550 [details, diff] 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
