Since upgrading to version 19.04 I can not open CQRLog. I receive this message:
Error during connection to database: TMySQL56 connection: Server connect failed.
This is from the mysql.err file:
2019-10-26T18:34:18.121825Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 26005
2019-10-26T18:34:18.122931Z 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-10-26T18:34:18.122941Z 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-10-26T18:34:18.128384Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2019-10-26T18:34:18.128497Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-10-26T18:34:18.128592Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-26T18:34:18.128834Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2) (Ubuntu).
Any suggestions to correct this error would be appreciated. Please be specific in any steps I need to take to make the correction, I am getting comfortable with the Linux file system and files but am not an expert.
Thanks--Peter, NN9k
I'm having the same problem. Apparently CQRLOG is looking for version 5.6 of MySQL and Ubuntu 19.10 has version 10. What do I do?
Thanks - Bill - N8ET
Received this message:
"The same here with Kubuntu 19.10. Plesase try uninstal mysql-server and instal mariadb-server version 10.3! On my side worked perfectly
73 GL Josef OK1DTM"
And it works. When I uninstalled mysql-server CQRLog also disappeared but reinstalling it and the Mariadb-client solved the problem. I used the command line to install CQRLog so be sure to watch the last lines in the terminal indicating that mysql or Mariadb are not present and then go from there.
I didn't have any QSOs saved in the CQRLog database but if you do I'd suggest you either move them or save them elsewhere.
Hope this helps.
Peter, NN9K
Peter, NN9K
sudo apt-get update
sudo apt-get install mariadb-server
Say YES to everything, wait until it's fnished, then start CQRLog and it works fine.
Nothing else needed, this worked for me at the first try :-)
Greetings, Bas. ON5HB
Installed and worked perfectly! Thanks!
73 - Bill - N8ET
Thank You! This worked a treat.
I almost resorted to paper!
73's
Douglas K / VE3YDK