Error 2 when uploading to LOTW

24 posts / 0 new
Last post
KB9TT
Error 2 when uploading to LOTW

Please help, I get an error -2 when I try to upload to LOTW webpage.

I ran CQRLOG from the terminal with debug=1 and this is the output:

**** DEBUG LEVEL 1 ****

SSL libraries:

Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.5
**********************************
Loaded 115701 LoTW users
Loaded 113723 eQSL users
Loaded 42080 SCP calls
*
User home directory: /home/kenny/
Program home directory: /home/kenny/.config/cqrlog/
Data directory: /home/kenny/.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.5
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/kenny/.config/cqrlog/database/mysql.cnf --datadir=/home/kenny/.config/cqrlog/database/ --socket=/home/kenny/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:2
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:3
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 313 -r /dev/ttyUSB0 -t 4532 -c 94
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 313

Starting RigCtld ...
/usr/bin/rigctld -m 313 -r /dev/ttyUSB0 -t 4532 -c 94
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 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 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-EN63CS;Home QTH;
login:

oh1kh
Error 2 when uploading to LOTW

HI!

Looks a bit like callsign/password error.
Can you log with browser using
https://LoTW.arrl.org/lotwuser/upload?login=YOURCALL&password=YOURPASSWD
?
And do you have correct password at prerferences+ correct qth at connection form.

Like you can see my picture it seems NOT to be caps-related as this is the one that I use and it works!

File: 

--
Saku
OH1KH

KB9TT
Error 2 when uploading to LOTW. Still not working

Saku,
Its still not working. I do have the correct callsign, password and QTH programmed in Preferences. I ran the command /usr/bin/tqsl -d -l "Home" /home/kenny/.config/cqrlog/lotw/2018-06-06_12-54-44.adi -x from terminal and it works fine. It appears to Export and Sign okay but error occurs when I Upload

I also get an error when trying to download from LOTW.

Any ideas? Thank you for your help!

73
Ken

here is the latest run with debug=1:

**** DEBUG LEVEL 1 ****

SSL libraries:

Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.5
**********************************
Loaded 117920 LoTW users
Loaded 115230 eQSL users
Loaded 39772 SCP calls
*
User home directory: /home/kenny/
Program home directory: /home/kenny/.config/cqrlog/
Data directory: /home/kenny/.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.5
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/kenny/.config/cqrlog/database/mysql.cnf --datadir=/home/kenny/.config/cqrlog/database/ --socket=/home/kenny/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL55Connection : 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 313 -r /dev/ttyUSB0 -t 4532
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 313

Starting RigCtld ...
/usr/bin/rigctld -m 313 -r /dev/ttyUSB0 -t 4532
rig_open: error = IO error
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 view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
TMP:

