Database connection error after install

4 posts / 0 new
Last post
n8vz
Database connection error after install

I just installed CQRLOG on a new linux computer. After doing the installing and clicking on setup database on local machine, I get the following error:

2023-09-01T17:53:57.741634Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34-0ubuntu0.22.04.1) starting as process 78860
2023-09-01T17:53:57.742215Z 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.
2023-09-01T17:53:57.742242Z 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.
2023-09-01T17:53:57.752967Z 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: 864bcbd7-48f0-11ee-81d3-f8ac65c6677c.
2023-09-01T17:53:57.757669Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-09-01T17:53:57.757782Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-09-01T17:53:57.757794Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-09-01T17:53:57.758070Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34-0ubuntu0.22.04.1) (Ubuntu).O

Obviously, I need to have prepared something additional before the installation, but what? Please advise how I should proceed. Thanks.

73,

Carl
N8VZ

oh1kh
Database connection error after install

HI!
This classic Ubuntu error.
It uses MariDB as default database, but Cqrlog needs MariaDB. You should install MariaDB that replaces Mysql.

See for example this:
https://www.cqrlog.com/comment/10993#comment-10993

You find more similar threads with https://www.google.com/search?q=cqrlog.com+mysql+mariadb

--
Saku
OH1KH

aloofyearly (not verified)
Thanks for your help. It is

Thanks for your help. It is very helpful. I installed MariaDB instead of Mysql and everything worked fine. eggy car

annata20 (not verified)
Ensure that you have provided

Ensure that you have provided the correct connections nyt database credentials (username, password, database name) during the installation process.