Tearing hair out if I had any

3 posts / 0 new
Last post
NK8O
Tearing hair out if I had any

I have tried version 2.4, version 2.5.1 and I still cannot connect to mysql. I have tried every which way, including updating/upgrading mariadb, purge install, re-install, and it just won't work. I have tried all the suggestions I could find online regarding mysql 8.0, but most of them didn't work even directly on the database. Currently installed is CQRlog 2.5.1

Running Linux Xubuntu 20.04. Here is the error log. HELP! It always comes up the same on this computer. I have CQRlog running well under this version of Linux on my laptop.

73,
Charles - NK8O

2021-02-04T04:41:34.289319Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
2021-02-04T05:17:59.288235Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 11048
2021-02-04T05:17:59.290275Z 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.
2021-02-04T05:17:59.290293Z 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.
2021-02-04T05:17:59.351931Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-02-04T05:17:59.352338Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-04T05:17:59.352455Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-04T05:17:59.353196Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
2021-02-07T21:11:44.983599Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 52860
2021-02-07T21:11:44.985685Z 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.
2021-02-07T21:11:44.985705Z 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.
2021-02-07T21:11:45.033858Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-02-07T21:11:45.034078Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-07T21:11:45.034192Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-07T21:11:45.034899Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
2021-02-07T21:34:21.999222Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 57729
2021-02-07T21:34:22.001485Z 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.
2021-02-07T21:34:22.001505Z 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.
2021-02-07T21:34:22.012500Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-02-07T21:34:22.012719Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-07T21:34:22.012836Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-07T21:34:22.013609Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
2021-02-07T21:43:05.503232Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 59818
2021-02-07T21:43:05.505498Z 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.
2021-02-07T21:43:05.505516Z 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.
2021-02-07T21:43:05.563832Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-02-07T21:43:05.564076Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-07T21:43:05.564205Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-07T21:43:05.564987Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).

oh1kh
Tearing hair out if I had any

Hi Charles !

Yes! Hair is problem. I lost most of it during work years with Micro$oft servers and clients being a local IT support. ;-)

First question is do you have previously existing database (created with mysql) ? Then it might be that your current MariaDB can not access it directly.
See https://www.cqrlog.com/node/3099

--
Saku
OH1KH

ok2cqr
ok2cqr's picture
Re: Tearing hair out if I had any

Hi,

according to error message, you have mysql installed. Please unistall it, install mariadb-server, libmariadbclient-dev, libmariadbclient-dev-compat and it should work.

73 Petr, OK2CQR