table { margin-left:40px; border-style:none; border-spacing:0px; padding:0px; border-collapse:collapse }
th { text-align:left; font-size:16px; font-family:Verdana,Arial,Helvetica,sans-serif; font-variant:small-caps;margin-bottom:24px; background-color:#d0d8e8 }
td { font-family:Verdana,Arial,Helvetica,sans-serif; font-size:14px }
.header { margin-top:30px; margin-bottom:4px }
.footer { margin-top:30px }
.footer td { padding-left:110px; margin-bottom: 0px; font-size:11px }

DK0WCY Magnetogram

Indices of 05 Jun 
Current Geomagnetic Field 
Forecast 

Boulder A 6
Kiel 3-hour k 2
Solar Activity quiet

Kiel A 10
Kiel current k 3.99
Geomagnetic Fieldquiet

Sunspot Number 0
Aurora no
  

Solar Flux 71
  
  

Erl�uterungen zum Magnetogramm
Notes on the magnetogram

Informationen zur neuen Magnetogramm Darstellung
About the new magnetogram display

Fragen? Senden Sie eine E-Mail an dk0wcy@darc.de
Questions? Contact us at dk0wcy@darc.de

Diese Seite wird alle 5 Minuten von Ihrem Browser neu geladen.
Your browser will reload this page every 5 minutes.

Time: Indices of 05 Jun
UTC: 17:54:30
Boulder A:6
Solar Act:quiet
Kiel A:10
Kiel K: 3.99
Kiel 3h 2
GF: quiet
SSN: 0
Aurora: no
SFI: 71
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 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-EN63CS;Home QTH;
Rounded Kidx for Graph: 399
There are : 1 Kdata entries
select * from cqrlog_main

select * from cqrlog_main

/usr/bin/tqsl -d -l "Home" /home/kenny/.config/cqrlog/lotw/2018-06-06_12-54-44.adi -x
https://LoTW.arrl.org/lotwuser/upload?login=KB9TT&password=****
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

SELECT COUNT(*) FROM cqrlog_main

select * from profiles order by nr

SELECT * FROM view_cqrlog_main_by_qsodate

Command line: tar -cvzf KB9TT_2018-06-06_12-55-25.tar.gz KB9TT_2018-06-06_12-55-25.adi
KB9TT_2018-06-06_12-55-25.adi
Closing rigs...
Section:frmPropDK0WCY
Saving window size a position (frmPropDK0WCY) (height|width|top|left):312|229|24|39
SaveForm: frmMain
Section:frmMain
Saving window size a position (frmMain) (height|width|top|left):587|1351|24|39
Closing QSO list window
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):592|1047|72|378
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: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/kenny/.config/cqrlog/database/kenny-Inspiron-1720.pid
Command:
kill 6308
Closing ini file ...

oh1kh
Error 2 when uploading to LOTW. Still not working

Hi Ken!

I did a test upload with debug=1 to see differences.

Were you have:
/usr/bin/tqsl -d -l "Home" /home/kenny/.config/cqrlog/lotw/2018-06-06_12-54-44.adi -x
https://LoTW.arrl.org/lotwuser/upload?login=KB9TT&password=****
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

My debug shows connection:
Msg from rig: 14074000
Msg from rig: USB
2400
Msg from rig: RPRT -11
https://LoTW.arrl.org/lotwuser/upload?login=oh1kh&password=*****
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML><HEAD><TITLE>Logbook File Upload</TITLE>

<link rel="stylesheet" href="/js/jquery-ui-1.11.4.custom/jquery-ui.min.css" type="text/css">
<link rel="stylesheet" href="/js/jquery-ui-1.11.4.custom/jquery-ui.structure.min.css" type="text/css">
<link rel="stylesheet" href="/js/jquery-ui-1.11.4.custom/jquery-ui.theme.min.css" type="text/css">

<link rel="stylesheet" ......

Page is rather long and ends to:

</TD>
</TR>
</table>

<!-- .UPL. accepted -->
<!-- .UPLMESSAGE. File queued for processing -->

</BODY></HTML>

select * from cqrlog_main where lotw_qslsdate is null

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 12544

So it seems you do not get connection to LoTW web site. On the other hand I can see that you have Dk0WCY propagation web site loaded ok.

Only difference between these 2 is that LoTW uses https while dk0wcy is plain http.

Before you said that you can connect LoTW manually using https address. So it can not be any proxy or firewall related problem.
That leaves only ssl remaining. Do you have OpenSSL and OpenSSL libraries installed and ok?

At the moment I'm quit out of new ideas to resolve this...

--
Saku
OH1KH

KB9TT
Thanks. i can log into https:

Thanks. i can log into https://LoTW.arrl.org/lotwuser/upload?login=YOURCALL&password=YOURPASSWD using my browser
with my callsign and password. I did recently change callsigns and maybe have the wrong one in the preferences. I'll look it over again.

thanks,
73
Ken
KB9TT

K1BJF
Lot login

I'm new to CQRLOG. I'm trying to setup the unofficial rpi version. I noticed that when I try to enter my LoTW password, the field size in the config GUI is only 7. My LoTW password is 8 characters, which is the minimum size that you can set it. Has anybody else seen this problem?

Barry Furnival
K1BJF
Jaffrey, NH
k1bjf@arrl.net

oh1kh
Lot login

Hi!

I do not know about rpi version changes, but looked from source LoTW passwd field has MaxLength 0.
That means there is no limit at that point.
With PC this field shows 10 spots, but after that input still continues. You just can not notice any key press as filed is full of dots (10) and adding a new one looks similar as before.

