MySQL problem with clean install openSUSE 15

2 posts / 0 new
Last post
KT5TE
MySQL problem with clean install openSUSE 15

I realize that openSUSE isn't supported, but any help would be appreciated. On LEAP 42.3 and older I've had no problems with CQRLOG, but this time I did a clean install instead of an update.
What did I not do correctly?

73, KT5TE

Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.

Error:

2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Uses event mutexes
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Using Linux native AIO
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Number of pools: 1
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Using SSE2 crc32 instructions
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Completed initialization of buffer pool
2018-07-14 9:12:33 140189382956800 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-14 9:12:33 140189842249920 [Note] InnoDB: 5.7.22 started; log sequence number 1603667
2018-07-14 9:12:33 140188806280960 [Note] InnoDB: Loading buffer pool(s) from /home/william/.config/cqrlog/database/ib_buffer_pool
2018-07-14 9:12:33 140188806280960 [Note] InnoDB: Buffer pool(s) load completed at 180714 9:12:33
2018-07-14 9:12:33 140189842249920 [Note] Plugin 'FEEDBACK' is disabled.
2018-07-14 9:12:33 140189842249920 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2018-07-14 9:12:33 140189842249920 [Note] Server socket created on IP: '::'.
2018-07-14 9:12:33 140189842249920 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2018-07-14 9:12:33 140189761550080 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2018-07-14 9:12:33 140189842249920 [Note] Reading of all Master_info entries succeded
2018-07-14 9:12:33 140189842249920 [Note] Added new Master_info '' to hash table
2018-07-14 9:12:33 140189842249920 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.2.15-MariaDB' socket: '/home/william/.config/cqrlog/database/sock' port: 64000 openSUSE package
2018-07-14 9:12:52 140189761242880 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2018-07-14 9:12:52 140189259257600 [Note] InnoDB: FTS optimize thread exiting.
2018-07-14 9:12:52 140189761242880 [Note] InnoDB: Starting shutdown...
2018-07-14 9:12:52 140188806280960 [Note] InnoDB: Dumping buffer pool(s) to /home/william/.config/cqrlog/database/ib_buffer_pool
2018-07-14 9:12:52 140188806280960 [Note] InnoDB: Buffer pool(s) dump completed at 180714 9:12:52
2018-07-14 9:12:53 140189761242880 [Note] InnoDB: Shutdown completed; log sequence number 1603695
2018-07-14 9:12:53 140189761242880 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-14 9:12:53 140189761242880 [Note] /usr/sbin/mysqld: Shutdown complete

I ran debug and got this:

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 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/william/
Program home directory: /home/william/.config/cqrlog/
Data directory: /home/william/.config/cqrlog/database/
Memebers directory: /home/william/.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/william/.config/cqrlog/database/mysql.cnf --datadir=/home/william/.config/cqrlog/database/ --socket=/home/william/.config/cqrlog/database/sock --port=64000
Trying to connect to database
2018-07-14 9:05:09 140182967699648 [Note] /usr/sbin/mysqld (mysqld 10.2.15-MariaDB) starting as process 14005 ...
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/william/.config/cqrlog/database/linux-hq78.pid
Command:
kill 14005
Closing ini file ...

oh1kh
SUSE

Hi !
You should load package libmysqlclient-devel that should give you "libmysqlclient.so" what cqrlog is looking for.

If you have installed it open console and give
cd /
sudo find -name libmysqlclient.*

To see if you actually have libmysqlclient, you should see something like:

[saku@tpad /]$ sudo find -name libmysqlclient.*
[sudo] salasana henkilölle saku:
./usr/lib64/mysql/libmysqlclient.so.20.3.9
./usr/lib64/mysql/libmysqlclient.so.20
./usr/lib64/libmysqlclient.so

If you have that package installed ok.

--
Saku
OH1KH