Hi know I should have a handle on this by now. I have built a Linux Mint 20/Windows10 laptop for myself. Of course CQRLOG gave me the issue when opening CQRLOG the first time. It was the typical TMYSQL error opening. I fixed that one by opening the terminal and installing Mariadb server10.x and mariadb client 10.x. After that it was all good.
I then programmed up my Raspberry PI 400 and on that I installed the Ubuntu desktop from the Raspberry PI website. Again I had a little trouble but it worked out fine.
So I am putting together another dual boot laptop for a friend. Again it is a Windoes10/ Linux machine. This time I chose to install Ubuntu 20,04,2,0 Desktop.
I have mariadb installed and yet I still get this error "Error during connection to database TMSQL57 connection. Server connection failed." At the same time I get the second box that says "MYSQL could not be started, please check if the MYSQL server is installed properly. Please look at https://wwwcqrlogfaq. Here is the error file.
2021-03-28T23:55:52.046104Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 2847
2021-03-28T23:55:52.047269Z 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-03-28T23:55:52.047283Z 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-03-28T23:55:52.134521Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-03-28T23:55:52.135126Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-03-28T23:55:52.135418Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-03-28T23:55:52.136972Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
2021-03-29T00:13:00.361463Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 5793
2021-03-29T00:13:00.362881Z 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-03-29T00:13:00.362895Z 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-03-29T00:13:00.371702Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-03-29T00:13:00.371944Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-03-29T00:13:00.372081Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-03-29T00:13:00.372592Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
Where do I go next. to fix this issue.
Looks like you are using mysql. You should be using MariaDB.
If you installed on a clean system, that should not have happened....
There should be no install issue's what so ever....
did you install by using these commands as stated on the download page? https://cqrlog.com/download
Ubuntu 18.04, 20.04, 20.10 and 21.04 users can use CQRLOG’s repository on Launchpad. To add repository to your system, put into terminal this:
sudo add-apt-repository ppa:ok2cqr/ppa;sudo apt-get update;sudo apt-get install cqrlog
I use LinuxMint, which is a Ubuntu based, and this has been working for me for ages......
Good Luck,
73,
Alex
PA1SBM