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?
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
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
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
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
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