I have not used cqrlog in a while but got interested in trying out the new version. I tried starting up what i had but got an error from the sql server. I uninstalled what I had, followed the instructions to modify my apt sources and update to the newer version. Same problem with the database. So, in the error dialog is said that if I couldn't find an answer in the faq, I should post in this forum with the last 20 lines of the sql server log.
I am doing so:
2021-07-03T17:12:15.331627Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) starting as process 5357
2021-07-03T17:12:15.332594Z 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-07-03T17:12:15.332605Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2021-07-03T17:12:15.343129Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-07-03T17:12:15.343282Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-07-03T17:12:15.343335Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-03T17:12:15.343677Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).
2021-07-03T17:12:51.805636Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) starting as process 5370
2021-07-03T17:12:51.806364Z 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-07-03T17:12:51.806373Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2021-07-03T17:12:51.811891Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-07-03T17:12:51.812043Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-07-03T17:12:51.812095Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-03T17:12:51.812550Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).
Can anyone help me?
Ron
HI Ron!
The problem seems to be that you are running mysql 8. You should replace it with MariaDB.
You did not tell your linux brand and not from where you are trying to install cqrlog.
How ever dump tells about ubuntu so did you add ppa repository from the download section of cqrlog.com?
If you have an old cqrlog you can first remove it, specially if you have packet called "cqrlog-data" installed. Removing cqrlog does not touch your log database at ~/.config/cqrlog folder (how ever backup is recommended before start).
There are many message chains about switch from mysql8 to mariadb in this forum.
--
Saku
OH1KH