SQL error fresh ubuntu install

5 posts / 0 new
Last post
KF4DRR
SQL error fresh ubuntu install

On a fresh Ubuntu 19.10 install, using the PPA I'm getting the following error when trying to open CQRLog.

2019-12-13T23:49:42.089468Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-0ubuntu0.19.10.1) starting as process 1986
2019-12-13T23:49:42.091423Z 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.
2019-12-13T23:49:42.091435Z 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.
2019-12-13T23:49:42.139000Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2019-12-13T23:49:42.139485Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-12-13T23:49:42.139589Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-12-13T23:49:42.140079Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-0ubuntu0.19.10.1) (Ubuntu).
2019-12-13T23:54:15.878653Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-0ubuntu0.19.10.1) starting as process 2792
2019-12-13T23:54:15.880610Z 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.
2019-12-13T23:54:15.880622Z 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.
2019-12-13T23:54:15.936699Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2019-12-13T23:54:15.937181Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-12-13T23:54:15.937283Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-12-13T23:54:15.937766Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-0ubuntu0.19.10.1) (Ubuntu).

KF4DRR
got it resolved. Found an old

got it resolved. Found an old thread discussing a similar issue. Ran one of the suggestions there and got it up and running. Maybe something to let the Ubuntu 19.10 devs know for dependency issues. I tried rolling back to the ubuntu repo, and a fresh (again) install using the ubuntu repo all resulting in the same issue. After running the command below all started working. Then I added the ppa to get the latest because of eQSL's change that caused issues in that upload/download from the repo version (again something for ubuntu devs to get updated in the repo).

The solution:

sudo apt install cqrlog libmariadb3 libmariadb-dev mariadb-common mariadb-server

KC3LZY
got same

Got the same error on a fresh install on 19.10, (although in my case I wasn't using the PPA). KF4DRR's command reset things properly, and got me working (thanks for that).

Dave

KF4DRR
Dave,

Dave,

You will want to use the PPA if you use eQSL and want to upload/download your eQSL confirmations directly from CQRlog. Unfortunately Ubuntu has not kept up with the changes (as of the start of this thread). eQSL changed something in their interface and the older versions of CQRlog will no longer upload to it. I read about it somewhere when i SUDDENLY started having issues before the hard disk failure that lead to the fresh install. I can try to find that info for you if need be, but that's probably a bit out of scope for this forum...

73 Chris.

KF4DRR
what I mean by older is the

what I mean by older is the one in the Ubuntu Repository is from BEFORE the change in eQSL's website.