Upgrade to Linux Mint 18: Cannot work with installed MySQL client

4 posts / 0 new
Last post
AB9YC
Upgrade to Linux Mint 18: Cannot work with installed MySQL client

When I start with --debug:

**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.5
**********************************
Loaded 95084 LoTW users
Loaded 99431 eQSL users
Loaded 45943 SCP calls
*
User home directory: /home/awillard/
Program home directory: /home/awillard/.config/cqrlog/
Data directory: /home/awillard/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.5
*
56 us states loaded

Then I get a window with "Error during connection to database: TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.7.13)."

Anthony
AB9YC

AB9YC
More info:

More info:

MySQL is on a different machine and I'm connecting from my workstation.

AB9YC
More info:

More info:

When I removed the version installed from the repo, and eliminated the libmysqlclient20, then built from the sources, it works fine.

The module in the repo seems to depend on incorrect MySQL objects, which is causing my issues; even built from source with the libmysqlclient20 installed exhibits the problem.

Here is what came up from the apt-get command line:

The following additional packages will be installed:
libdbd-mysql-perl libmysqlclient-dev libmysqlclient20 mariadb-client mariadb-client-10.0 mariadb-server mariadb-server-10.0
Suggested packages:
mariadb-test tinyca
Recommended packages:
libhtml-template-perl
The following NEW packages will be installed:
cqrlog libdbd-mysql-perl libmysqlclient-dev libmysqlclient20 mariadb-client mariadb-client-10.0 mariadb-server mariadb-server-10.0
0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.

I hope this helps.

I'm back working for now with the version built from source.

lz3sf
easy fix

The quicker solution for me was to remove the symbolic link to libmariadbclient18 and recreated to point to libmysclclient20:

cd /usr/lib/x86_64-linux-gnu/

Make sure this is symbolic link to libmariadbclient.so.18.0.0:

ls -al /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18

Then remove it and recreate it to point to

rm /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18

sudo ln -s libmysqlclient.so.20 libmariadbclient.so.18

Then just start cqrlog and enjoy the radio :)

Thanks Petr.

LZ3SF