Although the .deb installer created the initial cqrlog_common and cqrlog001 dB when I went to use the launcher to open the cqrlog app it was not anywhere and although locate cqrlog said it was installed, inspecting the various folders indicated files were not installed. I downloaded the generic linux OS tarball installer rather than the .deb installer, and it etxracted but did not install in the usually expected standard linux folders. it extracted in place and creating a shortcut to that application file seems to get it running, however trying to enter qso's, or show qso lists etc seems to generate errors that warn I am risking database corruption. I have att png file and include debug=1 text details. "New Log' resulted in creation of cqrlog002 in the mariadb database.

root@cedar:/home/USERid/installs/cqrlog/cqrlog-2.4.0/usr/bin# ls
cqrlog
root@cedar:/home/USERid/installs/cqrlog/cqrlog-2.4.0/usr/bin# su USERid
USERid@cedar:~/installs/cqrlog/cqrlog-2.4.0/usr/bin$ cqrlog

Command 'cqrlog' not found, but can be installed with:

sudo apt install cqrlog

USERid@cedar:~/installs/cqrlog/cqrlog-2.4.0/usr/bin$ ls
cqrlog
USERid@cedar:~/installs/cqrlog/cqrlog-2.4.0/usr/bin$ ~/installs/cqrlog/cqrlog-2.4.0/usr/bin/cqrlog

Cqrlog Ver:2.4.0 (001) Date:2019-10-27
**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****

OS:
Linux version 5.4.0-53-lowlatency (buildd@lcy01-amd64-007) (gcc version 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04)) #59-Ubuntu SMP PREEMPT Wed Oct 21 11:21:50 UTC 2020
TApplication.HandleException TMySQL57Connection : Error executing query: Unknown database 'cqrlog000'
Stack trace:
$00000000009355DF
$0000000000936CC8
$00000000006E4E0A
$00000000006E5653
$00000000006E4CF6
$00000000004311CF
$000000000067355D
$0000000000848302
$000000000085A361
Closing ini file ...
USERid@cedar:~/installs/cqrlog/cqrlog-2.4.0/usr/bin$ ~/installs/cqrlog/cqrlog-2.4.0/usr/bin/cqrlog --debug=1

Cqrlog Ver:2.4.0 (001) Date:2019-10-27
**** DEBUG LEVEL 1 ****

OS:
Linux version 5.4.0-53-lowlatency (buildd@lcy01-amd64-007) (gcc version 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04)) #59-Ubuntu SMP PREEMPT Wed Oct 21 11:21:50 UTC 2020
SSL libraries:
libssl.so
libcrypto.so
Loaded 134350 LoTW users
Loaded 125829 eQSL users
Loaded 36919 SCP calls
*
User home directory: /home/USERid/
Program home directory: /home/USERid/.config/cqrlog/
Data directory: /home/USERid/.config/cqrlog/database/
Memebers directory: /home/USERid/.config/cqrlog/members/
ZIP code directory: /home/USERid/installs/cqrlog/cqrlog-2.4.0/usr/share/cqrlog/zipcodes/
Binary dir: /home/USERid/installs/cqrlog/cqrlog-2.4.0/usr/bin/
Share dir: /home/USERid/installs/cqrlog/cqrlog-2.4.0/usr/share/cqrlog/
*
56 us states loaded
Grid map created
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

TApplication.HandleException "" is an invalid integer
Stack trace:
$000000000046F55C
$00000000005BCA22
$00000000006E4E0A
$00000000006E5653
$00000000006E4CF6
$00000000004311CF
$000000000067355D
$0000000000848302
$000000000085A361
use cqrlog000

TApplication.HandleException TMySQL57Connection : Error executing query: Unknown database 'cqrlog000'
Stack trace:
$00000000009355DF
$0000000000936CC8
$00000000006E4E0A
$00000000006E5653
$00000000006E4CF6
$00000000004311CF
$000000000067355D
$0000000000848302
$000000000085A361
TApplication.HandleException Access violation
Stack trace:
$000000000051C0C2
$00000000006E4E0A
$00000000006E5653
$00000000006E4CF6
$00000000004311CF
$000000000067355D
$0000000000848302
$000000000085A361
select log_nr from cqrlog_common.log_list order by log_nr

select log_nr from cqrlog_common.log_list where log_nr = 1

