LOTW signing adif file not working after upgrade to Kubuntu 20.04

10 posts / 0 new
Last post
KX4FZ
LOTW signing adif file not working after upgrade to Kubuntu 20.04

I have searched this forum to see if anyone else has had this problem.

Last week I upgraded from Kubuntu 18.04 to Kubuntu 20.04. This was an UPGRADE, not a clean install. Now I cannot sign an adif file to upload to LOTW. When I attempt to do so, I get the following error message:

Starting export to adif ...
Export to the adif file completed.
File:
/home/kx4fz/.config/cqrlog/lotw/2020-10-12_10-39-20.adi
Signing adif file ...
/usr/bin/tqsl: error while loading shared libraries: libwx_gtk2u_core-3.0.so.0: cannot open shared object file: No such file or directory

Kubuntu 20.04 does not have libwx_gtk2 libraries in the repository, it has libwxgtk3.0-gtk3-0v5. The Kubuntu 20.04 Release Notes say that
"All KDE4 and Qt4 libraries and applications have been removed from the 20.04 archive, and are therefore not supported".

I have verified that the TQSL app (v. 2.5.5) is working. I used it to sign and upload the adif file that cqrlog created.

Thanks for any help you can give me.

73
Terry, KX4FZ

oh1kh
LOTW signing adif file not working after upgrade to Kubuntu 20.

Hi Terry!

It seems that upgrading has removed gtk2 and replaced it with gtk3. Either completely or partially.

The release notes how ever talk about QT4 and KDE4, so could it be possible still install wx_gtk2 again ?
It is either called gtk2 or wx_gtk2.
Try to install it and see if that helps.

Stepping to GTK3 is going to cause problems for cqrlog as Lazarus/FPC, that is the programming tool, has still broken support for GTK3 and all cqrlog packages are now compiled with GTK2 support.

Cqrlog can be compiled for QT5 and it works 99,9%, At the moment only known fault with QT5 is Grayline map's connection to rbn.
Running with QT5 needs one more package libQT5pas install. QT5 will be the future for cqrlog but at the moment official cqrlog can only be found as self compiled for QT5

You may read this readme: https://github.com/OH1KH/cqrlog/tree/loc_testing/compiled

--
Saku
OH1KH

KX4FZ
Hello Saku,

Hello Saku,

Thank you for your reply. I believe that the upgrade has replaced gtk2. I cannot find the necessary gtk2 library file in the Synaptic Package Manager.

I decided to try the cqr5.zip (the QT5 version), as I do not use the grayline map. I followed your instructions closely (including making backups) but I am getting database access violation errors.

Here is the debug trace:

cqrlog --debug=1

Cqrlog Ver:2.4.0 (126) Date:2020-09-01
**** DEBUG LEVEL 1 ****

OS:
Linux version 5.4.0-48-generic (buildd@lcy01-amd64-010) (gcc version 9.3.0 (Ubuntu 9.3.0-10ubuntu2)) #52-Ubuntu SMP Thu Sep 10 10:58:49 UTC 2020
SSL libraries:
libssl.so
libcrypto.so
Loaded 148591 LoTW users
Loaded 135899 eQSL users
Loaded 34579 SCP calls
*
User home directory: /home/kx4fz/
Program home directory: /home/kx4fz/.config/cqrlog/
Data directory: /home/kx4fz/.config/cqrlog/database/
Memebers directory: /home/kx4fz/.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/kx4fz/.config/cqrlog/database/mysql.cnf
--datadir=/home/kx4fz/.config/cqrlog/database/
--socket=/home/kx4fz/.config/cqrlog/database/sock
--port=64000

Trying to connect to database
2020-10-13 11:19:48 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-1ubuntu1) starting as process 2404 ...
TMySQL57Connection : Server connect failed.
Trying:1
Loading login
Load values set local
/home/kx4fz/.config/cqrlog/database/TERRYSPC7.pid
saving login
saving as local
saving login
saving as local
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

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: 17
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

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

SaveForm: frmMain
Section:frmMain
Saving window size a position (frmMain) (height|width|top|left):1015|1020|0|0
Closing QSO list window
SELECT COUNT(*) FROM cqrlog_main

select * from profiles order by nr

SELECT * FROM view_cqrlog_main_by_qsodate

AProcess.Executable: tar Parameters: -cvzf
KX4FZ_backup.tar.gz
KX4FZ_backup.adi

KX4FZ_backup.adi
Closing rigs...
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):709|997|147|923
AProcess.Executable: killall Parameters: xplanet

select count(*) from cqrlog001.cqrlog_config

Saving ini file to database
select count(*) from cqrlog001.cqrlog_config

Saving ini file to database
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: 1cqrlog.cfg
Deleting config file: cqrlog.cfg
Closing dData
/home/kx4fz/.config/cqrlog/database/TERRYSPC7.pid
p.Executable: kill Parameters: 2404

[FORMS.PP] ExceptionOccurred
Sender=EAccessViolation
Exception=Access violation
Stack trace:
$00000000008D12BA
$0000000000778DA8
$0000000000772F9F
$0000000000772F89
$0000000000772F89
$0000000000772F89
$0000000000775DEC
$000000000078B361
$000000000044CD01
$000000000044E691
$00000000004A158D
$0000000000788901
$0000000000775F56
$000000000078B361
$000000000044CD01
$000000000044E691
$00000000004365C0
Exception at 00000000008D12BA: EAccessViolation:
Access violation.
Closing ini file ...
kx4fz@TERRYSPC7:~$

And this is the end of the mysql.err file:

