Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 540164 - dev-db/mysql-workbench - Your connection attempt failed for user 'root' from your host to server at localhost:3307: Can't get 'MysqlSqlFacade' module.
Summary: dev-db/mysql-workbench - Your connection attempt failed for user 'root' from ...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Hans de Graaff
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-15 17:26 UTC by Jaak Ristioja
Modified: 2015-07-12 09:54 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
Screenshot.png (MysqlSqlFacade.png,19.98 KB, image/png)
2015-02-15 17:26 UTC, Jaak Ristioja
Details
mysql-workbench debug log.txt (mysql-workbench.log,12.77 KB, text/plain)
2015-02-24 13:23 UTC, Jaak Ristioja
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jaak Ristioja 2015-02-15 17:26:21 UTC
Created attachment 396526 [details]
Screenshot.png

This might be bug #335839 all over again.

[ebuild   R   ~] dev-db/mysql-workbench-6.2.3  USE="doc -debug -gnome-keyring" PYTHON_TARGETS="python2_7" 0 KiB

Portage 2.2.14 (python 3.4.1-final-0, hardened/linux/amd64, gcc-4.9.2, glibc-2.19-r1, 3.18.5-hardened-uusarm x86_64)
=================================================================
System uname: Linux-3.18.5-hardened-uusarm-x86_64-Intel-R-_Core-TM-_i7-4700MQ_CPU_@_2.40GHz-with-gentoo-2.2
KiB Mem:    16299652 total,   6215448 free
KiB Swap:   16777212 total,  16777092 free
Timestamp of tree: Sat, 14 Feb 2015 00:45:01 +0000
ld GNU ld (Gentoo 2.24 p1.4) 2.24
distcc 3.1 x86_64-pc-linux-gnu [disabled]
ccache version 3.1.9 [disabled]
app-shells/bash:          4.2_p53
dev-lang/perl:            5.20.1-r4
dev-lang/python:          2.7.9-r1, 3.4.1
dev-util/ccache:          3.1.9-r4
dev-util/cmake:           2.8.12.2-r2
dev-util/pkgconfig:       0.28-r2
sys-apps/baselayout:      2.2
sys-apps/openrc:          0.13.9
sys-apps/sandbox:         2.6-r1
sys-devel/autoconf:       2.13, 2.69
sys-devel/automake:       1.11.6-r1, 1.12.6, 1.13.4, 1.14.1
sys-devel/binutils:       2.24-r3
sys-devel/gcc:            4.7.4, 4.8.4, 4.9.2
sys-devel/gcc-config:     1.7.3
sys-devel/libtool:        2.4.4
sys-devel/make:           4.0-r1
sys-kernel/linux-headers: 3.19 (virtual/os-headers)
sys-libs/glibc:           2.19-r1
ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="@FREE"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -march=native -ggdb"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/config /usr/share/gnupg/qualified.txt /usr/share/themes/oxygen-gtk/gtk-2.0"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-O2 -pipe -march=native -ggdb"
FCFLAGS="-O2 -pipe"
FEATURES="assume-digests binpkg-logs collision-protect config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch preserve-libs protect-owned sandbox sfperms splitdebug strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync webrsync-gpg xattr"
FFLAGS="-O2 -pipe"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
MAKEOPTS="-j10"
PORTAGE_CONFIGROOT="/"
USE="64bit X a52 aac acl acpi alsa amd64 amr aspell avx avx2 bash-completion bidi boost bzip2 cairo canberra caps cdda cdr cli colord consolekit cracklib crypt cups custom-optimization cxx dbus directfb djvu doc dri dvd dvdr dvdread eds emboss enca encode evo exif faac faad fam fbcon ffmpeg firefox flac fluidsynth fontforge fortran gcrypt gif git glitz gmp gnuplot gnutls gphoto2 gpm gstreamer gtk gtk3 hardened hdri htmlhandbook iconv icu id3tag idn imagemagick introspection ipv6 jack jpeg justify kate kde kontact kpathsea ladspa lapack laptop latex lcms libav libedit libnotify lua lzma lzo mad mailwrapper matroska md5sum midi mikmod mmap mms mmx mng modplug modules mp3 mp4 mpeg mudflap multilib ncurses nptl nptlonly ogg openal openexr opengl opus pam pax_kernel pcre pdf phonon pic plasma png policykit postscript ppds projectm qalculate qt4 readline reflection rrdtool rtmp scanner schroedinger sdl seccomp session smp sndfile source speex spell spl sqlite sse sse2 sse3 sse4_1 sse4_2 ssl ssse3 startup-notification subversion svg sysfs system-sqlite tbb tcpd theora threads tiff truetype ucs2 udev unicode urandom usb v4l v4l2 vaapi vdpau vorbis vpx webkit webp wifi wmf x264 xattr xcb xcomposite xetex xft xinerama xorg xosd xprint xscreensaver xtpax xulrunner xv xvid zlib" ABI_X86="64" ELIBC="glibc" KERNEL="linux"LINGUAS="en et et_EE" USERLAND="GNU"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, SYNC, USE_PYTHON
Comment 1 Jaak Ristioja 2015-02-24 13:23:42 UTC
Created attachment 397404 [details]
mysql-workbench debug log.txt

