Hello all,
I have problems after migration to Ubuntu 22.04 - CQRLOG is hanging. Looks like ther is a problem with the MariaDB connect: "TMySQL57Connection : Server connect failed".
Reinstalled MariaDB (v10.6.7) and CQRLOG.
Any ideas?
Thanks and 73 de SVen, DL2NEW
sven@nuc6i5-sven:~$ cqrlog --debug=1
(cqrlog:1461123): GLib-GObject-WARNING **: 13:03:18.521: ../../../gobject/gsignal.c:2613: signal 'populate-popup' is invalid for instance '0x270bdf0' of type 'GtkCellView'
(cqrlog:1461123): GLib-GObject-WARNING **: 13:03:18.521: ../../../gobject/gsignal.c:2613: signal 'populate-popup' is invalid for instance '0x2718220' of type 'GtkCellView'
Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****
OS:
Linux version 5.15.0-27-generic (buildd@ubuntu) (gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #28-Ubuntu SMP Thu Apr 14 04:55:28 UTC 2022
SSL libraries:
libssl.so
libcrypto.so
Loaded 172537 LoTW users
Loaded 153661 eQSL users
Loaded 40941 SCP calls
/home/sven/.config/cqrlog/database/nuc6i5-sven.pid
p.Executable: kill Parameters: 1454874
*
User home directory: /home/sven/
Program home directory: /home/sven/.config/cqrlog/
Data directory: /home/sven/.config/cqrlog/database/
Memebers directory: /home/sven/.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/sven/.config/cqrlog/database/mysql.cnf
--datadir=/home/sven/.config/cqrlog/database/
--socket=/home/sven/.config/cqrlog/database/sock
--port=64000
Trying to connect to database
2022-04-30 13:03:23 0 [Note] /usr/sbin/mysqld (server 10.6.7-MariaDB-2ubuntu1) starting as process 1461145 ...
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 2029 -r /dev/ttyUSB0 -t 4532 -s 38400 --set-conf=data_bits=8,stop_bits=1,serial_parity=None
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 2029
Starting RigCtld ...
rigProcess.Executable: /usr/bin/rigctld
Parameters:
-m
2029
-r
/dev/ttyUSB0
-t
4532
-s
38400
--set-conf=data_bits=8,stop_bits=1,serial_parity=None
rigctld started!
Connected to rigctld @ localhost:4532
Radio1 CW settings:
CW init keyer type:0
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=3
FreqmemNR:1=4
FreqmemNR:2=5
FreqmemNR:3=6
FreqmemNR:4=7
FreqmemNR:5=8
FreqmemNR:6=9
FreqmemNR:7=10
FreqmemNR:8=11
FreqmemNR:9=12
FreqmemNR:10=13
FreqmemNR:11=14
FreqmemFirst:3 FreqmemLast:14
Sending: fmv
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
Msg from rig: 7004680
CW
500
VFOA
[FORMS.PP] ExceptionOccurred
Sender=EAccessViolation
Exception=Access violation
Stack trace:
$00007F1CCB01D014
[FORMS.PP] ExceptionOccurred
Killed
Hi Sven!
The database startup looks normal. There is no database problem seen in your debug dump.
Seems that your databases are upgraded in start. Maybe the error lays there.
What happens if you move your /home/sven/.config/cqrlog folder to /home/sven/.config/cqrlogSAVE
console command:
mv /home/sven/.config/cqrlog /home/sven/.config/cqrlogSAVE
Then start Cqrlog and it claims you have never used it before. Let it crate a nev log and try to use that for few fake qsos.
Does it work, or do you get same kind of error also then?
--
Saku
OH1KH
Hi Saku,
thanks for the hint. It works.
73 de Sven, DL2NEW
I had the same issue, and tried running as described above, and all worked properly with a fresh log. However, I could not get it to work with my master log file. Somewhere in the back of my mind, I remembered something else I read here that might provide a solution short of recompiling from scratch. There was a "newupdate" script provided. I dug around and found it here:
https://www.cqrlog.com/comment/10150#comment-10150
Following those instructions allowed me to update to the newest Alpha release (122), and that corrected the issues I was having. Now everything works as it should. Might work for others as well.
73,
Dave, N1KX
I have encountered the same issue and thanks for sharing the instruction I have fix the issue. pool replastering Longwood