New installation of OS - trouble getting CQRLOG back

32 posts / 0 new
Last post
KI4IO
New installation of OS - trouble getting CQRLOG back

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

ok2cqr
ok2cqr's picture
Re: New installation of OS - trouble getting CQRLOG back

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

KI4IO
Still won't load

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

ik0dwj
ik0dwj's picture
Try updating to mariadb version 10.5

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

KI4IO
Still not working

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

oh1kh
New installation of OS - trouble getting CQRLOG back

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

ik0dwj
ik0dwj's picture
The version of mariadb is important.

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

ik0dwj
ik0dwj's picture
The version of mariadb is important.

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

KI4IO
Most recent

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

oh1kh
New installation of OS - trouble getting CQRLOG back

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

KI4IO
Saku,

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

oh1kh
New installation of OS - trouble getting CQRLOG back

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

KI4IO
here's the debug:

$ 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

oh1kh
here's the debug:

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

KI4IO
last line...

Yep, that's my last line..and the command line cursor just sits there blinking.
do I need to install "get" or "gt"

Jerry

ik0dwj
ik0dwj's picture
Read more carefully what Saku writes to you.

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

oh1kh
New installation of OS - trouble getting CQRLOG back

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

KI4IO
$ mysql --version

$ 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

KI4IO
Using Ubuntu 20.04.2 now -

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

oh1kh
$ mysql --version

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

KI4IO
mariaDB

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

oh1kh
mariaDB

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

KI4IO
de-bug

here's what I get:
Failed to load module "canberra-gtk-module"

Jerry

KI4IO
loaded canberra

but still get:
Error during connection to database: TMySQL57Connection : Server connect failed.

Jerry

KI4IO
update

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

oh1kh
New installation of OS - trouble getting CQRLOG back

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

KI4IO
old CQRLOG folder

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

oh1kh
old CQRLOG folder

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

KI4IO
Oooops

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

oh1kh
old CQRLOG folder

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

KI4IO
last 20 lines mysql error file

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

KI4IO
CQRLOG up and running

Thank you for your patience

Jerry
KI4IO