Lotw-Support in CQRLOG broken

Sat, 2018-03-03 10:37

dl8wa

Hello Everybody!

I am trying to use CQRLOG since a few months, and I am convinced now that Lotw support in CQRLOG is completely broken. There are a number of issues, which I am going to describe in detail below:

1. The QSO filter is completely ignored in Lotw export

2. QSOs are not marked as exported to Lotw

In total, this makes CQRLOG totally unusable to me. I do not know whether anyone else uses this functionality; my two posts in the CQRLOG forum (Sun, 2018-01-21 12:15 in open discussion, and Sat, 2018-01-06 15:05 in bugs) remained completely unanswered. I have meanwhile tried it with three different installations, and all show the same defects:

1. CQRLOG 2.0.2 (001) 2016-08-28 on a Raspberry Pi 2, running Raspbian Stretch and MariaDB. The CQRLOG package comes from the official Raspian repository.

2. CQRLOG 2.2.0-1 (package cqrlog_2.2.0-1_amd64.deb) from the CQRLOG download page, running on Debian Stretch 9.3 and MariaDB.

3. CQRLOG 2.2.0-1 from Petr's ppa, running on Ubuntu 16.04 LTS and MySQL. I specially installed a test machine with Ubuntu this morning to make an error report using the officially recommended OS, thus, my error report below has been written with reference to this installation, and also the files cqrlog_debug*.txt, which I uploaded.

My problem: I am operating from three different QTHs, and I have set up corresponding QTH profiles in cqrlog with corresponding station locations in tqsl/LOTW. I want to export my QSOs filtered by my QTH locator or QTH profile, so I can sign them with different station locations in Tqsl. This is described in the manual, quote from https://www.cqrlog.com/help/h7.html: "A suitable choice is a filter for date, QSL received etc.".

I could probably live with this problem if CQRLOG would mark the QSOs properly as uploaded to Lotw, but this also does not work.

I try to describe what I am doing step-by-step, each step with debug=1 and a corresponding .txt-file in the upload:

I start cqrlog with

cqrlog -debug=1 >> cqrlog_debug_1.txt

I open the QSO list, set a filter on MyLocator=JN15MS, and I get 6 QSOs displayed. I now try to QSL->LOTW->Export->Export QSOs to LoTW adif file. I check "Export only QSOs which have never been uploaded", "Mark QSOs as exported after export", and I enter the filename "lotw_test_export1.adi". I then click "Export". CQRLOG says "Exporting QSO nr. 56" (I have 56 QSOs in this test log.). I then click "Close". When I look into the adi-File, I find ALL the QSOs in my log in the adi-File, not only the 6 QSOs with MyLocator=JN15MS, which I see in the QSO list.

I then try to export these 6 QSOs using File->Export->ADIF. I enter the file name "cqrlog_test_export1.adi", and export. This file correctly contains only the 6 QSOs with MyLocator=JN15MS. BUT: No information in this .adi-file concerning LoTW upload...

I then close CQRLOG to keep the debug-file small.

Next try: Starting cqrlog with

cqrlog -debug=1 >> cqrlog_debug_2.txt

I open the QSO list, but I do not set any filter. Again, I now try to QSL->LOTW->Export->Export QSOs to LoTW adif file. I check "Export only QSOs which have never been uploaded", "Mark QSOs as exported after export", and I enter the filename "lotw_test_export2.adi". I then click "Export".

CQRLOG creates the .adi-file, which contains 56 QSOs as expected, but none of them is marked in the columns lotw_qsldate or lotw_qsls.

I can repeat this indefinitely, the QSOs are not marked. CQRLOG always exports all 56 QSOs. If you look into the debug file, you can see that CQRLOG is trying to update the qso records in the db, but for some reason this has no effect. I am not an sql expert, so I cannot tell why.

I have included all the files which I produced during testing in the upload (including this text). If you need any further information, please do not hesitate to contact me.

