Bug 649890 – dev-db/mysql-workbench-6.3.9 & 6.3.10 - Failure to connect to any host "Unsupported option provided to mysql_options()"

• Product: Gentoo Linux
• Status: RESOLVED TEST-REQUEST

[Description Alex Barker 2018-03-08 04:27:45 UTC]

Sigh, once again this quality application fails to function.  When I try connecting to mysql on the localhost, I see "Unsupported option provided to mysql_options()", no error on the command line.

I seem to remember a similar error from a while back related to a library mismatch, possibly mysql-connector-c++ or something stupid like that.

Reproducible: Always

Steps to Reproduce:
1.start mysql workbench
2.try connecting to a server
3.see error message on test connection



Portage 2.3.24 (python 2.7.14-final-0, default/linux/amd64/17.0/desktop/plasma, gcc-7.3.0, glibc-2.26-r6, 4.15.7-gentoo-r1 x86_64)
=================================================================
System uname: Linux-4.15.7-gentoo-r1-x86_64-Intel-R-_Core-TM-_i7_CPU_950_@_3.07GHz-with-gentoo-2.4.1
KiB Mem:    24679024 total,   1843276 free
KiB Swap:    8291540 total,   8291540 free
Timestamp of repository gentoo: Wed, 07 Mar 2018 23:45:01 +0000
Head commit of repository gentoo: 2341a7041023c44359b77f543ad1c8408f4e8747
sh bash 4.4_p19
ld GNU ld (Gentoo 2.30 p1) 2.30.0
app-shells/bash:          4.4_p19::gentoo
dev-java/java-config:     2.2.0-r3::gentoo
dev-lang/perl:            5.26.1-r2::gentoo
dev-lang/python:          2.7.14-r1::gentoo, 3.5.4-r1::gentoo
dev-util/cmake:           3.10.2::gentoo
dev-util/pkgconfig:       0.29.2::gentoo
sys-apps/baselayout:      2.4.1-r2::gentoo
sys-apps/openrc:          0.35.2::gentoo
sys-apps/sandbox:         2.13::gentoo
sys-devel/autoconf:       2.13::gentoo, 2.69-r4::gentoo
sys-devel/automake:       1.15.1-r2::gentoo, 1.16-r1::gentoo
sys-devel/binutils:       2.30::gentoo
sys-devel/gcc:            7.3.0::gentoo
sys-devel/gcc-config:     1.9.1::gentoo
sys-devel/libtool:        2.4.6-r4::gentoo
sys-devel/make:           4.2.1-r2::gentoo
sys-kernel/linux-headers: 4.15::gentoo (virtual/os-headers)
sys-libs/glibc:           2.26-r6::gentoo
Repositories:

gentoo
    location: /usr/portage
    sync-type: rsync
    sync-uri: rsync://rsync6.us.gentoo.org/gentoo-portage
    priority: -1000
    sync-rsync-verify-metamanifest: yes
    sync-rsync-extra-opts: 

local_overlay
    location: /usr/local/portage
    masters: gentoo
    priority: 0

fuverlay
    location: /var/lib/layman/fuverlay
    masters: gentoo
    priority: 50

hasufell
    location: /var/lib/layman/hasufell
    masters: gentoo
    priority: 50

