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
HI Joe!
OK!
Now a question how you have defined the Database Connection window?
Have you checked "save qso data to local machine" or not?
In case you have checked it Cqrlog should start a new instance of SQL server that is based to ~/.config/cqrlog/database folder.
Everything happens there, also the mysql.err file appears to that folder.
It is no need to create a database or database user, Cqrlog does everything.
If you have NOT checked that you should define SQL server address and port. They are visible in that case.
Address can be "localhost" and port 3306 that is default for MariaDB server already running in your PC. (but it can be on local lan, or internet too)
What you have to do then is to create a mysql user with password and grant privileges for it to do all operations to databases beginning with string cqr% . If you do not have any other SQL use you can grant all privileges to * instead of cqr%
After you have done it with mysql console or mysql admin program you put username and password to Database connect window, check "Remember me" and "Autoconnect" and press button "Connect".
After that Cqrlog should start to create the first log database same way as it does with "save log data to local machine" checked.
This case you do not find mysql.err file from ~/.config/cqrlog/database folder. It appears to folder where your MariaDB installation has defined it. (perhaps /var/lib/mysql, depending your Linux system).
Of course you can use database user "joe" also with Cqrlog if you like. Just put it to username and put your password to it's column.
I am using way NOT "save log data to local machine" checked. Has worked well since beginning. It allows also database replication to another SQL sever, but backup of logs should be done with mysqldump.
When checking "save log data to local machine" full backup is to save ~/.config/cqrlog folder. When not checked you have to do that and ALSO do mysqldump from log databases. I have made a script for that.
--
Saku
OH1KH