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.
Priority: Normal => High
Assigning to Jani rather than pkg-bugs, since he is the main committer of this pkg still around.
CC: (none) => lewyssmithAssignee: bugsquad => jani.valimaa
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-bugsCC: (none) => jani.valimaaSource RPM: mysql-workbench-6.3.10-6.mga7.src.rpm => mysql-connector-c++-1.1.9-2.mga7
Thank you Jani for the lightning fix!
CC: lewyssmith => (none)
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.
Ooops! :s/Fill/Feel/
I cann't see any package mysql-connector-c++ in the repo, old or new.
CC: (none) => herman.viaene
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. ;-)
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
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).
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
Validating.
Keywords: (none) => validated_updateCC: (none) => andrewsfarm, sysadmin-bugs
Keywords: (none) => advisoryCC: (none) => tmb
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2019-0091.html
Status: NEW => RESOLVEDResolution: (none) => FIXED
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
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.
I am using mga 6 so where and how do I install this version? Thanks.
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…
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.
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