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

3 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.

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 !