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
Thanks again, Saku. Your sticking with me on this issue is so encouraging.
1. I DID CHECK the box to "save qso data to local machine." Still got the error.
2. I started CQRLOG again and UNCHECKED the box. The database connection screen came up with an IP address and port 64000. I changed the IP address to localhost and the port to 3306. Still got the error.
3. The error is: "Error during connection to database: TMySQL57 connection: Server connection failed."
A second error window sometimes comes as well, saying:
My SQL could not be started, please check if the MySQL service is installed properly.
Please look at the https://www.cqrlog.com/faq .
4. In a terminal window, I tried to see if mariadb and mysql were behaving, and got this:
joe@joe-Studio-XPS-7100:~$ mariadb
ERROR 1045 (28000): Access denied for user 'joe'@'localhost' (using password: NO)
joe@joe-Studio-XPS-7100:~$ sudo mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 61
Server version: 11.8.6-MariaDB-5 from Ubuntu -- Please help get to 10k stars at https://github.com/MariaDB/Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| joedb |
| mysql |
| performance_schema |
| sys |
+--------------------+
5. Do you have anymore ideas?
Thanks,
Joe n0now
Hi Joe!
Sounds weird.
What if you connect to your MariaDB as root (joe@joe-Studio-XPS-7100:~$ sudo mysql -u root -p) and then do:
CREATE USER IF NOT EXISTS 'cqrlog'@'localhost' IDENTIFIED BY 'cqrlog';
GRANT ALL PRIVILEGES ON *.* TO 'cqrlog'@'localhost';
FLUSH PRIVILEGES;
QUIT;
Above is coped from message https://www.cqrlog.com/comment/11126#comment-11126
I have sometimes found out that tick ' does not work but using back tick ` instead passes through with those SQL command above. I have been too lazy to clear out why.
So If you got error with those comands (using direct copy paste) , try to replace ticks with back tick characters.
Then start Cqrlog and when in Database connect window do NOT check "save qso data to local machine". Set server:localhost , Port: 3306, User: cqrlog, Password: cqrlog, check Remember me, check Autoconnect and finally press Connect button.
Do you still get error?
If you do, without having any QSOs in logs, you can always start from clean table by deleting ~/.config/cqrlog folder. Do not do this if you have QSOs there already. They will be deleted then.
--
Saku
OH1KH
Saku,
Hooray! You did it! Creating the "cqrlog" user did the trick! Cqrlog now opens properly and is ready to go. I will now attempt to retrieve the old log from LOTW and import it.
Thanks for working so deeply for me. I hope this is later useful to others if similar issues arise for them.
Joe, n0now
Hi !
It seems to be a new kind of security issue that "save log data to local machine" does not get Mariadb running.
I am not debian/Ubutu/Xubuntu guru, so I can not make it running.
There is a apparmor fix in /usr/share/cqrlog but it seems to be so old that it can not fix latest OS with MariaDB.
How ever making a SQL user and then using installed MariaDB server running at port 3306 works great.
I installed Xubuntu 26.04 to Oracle virtual machine and tested with that.
Easiest way to install Cqrlog 2.5.2 is to use my script I made fro Ubuntu 22.04. It seems to work well enough also with 26.04
First make SQL user. Start mariadb in command console:
sudo mariadb
Give following commands (use copy paste to keep right formatting):
CREATE USER IF NOT EXISTS 'cqrlog'@'localhost' IDENTIFIED BY 'cqrlog';
GRANT ALL PRIVILEGES ON *.* TO 'cqrlog'@'localhost';
FLUSH PRIVILEGES;
QUIT;
All lines should give "ok" responses. If not check typing errors.
Then you can download my script that is in ZIP file open https://github.com/OH1KH/CqrlogAlpha/blob/main/compiled/install_Ubuntu22...
At right side there are 3 buttons: "Raw", "copy"(two squares), and "download" (arrow pointing down). Press rightmost; download.
When downloaded (assume it goes to your Downloads folder) open command terminal and give:
unzip Downloads/install_Ubuntu2204_cqrlog.zip -d /tmp
(you can also use your file manager to extract the zip to /tmp folder if you feel more comfortable)
After extracted give:
/tmp/install_cqrlog.sh
Follow instructions, you have to press enter key to get forward.
First dependencies are installed (includes mariadb you do not need to do it by yourself!) then version 2.5.2 is down loaded from cqrlog.com and installed.
After that you can update right away to CqrlogAlpha, or stop install to version official 2.5.2
if you stop to 2.5.2 and start cqrlog do NOT check default "yes" to save log to local machine. Say "no".
Then fill server:localhost , Port: 3306, User: cqrlog, Password: cqrlog, check Remember me, check Autoconnect and finally press Connect button.
First log should appear and you can open it.
Worked fine with Xubuntu (minimal) 26.04
If you decide to update right away to CqrlogAlpha update script wil be downloaded and started. Also with it just press enter key several times to get to the update end.
When cqrlog starts it offers 3 choices. Select the bottom one "external networked SQL server" and pres OK.
enter IP address as "localhost" set cursor to next column and then you can press OK
At that point you will get same server connection error. Press OK (there is error in first start of cqrlogAlpha&external database)
Then fill to Database connect window server:localhost , Port: 3306, User: cqrlog, Password: cqrlog, check Remember me, check Autoconnect and finally press Connect button.
Bingo !
Your first log 001 is already there, just press "open log"
If there is someone, Debian/Ubuntu guru, that can dig out how security settings have changed in version 26.xx and how it can be fixed so that another mariadb instance can be started using ~/.config/cqrlog/database as base folder please drop a message !
It must be some kind of apparmor, or what ever Debian variants use for security, issue.
--
Saku
OH1KH
What I forget: with new installation with my script is that it does not put user to dialout group.
You have to do it manually.
sudo usermod -a -G dialout $USER
Then your Hamlib will get connected to your rig.
--
Saku
OH1KH