Hi,
receiving database connection error, my .err last lines: looks like some sort of character missing?
73 tnx!
2022-08-31T08:01:01.143734Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 8389
2022-08-31T08:01:01.145334Z 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-08-31T08:01:01.145348Z 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.
2022-08-31T08:01:01.155177Z 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: 0dcd467e-2903-11ed-a028-a41731fa80c8.
2022-08-31T08:01:01.162630Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-31T08:01:01.162929Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-31T08:01:01.162963Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-31T08:01:01.163527Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.20.04.2) (Ubuntu).
2022-08-31T08:51:52.715197Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 16758
2022-08-31T08:51:52.716791Z 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-08-31T08:51:52.716806Z 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.
2022-08-31T08:51:52.727910Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-31T08:51:52.728207Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-31T08:51:52.728235Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-31T08:51:52.728717Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.20.04.2) (Ubuntu).
2022-08-31T08:58:11.865127Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 17538
2022-08-31T08:58:11.866746Z 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-08-31T08:58:11.866761Z 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.
2022-08-31T08:58:11.877610Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-31T08:58:11.877903Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-31T08:58:11.877930Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-31T08:58:11.878371Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.20.04.2) (Ubuntu).
I had the same issue i tryed to run the snap version of cqrlog gave me the error like yours go find the .deb version that is what i did its working fine.
Hi,
during a complete new installation having that here to.
What I found out is miss match in /etc/mysql. This folder is essential for mysql and as well for mariadb...
It's not clear clear to me, do cqrlog need booth mysql-server and mariadb-server?
73
Andy DK9HE
Hi!
Cqrlog needs MariaDB.
Mysql must be removed.
But do not mix things as MariaDB uses same binary and config names (for compatibility).
When typing "mysqld --version" you should get MariaDB.
[saku@hamtpad ~]$ mysqld --version
mysqld Ver 10.5.16-MariaDB-log for Linux on x86_64 (MariaDB Server)
If your error file includes lines with "(mysqld 8.0.30-0ubuntu0.20.04.2)", or similar having "mysqld 8." you know that your mysql server is not properly removed when instaling MariaDB and this must be fixed.
--
Saku
OH1KH
Installing MariaDB Worked! Thank you, oh1kh!
KO4ZZK
Hi there,
to keep the story short, confirming after installing MariaDB it works fine.
73
Andy dk9he