Attached output of `mysql-workbench --verbose --log-level=debug3 --log-to-stderr`.
Comment 2 Jaak Ristioja 2015-02-24 13:28:12 UTC
This also happens with a clean profile after `rm -rf ~/.mysql/workbench`.
Comment 3 Jaak Ristioja 2015-02-25 14:33:43 UTC
Compiling with --no-as-needed in LDFLAGS also didn't help, so --as-needed is not at fault here. By debugging this issue with the upstream developers on #workbench @ FreeNode we found that the problem is the undefined _ZN12mysql_parser7my_statEPKcP4stati symbol in /usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so. This symbol is instead defined in /usr/lib64/mysql-workbench/libsqlparser.so.6.2.3 but the problem is that nothing else links to that library, nor is it preloaded by the /usr/bin/mysql-workbench script.

The upstream devs (lolek) are further looking into the matter, but for users to work around this issue, one could add the following lines to /usr/bin/mysql-workbench after 'export DBC_DRIVER_PATH="$destdir/usr/lib64/mysql-workbench"':

if test "$LD_PRELOAD" != ""; then
    export LD_PRELOAD="$LD_PRELOAD:$DBC_DRIVER_PATH/libsqlparser.so.6.2.3"
else
    export LD_PRELOAD="$DBC_DRIVER_PATH/libsqlparser.so.6.2.3"
fi
Comment 4 Jaak Ristioja 2015-02-25 15:10:28 UTC
Upstream suggested it might be an issue with the Gentoo Hardened toolchain defaulting to full binds instead of lazy binds at runtime.

https://wiki.gentoo.org/wiki/Hardened/Toolchain#Default_full_binding_at_load-time_.28BIND_NOW.29
https://wiki.gentoo.org/wiki/Hardened/Toolchain#Binding_policy_NOW
Comment 5 Jaak Ristioja 2015-03-25 20:52:42 UTC
dev-db/mysql-workbench-6.2.5 is also affected.
Comment 6 Hans de Graaff gentoo-dev Security 2015-04-26 09:28:16 UTC
I have just added upstream's new GA version 6.3.3. Could you check if the issue is solved there? Is there an upstream bug for this issue?
Comment 7 Hans de Graaff gentoo-dev Security 2015-07-12 08:43:02 UTC
(In reply to Hans de Graaff from comment #6)
> I have just added upstream's new GA version 6.3.3. Could you check if the
> issue is solved there? Is there an upstream bug for this issue?

I can reproduce this with 6.3.4 when using -Wl,-z,now in LDFLAGS.
Comment 8 Hans de Graaff gentoo-dev Security 2015-07-12 09:54:13 UTC
Thanks for doing all the digging here. This should now be fixed in mysql-workbench 6.3.4.