I installed the MariaDb. All good now.
Just install CQRLOG. Upon running CQRLOG for the first time get this message: MySQL could not be started.
Log file shown below. Please assist.
Thank you for any help.
2024-05-03T00:42:16.174358Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 64593
2024-05-03T00:42:16.185855Z 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-05-03T00:42:16.185878Z 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-05-03T00:42:16.222870Z 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: fd50a1cd-08e5-11ef-b789-543530418047.
2024-05-03T00:42:16.269049Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-03T00:42:16.270921Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-03T00:42:16.270967Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-03T00:42:16.271757Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-03T00:50:33.687766Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 3412
2024-05-03T00:50:33.690117Z 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-05-03T00:50:33.690136Z 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-05-03T00:50:33.871922Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-03T00:50:33.872122Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-03T00:50:33.872159Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-03T00:50:33.872839Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-03T01:17:07.846408Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 9759
2024-05-03T01:17:07.848627Z 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-05-03T01:17:07.848648Z 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-05-03T01:17:07.862947Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-03T01:17:07.863221Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-03T01:17:07.863261Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-03T01:17:07.863940Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
HI!
The package install of Cqrog installs mysql that is wrong. Ubuntu maintainer fault.
In your log it shows out as (mysqld 8.0.36-0ubuntu0.22.04.1)
You should install MariaDB over the mysql to get Cqrlog started.
Se this message: https://www.cqrlog.com/node/3637
--
Saku
OH1KH
Thanks. Made correction. All good now!
73,
Nick