Comment 6 for bug 1872002

CQRLOG (2.5.2-3ubuntu2) still does not seem to run on Ubuntu 24.04 because it cannot connect to the MySQL database. See the attached screenshot. I cannot believe that this was still not fixed after 4 years!

This is in the mysql.err log file:
2024-06-18T10:30:05.440022Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37-0ubuntu0.24.04.1) starting as process 15289
2024-06-18T10:30:05.441321Z 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.
2024-06-18T10:30:05.441336Z 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.
2024-06-18T10:30:05.459006Z 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: ba6b7bc4-2d5d-11ef-963e-525400dd5534.
2024-06-18T10:30:05.465986Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-06-18T10:30:05.466138Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-06-18T10:30:05.466158Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-18T10:30:05.466733Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.37-0ubuntu0.24.04.1) (Ubuntu).
2024-06-18T10:51:44.918174Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37-0ubuntu0.24.04.1) starting as process 3066
2024-06-18T10:51:44.919415Z 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.
2024-06-18T10:51:44.919426Z 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.
2024-06-18T10:51:44.938263Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-06-18T10:51:44.938440Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-06-18T10:51:44.938463Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-18T10:51:44.938981Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.37-0ubuntu0.24.04.1) (Ubuntu).

The issue was resolved and CQRLOG started working correctly after running "sudo apt install mariadb-server" (replacing the mysql server with mariadb).

I don't know how the mysql/mariadb package is handled in Debian, but someone should probably send a Merge request to the Debian GitLab repository: https://salsa.debian.org/debian-hamradio-team/cqrlog