I am trying to update from Ubuntu 22.04 to a clean install of Ubuntu 26.04, and therefore have to reinstall all apts including CQRlog 2.5.2-6 .
1. I installed Ubuntu 26.04 LTS and it behaves successfully.
2. I installed mariadb-server and mariadb-client with these terminal commands:
sudo apt install mariadb-server mariadb-client
3. I installed CQRlog with this command:
sudo apt install cqrlog
4. From the Ubuntu desktop, I open the CQRLOG application.
5. An error window quickly pops up and says:
Error during connection to database: TMySQL57Connection:
Server connect failed.
Then a second window appears suggesting searching the FAQ on CQRLOG website, then posting to this forum.
6. The FAQ encouraged loading a repository with "add-apt-repository ppa:ok2cqr/ppa" but that appears to be missing Release files.
7. The second suggestion from FAQ was "sudo apt-get install cqrlog" which outputs
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
cqrlog is already the newest version (2.5.2-6).
Solving dependencies... Done
0 upgraded, 0 newly installed, 0 to remove and 23 not upgraded.
8. Finally, the FAQ suggested writing the forum and attaching the last 20 lines of mysql.err file. I cannot find such a file. The folder Home/.config/cqrlog/database contains ONLY the file mysql.cnf configuration file.
Please help. I am at a loss to know how to proceed. The database is obviously incorrectly constructed and no connection seems even possible.
Thanks,
Joe Traylor, N0NOW
HI Joe!
Try to install also mariadb-common
This was the command needed for Ubuntu 22.04 for Cqrlog to work:
sudo apt install libhamlib-utils libhamlib4 libmariadb-dev-compat libatk1.0-0 libcairo2 libgdk-pixbuf-2.0-0 libglib2.0-0 libgtk2.0-0 libpango-1.0-0 libx11-6 xplanet mariadb-client mariadb-server mariadb-common trustedqsl libssl-dev libqt5pas1
--
Saku
OH1KH
Thank you, Saku. I have made progress, but am still far from done.
I had already installed mariadb-common. Repeating the "sudo apt install mariadb-common" command produced info that the mariadb-common was already the latest version. And then doing your extensive sudo apt install libhamlib4...etc. executed properly, but made no difference in trying to open cqrlog. Same database connection error as before, and still no .err file in .config/cqrlog/databases folder.
May I ask:
1. Do I need to create a database called "cqrlog" in mariadb?
2. Do need to create a user "cqrlog" in mariadb"
I have been assuming that initializing an instance of cqrlog would do those things automatically. Or, perhaps there are other things that I must set up in mariadb that I have not thought of.
Note: I did successfully create a database "JoeT" and a user "joe" in mariadb, and they appear to work properly.
Thanks,
Joe, n0now