LOTW problem Raspberry Pi

4 posts / 0 new
Last post
KK6KC
KK6KC's picture
LOTW problem Raspberry Pi

I am running on Raspberry Pi 3+
I am having trouble with downloading and uploading to LOTW.

LOTW software is already installed and works fine directly.

I have already installed libssl-dev:

pi@KirksPi:~ $ sudo apt-get install libssl-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
libssl-dev is already the newest version (1.1.0f-3+deb9u2).
libssl-dev set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
pi@KirksPi:~ $

Here is an out file from trying to download from LOTW:

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 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 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: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /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 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-DM03UT;Lomita;
select * from view_cqrlog_main_by_qsodate where qsodate >= '2018-06-18' order by qsodate,time_on

LoadForm: frmNewQSO
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 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

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

WARNING: obsolete call to RecreateWnd for TfrmImportLoTWWeb
Warning: TWinControl.DestroyHandle frmImportLoTWWeb:TfrmImportLoTWWeb Handle not Allocated
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

DLLSSLName:
DLLUtilName:
https://LoTW.arrl.org/lotwuser/lotwreport.adi?login=KK6KC&password=********&qso_query=1&qso_qsldetail="yes"&qso_qslsince=2018-06-01&qso_owncall=KK6KC
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

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
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') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

Sending: fmv

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') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

SaveForm: frmMain
Section:frmMain
Saving window size a position (frmMain) (height|width|top|left):607|1910|324|0
Closing QSO list window
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Closing rigs...
1
2
3
4
5
6
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):736|898|36|256
select count(*) from cqrlog002.cqrlog_config

Saving ini file to database
select count(*) from cqrlog002.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: 2cqrlog.cfg
Closing dData
/home/pi/.config/cqrlog/database/KirksPi.pid
Command:
kill 5765
Closing ini file ...

As you see, it is not detecting the ssl libraries.

Why is this?

hi8smx
So do I

I have the same issue. Did you found a fix?

73, HI8SMX

KK6KC
KK6KC's picture
No solution for automatic

No solution for automatic uploading to LOTW.

In the mean time, I just do the manual method of making and .adi file of what needs to be uploaded and then upload it manually.

Kirk Crawford
KK6KC
Lomita, CA, USA

hi8smx
Great minds think alike

Yep, that's what I've been doing as well. If I find a solution I'll let you know.

Thanks.

73,

HI8SMX
Santiago