2020-10-13 11:19:48 0 [Note] InnoDB: Using Linux native AIO
2020-10-13 11:19:48 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-13 11:19:48 0 [Note] InnoDB: Uses event mutexes
2020-10-13 11:19:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-13 11:19:48 0 [Note] InnoDB: Number of pools: 1
2020-10-13 11:19:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-10-13 11:19:48 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2020-10-13 11:19:48 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-13 11:19:48 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-13 11:19:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-10-13 11:19:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-13 11:19:48 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-13 11:19:48 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-13 11:19:48 0 [Note] InnoDB: Waiting for purge to start
2020-10-13 11:19:48 0 [Note] InnoDB: 10.3.22 started; log sequence number 555516385; transaction id 527770
2020-10-13 11:19:48 0 [Note] InnoDB: Loading buffer pool(s) from /home/kx4fz/.config/cqrlog/database/ib_buffer_pool
2020-10-13 11:19:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-10-13 11:19:48 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2020-10-13 11:19:48 0 [Note] Server socket created on IP: '::'.
2020-10-13 11:19:48 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2020-10-13 11:19:48 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2020-10-13 11:19:49 0 [Note] Reading of all Master_info entries succeeded
2020-10-13 11:19:49 0 [Note] Added new Master_info '' to hash table
2020-10-13 11:19:49 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.22-MariaDB-1ubuntu1' socket: '/home/kx4fz/.config/cqrlog/database/sock' port: 64000 Ubuntu 20.04
2020-10-13 11:19:49 0 [Note] InnoDB: Buffer pool(s) load completed at 201013 11:19:49
2020-10-13 11:19:52 9 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2020-10-13 13:04:36 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2020-10-13 13:04:36 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-13 13:04:36 0 [Note] InnoDB: Starting shutdown...
2020-10-13 13:04:36 0 [Note] InnoDB: Dumping buffer pool(s) to /home/kx4fz/.config/cqrlog/database/ib_buffer_pool
2020-10-13 13:04:36 0 [Note] InnoDB: Buffer pool(s) dump completed at 201013 13:04:36
2020-10-13 13:04:38 0 [Note] InnoDB: Shutdown completed; log sequence number 555622016; transaction id 527781
2020-10-13 13:04:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-13 13:04:38 0 [Note] /usr/sbin/mysqld: Shutdown complete

I hope this information gives you clues to my problem.

Thanks again,

73,
Terry, KX4FZ

KX4FZ, Terry

oh1kh
LOTW signing adif file not working after upgrade to Kubuntu 20.0

Hi Terry!

I think this is because cqrlog is compiled with Fedora32. There has been indications of this also before.

It would be best if you compile your own QT5 version. I have just added a message telling how I did it with Mint 20
https://www.cqrlog.com/node/2998
Try to follow that. It should not be too difficult and you have now backups done.

--
Saku
OH1KH

KX4FZ
LOTW signing adif file not working after upgrade to Kubuntu 20.0

Hi Saku,

I am sorry, I got busy for a couple days and did not get back to this forum.

You were correct about recompiling my QT5 version with Kubuntu. The database access violation problem is fixed.

However, the original problem ( see my original post ) still exists.

I checked the date of my /usr/bin/cqrlog file and it is correct ( the date I re-compiled ). Also, I tried to connect to the RBN server and could not connect, so I am using the QT5 libraries.

Any ideas on what I should try next?

73,

Terry
KX4FZ

KX4FZ, Terry

KX4FZ
LOTW signing adif file not working after upgrade to Kubuntu 20.0

Saku,

I was examining the source code to see if I could find anything that referenced the gtk2 libraries and I found this in the cqrlog.lpi

Should any of these lines be change to use the QT5 libraries??

Terry
KX4FZ

KX4FZ, Terry

oh1kh
LOTW signing adif file not working after upgrade to Kubuntu 20.0

HI Terry!

Open Lazarus IDE (from start menu or console command: lazarus-ide) and with "Open project" navigate to src directory of the source and select from there cqrlog.lpi
Once it is open select Project/Project Options ( or Ctrl+Shift+F11).
From there select Additions and Overrides.
From top of right side select Set "LCLWidgetType"
Select Value "qt5" from the list. Targets should now show only IDE Macro LCLWidgetType = qt5 selected
Close from OK button
Select View/Messages (if not already shown)
Select Run/Clean up and Build
Press button Clean up and Build
Press Skip errors if you get error popup
Once compile finishes (Messages show a green line) you will find file (with fresh date and time) "cqrlog" from folder src
copy that to /usr/bin
sudo cp src/cqrlog /usr/bin

That way you can be sure everything is selected for qt5

--
Saku
OH1KH

oh1kh
LOTW signing adif file not working after upgrade to Kubuntu 20.0

Hi !

You may find also these useful. It seems that package cqrlog2.4.0-3 carries gtk2 libraries inside.

https://askubuntu.com/questions/279712/how-to-add-ubuntu-repositories-on...
https://packages.ubuntu.com/focal/cqrlog

--
Saku
OH1KH

KX4FZ
LOTW signing adif file not working after upgrade to Kubuntu 20.0

Hi Saku,

I tried both of your suggestions above ( post #7 and post #8 ). In both cases, I am still getting the same error about the missing gtk2.0 library when I try to sign a file to upload to LOTW.

I am about ready to switch to Ubuntu 20.04 if you do not have any other suggestions for me to try. Please let me know if you have any other ideas to try.

Thanks & 73,
Terry
KX4FZ

KX4FZ, Terry

oh1kh
LOTW signing adif file not working after upgrade to Kubuntu 20.0

Hi Terry !

Sorry but no better ideas. It is a bit hard when not seen and tested your setup by myself.
Maybe switch to another distribution helps. I hope so.

--
Saku
OH1KH