Problems after migration to Ubuntu 22.04 - issue with MariaDB?

5 posts / 0 new
Last post
dl2new
Problems after migration to Ubuntu 22.04 - issue with MariaDB?

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

oh1kh
Problems after migration to Ubuntu 22.04 - issue with MariaDB?

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

dl2new
Problems after migration to Ubuntu 22.04 - issue with MariaDB?

Hi Saku,
thanks for the hint. It works.
73 de Sven, DL2NEW

n1kx
I had the same issue, and

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

JensonJones (not verified)
I have encountered the same

I have encountered the same issue and thanks for sharing the instruction I have fix the issue. pool replastering Longwood