Can't run CQRlog

8 posts / 0 new
Last post
k8hw
k8hw's picture
Can't run CQRlog

I just installed CQRlog and am getting an error message upon running the program. I need help as I am new to Ubuntu.

Here is the contents of the error file:
2023-01-02T17:11:52.645281Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.2) starting as process 15082
2023-01-02T17:11:52.646322Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-01-02T17:11:52.646333Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2023-01-02T17:11:52.652551Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-01-02T17:11:52.652753Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-01-02T17:11:52.652775Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-01-02T17:11:52.653209Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31-0ubuntu0.20.04.2) (Ubuntu).

Any help would be greatly appreciated!

Dave - K8HW

oh1kh
Can't run CQRlog

HI Dave!

As so many time (and message threads here) you have installed an faulty Ubuntu package that does not change mysqld 8.0.31-0ubuntu0.20.04.2 to MariaDB.

It is unfortunate that this bug has not been fixed by Ubuntu people.
You have to install MariaDB server and client that replaces mysqld 8.0

sudo apt install mariadb-common mariadb-server mariadb-client

--
Saku
OH1KH

k8hw
k8hw's picture
Can't run CQRlog

Thanks for the answer Saku. That took care of the problem.
I have a problem with a log entry showing the wrong country. The call is AD8IO. The log is showing Alaska when QRZ and HamQTH are showing Ohio, USA. How can I correct this? Thanks!

oh1kh
Can't run CQRlog

Hi!
Official version of Cqrlog does not allow edited DXCC saving.
My alpha test version that I use locally here allows it. You find source code from https://github.com/OH1KH/cqrlog/tree/loc_testing and if you do not want to compile by yourself thre are ready build binaries in https://github.com/OH1KH/cqrlog/tree/loc_testing/compiled
Just download newupdate.zip, extract and run newupdate.sh in command terminal. It will do backups and update for you.

--
Saku
OH1KH

G3ZXX
G3ZXX's picture
Can't run CQRLog

Hi Saku.
I have the same issue as Dave K8HW.

I have followed your advice to Dave K8HW, but still not working.

I'm running Linux Mint 21.1 the latest version (Ubuntu ????) see screen shot attached.

When I run "sudo apt install mariadb-common mariadb-server mariadb-client" the process is .....

alex51@alex51-HP-EliteDesk-800-G2-SFF:~$ sudo apt install mariadb-common mariadb-server mariadb-client
[sudo] password for alex51:
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
mariadb-client is already the newest version (1:10.6.11-0ubuntu0.22.04.1).
mariadb-common is already the newest version (1:10.6.11-0ubuntu0.22.04.1).
mariadb-server is already the newest version (1:10.6.11-0ubuntu0.22.04.1).
The following packages were automatically installed and are no longer required:
libevent-core-2.1-7 libevent-pthreads-2.1-7 libglu1-mesa-dev libmecab2
libprotobuf-lite23 mecab-ipadic mecab-ipadic-utf8 mecab-utils
Use 'sudo apt autoremove' to remove them.
0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.
alex51@alex51-HP-EliteDesk-800-G2-SFF:~$

When I run "sudo apt autoremove" .........

alex51@alex51-HP-EliteDesk-800-G2-SFF:~$ sudo apt autoremove
[sudo] password for alex51:
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages will be REMOVED
libevent-core-2.1-7 libevent-pthreads-2.1-7 libglu1-mesa-dev libmecab2
libprotobuf-lite23 mecab-ipadic mecab-ipadic-utf8 mecab-utils
0 to upgrade, 0 to newly install, 8 to remove and 0 not to upgrade.
After this operation, 57.4 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 638667 files and directories currently installed.)
Removing libevent-pthreads-2.1-7:amd64 (2.1.12-stable-1build3) ...
Removing libevent-core-2.1-7:amd64 (2.1.12-stable-1build3) ...
Removing libglu1-mesa-dev:amd64 (9.0.2-1) ...
Removing mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...
update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Removing mecab-ipadic (2.7.0-20070801+main-3) ...
Removing mecab-utils (0.996-14build9) ...
Removing libmecab2:amd64 (0.996-14build9) ...
Removing libprotobuf-lite23:amd64 (3.12.4-1ubuntu7) ...
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
alex51@alex51-HP-EliteDesk-800-G2-SFF:~$

When I restart CQRLog, I get the same on screen error message, as I did initially.

Any help would be much appreciated .....

73 Dave G3ZXX.

File: 

73 Dave, G3ZXX.

oh1kh
Can't run CQRLog

HI Dave!

Could it be that installing MariaDB did not remove Mysql?
We have to find it out next.

Do you have any qsos in your log(s)? I.E is this an update, or fresh install?
In case you do NOT have any qsos you could first try to delete folder ~/.config/cqrlog
With command console:
rm -rf ~/.config/cqrlog

If you have qsos in log DO NOT DO THIS! It removes completely all: logs and settings.
If you did it and made a new fresh start without success, or if you could not do deleting then next to do is start Cqrlog from command console with:

cqrlog --debug=1 > /tmp/debug.txt

Once cqrlog has stopped and closed find the file /tmp/debug.txt and send it to me as attachment via email.
My address is ok in Hamqth or Qrz.

We can continue this via email

--
Saku
OH1KH

G3ZXX
G3ZXX's picture
Can't run CQRLog

Hi Saku.

Thank you for the reply.

All sorted ...

rm -rf ~/.config/cqrlog solved the problem.

Thank you very much.

73 Dave, G3ZXX

73 Dave, G3ZXX.

oh1kh
Can't run CQRLog

OK Dave.
Great news, enjoy Cqrlog!

--
Saku
OH1KH