CQR vs MySQL vs MariaDB

6 posts / 0 new
Last post
kk4ggl
CQR vs MySQL vs MariaDB

When I try to start CQRLog I get the following error:
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.

I am using OpenSuse 15.1, MariaDB and CQRLog version 2.3.0 from OpenSuse's Ham Radio Repository.

I was able to open CQRLog and update my log on Jan 31.

Any ideas?

kk4ggl
re: CQR vs MySQL vs MariaDB

cqrlog --debug=1

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib64/libssl.so.1.1
/usr/lib64/libcrypto.so.1.1
Loading libmysqlclient:
FATAL ERROR: Can not get MySQL client library version version!
Setting to default version (5.1)
**********************************
MySQL version assigned: 5.1
**********************************
Loaded 137805 LoTW users
Loaded 127870 eQSL users
Loaded 35084 SCP calls
*
User home directory: /home/rick/
Program home directory: /home/rick/.config/cqrlog/
Data directory: /home/rick/.config/cqrlog/database/
Memebers directory: /home/rick/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.1
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/rick/.config/cqrlog/database/mysql.cnf --datadir=/home/rick/.config/cqrlog/database/ --socket=/home/rick/.config/cqrlog/database/sock --port=64000
Trying to connect to database
2020-02-22 16:05:11 139852897923648 [Note] /usr/sbin/mysqld (mysqld 10.2.29-MariaDB) starting as process 10137 ...
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:1
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:2
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:3
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:4
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:5
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:6
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:7
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
/home/rick/.config/cqrlog/database/Tower.pid
Command:
kill 10137
Closing ini file ...

Rick, KK4GGL

oh1kh
CQR vs MySQL vs MariaDB

Hi!
Looks like you have lost libmysqlclient symlink (by updates?)

See this https://cqrlog.com/comment/8060#comment-8060

Does it give any help?

--
Saku
OH1KH

kk4ggl
CQR vs MySQL vs MariaDB

whereis libmariadb.so.3

libmariadb.so: /usr/lib/libmariadb.so.3 /usr/lib64/libmariadb.so.3

sudo ln -s /usr/lib64/libmariadb.so /usr/lib64/libmysqlclient.so

ls -l /usr/lib64/libmysqlclient.so

lrwxrwxrwx 1 root root 24 Feb 23 07:22 /usr/lib64/libmysqlclient.so -> /usr/lib64/libmariadb.so

cqrlog

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****

FATAL ERROR: Can not get MySQL client library version version!
Setting to default version (5.1)
2020-02-23 7:23:14 140557971771968 [Note] /usr/sbin/mysqld (mysqld 10.2.29-MariaDB) starting as process 8312 ...
Closing ini file ...

cqrlog --debug=1

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib64/libssl.so.1.1
/usr/lib64/libcrypto.so.1.1
Loading libmysqlclient:
FATAL ERROR: Can not get MySQL client library version version!
Setting to default version (5.1)
**********************************
MySQL version assigned: 5.1
**********************************
Loaded 137805 LoTW users
Loaded 127870 eQSL users
Loaded 35084 SCP calls
*
User home directory: /home/rick/
Program home directory: /home/rick/.config/cqrlog/
Data directory: /home/rick/.config/cqrlog/database/
Memebers directory: /home/rick/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.1
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/rick/.config/cqrlog/database/mysql.cnf --datadir=/home/rick/.config/cqrlog/database/ --socket=/home/rick/.config/cqrlog/database/sock --port=64000
Trying to connect to database
2020-02-23 7:27:54 140307224957504 [Note] /usr/sbin/mysqld (mysqld 10.2.29-MariaDB) starting as process 8872 ...
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:1
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:2
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:3
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:4
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:5
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:6
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:7
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
/home/rick/.config/cqrlog/database/Tower.pid
Command:
kill 8872
Closing ini file ...

Rick, KK4GGL

oh1kh
re: CQR vs MySQL vs MariaDB

Perhaps reinstalling mariadb and maridb-dev could help.
Or some of these https://www.google.com/search?q=libmysqlclient+suse+mariadb

How ever first take a copy from ~/.config/cqrlog with all files and subfolders.
cp -a ~/.config/cqrlog /a/backup/path/somewhere
It should not effect to cqrlog when reinstall mariadb, but safety first.

--
Saku
OH1KH

kk4ggl
re: CQR vs MySQL vs MariaDB

No need. A previous comment apparently didn't post. It's up and running. The first thing I did was an adif backup.
Thanks so much for your help/

Rick, KK4GGL