RHEL 8.3 MariaDB and CQRLog

5 posts / 0 new
Last post
KC3SWL
KC3SWL's picture
RHEL 8.3 MariaDB and CQRLog

Hi
I have several disks with CQRLog on different distro's but this new one is giving me issues.
On RHEL 8.3 I was able to install the MariaDB server and client but I can't get CQRLog to see it .
My entries as directed by the error box is this.

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

My last 20 entries as directed

2020-12-19 19:00:06 0 [Note] InnoDB: Using generic crc32 instructions
2020-12-19 19:00:06 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-12-19 19:00:06 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2020-12-19 19:00:06 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-19 19:00:06 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-19 19:00:06 0 [Note] InnoDB: 128 rollback segments are active.
2020-12-19 19:00:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-19 19:00:06 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-19 19:00:06 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-12-19 19:00:06 0 [Note] InnoDB: 10.5.8 started; log sequence number 1602680; transaction id 8
2020-12-19 19:00:06 0 [Note] InnoDB: Loading buffer pool(s) from /home/chris/.config/cqrlog/database/ib_buffer_pool
2020-12-19 19:00:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-19 19:00:06 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2020-12-19 19:00:06 0 [Note] InnoDB: Buffer pool(s) load completed at 201219 19:00:06
2020-12-19 19:00:06 0 [Note] Server socket created on IP: '::'.
2020-12-19 19:00:06 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2020-12-19 19:00:06 1 [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")
2020-12-19 19:00:06 0 [Note] Reading of all Master_info entries succeeded
2020-12-19 19:00:06 0 [Note] Added new Master_info '' to hash table
2020-12-19 19:00:06 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.5.8-MariaDB' socket: '/home/chris/.config/cqrlog/database/sock' port: 64000 MariaDB Server

The version of MariaDB is from the actual MariaDB site to prevent issues with the RHEL which did not seem to be able to find a maraidb-client. I followed the instructions on the mariadb.com website to get it installed on this machine.
Any help would be great
Thanks
Chris

oh1kh
RHEL 8.3 MariaDB and CQRLog

Hi Chris!

As it says it can not find mysql library files. They are not in regular named place. See this message. At the end of it I had to make a symink for library. https://cqrlog.com/node/2984

That could also be solved with Ubuntu by installing llibmariadb-dev-compat that I did not know as I am a Fedora user.

--
Saku
OH1KH

KC3SWL
KC3SWL's picture
RHEL 8.3 MariaDB and CQRLog

Hi Saku
I tried that I found all sorts of links to the libs but none of them worked. I then found that I had both mysql files and mariadb files so I am thinking it got confused.so yanking out all db that I can find. Maybe that is the problem. I tried to symlink but it didn't work still couldn't find the db.
Remoed the original MariaDB server and client packages and looking for the MySQL packages to clean out then will start with one only and work from there. I'm new at this so thanks for the help.
Chris

Chris Holladay

KC3SWL
KC3SWL's picture
RHEL 8.3 MariaDB and CQRLog

well this is interesting. I was trying to install the cqrlog from the EPEL
sources and of course, the newer version of mariadb did away with maria-libs package and now the newer version doens't require it. However the rpm's from EPEL for CQRLog do require it and it's a catch 22.
THe tar file on the CQRLog page is standalone and it still can't find the MySQL regardless of what I do. but this is different here than what I had before.
Here is the MySQL.err report

2020-12-21 0:30:14 0 [Note] InnoDB: Using Linux native AIO
2020-12-21 0:30:14 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-21 0:30:14 0 [Note] InnoDB: Uses event mutexes
2020-12-21 0:30:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-21 0:30:14 0 [Note] InnoDB: Number of pools: 1
2020-12-21 0:30:14 0 [Note] InnoDB: Using generic crc32 instructions
2020-12-21 0:30:14 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2020-12-21 0:30:14 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-21 0:30:14 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-21 0:30:14 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.5.8.
2020-12-21 0:30:14 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-12-21 0:30:15 0 [Note] InnoDB: Starting shutdown...
2020-12-21 0:30:15 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-12-21 0:30:15 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-21 0:30:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-21 0:30:15 0 [ERROR] Unknown/unsupported storage engine: innodb
2020-12-21 0:30:15 0 [ERROR] Aborting
I can only guess that somewhere it started a file then lost it .
I have a headache trying to get this to work. luckily I already have it on the Debian drive.I was hoping to get this working on the RHEL drive.
Thanks
Chris

Chris Holladay

KC3SWL
KC3SWL's picture
RHEL 8.3 MariaDB and CQRLog

I looked at a old issue which reminded me of a possible fix here on the forum where I erased the cqrlog folder in the ~.config folder.
I ditched it and it took a few seconds but then the error came back and now it pointedly says it can't find the files for mysql.
This is the log

2020-12-21 1:30:50 0 [Note] InnoDB: Using Linux native AIO
2020-12-21 1:30:50 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-12-21 1:30:50 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-21 1:30:50 0 [Note] InnoDB: Uses event mutexes
2020-12-21 1:30:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-21 1:30:50 0 [Note] InnoDB: Number of pools: 1
2020-12-21 1:30:50 0 [Note] InnoDB: Using generic crc32 instructions
2020-12-21 1:30:50 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2020-12-21 1:30:50 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-21 1:30:50 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-21 1:30:50 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-21 1:30:50 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
2020-12-21 1:30:50 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
2020-12-21 1:30:50 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
2020-12-21 1:30:51 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2020-12-21 1:30:51 0 [Note] InnoDB: New log files created, LSN=44897
2020-12-21 1:30:51 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-12-21 1:30:51 0 [Note] InnoDB: Doublewrite buffer created
2020-12-21 1:30:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-21 1:30:51 0 [Note] InnoDB: Creating foreign key constraint system tables.
2020-12-21 1:30:51 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-12-21 1:30:51 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-12-21 1:30:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-21 1:30:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-21 1:30:51 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-12-21 1:30:51 0 [Note] InnoDB: 10.3.27 started; log sequence number 0; transaction id 7
2020-12-21 1:30:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-21 1:30:51 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2020-12-21 1:30:51 0 [Note] Server socket created on IP: '::'.
2020-12-21 1:30:51 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2020-12-21 1:30:51 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")
2020-12-21 1:30:51 0 [Note] Reading of all Master_info entries succeeded
2020-12-21 1:30:51 0 [Note] Added new Master_info '' to hash table
2020-12-21 1:30:51 0 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.3.27-MariaDB' socket: '/home/chris/.config/cqrlog/database/sock' port: 64000 MariaDB Server

I have to get some sleep this is really a challenge sorting through all this.
Thanks
Chris

Chris Holladay