I GOT THIS MESSAGE:
2025-11-07T03:10:20.235395Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.43-0ubuntu0.24.04.2) starting as process 7714
2025-11-07T03:10:20.236117Z 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.
2025-11-07T03:10:20.236122Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-11-07T03:10:20.242369Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-11-07T03:10:20.242480Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-11-07T03:10:20.242494Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-11-07T03:10:20.242759Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.43-0ubuntu0.24.04.2) (Ubuntu).
ANYONE WILLING TO HELP?
Hi!
You have Mysql in your system by your message: "(mysqld 8.0.43-0ubuntu0.24.04.2) starting as process 7714"
You must install MariaDB that overrides Mysql.
You need packages: libmariadb-dev-compat mariadb-client mariadb-server mariadb-common
After that If you want a clean restart (note: all logs deleted if exist!) remove hidden folder ~/.config/cqrlog before starting Cqrlog again.
--
Saku
OH1KH
SAKU
THANKS FOR THE HELP. I AM NOT SURE EXACTLY HOW MANY PACKAGES YOU ARE SAYING I NEED.
I STARTED WITH sudo apt install libmariadb-dev-compat AND THE TERMINAL KEEPS SAYING IT CAN NOT GET CACHE LOCK OVER AND OVER.
HERE IS MY GUESS TO ACTUAL PACKAGE NAMES:
libmariadb-dev-compat
mariadb-client
mariadb-server
mariadb-common
AM I CORRECT.?
CAN YOU SUGGEST COMMANDS THAT WILL WORK? NOT AN EXPERT HERE.
73
BENNY K5KV
HI Benny!
Yes those are the packages.
You can install them from command terminal with line:
sudo apt install libmariadb-dev-compat mariadb-client mariadb-server mariadb-common
Or you can use GUI if your system has program Synaptic packet manager.
Then just find those from list, select them and "install selected"
More clicks, more work... That's why command console beats GUI
(actually GUI will finally use same text command behind user view)
--
Saku
OH1KH
THANKS SAKU
THE INSTALL FINE WHEN AN ERROR MESSAGE WAS ACKNOWLEDGE WITH AN ENTER INSTEAD OF A MOUSECLICK.
I AM HAVING A LOTW UPLOAD PROBLEM BUT WILL CREATE A NEW POST FOR THAT.
73
BENNY K5KV
I recently upgraded to Xubuntu 24.04. Now I can not get cqrlog to run. I reinstalled maridb etc, but when I try to run cqrlog I get /usr/bin/mysql message.
Then popup with Error during connection to database.
MuSQL5.7connection: Server connect failed.
I have been trying for hours. It should not be this hard.
HELP someone!
Jerry K5JC
Jerry K5JC
Hi Jerry!
No it should not.
Have you checked ~/.config/cqrlog/database/mysl.err contents ?
You have upgraded linux, so I assume you then have already qsos in Cqrlog log(s).
Then first delete file ~/.config/cqrlog/database/mysl.err to get just latest errors.
Delete also file(s) ~/.config/cqrlog/database/ib_logfileX file(s) where X can be any number. Usually it is 0 (zero).
Then start Cqrlog and run up to error stops it.
Look at file ~/.config/cqrlog/database/mysl.err with text editor. At the very beginning you should see line like:
2025-07-31 18:31:50 0 [Note] Starting MariaDB 10.11.11-MariaDB source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid DHNlftffXKoaZaTeZomTucuhUo0= as process 5296
What is important is that there shows up MariaDB If there is instead "Starting Mysql" it means you have not
succeeded to remove Mysql and install MariaDB instead.
That is the most common problem with Cqrlog startup error: "Error during connection to database. MySQL5.7connection: Server connect failed."
If you do not have any qsos in log, I.E. new clean Linux install, you can always delete whole ~/.config/cqrlog folder. That gives you a new clean start for Cqrlog.
(you do not need to remove and reinstall Cqrlog, that does not make clean start).
BUT!! If you already have qsos in log do not delete ~/.config/cqrlog folder. It deletes also all your qsos!
--
Saku
OH1KH
Thanks Saku,
when I sudo apt install libmariadb-dev-compat mariadb-client mariadb-server mariadb-common
I get (Reading database ... 388737 files and directories currently installed.)
Removing mysql-server-8.0 (8.0.45-0ubuntu0.24.04.1) ...
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: error processing package mysql-server-8.0 (--remove):
installed mysql-server-8.0 package pre-removal script subprocess returned error exit status 1
dpkg: too many errors, stopping
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
Failed to start mysql.service: Unit mysql.service not found.
invoke-rc.d: initscript mysql, action "start" failed.
Unit mysql.service could not be found.
dpkg: error while cleaning up:
installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Errors were encountered while processing:
mysql-server-8.0
Processing was halted because there were too many errors.
E: Sub-process /usr/bin/dpkg returned an error code (1)
Thanks
Jerry K5JC
Jerry K5JC