I would be very glad if someone could help me with this problem, since I have no clue what could be wrong here:-(

Best Regards & vy73 de

Andreas/DL8WA

File: cqrlog_debug_1.txt ---------------------------------------------------------------------

**** DEBUG LEVEL 1 ****

SSL libraries:
/lib/x86_64-linux-gnu/libssl.so.1.0.0
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.8
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/willi/
Program home directory: /home/willi/.config/cqrlog/
Data directory: /home/willi/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/willi/.config/cqrlog/database/mysql.cnf --datadir=/home/willi/.config/cqrlog/database/ --socket=/home/willi/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

use cqrlog001

SELECT * FROM cqrlog_config

select * from db_version

select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 132 -r /radio/tty-ftdx3000-if00 -t 4532
RunRigCtld: TRUE
RigDevice: /radio/tty-ftdx3000-if00
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 132

Starting RigCtld ...
/usr/bin/rigctld -m 132 -r /radio/tty-ftdx3000-if00 -t 4532
rigctld failed to start!
1
2
3
4
5
6

Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1

rotctld started!
Connected to localhost:4533
select id,freq,mode,bandwidth from freqmem order by id

CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = 1

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = 1

select locator from profiles where nr = 1

1-JN49HH;Walldorf/Baden/Germany;FT-DX3000/FT991A;
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

SELECT * FROM profiles ORDER BY nr

SELECT * FROM profiles WHERE nr = 1

SELECT * FROM view_cqrlog_main_by_qsodate WHERE (my_loc = 'JN15MS')
SELECT * FROM view_cqrlog_main_by_qsodate WHERE (my_loc = 'JN15MS')

SELECT * FROM view_cqrlog_main_by_qsodate WHERE (my_loc = 'JN15MS')

LoadForm: frmMain
select * from cqrlog_main where lotw_qslsdate is null

select * from cqrlog_main where lotw_qslsdate is null

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 1

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 2

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 3

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 4

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 5

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 6

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 7

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 8

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 9

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 10

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 11

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 12

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 13

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 14

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 15

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 16

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 17

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 18

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 19

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 20

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 21

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 22

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 23

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 24

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 25

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 26

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 27

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 28

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 29

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 30

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 31

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 32

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 33

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 34

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 35

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 36

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 37

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 38

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 39

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 40

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 41

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 42

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 43

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 44

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 45

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 46

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 47

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 48

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 49

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 50

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 51

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 52

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 53

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 54

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 55

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-03-03' where id_cqrlog_main = 56

SELECT * FROM view_cqrlog_main_by_qsodate WHERE (my_loc = 'JN15MS')

LoadForm: frmMain
SELECT * FROM view_cqrlog_main_by_qsodate WHERE (my_loc = 'JN15MS')

SELECT * FROM view_cqrlog_main_by_qsodate WHERE (my_loc = 'JN15MS')

select * from profiles order by nr

SaveForm: frmMain
Section:frmMain
Saving window size a position (frmMain) (height|width|top|left):1176|1855|24|65
Closing QSO list window
Section:frmTRXControl
Saving window size a position (frmTRXControl) (height|width|top|left):283|367|711|911
Closing rigs...
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):1176|1855|24|65
select count(*) from cqrlog001.cqrlog_config

Saving ini file to database
select count(*) from cqrlog001.cqrlog_config

Saving ini file to database
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: 1cqrlog.cfg
Deleting config file: cqrlog.cfg
Closing dData
/home/willi/.config/cqrlog/database/testrechner.pid
Command:
kill 2133

File: lotw_test_export1.adi --------------------------------------------------------

2.2.1
ADIF export from CQRLOG for Linux version 2.2.0 (001)
Copyright (C) 2018 by Petr, OK7AN and Martin, OK1RR

Internet: http://www.cqrlog.com

20180106
1748
DO6FOX
SSB
70CM
432.21
55
59

20180106
1745
DO6FOX
SSB
2M
144.295
59
59

20180106
1448
DL7ACN
SSB
2M
144.312
59
59

20180106
1446
DK0KG
SSB
2M
144.312
59
59

20180105
1727
DO6FOX
SSB
70CM
432.2
55
59

20180105
1724
DO6FOX
SSB
2M
144.295
59
59

20180104
1724
DK2DTF
SSB
70CM
432.2
51
44

20180104
1722
DK2DTF
SSB
2M
144.31
57
59

20180104
1713
DL7ACN
SSB
2M
144.32
59
59

20180104
1712
DK0KG
SSB
2M
144.32
59
59

20180104
1619
DO6FOX
SSB
70CM
432.2
52
57

20180104
1616
DO6FOX
SSB
2M
144.29
58
58

20180103
1257
DO6FOX
SSB
70CM
432.2
52
59

20180103
1254
DO6FOX
SSB
2M
144.3
57
59

20180102
1552
DO6FOX
SSB
70CM
432.2
52
59

20180102
1549
DO6FOX
SSB
2M
144.2975
58
59

20180102
1255
DH2PA
SSB
10M
28.49
52
52

20180102
1251
DH2PA
SSB
2M
144.2992
53
57

20180102
1245
DL3IAF
SSB
2M
144.2992
59
59

20180102
1245
DN1EDK
SSB
2M
144.3
59
59

20180102
1108
DL6MK
SSB
2M
144.2898
57
57

20180102
1103
DK2DTF
SSB
2M
144.3074
59
59

