I am setting up a new PC with Zoron 18.1. I installed CQRLog and when first launched it crashes trying to create the first database.
I get the following error: "MySql could not be started, please check if MySql Server is installed properly." and "Error during connection to database: TMySQL57Connection : Server connect failed."
From the terminal this is what I get for a MySql Server Status:
mysql.service - MySQL Community Server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: en>
Active: active (running) since Sat 2026-05-02 05:04:16 EDT; 13h ago
Main PID: 18040 (mysqld)
Status: "Server is operational"
Tasks: 37 (limit: 38024)
Memory: 362.3M (peak: 377.4M)
CPU: 10min 11.018s
CGroup: /system.slice/mysql.service
└─18040 /usr/sbin/mysqld
And from the CQRLog error message here's the MySql Error Log:
2026-05-02T21:40:33.834307Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.45-0ubuntu0.24.04.1) starting as process 859494
2026-05-02T21:40:33.834941Z 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.
2026-05-02T21:40:33.834950Z 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.
2026-05-02T21:40:33.836808Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8c8a0cd3-466f-11f1-ad68-345a60feebeb.
2026-05-02T21:40:33.839376Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2026-05-02T21:40:33.839476Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2026-05-02T21:40:33.839492Z 0 [ERROR] [MY-010119] [Server] Aborting
2026-05-02T21:40:33.839804Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.45-0ubuntu0.24.04.1) (Ubuntu).
2026-05-02T22:01:20.536737Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.45-0ubuntu0.24.04.1) starting as process 887975
2026-05-02T22:01:20.537258Z 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.
2026-05-02T22:01:20.537262Z 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.
2026-05-02T22:01:20.540096Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2026-05-02T22:01:20.540189Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2026-05-02T22:01:20.540209Z 0 [ERROR] [MY-010119] [Server] Aborting
2026-05-02T22:01:20.540502Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.45-0ubuntu0.24.04.1) (Ubuntu).
I could use some help understanding the error log and how do I go about trouble shooting this?
Thanks!
Tom G.
NE1NH
HI Tom!
You have the classic error that false designed installation packet from you Ubuntu Linux packet manager offers.
This has discussed here so many times.
I wonder why linux program distributors do not fix this issue.
As you can see from your error file:
2026-05-02T21:40:33.834307Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.45-0ubuntu0.24.04.1) starting as process 859494
Your system is starting Mysqld 8.0
Cqrlog requires MariaDB instead of Mysql. That is what packet managers can not fix. I wonder why.
You should install packets: libmariadb-dev-compat mariadb-client mariadb-server mariadb-common
Installing them should remove Mysql if all goes ok.
After that you can delete ~/.config/cqrlog folder to get a clean start.
NOTE: you should not have any qsos in log. Deleting the folder will delete ALL your qsos, too!
A proper view of mysql.err should start like this (version numbers may vary):
026-04-21 9:51:17 0 [Note] Starting MariaDB 10.11.16-MariaDB source revision 3218602d3100db9ce7a875511a591cddc173cc16 server_uid peP9NWQkZEp+HwLngj313QQoK6c= as process 7410
--
Saku
OH1KH