Solved CQRLOG / Linux Mint Issue - Now a Field Question

2 posts / 0 new
Last post
Solved CQRLOG / Linux Mint Issue - Now a Field Question

I had major issues getting CQRLOG working after upgrading my laptop from Linux Mint 18 to 19. There were several mysql errors. Eventually, I purged all of the mysql files via apt-get and reinstalled the latest version of mariadb. I also installed the latest version of CQRLOG. After doing both, everything works. Yea!!!


I have been using HAMLOGGER as my logging software, but thought I would go back and give CQRLOG another try. So I imported all 485 entries via an adif export from HAMLOGGER. The import went okay. My LoTW and eqsl entries came through. (I do understand from a previous forum topic that the 'qslr' meta-field shows an 'E' where I received an eqsl report, and a 'L' where I receive a LoTW report.) So far so good.

Unfortunately, within HAMLOGGER, I used a 'D' and a 'Q' to show where I had sent and received a paper QSL card, and a report via QRZ. I can manually enter the paper QSL data into the 'qsl_s' and 'qsl_r' fields, but how do I reflect the activity from QRZ?

BTW: it would be useful to have a key to the field names.

Bobby - KN4I

Solved CQRLOG / Linux Mint Issue - Now a Field Question

HI Bobby !

Nice to hear that you got cqrlog running.

If you edit qsos you can put any string to qsl_r and qsl_s. There is a selector that allows choose some letters, but typing is also possible.

Self "invented" letter combination may how ever affect to statistic results. I am not sure about that, it should be checked from source code or just tested by settings some values.

About field names:
Qsos are saved to table "cqrlog_main" of log database "cqrlogXXX" where XXX is the log's number.
You can see field names using sql console "QSL list/Filter/SQL console"
Write "show columns from cqrlog_main" to upper part of console and press first button (up /left) that has green arrow.

Another way is to start mysql console from command line when cqrlog is running (and "save log data to local machine" is checked):

mysql -S ~/.config/cqrlog/database/sock cqrlogXXX

Set the XXX to log number you use. First log is 001.

Then give:

show columns from cqrlog_main;

Difference is that you see column max sizes then. See picture.

If you like to automate the qsl_r / qsl_s change you can do it with mysql command either from SQL console or from command line mysql console.

update cqrlog_main set qsl_s="S" where qsl_s="y";

MariaDB [cqrlog004]> update cqrlog_main set qsl_s="S" where qsl_s="y";
Query OK, 1 row affected (0.001 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Remember to make backup of your log first !!
There is no "roll back" command !!

Easiest way is to copy whole directory of cqrlog (While cqrlog is NOT running):

cp -a ~/.config/cqrlog ~/.config/cqrlog_saved

If you need to return to previous just delete the current and make reverse copy:

rm -rf ~/.config/cqrlog
cp -a ~/.config/cqrlog_saved ~/.config/cqrlog

If you feel this too complicated there is also "Group edit" that lets you so some group changes. Look at QSL list/File/Group edit.
You must fist make filter to select all qsos you want to change, otherwise change happens to whole log!
When that is done open "Group edit" choose "Field" what you want to change (there are not all fields in list!).
Then give a new value to value field(but you just can choose it from list in case of qsl).
Then press Apply.

Also here: NO "roll back", so remember backups before pressing "Apply".