20180101
1627
DO6FOX
SSB
70CM
432.2
53
59

20180101
1624
DO6FOX
SSB
2M
144.3
57
59

20171226
1013
PA3GEH
SSB
20M
14.275
54-58
58

20171226
0950
IT9EXH
SSB
20M
14.263
58
57

20171226
0947
OH9SCL
SSB
20M
14.253
58
59

20171225
1024
DJ2EY
SSB
40M
7.2
58
59

20171225
0957
PY2KNK
SSB
20M
14.272
41-46
55

20171225
0930
OH8XAT
SSB
20M
14.307
57
41

20171216
0927
DO2PK
SSB
2M
144.3
52
59

20171126
0810
DK1FG
SSB
2M
144.3
54
57

20171119
0925
DL/F4GFT/P
FM
70CM
438.65
59
59

20171104
1243
DL6IAK
SSB
2M
144.285
59
59

20171002
1412
DK1FG
SSB
2M
144.3
57
59

20170930
1425
DK1FG
SSB
2M
144.315
54
59

20170910
1140
DK0MM
SSB
2M
144.29
53
51

20170902
2041
DL7ACN
SSB
2M
144.3
59
59

20170902
2038
DF4T
SSB
2M
144.3
54
59

20170902
2034
TM0W
SSB
2M
144.3
53
59

20170902
2029
DK5GB
SSB
2M
144.3
58
59

20170902
2022
DR5T
SSB
2M
144.3
53
59

20170902
2008
DH6ICE/P
SSB
2M
144.3
54
59

20170902
2002
DK2BK
SSB
2M
144.3
55
59

20170902
1951
DR9A
SSB
2M
144.3
59
59

20170902
1949
F8KID
SSB
2M
144.3
54
59

20170902
1945
DF0SX
SSB
2M
144.3
54
59

20170902
1935
HB9GF
SSB
2M
144.3
52
59

20170902
1931
DJ6QS
SSB
2M
144.3
53
59

20170902
1920
DK0BC
SSB
2M
144.3
54
59

20170902
1919
TM9A
SSB
2M
144.3
53
59

20170902
1905
HB9RF
SSB
2M
144.3
52
59

20170902
1902
DH1WM
SSB
2M
144.3
55
59

20170902
1852
DR3A
SSB
2M
144.3
57
59

20170902
1836
DM5N
SSB
2M
144.3
57
59

20170812
0804
F6GYH
SSB
2M
144.31
53
53

File: cqrlog_test_export1.adi -------------------------------------------------

Internet: http://www.cqrlog.com

2.2.1
CQRLOG
2.2.0 (001)

2017122610131013PA3GEHSSB14.27520M54-5858GeraldYNJN15MS100
PA263Callsign used was F/DL8WA2714B
3|JN15MS|Clermont-Ferrand|Yaesu FT-897, Homemade multiband dipole antenna|
EU
20180103

2017122609500950IT9EXHSSB14.26320M5857CarmeloCapo d'Orlando (me)YNJN15MS
100I248Callsign used was F/DL8WA qsl via bureau2815B
3|JN15MS|Clermont-Ferrand|Yaesu FT-897, Homemade multiband dipole antenna|
EU
20180103

2017122609470947OH9SCLSSB14.25320M5859SantaRovaniemiYNOH9ABKP37HM
JN15MS100OH224Callsign used was F/DL8WA VIA OH9AB (BURO OR DIRECT, LoTW1815MB
3|JN15MS|Clermont-Ferrand|Yaesu FT-897, Homemade multiband dipole antenna|
EU
20180103

2017122510241024DJ2EYSSB7.240M5859Rudolf82131 GautingYNJN58QB
JN15MS100DL230Callsign used was F/DL8WA VIA BUREAU2814B
3|JN15MS|Clermont-Ferrand|Yaesu FT-897, Homemade multiband dipole antenna|
EU
20180103

2017122509570832PY2KNKSSB14.27220M41-4655LeonardoP.O. BOX 817YNGG56LC
JN15MS100PY108Callsign used was F/DL8WA Very strong QSBStrong QSB1511SPSP,B
3|JN15MS|Clermont-Ferrand|Yaesu FT-897, Homemade multiband dipole antenna|
SA
20180103

2017122509300832OH8XATSSB14.30720M5741Timo31410 YlöpirttiYNKP10RQ
JN15MS100OH224Callsign used was F/DL8WA EQSL,LOTW AUTOMATIC. WILL ALSO CFM ALL BUREAU & DIRECT CARDS.1815B
3|JN15MS|Clermont-Ferrand|Yaesu FT-897, Homemade multiband dipole antenna|
EU
20180103

File: cqrlog_debug_2.txt ---------------------------------------------------