Bug 25071 - MySQL Workbench 6.3.10 fails to connect to MariaDB servers
Summary: MySQL Workbench 6.3.10 fails to connect to MariaDB servers
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 7
Hardware: All Linux
Priority: High critical
Target Milestone: ---
Assignee: QA Team
QA Contact:
URL:
Whiteboard: MGA7-64-OK
Keywords: advisory, validated_update
Depends on:
Blocks:
 
Reported: 2019-07-08 11:23 CEST by Davy Defaud
Modified: 2019-08-12 00:01 CEST (History)
7 users (show)

See Also:
Source RPM: mysql-connector-c++-1.1.9-2.mga7
CVE:
Status comment:


Attachments

Description Davy Defaud 2019-07-08 11:23:52 CEST
Description of problem:

Each time I try to connect to a MariaDB server (5.5.* and even Mageia’s 10.3.16) MySQL Workbench is failing with the following error message: “Unsupported option provided to mysql_options()”.
An interesting thing is that I’ve tried MySQL’s package dedicated to Fedora 27 (mysql-workbench-community-6.3.10-1.fc27.x86_64.rpm) which can be downloaded from https://dev.mysql.com/downloads/file/?id=474215 (it requires lib64jpeg62 as a dependency, and I forced the installation because of naming differences of other dependencies) and I’ve bee able to connect to my servers. So there’s really something bad in the version provided by Mageia 7.
Davy Defaud 2019-07-08 11:24:34 CEST

Priority: Normal => High

Comment 1 Lewis Smith 2019-07-08 21:39:04 CEST
Assigning to Jani rather than pkg-bugs, since he is the main committer of this pkg still around.

CC: (none) => lewyssmith
Assignee: bugsquad => jani.valimaa

Comment 2 Jani Välimaa 2019-07-09 20:50:42 CEST
Added patches from openSUSE to mysql-connector-c++ to make it to work with mariadb.

mysql-connector-c++-1.1.9-2.1.mga7 should be available soonish in core/updates_testing for mga7. Please test.

Assignee: jani.valimaa => qa-bugs
CC: (none) => jani.valimaa
Source RPM: mysql-workbench-6.3.10-6.mga7.src.rpm => mysql-connector-c++-1.1.9-2.mga7

Comment 3 Lewis Smith 2019-07-09 22:58:41 CEST
Thank you Jani for the lightning fix!

CC: lewyssmith => (none)

Comment 4 Davy Defaud 2019-07-09 23:18:10 CEST
Yes indeed, thank you for the quick fix Jani! I was pretty sure that mysql-connector-c++ was the culprit… ;-)
I confirm that MySQL Workbench can connect to MariaDB servers (at least mine).

Fill free to close the bug after pushing mysql-connector-c++-1.1.9-2.1.mga7 to Core update.
Comment 5 Davy Defaud 2019-07-10 17:26:19 CEST
Ooops!

:s/Fill/Feel/
Comment 6 Herman Viaene 2019-07-24 15:05:14 CEST
I cann't see any package mysql-connector-c++ in the repo, old or new.

CC: (none) => herman.viaene

Comment 7 Davy Defaud 2019-07-24 20:32:31 CEST
It’s called lib64mysqlcppconn7 or libmysqlcppconn7 on a 32-bit system. It hasn’t been pushed to core/updates yet. I don’t know why…
But you can still get it from the core/updates_testing repo. The simplest is to install it directly from the command line (as root), so you don’t even have to configure the repo:

rpm -Uvh ftp://ftp.belnet.be/mirror/mageia/distrib/7/x86_64/media/core/updates_testing/lib64mysqlcppconn7-1.1.9-2.1.mga7.x86_64.rpm

P.-S. : It’s a Belgian repo, the one suitable for you. ;-)
Comment 8 Herman Viaene 2019-07-25 13:21:11 CEST
The package was already installed,but I was having trouble getting to connect to port 3306.
Got around the problem by adding following two lines to /etc/my.cnf.d/server.cnf in the setion [mysqld]:
skip-networking=false
bind-address=127.0.0.1
and then restarting mysqld.
Then wrkbench connected OK.