CREATE DATABASE IF NOT EXISTS cqrlog001 DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_bin;

use cqrlog001;

CREATE TABLE cqrlog_main (
id_cqrlog_main INT AUTO_INCREMENT PRIMARY KEY,
qsodate DATE NOT NULL,
time_on VARCHAR(5) NOT NULL,
time_off VARCHAR(5) DEFAULT '',
callsign VARCHAR(20) NOT NULL,
freq NUMERIC(10,4) NOT NULL,
mode VARCHAR(12) NOT NULL,
rst_s VARCHAR(20) DEFAULT '',
rst_r VARCHAR(20) DEFAULT '',
name VARCHAR(40) DEFAULT '',
qth VARCHAR(60) DEFAULT '',
qsl_s VARCHAR(4) DEFAULT '',
qsl_r VARCHAR(3) DEFAULT '',
qsl_via VARCHAR(30) DEFAULT '',
iota VARCHAR(6) DEFAULT '',
pwr VARCHAR(10) DEFAULT '',
itu INT DEFAULT 0,
waz INT DEFAULT 0,
loc VARCHAR(10) DEFAULT '',
my_loc VARCHAR(10) DEFAULT '',
county VARCHAR(30) DEFAULT '',
award VARCHAR(50) DEFAULT '',
remarks VARCHAR(200) DEFAULT '',
adif INTEGER DEFAULT 0,
/*dxcc_ref VARCHAR(20) DEFAULT '',*/
band VARCHAR(6) DEFAULT '',
qso_dxcc INT DEFAULT 0,
profile INT DEFAULT 0,
idcall VARCHAR(20) DEFAULT '',
state VARCHAR(4) DEFAULT '',
lotw_qslsdate DATE,
lotw_qslrdate DATE,
lotw_qsls VARCHAR(3) DEFAULT '' not null,
lotw_qslr VARCHAR(3) DEFAULT '' not null,
cont VARCHAR(3) DEFAULT '',
qsls_date VARCHAR(10),
qslr_date VARCHAR(10),
club_nr1 VARCHAR(100) DEFAULT '',
club_nr2 VARCHAR(100) DEFAULT '',
club_nr3 VARCHAR(100) DEFAULT '',
club_nr4 VARCHAR(100) DEFAULT '',
club_nr5 VARCHAR(100) DEFAULT '',
eqsl_qsl_sent varchar(1) default '' not null,
eqsl_qslsdate date default null,
eqsl_qsl_rcvd varchar(1) default '' not null,
eqsl_qslrdate date default null,
rxfreq NUMERIC(10,4) NULL,
satellite VARCHAR(30) DEFAULT '',
prop_mode VARCHAR(30) DEFAULT '',
contestname VARCHAR(40) NULL,
stx VARCHAR(6) NULL,
srx VARCHAR(6) NULL,
stx_string VARCHAR(50) NULL,
srx_string VARCHAR(50) NULL
);

TApplication.HandleException TMySQL57Connection : Error executing query: Table 'cqrlog_main' already exists
Stack trace:
$00000000009355DF
$0000000000936CC8
$00000000006E4E0A
$00000000006E5653
$00000000006E4CF6
$00000000004311CF
$000000000067355D
$0000000000848302
$000000000085A361
select log_nr from cqrlog_common.log_list order by log_nr

select log_nr from cqrlog_common.log_list where log_nr = 2

CREATE DATABASE IF NOT EXISTS cqrlog002 DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_bin;

use cqrlog002;

