I installed CQRLOG through POP_SHOP. I am a new user to POP!OS which is basically UBUNTU. The error appears to be related to mysql. The error suggests I post the last few lines of the debug file here. Please be nice I am new to Linux. I'm learning it as fast as I can . HA HA
Thoughts on how to resolve this??
2019-11-24T15:57:24.840491Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-0ubuntu0.19.10.1) starting as process 3928
2019-11-24T15:57:24.842340Z 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-11-24T15:57:24.842356Z 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-11-24T15:57:24.912390Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2019-11-24T15:57:24.912579Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-11-24T15:57:24.912676Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-11-24T15:57:24.913310Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-0ubuntu0.19.10.1) (Ubuntu).
2019-11-24T16:58:29.383169Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-0ubuntu0.19.10.1) starting as process 8108
2019-11-24T16:58:29.385057Z 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.
Please consider using UTF8MB4 in order to be unambiguous
Thanks and 73 de KG4EHL
Rob
>> sudo apt update <<
>> sudo apt install mariadb-server <<
Say yes to everything, then start CQRlog after.
MySQL has been replaced by MariaDB in Ubuntu some time ago, but doesn't install automatically.
Greetings, Bas. ON5HB
OK, I am getting at the start of CQRLOG "Error during connection to database: TMySQL57 Connection: Server connect failed." error. Using info above info, I removed MySQL, I re-loaded (after uninstall) CQRLOG and ran >> sudo apt update << and >> sudo apt install mariadb-server <<.. I get the same error. ??
I didn't get "much" to say Y to.
steve@steve-ThinkPad-T460p:~$ sudo apt install mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mariadb-server is already the newest version (1:10.1.43-0ubuntu0.18.04.1).
mariadb-server set to manually installed.
The following package was automatically installed and is no longer required:
libevent-core-2.1-6
Use 'sudo apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
I am running Mint 19.2
I used Package Manager to remove/uninstall. and I "saw" that mariadb was included... w/cqrlog.
73, steve WB3LGC
You should not have removed MySQL first, when installing MariaDB it "sees" what other packages are installed with MySQL and replaces them with MariaDB versions.
Looks like you are missing some client-dependencies.
Try apt-get install --reinstall cqrlog, maybe it fixes it.
Is mariadb-client and mariadb-client-core installed?
Can you connect to the database at all?
Else see this topic, could also be the problem:
https://www.cqrlog.com/node/2092
Greetings, Bas. ON5HB
Also Mint MATE 64 Bit here
Onliest thing what not run is CQRLog.
MariaDB installed, also the apt-get reinstall done ...
I cannot find any description whats really needed .... "searching a sandkorn in the desert"
Erich
---
*************
73 de Erich
HB9FIH
HS0ZLS
Try this:
>> sudo apt install libmariadb3 libmariadb-dev <<
See if it works then.
Greetings, Bas. ON5HB
TNX Bas - helped it works now.
73 Erich
---
*************
73 de Erich
HB9FIH
HS0ZLS
You're welcome....the bill will follow later :-)
Greetings, Bas. ON5HB