torbrowser
    location: /var/lib/layman/torbrowser
    masters: gentoo
    priority: 50

ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="*"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=native -mtune=native -O2 -fomit-frame-pointer -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/lib64/libreoffice/program/sofficerc /usr/share/config /usr/share/gnupg/qualified.txt"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.6/ext-active/ /etc/php/apache2-php7.0/ext-active/ /etc/php/apache2-php7.2/ext-active/ /etc/php/cgi-php5.6/ext-active/ /etc/php/cgi-php7.0/ext-active/ /etc/php/cgi-php7.2/ext-active/ /etc/php/cli-php5.6/ext-active/ /etc/php/cli-php7.0/ext-active/ /etc/php/cli-php7.2/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-march=native -mtune=native -O2 -fomit-frame-pointer -pipe"
DISTDIR="/usr/portage/distfiles"
EMERGE_DEFAULT_OPTS="--with-bdeps=y --jobs=16 --load-average=10.0"
FCFLAGS="-O2 -pipe"
FEATURES="assume-digests binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync multilib-strict news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr"
FFLAGS="-O2 -pipe"
GENTOO_MIRRORS="http://gentoo.mirrors.easynews.com/linux/gentoo/ http://gentoo.osuosl.org/"
LANG="en_US.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
LINGUAS="en en_US"
MAKEOPTS="-j8"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --exclude=/.git"
PORTAGE_TMPDIR="/var/tmp"
USE="X a52 aac acl acpi activities alsa amd64 amr berkdb branding btrfs bzip2 cairo cdda cddb cdr cifs cli consolekit crypt cups curl custom-cflags cxx dbus declarative dri dts dvd dvdr emboss encode exif faac fam fat ffmpeg flac fortran ftp gdbm gif glamor gpm graphite gsm gstreamer gtk gtk3 hal hfs iconv icu ipv6 javafx jpeg kde kipi kwallet lame lcms legacy-systray libnotify lm_sensors lto lzma mad matroska mmx mmxext mng modules mp3 mp4 mpeg multilib musepack mysql ncurses nfs nls nptl nptlonl ntfs offensive ogg openal opengl openmp opus pam pango pcre pdf pdo phonon pic plasma png policykit popcnt postproc ppds qml qt3support qt5 rar rdesktop rdp readline samba sdl seccomp speex spell sqlite sse sse2 sse3 sse4 sse4_1 sse4_2 ssl ssse3 startup-notification svg system-harfbuzz system-icu system-jpeg system-libevent system-libvpx system-sqlite taglib tcpd theora threads tiff truetype udev udisks unicode upower usb v4l vaapi vdpau vnc vorbis wavpack widgets wxwidgets x264 xattr xcb xcomposite xfs xml xv xvid xvmc zip zlib" ABI_X86="64 32" ALSA_CARDS="hda-intel" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump author" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" CPU_FLAGS_X86="mmx mmxext popcnt sse sse2 sse3 sse4_1 sse4_2 ssse3" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock isync itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf skytraq superstar2 timing tsip tripmate tnt ublox ubx" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LLVM_TARGETS="AMDGPU X86" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php5-6 php7-0 php7-2" POSTGRES_TARGETS="postgres9_5" PYTHON_SINGLE_TARGET="python3_5" PYTHON_TARGETS="python2_7 python3_5" RUBY_TARGETS="ruby22 ruby23" SANE_BACKENDS="artec_eplus48u" USERLAND="GNU" VIDEO_CARDS="amdgpu radeon radeonsi" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset:  CC, CPPFLAGS, CTARGET, CXX, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

[Comment 1 Alex Barker 2018-03-08 04:53:34 UTC]

I strongly suspect that this is related to mysql:5.7 not being in portage... Is it not coming to portage, or was mysql-workbench .9 and .10 released before that ebuild?  Regardless, the ebuild should depend on the correct mysql/marina version.

[Comment 2 Jeroen Roovers (RETIRED) 2018-03-08 14:24:49 UTC]

Could you please provide a proper Summary - it should tell everyone what you think is actually wrong.

[Comment 3 Alex Barker 2018-03-08 20:45:03 UTC]

I don't actually know what is wrong... I think it maybe related to https://bugs.gentoo.org/638558 but I have no idea how.

[Comment 4 Alex Barker 2018-03-08 20:53:11 UTC]

(In reply to Jeroen Roovers from comment #2)
> Could you please provide a proper Summary - it should tell everyone what you
> think is actually wrong.

This particular piece of software has a stability rate revealing that of KDE/Plasma, which is impressive given its scope... I have no idea what is actually wrong, although I suspect it is somehow related to https://bugs.gentoo.org/638558. As reported, I was unable to locate any obvious error aside from the nondescript error dialog described.  This problem does not affect the older versions, rollback seems to work.  If you are aware of some output log that may have additional information, please don't hesitate.

[Comment 5 Jakub Caban 2018-04-23 08:34:43 UTC]

I was struggling with this problem for quite a long time. If you don't want to use mysql 5.7 (as Gentoo seems to suggest), you should use mariadb-10.1.*. Any version 10.2.* ends with this problem as far as I remember, so needs to be masked.

[Comment 6 Hans de Graaff 2018-04-23 18:47:11 UTC]

Ccing the mysql team since they may know more about these changes and overall compatability issues in Gentoo.

[Comment 7 Hans de Graaff 2019-07-23 08:56:59 UTC]

mysql-workbench 8.0.17 (and I assume all 8.x versions) work fine with my connecting to mariadb 10.2.x. mysql-workbench 8.x uses mysql-connector-c++ to connect, so this may be responsible for the fix.

Please reopen if this is still an issue with mysql-workbench 8.x.