I am trying to migrate from a raspberry pi 4 64 bit running Ubuntu 22.04 to an amd64 also running Ubuntu 22.04. I copy the ~/.config/cqrlog folder from one machine to the other. When i attempt to start CQRLOG I get the Access Denied message. Both Abort and OK close the program. I have migrated CQRLOG several times before with no issues. Any idea what the problem could be?
Jerry
W5MIG
Hi Jerry!
After you have copied ~/.config/cqrlog do a comman console command:
sudo chown yourusername.yourusername ~/.config/cqrlog
Replace yourusername with your real username of your new computer. Remember the dot between usernames.
It looks like your user ID at raspberry has been different that it is in new computer.
Even when you set same username at PI and new computer it may not be same when Linux thinks about it because it uses UID numbers to identify users. https://linuxhandbook.com/uid-linux/
This should remove Access denied message.
If not next is to check that your username belongs to group dialout at new computer. That is needed to access your rig via serial (usb) port. https://www.folkstalk.com/tech/add-user-to-dialout-group-with-code-examp...
Finally let's hope both computers have same kind of SQL server. Then this copying works. Otherwise you have to move your log contents via full ADIF export and log settings via Database_connection/utils/configuration/Export(and import on new pc)
--
Saku
OH1KH
Sorry, correction:
The command needs "-R" to effect all files and subfolders.
sudo chmod -R yourusername.yourusername ~/.config/cqrlog
--
Saku
OH1KH
Nor good dat today !
it was not chmod, but chown:
sudo chown -R yourusername.yourusername ~/.config/cqrlog
I hope it is finally ok now.
--
Saku
OH1KH
Well, things have gone from bad to worse. I did the chown on the amd64 and that got me pass the Access Denied message only to get the "Error during connection to database: TMYQSLConnection: Server connect failed.: message. And behind that the message Database Problem: MySQL could not be started, please check if the MySQL server is installed properly . . . .
I also did a systemctl status myslq on both computers. The old arm64 computer came up with mariadb.service and the new amd64 came up with mysql.service. So, I figured that I would have to do the last resort you suggested in going to Database_Connection and doing an export. Here's the worse part, I open CQRLOG on the arm64 and I get the "Error during connection to database: TMySQLConnection: Server connect failed" message. Never happened before on that computer. So where can I go from here??
Jerry
W5MIG
HI!
Cqrlog will not run with mysql 8.0. You have to install MariaDB server and client packages like your arm64 have.
That is the Ubuntu error that keeps happening all the time now for all users.
--
Saku
OH1KH
Oh, so when I try the Database connection on the arm64 to do the export, i enter a name to save the file to, select Save, and I get the message List index (0) out of bounds. So I get nowhere.
Jerry
W5MIG
Somehow this sounds familiar from past.
I just can not remember what caused this.
What is the Cqrlog version and version date of arm64?
What if you try to export small amount of qsos from logs start (or end)? I somehow have feeling that it could happen if there is a broken logged qso somewhere.
Make filter by date and try small parts from start and end and if it goes ok make the amount of qsos larger until it stops to pinpoint broken qso.
You can also send a "zip -r " of your arm64 ~/.config/cqrlog to me for check. Email is ok on qrz or Hamqth.
--
Saku
OH1KH
Problem solved. I looked through various other postings on this forum and came up with the following that solved my problem. First, since the new computer had mysql and not mariabd, I installed mariadb on the new computer. That got me to the CQRLOG new qso page where CQRLOG would then freeze. Searching for CQRLOG freezes, I came across a post which gave this link. https://www.cqrlog.com/node/2984. I followed the instructions there to compile CQRLOG and now all works!
Jerry
W5MIG
Fine Jerry!
Well, I should learn to go through all messages first. Not to answer one by one in order, hi.
Main thing is that you got it working!
--
Saku
OH1KH