Have you just tried to type in your full password and test the connection to LoTW ?

--
Saku
OH1KH

K1BJF
Lot login

After going to the LoTW site and resetting my password, I went into the rpi version of CQRLOG and tried to set it to the new password. Then I tried to download my last group of entries and it said that the login failed. I counted the dots in the password field and there were only 7 dots. Maybe that is not a good indication of what is in the field. I tried to reenter the password several more times with the same result. I can log into the LoTW website withe the new password and look at all my entries.

Barry Furnival
K1BJF
Jaffrey, NH
k1bjf@arrl.net

oh1kh
Lot login

HI Barry!

Same suggestion for you as fror Ken. Do you have your OpenSSL and libraries installed?

Cqrlog Help / Dependencies says:
libssl-devel needed if you want to use LoTW and/or online log upload

You can do a debug with starting cqrlog from command terminal window using:
cqrlog debug=1 > /tmp/debug.txt

Try to connect LoTW and after that close cqrlog.
Then open /tmp/debug.txt with your favorite text editor and seek a line having text "https://LoTW.arrl.org/lotwuser/upload?".

Your password should be there in plain text. Is it correct?

If you get connected next lines will have:
!DOCTYPE HTML PUBLIC "-//W3C//DTD HT ... and so on.
See my reply to Ken on this thread.

--
Saku
OH1KH

K1BJF
Lot login

Hi Saku,

Since I last posted here, I downloaded Petr's version and found that I had the same problem. I ran with debug redirected to out.txt. I'll include a listing of the file below (with my password stared out). The password was correct in the call to LoTW. I noticed that at the beginning of the file, I have no SSL libs listed. I double checked and both openssl and libssl-dev are installed. I'm trying to download my QSO list from LoTW. It looks like the login fails, however, I can copy the https call from the file and paste it into a browser and the adi file is downloaded. So I'm back to looking at why CQRLog cannot see my ssl libs.

out.txt file:

**** DEBUG LEVEL 1 ****

SSL libraries:

Loading libmysqlclient:
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 117920 LoTW users
Loaded 115230 eQSL users
Loaded 39772 SCP calls
*
User home directory: /home/pi/
Program home directory: /home/pi/.config/cqrlog/
Data directory: /home/pi/.config/cqrlog/database/
Memebers directory: /home/pi/.config/cqrlog/members/
ZIP code directory: /home/pi/cqrlog-20180421/usr/share/cqrlog/zipcodes/
Binary dir: /home/pi/cqrlog-20180421/usr/bin/
Share dir: /home/pi/cqrlog-20180421/usr/share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
WARNING: obsolete call to RecreateWnd for TfrmDBConnect
Warning: TWinControl.DestroyHandle frmDBConnect:TfrmDBConnect Handle not Allocated
/usr/sbin/mysqld --defaults-file=/home/pi/.config/cqrlog/database/mysql.cnf --datadir=/home/pi/.config/cqrlog/database/ --socket=/home/pi/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL56Connection : 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

[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
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 1 -r -t 4532
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1

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
FreqmemSql:select id,freq,mode,bandwidth from freqmem order by id

FreqmemFirst:0 FreqmemLast:0
CW init
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 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

WARNING: obsolete call to RecreateWnd for TfrmImportLoTWWeb
Warning: TWinControl.DestroyHandle frmImportLoTWWeb:TfrmImportLoTWWeb Handle not Allocated
DLLSSLName:
DLLUtilName:
https://LoTW.arrl.org/lotwuser/lotwreport.adi?login=k1bjf&password=*****..."yes"&qso_qslsince=2012-01-01&qso_owncall=K1BJF
Section:frmImportLoTWWeb
Saving window size a position (frmImportLoTWWeb) (height|width|top|left):583|572|36|20
WARNING: obsolete call to RecreateWnd for TfrmWorking
Warning: TWinControl.DestroyHandle frmWorking:TfrmWorking Handle not Allocated
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

SaveForm: frmMain
Section:frmMain
Saving window size a position (frmMain) (height|width|top|left):587|854|36|0
Closing QSO list window
WARNING: obsolete call to RecreateWnd for TfrmExportProgress
Warning: TWinControl.DestroyHandle frmExportProgress:TfrmExportProgress Handle not AllocateK1BJF_2018-06-09_02-46-56.adi
d
SELECT COUNT(*) FROM cqrlog_main

select * from profiles order by nr

SELECT * FROM view_cqrlog_main_by_qsodate

Command line: tar -cvzf K1BJF_2018-06-09_02-46-56.tar.gz K1BJF_2018-06-09_02-46-56.adi
Closing rigs...
Closing Details window
Section:frmQSODetails
Saving window size a position (frmQSODetails) (height|width|top|left):210|266|36|20
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):651|807|36|103
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/pi/.config/cqrlog/database/hampi.pid
Command:
kill 3026
Closing ini file ...

