Hello All. I recently did a fresh install of Debian 9.10 and installed CQRLog 2.1. When I try to launch CQRLog, I get the following error messages:
"Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation."
Following the instructions on the database error tab that came up, these are the last 20 lines of the mysql.err file. Any and all help is greatly appreciated.
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Using Linux native AIO
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Using generic crc32 instructions
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Completed initialization of buffer pool
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Waiting for purge to start
2017-08-18 13:47:24 139897514238528 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600759
2017-08-18 13:47:24 139896886900480 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-08-18 13:47:24 139897514238528 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-18 13:47:24 139897514238528 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2017-08-18 13:47:24 139897514238528 [Note] Server socket created on IP: '::'.
2017-08-18 13:47:24 139897514238528 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2017-08-18 13:47:24 139897513782016 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2017-08-18 13:47:24 139897514238528 [Note] Reading of all Master_info entries succeded
2017-08-18 13:47:24 139897514238528 [Note] Added new Master_info '' to hash table
2017-08-18 13:47:24 139897514238528 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.23-MariaDB-9+deb9u1' socket: '/home/dave/.config/cqrlog/database/sock' port: 64000 Debian 9.0
Further info: After reading another post, and taking Petr's advice to the other ham, I ran 'cqrlog --debug=1' from a terminal. This is the response:
**** DEBUG LEVEL 1 ****
SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.2
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.2
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Ctyfiles dir: /usr/share/cqrlog/ctyfiles/
Local ctyfiles dir: /root/.config/cqrlog/ctyfiles/
[FORMS.PP] ExceptionOccurred
Sender=EFOpenError
Exception=Unable to open file "/root/.config/cqrlog/ctyfiles/Country.tab"
Stack trace:
$0000000000482BD3
$00000000004829DC
$000000000045A7C5
TApplication.HandleException Unable to open file "/root/.config/cqrlog/ctyfiles/Country.tab"
Stack trace:
$0000000000482BD3
$00000000004829DC
$000000000045A7C5
Closing ini file ...
Again, any and all help greatly appreciated.
Hi!
What worries me is that why you are running cqrlog as "root" ?
You should not use root at all !
"Normal user" with sudo- rights can do all normally needed operations for linux usage.
if you start cqrlog from console with debug=1 as user dave is the resulting text same?
--
Saku
OH1KH
--
Saku
OH1KH
Saku, many thanks for the response. When I run CQRLog as normal user I don't use sudo. From a terminal I just type in 'cqrlog --debug-1. These are the result, which has changed from my first post.
**** DEBUG LEVEL 1 ****
SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.2
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.2
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/dave/
Program home directory: /home/dave/.config/cqrlog/
Data directory: /home/dave/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
WARNING: obsolete call to RecreateWnd for TfrmDBConnect
Warning: TWinControl.DestroyHandle frmDBConnect:TfrmDBConnect Handle not Allocated
Also, I get an error box titled 'Error' which says,
"Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.18" or "libmysqlclient.so"). Check your installation."
and a Database Connection box which has boxes asking for the server name, the port, the user name, the password, check boxes to 'remember me and auto connect, both of which are checked. I am going to remove and reinstall cqrlog to see if that helps.
Dave
Removed and reinstalled CQRLog, same errors. I have it installed on another hard drive on this computer (don't know if it's the same version) running Linux Mint, and it works flawlessly.
Dave
Saku, consider this one solved. Did a few more things and have it working. Thanks again for the help.
Dave KD8AZO
Dave
Hi Dave,
I've hit the same problem with a fresh install of Debian 9.1 and CQRLog 2.1.0-1 (error log below)
...any clues as to what you fiddled with to make it work?
Thanks
Andy G7UHN
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Using Linux native AIO
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Using SSE crc32 instructions
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Completed initialization of buffer pool
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Waiting for purge to start
2017-08-31 13:10:52 139896344277568 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1600719
2017-08-31 13:10:52 139896344277568 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-31 13:10:52 139895678957312 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-08-31 13:10:52 139896344277568 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2017-08-31 13:10:52 139896344277568 [Note] Server socket created on IP: '::'.
2017-08-31 13:10:52 139896344277568 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2017-08-31 13:10:52 139896343829248 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2017-08-31 13:10:52 139896344277568 [Note] Reading of all Master_info entries succeded
2017-08-31 13:10:52 139896344277568 [Note] Added new Master_info '' to hash table
2017-08-31 13:10:52 139896344277568 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.26-MariaDB-0+deb9u1' socket: '/home/andy/.config/cqrlog/database/sock' port: 64000 Debian 9.1
....sorry, a little bit more reading on the forum revealed the answer for me:
apt-get install libmariadbclient-dev-compat
... thanks to Colin G8TMV :-)