MySQL will not not on new CQRLOG install

3 posts / 0 new
Last post
Kf5cjg
MySQL will not not on new CQRLOG install

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

oh1kh
MySQL will not not on new CQRLOG install

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

Kf5cjg
Thanks. Made correction.

Thanks. Made correction. All good now!

73,
Nick