Cqrlog Ver:2.4.0 (001) Date:2019-11-09 **** DEBUG LEVEL 1 **** OS: Linux version 5.4.0-51-generic (buildd@lgw01-amd64-030) (gcc version 7.5.0 (Ubuntu 7.5.0-3ubuntu1~18.04)) #56~18.04.1-Ubuntu SMP Tue Oct 6 09:47:18 UTC 2020 SSL libraries: libssl.so libcrypto.so Loaded 148591 LoTW users Loaded 135899 eQSL users Loaded 34579 SCP calls * User home directory: /home/slaveckm/ Program home directory: /home/slaveckm/.config/cqrlog/ Data directory: /home/slaveckm/.config/cqrlog/database/ Memebers directory: /home/slaveckm/.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/slaveckm/.config/cqrlog/database/mysql.cnf --datadir=/home/slaveckm/.config/cqrlog/database/ --socket=/home/slaveckm/.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 127 -r /dev/serial/by-id/usb-FTDI_FT232R_USB_UART_A13F75A2-if00-port0 -t 4532 -s 38400 --set-conf=data_bits=8,stop_bits=2,serial_handshake=None,dtr_state=OFF,rts_state=OFF RunRigCtld: TRUE RigDevice: /dev/serial/by-id/usb-FTDI_FT232R_USB_UART_A13F75A2-if00-port0 RigCtldPort:4532 RigCtldHost:localhost RigPoll: 500 RigSendCWR: FALSE RigId: 127 Starting RigCtld ... rigProcess.Executable: /usr/bin/rigctld Parameters: -m 127 -r /dev/serial/by-id/usb-FTDI_FT232R_USB_UART_A13F75A2-if00-port0 -t 4532 -s 38400 --set-conf=data_bits=8,stop_bits=2,serial_handshake=None,dtr_state=OFF,rts_state=OFF rigctld started! Connected to rigctld @ localhost:4532 Radio1 CW settings: CW init keyer type:1 Device: /dev/serial/by-id/usb-FTDI_FT230X_Basic_UART_DN04KJ7J-if00-port0 Last error nr: 0 Last error desc:OK After sending null command After sending echo command: 20 Firmware version: 31 Speed: 0 Speed: 18 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=0 FreqmemFirst:0 FreqmemLast:0 Sending: fmv WinKeyer closed Radio1 CW settings: CW init keyer type:1 Device: /dev/serial/by-id/usb-FTDI_FT230X_Basic_UART_DN04KJ7J-if00-port0 Last error nr: 0 Last error desc:OK After sending null command After sending echo command: 20 Firmware version: 31 Speed: 0 Speed: 18 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 Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv 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 my_loc,loc FROM cqrlog_main SELECT COUNT(DISTINCT(LEFT(loc,4))) FROM cqrlog_main WHERE left(loc,4) <> "" Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv DROP TRIGGER IF EXISTS cqrlog_main_bd DROP TRIGGER IF EXISTS cqrlog_main_ai DROP TRIGGER IF EXISTS cqrlog_main_bu update cqrlog_main q left join club3 c on q.idcall= c.clubcall and c.fromdate <= q.qsodate and c.todate >= q.qsodate set q.club_nr3 = c.club_nr where qsodate >= '2019-01-25' update cqrlog_main q left join club3 c on q.idcall= c.clubcall and c.fromdate <= q.qsodate and c.todate >= q.qsodate set award='TRC' where qsodate >= '2019-01-25' and award='' Sending: fmv CREATE TRIGGER `cqrlog_main_ai` AFTER INSERT ON `cqrlog_main` FOR EACH ROW insert into log_changes(id_cqrlog_main,cmd,qsodate,time_on,callsign,mode,freq,band) values (NEW.id_cqrlog_main,'INSERT',NEW.qsodate,NEW.time_on,NEW.callsign,NEW.mode,NEW.freq,NEW.band); CREATE TRIGGER `cqrlog_main_bd` BEFORE DELETE ON `cqrlog_main` FOR EACH ROW insert into log_changes(id_cqrlog_main,cmd,old_qsodate, old_time_on, old_callsign, old_mode, old_band,old_freq) values (OLD.id_cqrlog_main,'DELETE',OLD.qsodate, OLD.time_on, OLD.callsign, OLD.mode, OLD.band, OLD.freq); CREATE TRIGGER `cqrlog_main_bu` BEFORE UPDATE ON `cqrlog_main` FOR EACH ROW insert into log_changes(id_cqrlog_main,cmd,old_qsodate, old_time_on, old_callsign, old_mode, old_band,old_freq, qsodate, time_on, callsign, mode, band,freq) values (OLD.id_cqrlog_main,'UPDATE',OLD.qsodate, OLD.time_on, OLD.callsign, OLD.mode, OLD.band,OLD.freq, NEW.qsodate, NEW.time_on, NEW.callsign, NEW.mode, NEW.band, NEW.freq); Sending: fmv Sending: fmv Sending: fmv Section:frmRebuildMembStat Saving window size a position (frmRebuildMembStat) (height|width|top|left):269|515|248|426 Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv SELECT COUNT(*) FROM cqrlog_main select id_cqrlog_main,qsodate,callsign,adif,qso_dxcc from cqrlog_main Sending: fmv Sending: fmv Sending: fmv select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0 Sending: fmv select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 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 my_loc,loc FROM cqrlog_main SELECT COUNT(DISTINCT(LEFT(loc,4))) FROM cqrlog_main WHERE left(loc,4) <> "" Sending: fmv 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 my_loc,loc FROM cqrlog_main SELECT COUNT(DISTINCT(LEFT(loc,4))) FROM cqrlog_main WHERE left(loc,4) <> "" Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv SaveForm: frmMain Section:frmMain Saving window size a position (frmMain) (height|width|top|left):713|1366|27|0 Closing QSO list window Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv SELECT COUNT(*) FROM cqrlog_main select * from profiles orEI6KW_backup.adi der by nr SELECT * FROM view_cqrlog_main_by_qsodate Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv AProcess.Executable: tar Parameters: -cvzf EI6KW_backup.tar.gz EI6KW_backup.adi Closing rigs... 1 1a 2 3 4 5 6 WinKeyer closed Section:frmNewQSO Saving window size a position (frmNewQSO) (height|width|top|left):659|801|27|0 select count(*) from cqrlog001.cqrlog_config Saving ini file to database select count(*) from cqrlog001.cqrlog_config Saving ini file to database 1 2 3 4 5 6 Closing DXCluster window Closing TRXControl window Closing GrayLine window Closing dDXCC Deleting config file: cqrlog.cfg Deleting config file: 1cqrlog.cfg Closing dData /home/slaveckm/.config/cqrlog/database/ei6kw.pid p.Executable: kill Parameters: 25778