After starting CQRLog I get an exception. I can choose a log and it displays normally then freezes.
So far:
Installed the Linux Mint (Ubuntu) version of CQRLog
I have installed mariadb-server over mysql
Reinstalled CQRLog
Reinstalled mariadb-server
Below is the debug output from CQRLog
73 de Graeme ZL2APV
Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****
OS:
Linux version 5.15.0-52-generic (buildd@lcy02-amd64-032) (gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #58-Ubuntu SMP Thu Oct 13 08:03:55 UTC 2022
SSL libraries:
libssl.so
libcrypto.so
Loaded 179909 LoTW users
Loaded 158514 eQSL users
Loaded 59943 SCP calls
/home/gvj/.config/cqrlog/database/DLap.pid
p.Executable: kill Parameters: 5095
*
User home directory: /home/gvj/
Program home directory: /home/gvj/.config/cqrlog/
Data directory: /home/gvj/.config/cqrlog/database/
Memebers directory: /home/gvj/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
*
56 us states loaded
Grid map created
/usr/bin/mysqld
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/gvj/.config/cqrlog/database/mysql.cnf
--datadir=/home/gvj/.config/cqrlog/database/
--socket=/home/gvj/.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
[UpgradeMainDatabase] Old version: 18 cDB_MAIN_VER: 18
select * from cqrlog_common.db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
SELECT * FROM cqrlog_common.bands
Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 2 -t 4532
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 2
Not started rigctld process. (Run is set FALSE)
Connected to rigctld @ localhost:4532
Radio1 CW settings:
CW init keyer type:1
Device:
Last error nr: 9
Last error desc:Bad file number
Speed: 30
CW keyer reloaded by TRControl radio1 change
Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:-m 1 -t 4533
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1
Not started rotctld process. (Run is set FALSE)
Connected to rotctld @ localhost:4533
FreqmemSql:select id,freq,mode,bandwidth,info from freqmem order by id
FreqmemNR:0=0
FreqmemFirst:0 FreqmemLast:0
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
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
Wrong image format
Sending: fmv
Please enter your call:
Local users = 108
Current spot rate is 16308 per hour
ZL2APV de SK1MMR-1 08-Nov-2022 19:59Z >
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
login:
DX de KM3T-#: 21010.0 PS7DX CW 8 dB 19 WPM CQ 1959Z
Spotter:KM3T*
Signal: 8*
*Freq: 21010.0*
call: PS7DX spotter:KM3T stren: 8 freq: 21010.0 band: 15M Lat: 39.98N Long: 76.88W
ZL2APV
Hello Graeme, this is ZL2ARN-10 in Waikanae, Kapiti Coast, New Zealand
running DXSpider V1.55 build 249
Capabilities: ve7cc
+
Welcome to the South Pacific DXSpider Cluster Network
+
+
This Cluster is running on a Raspberry Pi4, and is using
SOLAR ENERGY
+
The DXSpider User Manual can be found at:-
http://www.dxcluster.org/main/usermanual_en.html
+
Nodes: 13/408 Users [Loc/Clr]: 14/4615 Max: 25/6957 - Uptime: 29d 38m
Please enter your QTH, set/qth
Please enter your location with set/location or set/qra
Please enter your Home Node, set/homenode
ZL2APV de ZL2ARN-10 8-Nov-2022 1959Z dxspider >
pos: 48 len:48
Chat : line is cluster prompt!
Sending: fmv
DX de KM3T-#: 14032.4 KA1EFO CW 9 dB 22 WPM CQ Found - PS7DX
select id_cqrlog_main from cqrlog_main where (callsign= :callsign) and (band = :band) and (mode = :mode) and (str_to_date(concat(qsodate, ' ',time_on), '%Y-%m-%d %H:%i')) > str_to_date(:last_date_time, '%Y-%m-%d %H:%i')
Found - KA1EFO
select 1959Z
Spotter:KM3T*
Signal: 9*
*Freq: 14032.4*
call: KA1EFO spotter:KM3T stren: 9 freq: 14032.4 band: 20M Lat: 39.98N Long: 76.88W
Sending: fmv
Sending: fmv
[FORMS.PP] ExceptionOccurred
Sender=EAccessViolation
Exception=Access violation
Stack trace:
$00007F65DE3A2014
[FORMS.PP] ExceptionOccurred
Hi!
Forms.PP exception is one of errors that actually comes from GTK (graphics handler) and it is a bit hard to catch. Is your Mint a new one? Could it have GTK3 that runs GTK2 programs (like Cqrlog) in some kind of legacy mode?
What I am seeing is that you use rigctld model #2 Net Hamlib rigcld as rig. How ever there is no connection to any (outside) running rigctld as the polling "fmv" does not get any response.
Also it seems that CW keyer is defined as Winkeyer but there is no I/O port for device .
These are things that *may* cause problems. I have found source code parts where control (rig, cq key, etc.) are tried to access even when initialization has failed. I can not remember what versions have those fixes.
I suggest following:
Compile Cqrlog from GitHub source. You will get latest 2.6.0 version from there. Here are some examples how it happens:
New Ubuntu and latest cqrlog https://www.cqrlog.com/node/2984
Mint 20 Cinnamon and new cqrlog https://www.cqrlog.com/node/2998
If you do not want to compile you find a newupdate.zip that holds newupdate.sh script that can backup and update your current version of Cqrlog. From there you find also version 2.6.0. See : https://github.com/OH1KH/cqrlog/tree/loc_testing/compiled
You could also try QT5 graphics version of Cqrlog. Either by self compile or via update script. Then you need to install packages
libqt5pas1 libqt5pas-dev before trying. They may also install some dependency packages automated.
Version 2.6.0 has several fixes and you can also define rig model #1 Hamlib dummy for use if you do not have CAT connected radio.
That way you can enter used mode and frequency via TRXControl that is easier way to get right values to NewQSO for logging.
--
Saku
OH1KH