CREATE TABLE cqrlog_main (
id_cqrlog_main INT AUTO_INCREMENT PRIMARY KEY,
qsodate DATE NOT NULL,
time_on VARCHAR(5) NOT NULL,
time_off VARCHAR(5) DEFAULT '',
callsign VARCHAR(20) NOT NULL,
freq NUMERIC(10,4) NOT NULL,
mode VARCHAR(12) NOT NULL,
rst_s VARCHAR(20) DEFAULT '',
rst_r VARCHAR(20) DEFAULT '',
name VARCHAR(40) DEFAULT '',
qth VARCHAR(60) DEFAULT '',
qsl_s VARCHAR(4) DEFAULT '',
qsl_r VARCHAR(3) DEFAULT '',
qsl_via VARCHAR(30) DEFAULT '',
iota VARCHAR(6) DEFAULT '',
pwr VARCHAR(10) DEFAULT '',
itu INT DEFAULT 0,
waz INT DEFAULT 0,
loc VARCHAR(10) DEFAULT '',
my_loc VARCHAR(10) DEFAULT '',
county VARCHAR(30) DEFAULT '',
award VARCHAR(50) DEFAULT '',
remarks VARCHAR(200) DEFAULT '',
adif INTEGER DEFAULT 0,
/*dxcc_ref VARCHAR(20) DEFAULT '',*/
band VARCHAR(6) DEFAULT '',
qso_dxcc INT DEFAULT 0,
profile INT DEFAULT 0,
idcall VARCHAR(20) DEFAULT '',
state VARCHAR(4) DEFAULT '',
lotw_qslsdate DATE,
lotw_qslrdate DATE,
lotw_qsls VARCHAR(3) DEFAULT '' not null,
lotw_qslr VARCHAR(3) DEFAULT '' not null,
cont VARCHAR(3) DEFAULT '',
qsls_date VARCHAR(10),
qslr_date VARCHAR(10),
club_nr1 VARCHAR(100) DEFAULT '',
club_nr2 VARCHAR(100) DEFAULT '',
club_nr3 VARCHAR(100) DEFAULT '',
club_nr4 VARCHAR(100) DEFAULT '',
club_nr5 VARCHAR(100) DEFAULT '',
eqsl_qsl_sent varchar(1) default '' not null,
eqsl_qslsdate date default null,
eqsl_qsl_rcvd varchar(1) default '' not null,
eqsl_qslrdate date default null,
rxfreq NUMERIC(10,4) NULL,
satellite VARCHAR(30) DEFAULT '',
prop_mode VARCHAR(30) DEFAULT '',
contestname VARCHAR(40) NULL,
stx VARCHAR(6) NULL,
srx VARCHAR(6) NULL,
stx_string VARCHAR(50) NULL,
srx_string VARCHAR(50) NULL
);

CREATE INDEX main_index ON cqrlog_main(qsodate DESC,time_on DESC);

CREATE INDEX callsign ON cqrlog_main(callsign);

CREATE INDEX name ON cqrlog_main(name);

CREATE INDEX qth ON cqrlog_main(QTH);

CREATE INDEX adif ON cqrlog_main(adif);

CREATE INDEX idcall ON cqrlog_main(idcall);

CREATE INDEX band ON cqrlog_main(band);

CREATE INDEX club_nr1 ON cqrlog_main(club_nr1);

CREATE INDEX club_nr2 ON cqrlog_main(club_nr2);

CREATE INDEX club_nr3 ON cqrlog_main(club_nr3);

CREATE INDEX club_nr4 ON cqrlog_main(club_nr4);

CREATE INDEX club_nr5 ON cqrlog_main(club_nr5);

CREATE TABLE notes(
id_notes INT AUTO_INCREMENT PRIMARY KEY,
callsign VARCHAR(20) DEFAULT '',
longremarks VARCHAR(256) DEFAULT ''
);

CREATE INDEX callsign ON notes(callsign);

CREATE TABLE profiles (
id_profiles INT AUTO_INCREMENT PRIMARY KEY,
nr INT NOT NULL,
locator VARCHAR(6) DEFAULT '',
qth VARCHAR(250) DEFAULT '',
rig VARCHAR(250) DEFAULT '',
remarks VARCHAR(250) DEFAULT '',
visible INT DEFAULT 1
);

CREATE INDEX nr ON profiles(nr);

CREATE TABLE long_note (
id_long_note INT AUTO_INCREMENT PRIMARY KEY,
note LONGTEXT
);

CREATE TABLE version (
major INTEGER DEFAULT 0,
minor INTEGER DEFAULT 9,
releas INTEGER DEFAULT 4
);

CREATE TABLE club1 (
id_club1 INT AUTO_INCREMENT PRIMARY KEY,
club_nr VARCHAR(100) DEFAULT '',
clubcall VARCHAR(100) DEFAULT '',
fromdate DATE,
todate DATE
);

CREATE INDEX club_nr ON club1(club_nr);

CREATE INDEX fromdate ON club1(fromdate);

CREATE INDEX todate ON club1(todate);

CREATE INDEX clubcall ON club1(clubcall);

CREATE TABLE club2 (
id_club2 INT AUTO_INCREMENT PRIMARY KEY,
club_nr VARCHAR(100) DEFAULT '',
clubcall VARCHAR(100) DEFAULT '',
fromdate DATE,
todate DATE
);

