When trying to query database, the gui complains about 'MysqlSqlFacade' module. http://forums.gentoo.org/viewtopic-t-836731.html Running mysql-workbench with --verbose, the modules with unknown symbols are spit out. Additional Information section has some of the symbols. Reproducible: Always Steps to Reproduce: 1. Launch program 2. Select server 3. Open connection to start querying Actual Results: Error message is given: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Can't get 'MysqlSqlFacade' module. Please: 1 Check that mysql is running on server 127.0.0.1 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from Expected Results: Connection to database and a new query tab. dir="/usr/lib/mysql-workbench/modules/" for i in \ _ZNK16Mysql_sql_editor18get_function_namesEv \ _ZN16Mysql_sql_editorD1Ev \ _ZNK16Mysql_sql_editor12get_keywordsEN10Sql_editor11KeywordListE \ _ZN16Mysql_sql_editorC1EN3grt3RefI13db_mgmt_RdbmsEE do rebind -w $dir/wb.model.grt.so.0 $i done for i in \ _ZN12mysql_parser7my_statEPKcP4stati do rebind -w $dir/db.mysql.sqlparser.grt.so.0 $i done Above script fixes the database query here. The following module error remains: ** Message: WARNING: Could not get pointer to grt_module_init in module /usr/lib/mysql-workbench/modules/wb.mysql.validation.grt.so (`grt_module_init': /usr/lib/mysql-workbench/modules/wb.mysql.validation.grt.so: undefined symbol: grt_module_init) ** Message: WARNING: Could not load wb.mysql.validation.grt.so: Invalid module /usr/lib/mysql-workbench/modules/wb.mysql.validation.grt.so ** Message: WARNING: Could not get pointer to grt_module_init in module /usr/lib/mysql-workbench/modules/wb.validation.grt.so (`grt_module_init': /usr/lib/mysql-workbench/modules/wb.validation.grt.so: undefined symbol: grt_module_init) ** Message: WARNING: Could not load wb.validation.grt.so: Invalid module /usr/lib/mysql-workbench/modules/wb.validation.grt.so
Can this still be reproduced with mysql-workbench 5.2.29? I'm using mysql-workbench against a local mysql myself and I haven't seen these issues. Also note that the module errors at the end of the bug report are no longer relevant, because these validation modules are no longer installed in recent version of mysql-workbench. I haven't checked when exactly but they are no longer installed in 5.2.29.
(In reply to comment #1) > Can this still be reproduced with mysql-workbench 5.2.29? I'm using > mysql-workbench against a local mysql myself and I haven't seen these issues. > Also note that the module errors at the end of the bug report are no longer > relevant, because these validation modules are no longer installed in recent > version of mysql-workbench. I haven't checked when exactly but they are no > longer installed in 5.2.29. > I am having this same issue under 5.2.29 I have tried to my remote server and my local server, with and without an ssh tunnel, in all instances I get the same error. I am using ~amd64
(In reply to comment #2) > (In reply to comment #1) > > Can this still be reproduced with mysql-workbench 5.2.29? I'm using > > mysql-workbench against a local mysql myself and I haven't seen these issues. > > Also note that the module errors at the end of the bug report are no longer > > relevant, because these validation modules are no longer installed in recent > > version of mysql-workbench. I haven't checked when exactly but they are no > > longer installed in 5.2.29. > > > > I am having this same issue under 5.2.29 > I have tried to my remote server and my local server, with and without an ssh > tunnel, in all instances I get the same error. > I am using ~amd64 > mysql-workbench with --verbose ** Message: Gnome keyring daemon seems to not be available. Stored passwords will be lost once quit ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/catalog_utils.grt.lua' (lua) ** Message: Initialized Lua module /usr/lib64/mysql-workbench/modules/catalog_utils.grt.lua (WbUtils) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/db.mysql.grt.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/db.mysql.query.grt.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/db.mysql.sqlide.grt.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/dbutils.grt.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/forms.grt.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/sqlide_grt.py' (python) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/table_utils.grt.lua' (lua) ** Message: Initialized Lua module /usr/lib64/mysql-workbench/modules/table_utils.grt.lua (WbTableUtils) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/text_grt.py' (python) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/tools.grt.lua' (lua) ** Message: Initialized Lua module /usr/lib64/mysql-workbench/modules/tools.grt.lua (WbTools) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/wb.model.grt.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/wb.mysql.import.grt.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/wb_admin_grt.py' (python) /usr/lib64/python2.6/site-packages/Crypto/Util/randpool.py:40: RandomPool_DeprecationWarning: This application uses RandomPool, which is BROKEN in older releases. See http://www.pycrypto.org/randpool-broken RandomPool_DeprecationWarning) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/wb_doclib_grt.py' (python) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/wb_utils_grt.py' (python) ** Message: Trying to load module '/usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so' (cpp) ** Message: WARNING: Could not open module /usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so (/usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so: undefined symbol: _ZN12mysql_parser7my_statEPKcP4stati) ** Message: WARNING: Could not load db.mysql.sqlparser.grt.so: Cannot open /usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so ** Message: Trying to load module '/usr/lib64/mysql-workbench/plugins/db.checks.wbp.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/plugins/db.mysql.editors.wbp.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/plugins/db.mysql.wbp.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/plugins/wb.model.editors.wbp.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/plugins/wb.printing.wbp.so' (cpp) ** Message: Trying to load module '/usr/lib64/mysql-workbench/plugins/db.mysql.diff.reporting.wbp.so' (cpp) ** (mysql-workbench-bin:28066): WARNING **: Plugin 'wb.tools.quickTables' from module WbTools has invalid type '' ** (mysql-workbench-bin:28066): WARNING **: Plugin 'wb.tools.quickTables' from module WbTools has invalid type '' ** Message: addModelDiagram built-in command is being overwritten ** Message: addModelSchema built-in command is being overwritten ** Message: addModelTable built-in command is being overwritten ** Message: addModelView built-in command is being overwritten ** Message: addModelRoutine built-in command is being overwritten ** (mysql-workbench-bin:28066): WARNING **: :186: link 'com.mysql.wb.toolbar.dbquery' <object db.Toolbar> key=owner could not be resolved
(In reply to comment #3) > '/usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so' (cpp) > ** Message: WARNING: Could not open module > /usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so > (/usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so: undefined > symbol: _ZN12mysql_parser7my_statEPKcP4stati) > ** Message: WARNING: Could not load db.mysql.sqlparser.grt.so: Cannot open I don't see this in my local version. For those of you who see this failure: please attach emerge --info output or try to diagnose the problem yourselves.
(In reply to comment #4) > (In reply to comment #3) > > > '/usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so' (cpp) > > ** Message: WARNING: Could not open module > > /usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so > > (/usr/lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so: undefined > > symbol: _ZN12mysql_parser7my_statEPKcP4stati) > > ** Message: WARNING: Could not load db.mysql.sqlparser.grt.so: Cannot open > > I don't see this in my local version. For those of you who see this failure: > please attach emerge --info output or try to diagnose the problem yourselves. > emerge --info Portage 2.1.9.25 (default/linux/amd64/10.0/desktop, gcc-4.5.1, glibc-2.12.1-r3, 2.6.31-zen0 x86_64) ================================================================= System uname: Linux-2.6.31-zen0-x86_64-Intel-R-_Core-TM-2_CPU_6600_@_2.40GHz-with-gentoo-2.0.1 Timestamp of tree: Sun, 19 Dec 2010 07:00:01 +0000 app-shells/bash: 4.1_p9 dev-java/java-config: 2.1.11-r3 dev-lang/python: 2.6.6-r1, 2.7.1, 3.1.3 dev-util/cmake: 2.8.3 sys-apps/baselayout: 2.0.1-r1 sys-apps/openrc: 0.6.8 sys-apps/sandbox: 2.4 sys-devel/autoconf: 2.13, 2.68 sys-devel/automake: 1.4_p6, 1.5, 1.9.6-r3, 1.10.3, 1.11.1 sys-devel/binutils: 2.21 sys-devel/gcc: 4.5.1-r1 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.4-r1 sys-devel/make: 3.82 virtual/os-headers: 2.6.36.1 (sys-kernel/linux-headers) ACCEPT_KEYWORDS="amd64 ~amd64" ACCEPT_LICENSE="*" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe -march=native -fomit-frame-pointer" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/config" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.3/ext-active/ /etc/php/cgi-php5.3/ext-active/ /etc/php/cli-php5.3/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo" CXXFLAGS="-O2 -pipe -march=native -fomit-frame-pointer" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests binpkg-logs distlocks fixlafiles fixpackages news parallel-fetch protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch" GENTOO_MIRRORS="http://distfiles.gentoo.org" LANG="C" LDFLAGS="-Wl,-O1 -Wl,--sort-common -Wl,--as-needed -Wl,--hash-style=gnu -Wl,-znow" MAKEOPTS="-j4" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/var/lib/layman/techwolf" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="X a52 aac acl acpi alsa amd64 avi berkdb bluetooth bmp branding bzip2 cairo cddb cdparanoia cdr cdrtools cli consolekit cracklib crypt cups cxx dbus dri dts dvd dvdr emboss encode exif fam fbcon ffmpeg firefox flac fortran gdbm gdm gdu gif gimp gpm gtk hal iconv ipv6 java jpeg lcms ldap libnotify mad mikmod mmx mng modules mp3 mp4 mpeg mplayer mudflap multilib mysql ncurses nls nptl nptlonly nsplugin nspluginwrapper objc ogg opengl openmp openssl pam pango pcre pdf perl php png policykit ppds pppd python qt3support qt4 quicktime readline sdl session spell sse sse2 ssl startup-notification svg sysfs tcpd thunar tiff tk truetype unicode usb vorbis x264 xcb xfce xml xorg xulrunner xv xvid zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="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" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" PHP_TARGETS="php5-2" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="nvidia" 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: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, LINGUAS, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Please reopen or comment if this is still an issue with mysql-workbench 5.2.36.