Thanks,
Barry

Barry Furnival
K1BJF
Jaffrey, NH
k1bjf@arrl.net

oh1kh
Lot login

Hi Barry!

I have been trying to set up my old rpi2 for testing latest beta.
I was able to install it, but I have been looking for tqsl package without luck. (seen mentions abt it with googling, but it does not exist in standard repositories.
Downloaded the source, but there are quite lot to load to get compiler work with tqsl source.

Without tqsl I'm not able to test LoTW part.

If I understand right rpi cqrlog version has been compiled with a bit older lazarus, as rpi does not have the latest one.
Could that make the problem with https (ssl) pages?

I will look it more when time permits.

--
Saku
OH1KH

K1BJF
Lot login

Hi Saku,

OK, I will try that tonight and let you know the results. Thanks much for your response. I'm using a new rpi also, so it may not have all the needed dependencies installed. Again this is the unofficial build that one of the users posted here. It's working great other than the login issue.

Barry Furnival
K1BJF
Jaffrey, NH
k1bjf@arrl.net

oh1kh
Have you noticed that Petr

Have you noticed that Petr has Beta version also for RPI ?
https://www.cqrlog.com/node/2021

Installation goes same way as I have here:
https://www.cqrlog.com/comment/6412#comment-6412

--
Saku
OH1KH

KB9TT
LOTW UPLOAD ERROR SOLVED

Based on your comment below on another thread from January, I downloaded cqrtest220-141_i386.zip and then copied that binary into /usr/bin and it uploaded to LOTW just fine. My CQRLOG debug=1 output is below.

"Could someone of you test the 1.6.4 Lazarus compiled binary from my test web: http://www.saunalahti.fi/~sakny/bin/cqrlog2/
Be sure to have logs backup (first thing to do before anything else).
Download zip to /tmp and extract it.
Move (or copy) your original /usr/bin/cqrlog to safe place for restore.
Copy extracted /tmp/cqrlog to /usr/bin
(/usr/bin operation needs sudo or being root)
Start cqrlog as usually.
It would be interesting to know if upload to LoTW works with that binary.
--
Saku
OH1KH"

kenny@kenny-Inspiron-1720:~$ cqrlog --debug=1

Cqrlog Ver:2.2.0 (141) Date:2018-06-03
**** DEBUG LEVEL 1 ****

SSL libraries:
/lib/i386-linux-gnu/libssl.so.1.0.0
/lib/i386-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.5
**********************************
Loaded 117920 LoTW users
Loaded 115230 eQSL users
Loaded 39772 SCP calls
*
User home directory: /home/kenny/
Program home directory: /home/kenny/.config/cqrlog/
Data directory: /home/kenny/.config/cqrlog/database/
Memebers directory: /home/kenny/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.5
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/kenny/.config/cqrlog/database/mysql.cnf --datadir=/home/kenny/.config/cqrlog/database/ --socket=/home/kenny/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:2
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

[UpgradeMainDatabase] Old version: 13 cDB_MAIN_VER: 15
alter table cqrlog_main change mode mode varchar(12) not null

alter table log_changes change mode mode varchar(12) null

alter table log_changes change old_mode old_mode varchar(12) null

alter table call_alert change mode mode varchar(12) null

alter table freqmem change mode mode varchar(12) null

alter table cqrlog_main add rxfreq numeric(10,4) null

alter table cqrlog_main add satellite varchar(30) default ''

alter table cqrlog_main add prop_mode varchar(30) default ''

select table_name from information_schema.tables where table_schema='cqrlog001' and table_name='view_cqrlog_main_by_callsign'

drop view view_cqrlog_main_by_callsign

select table_name from information_schema.tables where table_schema='cqrlog001' and table_name='view_cqrlog_main_by_qsodate'

drop view view_cqrlog_main_by_qsodate

select table_name from information_schema.tables where table_schema='cqrlog001' and table_name='view_cqrlog_main_by_qsodate_asc'

drop view view_cqrlog_main_by_qsodate_asc

CREATE VIEW view_cqrlog_main_by_qsodate AS SELECT id_cqrlog_main,qsodate,time_on,time_off,callsign, freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,
award,remarks, band, dxcc_id.dxcc_ref AS dxcc_ref ,qso_dxcc, profile,idcall, state, lotw_qslsdate, lotw_qslrdate,lotw_qsls, lotw_qslr, cont, qsls_date,qslr_date,club_nr1,club_nr2,club_nr3,
club_nr4,club_nr5,eqsl_qsl_sent,eqsl_qslsdate,eqsl_qsl_rcvd,eqsl_qslrdate,concat(qsl_r,lotw_qslr,eqsl_qsl_rcvd) as qslr,dxcc_id.country, rxfreq, satellite, prop_mode FROM cqrlog_main JOIN dxcc_id ON dxcc_id.adif = cqrlog_main.adif order by qsodate DESC, time_on DESC;

CREATE VIEW view_cqrlog_main_by_qsodate_asc AS SELECT id_cqrlog_main,qsodate,time_on,time_off,callsign, freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,
award,remarks, band, dxcc_id.dxcc_ref AS dxcc_ref ,qso_dxcc, profile,idcall, state, lotw_qslsdate, lotw_qslrdate,lotw_qsls, lotw_qslr, cont, qsls_date,qslr_date,club_nr1,club_nr2,club_nr3,
club_nr4,club_nr5,eqsl_qsl_sent,eqsl_qslsdate,eqsl_qsl_rcvd,eqsl_qslrdate,concat(qsl_r,lotw_qslr,eqsl_qsl_rcvd) as qslr,dxcc_id.country, rxfreq, satellite, prop_mode FROM cqrlog_main JOIN dxcc_id ON dxcc_id.adif = cqrlog_main.adif order by qsodate ASC, time_on ASC;

CREATE VIEW view_cqrlog_main_by_callsign AS SELECT id_cqrlog_main,qsodate,time_on,time_off,callsign, freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,
award,remarks, band, dxcc_id.dxcc_ref AS dxcc_ref ,qso_dxcc, profile,idcall, state, lotw_qslsdate, lotw_qslrdate,lotw_qsls, lotw_qslr, cont, qsls_date,qslr_date,club_nr1,club_nr2,club_nr3,
club_nr4,club_nr5,eqsl_qsl_sent,eqsl_qslsdate,eqsl_qsl_rcvd,eqsl_qslrdate,concat(qsl_r,lotw_qslr,eqsl_qsl_rcvd) as qslr,dxcc_id.country, rxfreq, satellite, prop_mode FROM cqrlog_main JOIN dxcc_id ON dxcc_id.adif = cqrlog_main.adif order by callsign;

update db_version set nr=15

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 313 -r /dev/ttyUSB0 -t 4532
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 313

Starting RigCtld ...
/usr/bin/rigctld -m 313 -r /dev/ttyUSB0 -t 4532
rig_open: error = IO error
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
FreqmemSql:select id,freq,mode,bandwidth from freqmem order by id

FreqmemFirst:0 FreqmemLast:0
CW init
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

TMP:

table { margin-left:40px; border-style:none; border-spacing:0px; padding:0px; border-collapse:collapse }
th { text-align:left; font-size:16px; font-family:Verdana,Arial,Helvetica,sans-serif; font-variant:small-caps;margin-bottom:24px; background-color:#d0d8e8 }
td { font-family:Verdana,Arial,Helvetica,sans-serif; font-size:14px }
.header { margin-top:30px; margin-bottom:4px }
.footer { margin-top:30px }
.footer td { padding-left:110px; margin-bottom: 0px; font-size:11px }

DK0WCY Magnetogram

Indices of 06 Jun 
Current Geomagnetic Field 
Forecast 

Boulder A 7
Kiel 3-hour k 2
Solar Activity quiet

Kiel A 9
Kiel current k 2.10
Geomagnetic Fieldquiet

Sunspot Number 0
Aurora no
  

Solar Flux 71
  
  

Erl�uterungen zum Magnetogramm
Notes on the magnetogram

Informationen zur neuen Magnetogramm Darstellung
About the new magnetogram display

Fragen? Senden Sie eine E-Mail an dk0wcy@darc.de
Questions? Contact us at dk0wcy@darc.de

Diese Seite wird alle 5 Minuten von Ihrem Browser neu geladen.
Your browser will reload this page every 5 minutes.

Time: Indices of 06 Jun
UTC: 02:24:13
Boulder A:7
Solar Act:quiet
Kiel A:9
Kiel K: 2.10
Kiel 3h 2
GF: quiet
SSN: 0
Aurora: no
SFI: 71
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-EN63CS;Home QTH;
Rounded Kidx for Graph: 210
There are : 1 Kdata entries
select * from cqrlog_main where lotw_qslsdate is null

select * from cqrlog_main where lotw_qslsdate is null

/usr/bin/tqsl -d -l "Home" /home/kenny/.config/cqrlog/lotw/2018-06-07_21-24-31.adi -x
https://LoTW.arrl.org/lotwuser/upload?login=KB9TT&password=****

Logbook File Upload

jQuery( document ).tooltip();

jQuery(document).ready(function() {
dlgLOTW.ready();
});

Today is Fri, 8 Jun 2018 UTC

You are KB9TT

Log Off

You have 134 QSO records

You have 41 QSL records

 

Search Help:
Search

Home
Your QSOs
Awards
Find Call
Upload File
Your Account
Help

Logbook File Upload

File /home/kenny/.config/cqrlog/lotw/2018-06-07_21-24-31.tq8 queued for processing.

Here you can upload a log (.TQ8) or certificate-request (.TQ5) file.

File to Upload&colon;

You can also submit files via email to lotw-logs@arrl.org.

Copyright 2018 American Radio Relay League, Inc.
All Rights Reserved

Terms of Use/Privacy Policy

select * from cqrlog_main where lotw_qslsdate is null

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 57

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 58

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 59

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 60

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 61

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 62

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 63

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 64

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 65

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 66

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 67

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 68

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 69

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 70

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 71

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 72

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 73

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 74

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 75

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 76

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 77

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 78

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 79

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 80

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 81

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 82

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 83

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 84

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 85

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 86

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 87

update cqrlog_main set lotw_qsls = 'Y',lotw_qslsdate = '2018-06-07'where id_cqrlog_main = 88

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

SELECT COUNT(*) FROM cqrlog_main

select * from profiles order by nr

SELECT * FROM view_cqrlog_main_by_qsodate

Command line: tar -cvzf KB9TT_2018-06-07_21-25-13.tar.gz KB9TT_2018-06-07_21-25-13.adi
KB9TT_2018-06-07_21-25-13.adi
Closing rigs...
Section:frmPropDK0WCY
Saving window size a position (frmPropDK0WCY) (height|width|top|left):312|229|24|39
SaveForm: frmMain
Section:frmMain
Saving window size a position (frmMain) (height|width|top|left):587|1351|24|39
Closing QSO list window
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):592|1047|72|378
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: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/kenny/.config/cqrlog/database/kenny-Inspiron-1720.pid
Command:
kill 7315
Closing ini file ...

oh1kh
LOTW UPLOAD ERROR SOLVED

HI Ken !

Nice to hear that it works now !

As you now have the latest test version please install help files also to get updated help.
There is readme_install.txt at website telling how to do that. Help is inside the ZIP

Also README inside the ZIP tells slightly about new features.

--
Saku
OH1KH

k5ejb
Same error when uploading

Same error when uploading here. Any suggestions?

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****

SSL libraries:

Loading libmysqlclient:
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 138685 LoTW users
Loaded 128540 eQSL users
Loaded 35719 SCP calls
/home/pi/.config/cqrlog/database/raspberrypi.pid
Command:
kill 5811
*
User home directory: /home/pi/
Program home directory: /home/pi/.config/cqrlog/
Data directory: /home/pi/.config/cqrlog/database/
Memebers directory: /home/pi/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/pi/.config/cqrlog/database/mysql.cnf --datadir=/home/pi/.config/cqrlog/database/ --socket=/home/pi/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL56Connection : 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 cqrlog002

use cqrlog002

use cqrlog002

use cqrlog002

use cqrlog002

SELECT * FROM cqrlog_config

select * from db_version

[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
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 2 -r -t 4532
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 2

rigctld started!
Connected to localhost:4532

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

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

FreqmemFirst:0 FreqmemLast:0
Sending: fmv

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-EL17IV;South Texas;IC 7300, Mac OS, Pi, EFHW @ 20 ft;
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

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

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

select * from cqrlog_main where lotw_qslsdate is null

select * from cqrlog_main where lotw_qslsdate is null

/usr/bin/tqsl -d -l "Home" /home/pi/.config/cqrlog/lotw/2020-03-05_06-17-15.adi -x
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

https://LoTW.arrl.org/lotwuser/upload?login=k5ejb&password=PSWD
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

https://LoTW.arrl.org/lotwuser/upload?login=k5ejb&password=PSWD
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

https://LoTW.arrl.org/lotwuser/upload?login=k5ejb&password=PSWD
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

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

Sending: fmv

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

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending:

oh1kh
Same error when uploading

HI!

Have you libssl-dev installed?

Try console commands (in order):
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install libssl-dev

If if last one fails then try:
sudo apt-get install libssl1.0-dev

--
Saku
OH1KH

k5ejb
Thank you. I did this. Same

Thank you. I did this. Same results, error -2

oh1kh
Thank you. I did this. Same

Hi!
Did that give response that libssl-dev is already installed, or did it say that package was not found, or that installaton was successful?

--
Saku
OH1KH

k5ejb
Installation was successful

Installation was successful and then I rebooted.

oh1kh
Thank you. I did this. Same

Hi
Now I found what I was remembering to be somewhere.

If your libssl- dev seems to be installed then read this mail:
(by ON4ABR)
https://www.cqrlog.com/comment/7703#comment-7703

--
Saku
OH1KH

k5ejb
Thank you for staying in

Thank you for staying in there with me. Did this too. It does not work. Same issue, still.

I notice that you said do not put a "&" in the password. Will a "!" present a problem too?

oh1kh
Thank you for staying in

Hi!
Ohh.. I am soon out of any new ideas.
Are you sure that library files are now at right folder. I assume they are symlinks. Give
ls -l
To list them and see to what directory/file they are pointing to and check that you can also found that file in question.
If ok, check first lines of cqrlog debug to see does it find ssl libraries.

& is fatal character as html code uses it as prefix for special characters like arrow right is & g t ; If i write them without spaces between result is >
! May go, but it is also used at html remarks. So better not to use that either. Best solution is letters (high/lowcase) and numbers.

I wish I could test with new rpi, but I do not have new pi. Just v2 that is too slow and small. And on the other hand I have also some limitatons what all I can do.
The current versions for it are so old that someone should compile latest one ( 2.4.0) from github source.
It does not have to be in installation packet as only copying the binary file (/usr/bin/cqrlog) is enouhg for upgrade already installed (from packet) version If help files upgading is not needed.

--
Saku
OH1KH

k5ejb
Well, I am not sure what the

Well, I am not sure what the problem was, but I fixed it. I updated to version 3.4 and all the issues went away. Unfortunately, the pi repo does not have this version on it and that old version is buggy.