CQRLOG on Fresh Ubuntu 22.04 MySQL issue

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


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

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


A quick script

sudo apt update
sudo apt install -y mariadb-server-10.6 mariadb-client-10.6
sudo apt autoremove
sudo apt clean

Why can't it work with MySQL,

Why can't it work with MySQL, over TCP/IP for example using localhost:3306? I need MySQL for other stuff and can't remove it in favor of MariaDB. Does it mean I can't use CQRLOG at all?

Why can't it work with MySQL,

Of course you can use mysql at port 3306.
That is what I use here.

But mysql (by Oracle) does not run as second thread when database is located in user's home folder. Like it is when "save log data in local machine" is checked.
This is an security issue that does not happen when MariaDB is used.

You just have to create mysql user and grant all privileges for it to full control log databases. Then you can uncheck "save log data in local machine" and give mysql server address and port (can be also networked server) and username and password.