Lotw-Support in CQRLOG broken

7 posts / 0 new
Last post
dl8wa
Lotw-Support in CQRLOG broken

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

use cqrlog001

use cqrlog001

use cqrlog001

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

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

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')

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

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')

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 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 view_cqrlog_main_by_qsodate WHERE (my_loc = 'JN15MS')

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 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 -------------------------------------------------

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

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 ---------------------------------------------------

**** 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

use cqrlog001

use cqrlog001

use cqrlog001

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

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

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 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 LIMIT 500 OFFSET 0

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 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

0
SaveForm: frmMain
SaveForm: frmMain
SaveForm: frmMain
SaveForm: frmMain
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 2271

File: lotw_test_export2.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

oh1kh
Debug2

Hi

Have actually loaded those 56 qsos to lotw?. At least for me the "never uploaded" works ok.
If actual upload fails qsos may not be marked as uploaded until upload is accepted.

For case 1: I have not tested that way ever. But sometimes I have noticed that instead of selected export I have got all qsos of the log. But it was with earlier version. With current one my selected exports have worked ok. (But not so many of them)

--
Saku
OH1KH

dl8wa
Hi!

Hi!

Actually, a failed upload brought to my mind that the lotw export does not work as expected: I had already uploaded a number of QSOs, and when I made a second attempt, cqrlog complained that I had already uploaded many of them... I don't know what's going wrong here.

Actually, this bug is already in the current Rasbian version 2.0.2 (001) 2016-08-28, and probably olders as well.

Also, cqrlog must mark the qsos as exported, since there is no feedback path from tqsl to cqrlog if you do it the way i do... You can see in the debug file that cqrlog tries to update the qso records with the current date and a 'Y' in the lotw_qsldate and lotw_qsls records, but somehow this information gets lost.

If I can help you with any other information, please let me know and I'll give you (almost) anything you want.

Many thanks & Best Regards,

Andreas

dl8wa
Same bug as in https://www.cqrlog.com/node/1987?

One more comment: I just went through the forum and saw John's post: https://www.cqrlog.com/node/1987

This COULD be the same error as I have described above.

73, Andreas

oh1kh
Lotw export

Hi
I wll peek the source next time Im at my programming pc. Mainly to see how it handles upload and does it get any response from upload.
Commonly speaking versions under 2.2.0 should not be used. At least all bugs should be accepted then.

Petr has just released a script that fixes "use dollar sign"-bug that has prevented latest version to compile/run with rasp. (I think! I do not have currently any running rasp to test this, but I hope it does help.)
All work sould be directed to make the latest version running on rasp. Before that thre is no mind to waste time with bugs in old versions.

--
Saku
OH1KH

oh1kh
Lotw export

Hi
Ok. Now I have looked lotw upload source.
When you press upload-button the upload starts.
When it ends and lotw gives "<!-- .UPL. accepted -->" then variable "suc" is set.

A bit later in source if "suc" is set then database is updated and qsos "lotw_qsls" will get value Y and "lotw_qsldate" gets current date.
Just what I thought !
Upload must succeed and only after that qsos are marked as uploaded to lotw.

I also tried with one qso that was not uploaded to lotw.

If you select one qso with filter that goes to adif export as one qso.
If you try to use filtered result to lotw upload it does not work.

That is because the adif export routine is different for export and lotw-export.
Lotw-export understands only "all qsos" or "qsos never uploaded" and uses "lotw_qsldate"
to see if upload is done or not.

And we are talking now 2.2.0 version, not any earlier one.

Do we really need anything else?

If there is need to confirm only some qsos, not all, you have to export them as adif to file.
Then sign this file with TQSL program and manually upload result to lotw web page.
This is how ever very rare situation. Normally all qsos are confirmed. (or none, depending operator!)

--
Saku
OH1KH

--
Saku
OH1KH

oh1kh
LoTW export

Hi !
Petr has fixed filtered LoTW export.
Now select qsos with filter and then do LoTW export as "Export all qsos". Filtered qsos are uploaded to LoTW.
I have tested it now few times and it works as expected.

Fixed version is released as source code at his GitHub and will be with next official release.

It is worth to mention that there, in tools directory, is also a script that sets package suitable for armhf. I.E for rasp.

Tnx Petr!

--
Saku
OH1KH

--
Saku
OH1KH