**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned:  5.500000000000000000E+00
**********************************
Loaded 93257 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory:    /home/pa1sbm/
Program home directory: /home/pa1sbm/.config/cqrlog/
Data directory:         /home/pa1sbm/.config/cqrlog/database/
Memebers directory:     /home/pa1sbm/cqrlog_191_005/usr/share/cqrlog/members/
ZIP code directory:     /home/pa1sbm/cqrlog_191_005/usr/share/cqrlog/zipcodes/
Binary dir:             /home/pa1sbm/cqrlog_191_005/usr/bin/
Share dir:              /home/pa1sbm/cqrlog_191_005/usr/share/cqrlog/
TConnection to MySQL:   5.5
*
56 us states loaded
Trying to connect to database
160417 12:47:28 [Note] /usr/sbin/mysqld (mysqld 5.5.47-MariaDB-1ubuntu0.14.04.1) starting as process 2776 ...
TMySQL55Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:2
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

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

drop view view_cqrlog_main_by_callsign

drop view view_cqrlog_main_by_qsodate

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 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_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 FROM cqrlog_main JOIN dxcc_id ON dxcc_id.adif = cqrlog_main.adif order by callsign;

update db_version set nr=11

select * from cqrlog_common.db_version

alter table cqrlog_common.bands add rx_offset numeric(10,4) default 0

alter table cqrlog_common.bands add tx_offset numeric(10,4) default 0

update cqrlog_common.db_version set nr=4

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF


Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 1 -r  -t 4532  
RunRigCtld: FALSE
RigDevice:  
RigCtldPort:4532
RigCtldHost:localhost
RigPoll:    500
RigSendCWR: FALSE
RigId:      1

rigctld started!
Connected to localhost:4532

Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:  
RotCtldPort:4533
RotCtldHost:localhost
RotPoll:    500
RotId:      1

rotctld started!
Connected to localhost:4533
select id,freq,mode,bandwidth from freqmem order by id

TApplication.HandleException List index (1) out of bounds
  Stack trace:
  $00000000005A4330
  $000000000073FB1A
  $0000000000740363
  $000000000073FA05
  $0000000000430E9F
  $0000000000708FE4
  $00000000007DA362
  $00000000007EBFE1
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

1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: 1cqrlog.cfg
Deleting config file: cqrlog.cfg
Closing dData
/home/pa1sbm/.config/cqrlog/database/hampc-lm-vm.pid
Command: 
kill 2776
WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
Closing ini file ...
[TGtk2WidgetSet.Destroy] WARNING: There are 1 TimerInfo structures left, I'll free them