CREATE INDEX club_nr ON club2(club_nr);

CREATE INDEX fromdate ON club2(fromdate);

CREATE INDEX todate ON club2(todate);

CREATE INDEX clubcall ON club2(clubcall);

CREATE TABLE club3 (
id_club3 INT AUTO_INCREMENT PRIMARY KEY,
club_nr VARCHAR(100) DEFAULT '',
clubcall VARCHAR(100) DEFAULT '',
fromdate DATE,
todate DATE
);

CREATE INDEX club_nr ON club3(club_nr);

CREATE INDEX fromdate ON club3(fromdate);

CREATE INDEX todate ON club3(todate);

CREATE INDEX clubcall ON club3(clubcall);

CREATE TABLE club4 (
id_club4 INT AUTO_INCREMENT PRIMARY KEY,
club_nr VARCHAR(100) DEFAULT '',
clubcall VARCHAR(100) DEFAULT '',
fromdate DATE,
todate DATE
);

CREATE INDEX club_nr ON club4(club_nr);

CREATE INDEX fromdate ON club4(fromdate);

CREATE INDEX todate ON club4(todate);

CREATE INDEX clubcall ON club4(clubcall);

CREATE TABLE club5 (
id_club5 INT AUTO_INCREMENT PRIMARY KEY,
club_nr VARCHAR(100) DEFAULT '',
clubcall VARCHAR(100) DEFAULT '',
fromdate DATE,
todate DATE
);

CREATE INDEX club_nr ON club5(club_nr);

CREATE INDEX fromdate ON club5(fromdate);

CREATE INDEX todate ON club5(todate);

CREATE INDEX clubcall ON club5(clubcall);

CREATE TABLE zipcode1 (
id_zipcode1 INT AUTO_INCREMENT PRIMARY KEY,
zip VARCHAR(20) DEFAULT '',
county VARCHAR(100) DEFAULT ''
);

CREATE INDEX zip ON zipcode1(zip);

CREATE TABLE zipcode2 (
id_zipcode2 INT AUTO_INCREMENT PRIMARY KEY,
zip VARCHAR(20) DEFAULT '',
county VARCHAR(100) DEFAULT ''
);

CREATE INDEX zip ON zipcode2(zip);

CREATE TABLE zipcode3 (
id_zipcode3 INT AUTO_INCREMENT PRIMARY KEY,
zip VARCHAR(20) DEFAULT '',
county VARCHAR(100) DEFAULT ''
);

CREATE INDEX zip ON zipcode3(zip);

CREATE TABLE cqrlog_config (
id_cqrlog__config INT AUTO_INCREMENT PRIMARY KEY,
config_file LONGTEXT
);

INSERT INTO cqrlog_config (config_file) VALUES ('');

CREATE TABLE dxcc_id
(
id_dxcc INT AUTO_INCREMENT PRIMARY KEY,
adif INT DEFAULT 0,
dxcc_ref VARCHAR(16) NOT NULL,
country VARCHAR(100) NOT NULL
);

CREATE INDEX adif ON dxcc_id(adif);

CREATE TABLE db_version
(
nr SMALLINT NOT NULL
);

CREATE TABLE log_changes (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
id_cqrlog_main int(11) NULL,
cmd varchar(20) NOT NULL,
qsodate date NULL,
time_on varchar(5) NULL,
callsign varchar(20) NULL,
mode varchar(12) NULL,
band varchar(6) NULL,
freq numeric(10,4) NULL,
old_qsodate date NULL,
old_time_on varchar(5) NULL,
old_callsign varchar(20) NULL,
old_mode varchar(12) NULL,
old_band varchar(6) NULL,
old_freq numeric(10,4) NULL,
upddeleted int(1) default 1
) COLLATE 'utf8_bin';

ALTER TABLE log_changes
ADD INDEX id_cqrlog_main (id_cqrlog_main);

ALTER TABLE log_changes
ADD FOREIGN KEY (id_cqrlog_main) REFERENCES cqrlog_main (id_cqrlog_main) ON DELETE SET NULL ON UPDATE CASCADE;

CREATE TABLE upload_status (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
logname varchar(30) NOT NULL,
id_log_changes int(11) NULL,
FOREIGN KEY (id_log_changes) REFERENCES log_changes (id) ON DELETE SET NULL
) COLLATE 'utf8_bin';

