Hello,
I am using a Raspberry Pi 3 B+ running:
PRETTY_NAME="Raspbian GNU/Linux 9 (stretch)"
NAME="Raspbian GNU/Linux"
VERSION_ID="9"
VERSION="9 (stretch)"
I am running CQRLOG 2.3.0 (001) 2018-06-07
When I select to upload new QSO's to ClubLog the status of the log upload shows:
ClubLog: Upload failed! Check Internet connection
I have two other computers, both running the same CQRLOG version on Ubuntu 18.04 that have no problems uploading.
What else could be done to problem solve this?
Thanks and 73 John NU8M
---- Debug Info ----
Running CQRLOG in debug mode, it shows the following:
--------------------------------------------------------------------------------------------
SyncUpdate:
SyncMsg :ClubLoselect * from upload_status where logname='ClubLog'
select * from log_changes where id > 6 order by id
select * from log_changes where id = 7
select * from cqrlog_main where id_cqrlog_main = 3
data.Text:
email=nu8m@arrl.net
password="deleted from posting"
callsign=nu8m
api=21507885dece41ca049fec7fe02a813f2105aff2
adif=201812281609N0UR40MFT87.0741610+07+00JamesELLENDALENNEN33IUEN82DL74MNMN,SteeleNNNA
-----------
Response :
ResultCode:500
-----------
g: Uploading N0UR
SyncUpdate:
SyncMsg :ClubLog: Upload failed! Check Internet connection
Sending: fmv
Hi!
I do not use any of those logs, but made a peek to source code and from there it can be seen that HamQth and HrdLog uses http and Clublog uses https.
If I remember right there has been problems with raspberry ssl libraries.
If ssl libraries are not installed http will work but https does not. In that case loTW and Clublog are those that fail.
Your other computers running Ubuntu probably have ssl libraries installed ok.
That is just a guess.
--
Saku
OH1KH
Thanks,
This is what I found:
-------------------------------------
apt-cache policy openssl
openssl:
Installed: 1.1.0j-1~deb9u1
Candidate: 1.1.0j-1~deb9u1
Version table:
*** 1.1.0j-1~deb9u1 500
500 http://raspbian.raspberrypi.org/raspbian stretch/main armhf Packages
100 /var/lib/dpkg/status
John NU8M
Hi!
That was just a quess.
You can start cqrlog at Ubuntu and raspberry from console:
cqrlog debug=1 > /tmp/debug.txt
Then stop them and compare files /tmp/debug.txt between Ubuntu and raspberry.
You should see something like:
---------------------
Cqrlog Ver:2.3.0 (206) Date:2018-12-26
**** DEBUG LEVEL 1 ****
SSL libraries:
libssl.so
libcrypto.so
Loaded 124164 LoTW users
Loaded 119318 eQSL users
Loaded 38979 SCP calls
*
User home directory: /home/saku/
Program home directory: /home/saku/.config/cqrlog/
-------------
Compare part "SSL libraries" do both indicate that libraries are loaded ok?
What I'm after is does rasperry's cqrlog load SSL ok. Even when they are installed they can be ignored by cqrlog.
Look at this thread: https://www.cqrlog.com/node/2073
--
Saku
OH1KH
That appears to be the problem;
For one of my linux computers, the debug shows:
------------------------------------------------------------------
Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****
SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.7
----------------------------------------------------------
Whereas for the Rp3B+ it shows no loading of SSL libraries:
qrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****
SSL libraries:
Loading libmysqlclient:
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
------------------------------------------------------------------------------------------
According the the thread, no solution is yet available.
Thanks and 73 John NU8M
John NU8M
I built CQRLOG 2.3.0 (002) 2018-12-03 from the git repository on my Raspberry Pi 3 this week and the ssl error problem with uploading/downloading from LOTW was resolved.