MySQL Forums
Forum List  »  MySQL Workbench

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

Clarence, Thank you for your response.

I have attempted to set up an ltrace on my server, but have no experience in setting filters, so am unable to pick out anything at all from the deluge of information presented. A couple of tips on how you established your trace will be most appreciated.

That aside, it seems to me that the login/connection process fails within WB before any connection is attempted with the database, so I don't believe it's MySQL or MariaDb specific.

The following is an extract from the wb.log:

--------------------------

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

Please:
1 Check that mysql is running on server 192.168.0.3
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 192.168.0.3 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 192.168.0.3 connecting from the host address you're connecting from

---------------------------

It seems to fail with the do_connect method exception. It'd, perhaps, be useful if one could see what the unsupported option (or lack thereof) is being passed to the mysql_options() function.

My conclusion that this is an internal failure is borne out by the fact that I am able to manually connect to a remote MariaDb/MySQL database using the Config Management Server tool within WB, but not with the appropriate connection link.

Also, by the fact that there is no traffic received on port 3306 using tcpdump on the remote server.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
99
December 23, 2017 06:28AM


Sorry, only registered users may post in this forum.

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.