Ubuntu 20.04 CQRLOG (2.4.0) failed to start. Cannot connect to mysql database.

11 posts / 0 new
Last post
w5kye
Ubuntu 20.04 CQRLOG (2.4.0) failed to start. Cannot connect to mysql database.

I have Ubuntu 20.04 and I installed cqrlog from the ubuntu archives, when I start cqrlog it asks if I want to create a local database, and then quickly fails with the following error message.

2020-04-08T05:19:43.028690Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19-0ubuntu4) starting as process 5782
2020-04-08T05:19:43.029548Z 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.
2020-04-08T05:19:43.029558Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-04-08T05:19:43.043741Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-04-08T05:19:43.043907Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-04-08T05:19:43.043969Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-04-08T05:19:43.044314Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19-0ubuntu4) (Ubuntu).

Looks like since I am starting with nothing in the database it fails to create and connect ? I am new HAM and dont have any qsos.

-- Running with DEBUG:

$ cqrlog DEBUG=1
Gtk-Message: 00:25:49.641: Failed to load module "canberra-gtk-module"

Cqrlog Ver:2.4.0 (001) Date:2019-10-27
**** DEBUG LEVEL 1 ****

OS:
Linux version 5.4.0-21-generic (buildd@lcy01-amd64-006) (gcc version 9.3.0 (Ubuntu 9.3.0-8ubuntu1)) #25-Ubuntu SMP Sat Mar 28 13:10:28 UTC 2020
SSL libraries:
libssl.so
libcrypto.so
Loaded 134350 LoTW users
Loaded 125829 eQSL users
Loaded 36919 SCP calls
*
User home directory: /home/manjo/
Program home directory: /home/manjo/.config/cqrlog/
Data directory: /home/manjo/.config/cqrlog/database/
Memebers directory: /home/manjo/.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/manjo/.config/cqrlog/database/mysql.cnf
--datadir=/home/manjo/.config/cqrlog/database/
--socket=/home/manjo/.config/cqrlog/database/sock
--port=64000

Trying to connect to database
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

w5kye
here is a fix for this issue.

use mariadb instead. If you install mariadb-server you are going to run into issues.. if you are on ubutnu 20.04 install maria-db server as follows:

$ sudo apt install mariadb-server-10.3 mariadb-client-10.3

After this I am able to launch cqrlog.

n0vep
ubutnu 20.04

This solution worked for me on a fresh install of 20.04.

ofrie (not verified)
remove mysql

it is strictly recommended, to fellow the installation option mariadb-server-10.3... . During the installation of mariadb-server-10.3 ... will be removed all not necessary components of mysql.
Do not remove mysql-server ore mysqlserver-8.0 on cli !

DF7EM
solution doesn't work with xubuntu 20.04LTS

I tried the solution but I still get the error log.

2020-08-28T20:08:29.377118Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 11810
2020-08-28T20:08:29.380409Z 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.
2020-08-28T20:08:29.380436Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-08-28T20:08:29.408186Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-08-28T20:08:29.408629Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-08-28T20:08:29.408807Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-08-28T20:08:29.409953Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).

Do you have an idea?
73

dl2vwr
cqrlog doesn't work with ubuntu 20.04 lts

"Server connect failed", but why?

oh1kh
cqrlog doesn't work with ubuntu 20.04 lts

Hi!
[Server] Failed to find valid data directory.

Do you have some kind of protection (root kit / apparmor, maridb base settings... what ever Ubuntu uses, I do not know) that prevents mysql to use any other directory for database as what is stated in settings from it's install package?

--
Saku
OH1KH

DL8YDU
cqrlog doesn't work with ubuntu 20.04 lts

Hello to all,
yesterday I changed my OS from Ubuntu Mate 18.04lts to 20.04lts. When I did install cqrlog 2.4.0 in the latest version I get a message, that apparmor changed something at the mysql installation. After the installation finisched, Start of cqrlog failed with the message "TMySQL57Connection : Server connect failed". After that I take a look in this posts and try to install mariadb instead of mysql. It works at once.

Hardy
DL8YDU

WG9L
How to migrate old MySQL log to Mariadb

Hi,

I installed a new SSD on my Linux machine. I also decided to upgrade from Mint 19.2 to Mint 20 (5.4.0.48 kernel). I have been following the various threads regarding the need to change from MySQL to Mariadb in order to get CQRLog working.

I did a fresh clean install of Mint 20 (64 bit) and then installed Mariadb and then installed CQRLog (2.4.0 (001). CQRLog will start, but then I get the "Database connection" window (see attached image). I'm not sure what to do at this point? How can I get CQRLog to read my old MySQL log file and populate the Database connection window properly and then run CQRLog program properly? I want to carry over all my old settings and config files and log file without any loss of data. Any thoughts?

Thanks,
Bob, WG9L

File: 

oh1kh
How to migrate old MySQL log to Mariadb

Hi Bob!

You should have copy from hidden directory ~/.config/cqrlog from your old machine setup.
It is the place where all settings and logs are if you have checked "save log data to local machine". If the folder is there I.E. you did not roll over your username's home folder with new install it should be there. (perhaps pick it up with usb stick from old HDD)

You should use "save log data to local machine" checkbox if you used it with previous Linux install.

--
Saku
OH1KH

WG9L
That worked, Saku. Thanks

That worked, Saku. Thanks once again.