Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
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.
Subject
Views
Written By
Posted
1458
December 13, 2017 12:10PM
4017
December 17, 2017 11:06AM
1209
December 22, 2017 06:57AM
987
December 22, 2017 04:36PM
Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
1699
December 23, 2017 06:28AM
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.