You are here

CQRLOG on Fresh Ubuntu 22.04 MySQL issue

2 posts / 0 new
Last post
OZ1BV
CQRLOG on Fresh Ubuntu 22.04 MySQL issue

Hi

Just installed Ubuntu 22.04 from scratch and then CQRLOG. When launching the program for the first time I get this message:

"Database problem"
"MySQL could not be started, please check if the MySQL server is installed properly."

But, "service mysql status" tells me that it is running. I can also log in to MySQL DB using "sudo mysql -u root".

As told in the dialog box, the last 20 lines of the error file (there are only 8):

2022-07-16T14:57:23.302212Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-0ubuntu0.22.04.2) starting as process 20625
2022-07-16T14:57:23.302804Z 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.
2022-07-16T14:57:23.302810Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-07-16T14:57:23.307483Z 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: 9952b4db-0517-11ed-acb4-3800258bf18c.
2022-07-16T14:57:23.311412Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-07-16T14:57:23.311523Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-07-16T14:57:23.311557Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-07-16T14:57:23.311833Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-0ubuntu0.22.04.2) (Ubuntu).

My goal is to store my log on a NAS and if I just can get a MySQL dump of an empty database I will be very happy :-)

Best 73 de OZ1BV, Brian

oh1kh
CQRLOG on Fresh Ubuntu 22.04 MySQL issue

Hi Brian!

You should install MariaDB as you now seems to have mysql " (mysqld 8.0.29-0ubuntu0.22.04.2)" shows your log.
Installing MariaDB will remove mysql and after that you should get Cqrlog working.

sudo apt-get install mariadb-client-10.3 mariadb-server-10.3 libmariadb3 libssl-dev

See for example: https://www.cqrlog.com/node/2984

--
Saku
OH1KH