MySQL error

3 posts / 0 new
Last post
Anonymous (not verified)
MySQL error

Hi,
I recently did a fresh install of MX Linux and Cqrlog 2.5.2. When I try to launch CQRLog, I get the following error messages:

2021-09-06 22:48:55 0 [Note] InnoDB: Using Linux native AIO
2021-09-06 22:48:55 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-09-06 22:48:55 0 [Note] InnoDB: Uses event mutexes
2021-09-06 22:48:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-06 22:48:55 0 [Note] InnoDB: Number of pools: 1
2021-09-06 22:48:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-06 22:48:55 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2021-09-06 22:48:55 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-06 22:48:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-06 22:48:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-06 22:48:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-06 22:48:55 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-06 22:48:55 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-09-06 22:48:55 0 [Note] InnoDB: Waiting for purge to start
2021-09-06 22:48:55 0 [Note] InnoDB: 10.3.29 started; log sequence number 1602128; transaction id 8
2021-09-06 22:48:55 0 [Note] InnoDB: Loading buffer pool(s) from /home/mateusz/.config/cqrlog/database/ib_buffer_pool
2021-09-06 22:48:55 0 [Note] InnoDB: Buffer pool(s) load completed at 210906 22:48:55
2021-09-06 22:48:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-06 22:48:55 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2021-09-06 22:48:55 0 [Note] Server socket created on IP: '::'.
2021-09-06 22:48:55 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2021-09-06 22:48:55 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2021-09-06 22:48:55 0 [Note] Reading of all Master_info entries succeeded
2021-09-06 22:48:55 0 [Note] Added new Master_info '' to hash table
2021-09-06 22:48:55 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.29-MariaDB-0+deb10u1' socket: '/home/mateusz/.config/cqrlog/database/sock' port: 64000 Debian 10

I also run cqrlog with debug=1 from terminal, this is the response:
OS:
Linux version 5.10.0-5mx-amd64 (stevep@mxlinux.org) (gcc-8 (Debian 8.3.0-6) 8.3.0, GNU ld (GNU Binutils for Debian) 2.31.1) #1 SMP Debian 5.10.26-1~mx19+1 (2021-04-01)
SSL libraries:
libssl.so
libcrypto.so
Loaded 134350 LoTW users
Loaded 125829 eQSL users
Loaded 36919 SCP calls
*
User home directory: /home/mateusz/
Program home directory: /home/mateusz/.config/cqrlog/
Data directory: /home/mateusz/.config/cqrlog/database/
Memebers directory: /home/mateusz/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
*
56 us states loaded
Grid map created
/usr/bin/mysqld
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/mateusz/.config/cqrlog/database/mysql.cnf
--datadir=/home/mateusz/.config/cqrlog/database/
--socket=/home/mateusz/.config/cqrlog/database/sock
--port=64000

Trying to connect to database
2021-09-06 22:51:59 0 [Note] /usr/sbin/mysqld (mysqld 10.3.29-MariaDB-0+deb10u1) starting as process 11965 ...
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:1
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:2
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:3
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:4
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:5
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:6
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:7
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:8

oh1kh
MySQL error

Hi!

Like the dump says you do not have libmysqlclient package installed.

But first check that you have MariaDB, not Mysql 8 (or up) because cqrlog will not work with that.
Using command terminal type command:
mysql --version

You should see somenthing like:
[saku@hamtpad ~]$ mysql --version
mysql Ver 15.1 Distrib 10.5.11-MariaDB, for Linux (x86_64) using EditLine wrapper

If there is no mention about MariaDB then you should install MariDB. Installing that should remove MYSQL v8
There are lots of messages about this subject in this forum.

--
Saku
OH1KH

ok2cqr
ok2cqr's picture
Re: MySQL error

Saku is right. Also install libmariadbclient-dev and libmariadbclient-dev-compat packages.