MySQL Forums
Forum List  »  MySQL Workbench

Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
Posted by: Malcolm White
Date: December 17, 2017 11:06AM

Further information regarding my attempts at getting this to work.

I have been led to understand that as Workbench is classed as an external application, it is necessary to enable remote login through mysql_secure_connection. This I have done and have connected to the database from another computer using the command line and the username and password configured in Workbench. However, still no connection with WB.

The following is a copy of the log file at the point of launching WB plus the failed connect attempt which starts at 16:28.

16:21:27 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /usr/share/mysql-workbench
plugin path: /usr/lib64/mysql-workbench/plugins
struct path: /usr/share/mysql-workbench/grt
module path: /usr/lib64/mysql-workbench/modules
library path: /usr/share/mysql-workbench/libraries
user data dir: /home/mwhite/.mysql/workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
16:21:27 [INF][ WBContext]: WbContext::init
16:21:28 [WRN][ grt]: Could not load wb.model.grt.so: Could not open module /usr/lib64/mysql-workbench/modules/wb.model.grt.so (/usr/lib64/mysql-workbench/modules/wb.model.grt.so: undefined symbol: _ZN9Scintilla8WordListD1Ev)
16:21:30 [INF][ WBA]: Looking for extension modules for WBA...
16:21:30 [INF][ WBA]: 0 extension modules found
16:21:30 [WRN][ grt]: Could not load db.mysql.diff.reporting.wbp.so: Could not open module /usr/lib64/mysql-workbench/plugins/db.mysql.diff.reporting.wbp.so (/usr/lib64/mysql-workbench/plugins/db.mysql.diff.reporting.wbp.so: undefined symbol: _Z17build_catalog_mapN3grt3RefI16db_mysql_CatalogEERSt3mapINSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEENS0_I14GrtNamedObjectEESt4lessIS9_ESaISt4pairIKS9_SB_EEE)
16:21:30 [WRN][ grt]: /home/mwhite/.mysql/workbench/connections.xml:25: link 'b424bd52-e26e-11e7-a0cb-902b3441ed70' <object GrtObject> key=owner could not be resolved
16:21:30 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Linux/Unix version 6.3.10 CE build 12092614 (64 bit)
Configuration Directory: /home/mwhite/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.15.8
OS: x86_64
CPU: 2x Intel(R) Celeron(R) CPU G540 @ 2.50GHz (2494.159MHz) - 3.75GiB RAM
No video adapter info available
Distribution: openSUSE Tumbleweed

Fips mode enabled: no

16:21:31 [WRN][ WBModule]: OS not found on supported OS list. OS string: ' x86_64'

16:28:35 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Unsupported option provided to mysql_options()
16:28:35 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Unsupported option provided to mysql_options()
16:28:35 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Unsupported option provided to mysql_options()
16:28:35 [ERR][ WQE backend]: Got an exception during connection: Unsupported option provided to mysql_options()
16:28:35 [ERR][SQL Editor Form]: SQL editor could not be connected: Unsupported option provided to mysql_options()
16:28:35 [ERR][SQL Editor Form]: Your connection attempt failed for user 'workbench' from your host to server at localhost:3306:
Unsupported option provided to mysql_options()

Please:
1 Check that mysql is running on server localhost
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the workbench has rights to connect to localhost 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 localhost connecting from the host address you're connecting from

Assuming that the WRN messages are non-fatal, the exception thrown in the do_connect method would sem a good indicator, but not knowing what the exception is makes it a bit difficult to resolve.

Any ideas?

Many thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
553
December 17, 2017 11:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.