So I had a problem and had to do a fresh install (Linux Mint 19.1).
When I re-installed CQRLOG, I got the following message:
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Anything I can do?
Jerry
KI4IO
Hi Jerry,
please install libmariadbclient-dev and libmariadbclient-dev-compat packages. How did you install the package? All needed dependencies are listed and should be installed together with the CQRLOG deb package.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thanks Petr
So I installed the two files you suggested, but still get:
"Error during connection to database: TMySQL56Connection : Server connect failed."
I installed CQRlog originally from the Linux Mint Synaptic Package manager. My notes from a few years ago mentioned these dependencies. Wonder if I should un-install and then re-install via the command line?
Thanks
Jerry
KI4IO
i think the problem is in the database version.
Linux Mint 19.1 should use version 10.2.
You should install mariadb 10.5 but it should be available on Linux Mint 20.
--
Giuseppe
IKØDWJ
I had been running Mint 19.1 for over a year and CQRLOG was FB - so I don't know if
upgrading to Mint 20 is the answer. I downloaded and installed the suggested files to
no avail. I even deleted CQRLOG and loaded it from the command line. Nothing.
Will tinker with this in the morning
Thanks all
Jerry
KI4IO
HI Jerry !
Any help from checking these:
sudo apt install mariadb-common mariadb-server mariadb-client
sudo apt install cqrlog
(That is from message : https://www.cqrlog.com/node/2507 )
As usual "can not connect to database"! This is what I have seen so many times here.
At this time my install was done without package and I cannot blame package makers.
After few starts as cqrlog debug=1 it cleared out that cqrlog cannot find a link to mariadb libraries. Link was not there where cqrlog expects it to be. A symlink was needed to fix this:
sudo ln -s /usr/lib/x86_64-linux-gnu/libmysqlclient.so.21 /lib/libmysqlclient.so
After that cqrlog started nicely!
(That is from message : https://www.cqrlog.com/node/2984 )
Try to install "libmariadb-dev-compat" and you do not need a symlink.
(Same as Petr suggest, but here is question of Ubuntu, not Mint. Are they similar enough?)
(That is from message : https://www.cqrlog.com/comment/8769#comment-8769 )
--
Saku
OH1KH
Hi Saku,
from what you say there seems to be a dependency management problem, otherwise it is not explained why I, for example, would have to install "libmariadb-dev-compat" separately, to get cqrlog to work.
See below:
$ apt-cache depends cqrlog | grep mariadb
mariadb-client-core-10.5
mariadb-server-core-10.5
Depends: libmariadb-dev-compat
These are the dependencies of the original cqrlog package valid since 2.5.0.
Back to 2.5.0 I didn't check.
That's why I advised in the answer to Jerry to switch to mariadb 10.5.
On Debian the above packages are automatically installed by cqrlog, otherwise cqrlog would not be installable. I understand that every linux distribution is different from another, but at least the dependencies of one package should be the same for all.
--
Giuseppe
IKØDWJ
However a version number for mariadb is not specified in the cqrlog dependencies, it uses the available version provided by the Linux distribution used.
--
Giuseppe
IKØDWJ
have installed the software recommended by Saku (OK1KH) and now get the following:
Error during connection to database: TMySQL56Connection : Server connect failed.
Not sure if this is progress
Thanks!
Jerry
Hi Jerry!
Can you start your current cqrlog from console window as:
cqrlog --debug=1 > /tmp/debug.txt
And when it stops to error add the file /tmp/debug.txt to your next message here. Then we can see if there is any glue.
And for Giuseppe,IKØDWJ:
Good points! I can not check those things as I have Fedora here and it has dnf instead of apt and different repositories.
--
Saku
OH1KH
Saku,
This is what I got:
Unable to open file "/root/.config/cqrlog/ctyfiles/Country.tab".
Press OK to ignore and risk data corruption.
Press Abort to kill the program.
Jerry
OK Jerry!
You should NEVER run cqrlog as root user.
You install it as root (or sudo) but then you must use your regular username for daily use, not root.
--
Saku
OH1KH
$ cqrlog --debug=1 > /tmp/debug.txt
[1] 3781
Command 'gt' not found, but can be installed with:
sudo apt install genometools
bash: /tmp/debug.txt: Permission denied
jerryw@jerrywlinux:~$
**** DEBUG LEVEL 1 ****
SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.20
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/jerryw/
Program home directory: /home/jerryw/.config/cqrlog/
Data directory: /home/jerryw/.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.7
*
56 us states loaded
Opps!
How you did get & gt; in command, it be arrow left how it shows out here in browser.
But never mind. debug so far does not show anything wrong. Is this really all you get?
"56 us states loaded" is the last line?
Because after that the interesting part should exist like:
*
56 us states loaded
Grid map created
/usr/bin/mysqld
MySQLProcess.Executable: /usr/bin/mysqld_safe Parameters: --defaults-file=/home/saku/.config/cqrlog/database/mysql.cnf
--datadir=/home/saku/.config/cqrlog/database/
--socket=/home/saku/.config/cqrlog/database/sock
--port=64000
Trying to connect to database
210214 21:38:10 mysqld_safe Logging to '/home/saku/.config/cqrlog/database//mysql.err'.
210214 21:38:10 mysqld_safe Starting mysqld daemon with databases from /home/saku/.config/cqrlog/database/
TMySQL57Connection : Server connect failed.
Trying:1
Loading login
Load values set local
Try to give these "whereis" commands in your console:
[saku@hamtpad ~]$ whereis mysqld
mysqld: /usr/libexec/mysqld /usr/share/man/man8/mysqld.8.gz
[saku@hamtpad ~]$ whereis mysqld_safe
mysqld_safe: /usr/bin/mysqld_safe /usr/share/man/man1/mysqld_safe.1.gz
[saku@hamtpad ~]$
--
Saku
OH1KH
Yep, that's my last line..and the command line cursor just sits there blinking.
do I need to install "get" or "gt"
Jerry
Hi Jerry!
It is not necessary to install "get" or "gt". The arrow on the right ">" for some reason has been changed with the related html code "
>"and misinterpreted as commad "gt" which obviously has nothing to do with debugging.73
--
Giuseppe
IKØDWJ
Hi Jerry!
Open command terminal. Do not open root terminal, but terminal with user account.
You should see prompt like (username @ PC name):
[saku@tpad ~]$
Then write:
mysql --version (and press enter to get some results)
whereis mysqld (and press enter to get some results)
whereis mysqld_safe (and press enter to get some results)
Paint, copy and paste results to your next message, or take screen copy from command console and add picture to your next message.
--
Saku
OH1KH
$ mysql --version
mysql Ver 14.14 Distrib 5.7.33, for Linux (x86_64) using EditLine wrapper
$ whereis mysqld
mysqld: /usr/sbin/mysqld /usr/share/man/man8/mysqld.8.gz
$ whereis mysqld_safe
mysqld_safe: /usr/bin/mysqld_safe /usr/share/man/man1/mysqld_safe.1.gz
If I continue to have difficulties - I may switch over to Ubuntu which, I see, seems to work well with CQRLOG
Thanks so much for all the help!
Jerry
Using Ubuntu 20.04.2 now - here's what I get
$ mysql --version
mysql Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
$ whereis mysqld
mysqld: /usr/sbin/mysqld /usr/share/man/man8/mysqld.8.gz
mysqld_safe: /usr/bin/mysqld_safe /usr/share/man/man1/mysqld_safe.1.gz
Jerry
KI4IO
HI Jerry!
"mysql Ver 14.14 Distrib 5.7.33" shows out that you do not have MariDB installed, or working properly. Then you will have problems with cqrlog.
Your Ubuntu install shows better. You have MariaDB there and cqrlog should work better.
--
Saku
OH1KH
Yes, I see that I do have it installed, but this morning - still no luck. Here's what I get:
Error during connection to database: TMySQL57Connection : Server connect failed.
Jerry
HI Jerry!
Try again now user console command
cqrlog --debug=1 > /tmp/debug.txt
And when cqrlog stops take /tmp/debug.txt and add it to your next message (below message edit window here is: file /choose file / upload )
--
Saku
OH1KH
here's what I get:
Failed to load module "canberra-gtk-module"
Jerry
but still get:
Error during connection to database: TMySQL57Connection : Server connect failed.
Jerry
Realizing that it's not kosher to reply to ones own email - I've been going through the .config files and notice a huge discrepancy between what I have on my back-up drive and what's installed in my 1TB home folder inside the computer. Not sure, but I'd be surprised of that wasn't the source of my woes.
For example, the jerryw/.config/cqrlog/database folder doesn't even exist in my system home folder.
another example, the jerryw/.config/cqrlog is also different - assume the back-up drive has the correct version
Happy to accept any advice before I try to copy/replace those hidden files
Jerry
KI4IO
Hi Jerry!
Do not copy/replace anything yet.
Make backup copy of your current jerryw/.config/cqrlog folder with console:
cp -a /home/jerryw/.config/cqrlog /home/jerryw/.config/cqrlog_backup
Check that /home/jerryw/.config/cqrlog_backup looks similar as /home/jerryw/.config/cqrlog
Then remove /home/jerryw/.config/cqrlog
rm -rf /home/jerryw/.config/cqrlog
And try to start cqrlog again.
If it starts it should say that "seems that you have not use cqrlog before" .... let it use local machine for logs and make log001
If it works the you know that you previous folder /home/jerryw/.config/cqrlog had something wrong.
After successful start you can again remove
rm -rf /home/jerryw/.config/cqrlog
and restore old directory completely from backup drive or restore the backup you did with
cp -a /home/jerryw/.config/cqrlog_backup /home/jerryw/.config/cqrlog
And start to dig out what is wrong in folder.
--
Saku
OH1KH
I had a modest screw-up - I removed that .config/CQRLOG folder but didn't copy it...realizing that I have a good copy of /.config/cqrlog from my old OS where CQRLOG worked just fine.
At this point I have no choice - I'll just copy that old .config/cqrlog file over and see what happens
Jerry
Hi Jerry!
Sad to hear!
You did not follow my orders line by line. Do not find short path to skip something.
I asked you
1) backup your folder
2) delete original folder
3) start cqrlog Did you this? what happened then? You just say you copied old folder from old OS
I am very interested in what happens when you start cqrlog so that you have first removed ~/.cqnfig/cqrlog folder completely and NOT COPIED anything. That corresponds situation where you have never used cqrlog before and everything is started from zero.
But do not delete your ~/.cqnfig/cqrlog folder unless you have first checked that your backup copy is ok and you are able to restore it!
The tail of mysql.err file does not tell anything valuable for me.
A screen copy how far cqrlog starts and maybe the complete debug dump that you get if you start cqrlog from console as "cqrlog --debug=1" may say more.
--
Saku
OH1KH
Sorry
The answer is that yes, after I deleted /.config/cqrlog, CQRLOG came on, as if I was a new user.
That's when I then installed the old /.config/cqrlog file from when CQRLOG was last working. CQRLOG wou not load. Here is what I get in response to "cqrlog --debug=1"
$ cqrlog --debug=1
Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****
OS:
Linux version 5.8.0-43-generic (buildd@lcy01-amd64-018) (gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #49~20.04.1-Ubuntu SMP Fri Feb 5 09:57:56 UTC 2021
SSL libraries:
libssl.so
libcrypto.so
Loaded 153942 LoTW users
Loaded 139970 eQSL users
Loaded 34473 SCP calls
*
User home directory: /home/jerryw/
Program home directory: /home/jerryw/.config/cqrlog/
Data directory: /home/jerryw/.config/cqrlog/database/
Memebers directory: /home/jerryw/.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/jerryw/.config/cqrlog/database/mysql.cnf
--datadir=/home/jerryw/.config/cqrlog/database/
--socket=/home/jerryw/.config/cqrlog/database/sock
--port=64000
Trying to connect to database
Warning: World-writable config file '/home/jerryw/.config/cqrlog/database/mysql.cnf' is ignored
2021-02-18 10:10:36 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0ubuntu0.20.04.1) starting as process 4305 ...
2021-02-18 10:10:36 0 [Note] InnoDB: Using Linux native AIO
2021-02-18 10:10:36 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-18 10:10:36 0 [Note] InnoDB: Uses event mutexes
2021-02-18 10:10:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-18 10:10:36 0 [Note] InnoDB: Number of pools: 1
2021-02-18 10:10:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-18 10:10:36 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-02-18 10:10:36 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-18 10:10:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-18 10:10:36 0 [Note] InnoDB: The log sequence number 1317100793 in the system tablespace does not match the log sequence number 1317101068 in the ib_logfiles!
2021-02-18 10:10:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-18 10:10:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-18 10:10:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-18 10:10:36 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-18 10:10:36 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-02-18 10:10:36 0 [Note] InnoDB: Waiting for purge to start
2021-02-18 10:10:36 0 [Note] InnoDB: 10.3.25 started; log sequence number 1317101068; transaction id 1105932
2021-02-18 10:10:36 0 [Note] InnoDB: Loading buffer pool(s) from /home/jerryw/.config/cqrlog/database/ib_buffer_pool
2021-02-18 10:10:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-18 10:10:36 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-02-18 10:10:36 0 [Note] Recovering after a crash using tc.log
2021-02-18 10:10:36 0 [Note] Starting crash recovery...
2021-02-18 10:10:36 0 [Note] Crash recovery finished.
2021-02-18 10:10:36 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2021-02-18 10:10:36 0 [Note] Server socket created on IP: '::'.
2021-02-18 10:10:36 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
TMySQL57Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:2
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:3
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:4
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:5
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:6
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:7
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
Hi !
Try these commands from console:
chown -R jerryw.jerryw /home/jerryw/.config/cqrlog/
If you get errors then add sudo
sudo chown -R jerryw.jerryw /home/jerryw/.config/cqrlog/
After that give
chmod -R 755 /home/jerryw/.config/cqrlog/
And after that try again start cqrlog with debug=1
--
Saku
OH1KH
2021-02-12T04:22:16.076741Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-02-12T04:22:16.076750Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-02-12T04:22:16.076757Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-02-12T04:22:16.076803Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-02-12T04:22:16.076811Z 0 [Note] Shutting down plugin 'MyISAM'
2021-02-12T04:22:16.076832Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-02-12T04:22:16.076840Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-02-12T04:22:16.076847Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-02-12T04:22:16.076854Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-02-12T04:22:16.076860Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-02-12T04:22:16.076867Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-02-12T04:22:16.076874Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-02-12T04:22:16.076881Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-02-12T04:22:16.076888Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-02-12T04:22:16.076895Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-02-12T04:22:16.076901Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-02-12T04:22:16.076908Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-02-12T04:22:16.076915Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-02-12T04:22:16.076922Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-02-12T04:22:16.076929Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-02-12T04:22:16.076935Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-02-12T04:22:16.076942Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-02-12T04:22:16.076949Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-02-12T04:22:16.076956Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-02-12T04:22:16.076964Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-02-12T04:22:16.076971Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-02-12T04:22:16.076979Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-02-12T04:22:16.076986Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-02-12T04:22:16.076994Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-02-12T04:22:16.077002Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-02-12T04:22:16.077008Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-02-12T04:22:16.077015Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-02-12T04:22:16.077021Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-02-12T04:22:16.077028Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-02-12T04:22:16.077036Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-02-12T04:22:16.077042Z 0 [Note] Shutting down plugin 'InnoDB'
2021-02-12T04:22:16.077107Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-02-12T04:22:16.077221Z 0 [Note] InnoDB: Starting shutdown...
2021-02-12T04:22:16.178091Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/jerryw/.config/cqrlog/database/ib_buffer_pool
2021-02-12T04:22:16.178424Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210211 23:22:16
2021-02-12T04:22:17.835450Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1317100784
2021-02-12T04:22:17.838253Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-12T04:22:17.838285Z 0 [Note] Shutting down plugin 'MEMORY'
2021-02-12T04:22:17.838295Z 0 [Note] Shutting down plugin 'CSV'
2021-02-12T04:22:17.838303Z 0 [Note] Shutting down plugin 'sha256_password'
2021-02-12T04:22:17.838309Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-02-12T04:22:17.838491Z 0 [Note] Shutting down plugin 'binlog'
2021-02-12T04:22:17.838813Z 0 [Note] Unable to delete pid file: No such file or directory
2021-02-12T04:22:17.838825Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Thank you for your patience
Jerry
KI4IO