Whiteboard: (none) => MGA7-64-OK

Comment 9 Herman Viaene 2019-07-26 10:14:45 CEST
As an afterthought: maybe my problem has been caused by the options I took when initiating the mysql-server with mysql-secure-installation: I do not allow remote oeration (or something alike).
Comment 10 PC LX 2019-07-30 16:33:09 CEST
Installed and tested without issue.

I had this same issue with mysql workbench not connecting to mariadb.

After installing the package lib64mysqlcppconn7-1.1.9-2.1.mga7.x86_64 the issue is resolved and workbench connects to mariadb without issues.

System: Mageia 7, x86_64, Plasma DE, LXQt DE, MariaDB, MySQL Workbench, Intel CPU, nVidia GPU using nvidia340 proprietary driver.


$ uname -a
Linux marte 5.1.18-desktop-1.mga7 #1 SMP Sun Jul 14 10:08:39 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
$ rpm -q lib64mysqlcppconn7 mariadb mysql-workbench
lib64mysqlcppconn7-1.1.9-2.1.mga7
mariadb-10.3.16-1.mga7
mysql-workbench-6.3.10-6.mga7

CC: (none) => mageia

Comment 11 Thomas Andrews 2019-08-09 13:12:05 CEST
Validating.

Keywords: (none) => validated_update
CC: (none) => andrewsfarm, sysadmin-bugs

Thomas Backlund 2019-08-09 22:36:04 CEST

Keywords: (none) => advisory
CC: (none) => tmb

Comment 12 Mageia Robot 2019-08-10 02:14:13 CEST
An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2019-0091.html

Status: NEW => RESOLVED
Resolution: (none) => FIXED

Comment 13 Vincent Coen 2019-08-10 13:49:17 CEST
Is there a fix for this problem for Mga 6  ?

I issued a bug report a long time back with the same problem.

Using packages :

rpm -q lib64mysqlcppconn7 mariadb mysql-workbench
lib64mysqlcppconn7-1.1.8-1.mga6
mariadb-10.1.39-1.mga6
mysql-workbench-6.3.9-1.mga6

CC: (none) => vbcoen

Comment 14 Davy Defaud 2019-08-10 15:45:08 CEST
I didn’t experience this problem when I was running Mageia 6. It came with the new mysql-connector-c++ 1.1.9 from Mageia 7. It’s probably something different.
Comment 15 Vincent Coen 2019-08-10 18:26:46 CEST
I am using mga 6 so where and how do I install this version?

Thanks.
Comment 16 Davy Defaud 2019-08-10 19:31:11 CEST
Which version?

If you want to try mysql-connector-c++-1.1.9 with with mysql-workbench-6.3.9-1.mga6, you can do it with a simple RPM command as I already wrote in comment #7:

rpm -Uvh ftp://ftp.belnet.be/mirror/mageia/distrib/7/x86_64/media/core/updates_testing/lib64mysqlcppconn7-1.1.9-2.1.mga7.x86_64.rpm

But that will be with no guarantee.

You could also add MGA7 repos (main and update) temporarily (see https://wiki.mageia.org/en/URPMI#Adding_media_for_a_distribution) then let URPMI solve the dependencies for MySQL Workbench:

urpmi mysql-workbench

And then remove the MGA7 repos.

But honestly, you’d rather consider upgrading your Mageia to version 7, with all the new software stack…
Comment 17 Vincent Coen 2019-08-11 22:56:40 CEST
Well that went bad as too many failed dependancies - yes was expecting it.

Just how stable is v7.1 and can I update over v6?

I am running a server based system that is also used for development GnuCobol among others along with ftp, mysql, apache and mbse (BBS) servers.
Comment 18 Davy Defaud 2019-08-12 00:01:05 CEST
This is out of topic, Mageia forum is the good place for that kind of subjects…

AFAIK, update from Mageia 6 to 7 hasn’t been pushed to users yet. But, if you want to update now, see: https://wiki.mageia.org/en/URPMI#Adding_media_for_a_distribution

Note You need to log in before you can comment on or make changes to this bug.