Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****

OS:
Linux version 5.13.0-35-generic (buildd@ubuntu) (gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #40~20.04.1-Ubuntu SMP Mon Mar 7 09:18:32 UTC 2022
SSL libraries:
   libssl.so
   libcrypto.so
Loaded 171036 LoTW users
Loaded 152563 eQSL users
Loaded 35417 SCP calls
*
User home directory:    /home/massimo/
Program home directory: /home/massimo/.config/cqrlog/
Data directory:         /home/massimo/.config/cqrlog/database/
Memebers directory:     /home/massimo/.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/massimo/.config/cqrlog/database/mysql.cnf
--datadir=/home/massimo/.config/cqrlog/database/
--socket=/home/massimo/.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 373 -r /dev/ttyUSB3 -t 4532  -s 19200  --set-conf=data_bits=8,stop_bits=2,serial_handshake=None
RunRigCtld: TRUE
RigDevice:  /dev/ttyUSB3
RigCtldPort:4532
RigCtldHost:localhost
RigPoll:    500
RigSendCWR: FALSE
RigId:      373

Starting RigCtld ...
rigProcess.Executable: /usr/bin/rigctld
Parameters:
-m
373
-r
/dev/ttyUSB3
-t
4532
-s
19200
--set-conf=data_bits=8,stop_bits=2,serial_handshake=None

rigctld failed to start!
1
2
3
4
5
6

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

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles