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).
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: 18T10:30: 05.440022Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37- 0ubuntu0. 24.04.1) starting as process 15289 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. 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. 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-525400dd55 34. 18T10:30: 05.465986Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory. 18T10:30: 05.466138Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 18T10:30: 05.466158Z 0 [ERROR] [MY-010119] [Server] Aborting 18T10:30: 05.466733Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.37- 0ubuntu0. 24.04.1) (Ubuntu). 18T10:51: 44.918174Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37- 0ubuntu0. 24.04.1) starting as process 3066 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. 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. 18T10:51: 44.938263Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory. 18T10:51: 44.938440Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 18T10:51: 44.938463Z 0 [ERROR] [MY-010119] [Server] Aborting 18T10:51: 44.938981Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.37- 0ubuntu0. 24.04.1) (Ubuntu).
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
2024-06-
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