CREATE TABLE call_alert (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
callsign varchar(20) NOT NULL,
band varchar(6) NULL,
mode varchar(12) NULL
) COLLATE 'utf8_bin';

ALTER TABLE call_alert ADD INDEX (id);

ALTER TABLE call_alert ADD INDEX (callsign);

CREATE TABLE freqmem (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
freq numeric(10,4) NOT NULL,
mode varchar(12) NOT NULL,
bandwidth int NOT NULL,
info varchar(25) NULL
) COLLATE 'utf8_bin';

CREATE VIEW view_cqrlog_main_by_qsodate AS SELECT id_cqrlog_main,qsodate,time_on,time_off,callsign, freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,
award,remarks, band, dxcc_id.dxcc_ref AS dxcc_ref ,qso_dxcc, profile,idcall, state, lotw_qslsdate, lotw_qslrdate,lotw_qsls, lotw_qslr, cont, qsls_date,qslr_date,club_nr1,club_nr2,club_nr3,
club_nr4, club_nr5, eqsl_qsl_sent, eqsl_qslsdate, eqsl_qsl_rcvd,eqsl_qslrdate,concat(qsl_r,lotw_qslr,eqsl_qsl_rcvd) as qslr,dxcc_id.country, rxfreq, satellite, prop_mode, srx, stx, srx_string, stx_string, contestname FROM cqrlog_main JOIN dxcc_id ON dxcc_id.adif = cqrlog_main.adif order by qsodate DESC, time_on DESC;

CREATE VIEW view_cqrlog_main_by_qsodate_asc AS SELECT id_cqrlog_main,qsodate,time_on,time_off,callsign, freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,
award,remarks, band, dxcc_id.dxcc_ref AS dxcc_ref ,qso_dxcc, profile,idcall, state, lotw_qslsdate, lotw_qslrdate,lotw_qsls, lotw_qslr, cont, qsls_date,qslr_date,club_nr1,club_nr2,club_nr3,
club_nr4,club_nr5,eqsl_qsl_sent,eqsl_qslsdate,eqsl_qsl_rcvd,eqsl_qslrdate,concat(qsl_r,lotw_qslr,eqsl_qsl_rcvd) as qslr,dxcc_id.country, rxfreq, satellite, prop_mode, srx, stx, srx_string, stx_string, contestname FROM cqrlog_main JOIN dxcc_id ON dxcc_id.adif = cqrlog_main.adif order by qsodate ASC, time_on ASC;

CREATE VIEW view_cqrlog_main_by_callsign AS SELECT id_cqrlog_main,qsodate,time_on,time_off,callsign, freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,
award,remarks, band, dxcc_id.dxcc_ref AS dxcc_ref ,qso_dxcc, profile,idcall, state, lotw_qslsdate, lotw_qslrdate,lotw_qsls, lotw_qslr, cont, qsls_date,qslr_date,club_nr1,club_nr2,club_nr3,
club_nr4,club_nr5,eqsl_qsl_sent,eqsl_qslsdate,eqsl_qsl_rcvd,eqsl_qslrdate,concat(qsl_r,lotw_qslr,eqsl_qsl_rcvd) as qslr,dxcc_id.country, rxfreq, satellite, prop_mode, srx, stx, srx_string, stx_string, contestname FROM cqrlog_main JOIN dxcc_id ON dxcc_id.adif = cqrlog_main.adif order by callsign;

insert into db_version (nr) values(16)

insert into cqrlog_common.log_list (log_nr,log_name) values (2,'cqrlog002')

insert into log_changes (id,cmd) values(1,'ALLDONE')

insert into upload_status (logname, id_log_changes) values ('HamQTH',1)

insert into upload_status (logname, id_log_changes) values ('ClubLog',1)

insert into upload_status (logname, id_log_changes) values ('HRDLog',1)

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

TApplication.HandleException Access violation
Stack trace:
$000000000051C0C2
$00000000006E4E0A
$00000000006E5653
$00000000006E4CF6
$00000000004311CF
$000000000067355D
$0000000000848302
$000000000085A361
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: cqrlog.cfg
Closing dData
Closing ini file ...
USERid@cedar:~/installs/cqrlog/cqrlog-2.4.0/usr/bin$