Petr,
I posted this on LinuxHam (yahoo group) today. Probably should have posted it here first. Sorry.
The problem does not seem quite the same as Derak's (SP2MKI).
Nothing is appearing on my CQRLOG bandmap anymore. Everything else is working fine. The DXCluster spots come in with no problems and all TRX Control functions are controlling my Kenwood TS-480-SAT without error. Frequency readout is correct. Band and mode switching are working fine.
I am running CQRLOG 1.4.1 with Ubuntu 12.04. I've been using CQRLOG for more than a year and I have never had this problem before. I just upgraded to 12.04 and 1.4.1 at about the same time (not wise, I agree). So I am not sure where the problem lies.
I have tried toggling the boxes "Show only active band" and "Show only active mode." But this makes no difference.
Can you please help me, Petr?
Thanks.
Rich TI7/AA2UP
Rich,
I'm sorry, I don't read linuxham list very often.
Truth is, I've never met this problem. Could you please run cqrlog from console and paste here what it writes down? Also please try to add your own station to bandmap with + key.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hello Petr,
This is what I get when I start cqrlog form the terminal.
I tried adding my own call with + and also with ctl-A. Did not work.
Thank you for your help.
Rich TI7/AA2UP
richard@richard-LINUX:~$ cqrlog
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so.0.9.8
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18
Loaded 52090 LoTW users
Loaded 62016 eQSL users
*
User home directory: /home/richard/
Program home directory: /home/richard/.config/cqrlog/
Data directory: /home/richard/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
*
/usr/sbin/mysqld --defaults-file=/home/richard/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/richard/.config/cqrlog/database/ --socket=/home/richard/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K
120525 9:38:53 [Note] Plugin 'FEDERATED' is disabled.
120525 9:38:53 InnoDB: The InnoDB memory heap is disabled
120525 9:38:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120525 9:38:53 InnoDB: Compressed tables use zlib 1.2.3.4
120525 9:38:53 InnoDB: Initializing buffer pool, size = 128.0M
120525 9:38:53 InnoDB: Completed initialization of buffer pool
120525 9:38:53 InnoDB: highest supported file format is Barracuda.
120525 9:38:53 InnoDB: Waiting for the background threads to start
120525 9:38:54 InnoDB: 1.1.8 started; log sequence number 1589339
120525 9:38:54 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
120525 9:38:54 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120525 9:38:54 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120525 9:38:54 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120525 9:38:54 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.22-0ubuntu1' socket: '/home/richard/.config/cqrlog/database/sock' port: 64000 (Ubuntu)
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
use cqrlog002
use cqrlog002
SELECT * FROM cqrlog_config
select * from db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
huu1
huu2
In create
All objects created
huu3
huu4
Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 228 -r /dev/ttyUSB0 -s 9600 -C stop_bits=1
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 228
Starting RigCtld ...
/usr/bin/rigctld -m 228 -r /dev/ttyUSB0 -s 9600 -C stop_bits=1
rigctld started!
Result0:N
Result1:Y
Result2:Y
Connected to localhost:4532
Loading window size a position (height|width|top|left):634|862|255|400
Section:frmTRXControl
Loading window size a position (frmTRXControl) (height|width|top|left):232|339|352|50
Section:frmDXCluster
Loading window size a position (frmDXCluster) (height|width|top|left):305|753|24|470
Section:frmQSODetails
Loading window size a position (frmQSODetails) (height|width|top|left):210|266|685|82
Section:frmBandMap
Loading window size a position (frmBandMap) (height|width|top|left):276|251|24|107
CW init
SunDelta:-5.999900000000000000E+00
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
select locator from profiles where nr = 1
select locator from profiles where nr = 1
1-EK70MN;Costa Rica;
select * from view_cqrlog_main_by_qsodate where qsodate >= '2012-05-20' order by qsodate,time_on
LoadForm: frmNewQSO
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: id_cqrlog_main Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsodate Width: 110
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: time_on Width: 77
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: time_off Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: callsign Width: 220
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: freq Width: 110
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: mode Width: 88
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_s Width: 220
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_r Width: 220
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: name Width: 440
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qth Width: 660
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_s Width: 55
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_r Width: 55
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_via Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: iota Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: pwr Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: itu Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: waz Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: loc Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: my_loc Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: county Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: award Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: remarks Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: band Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: dxcc_ref Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qso_dxcc Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: profile Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: idcall Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: state Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslsdate Width: 143
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslrdate Width: 143
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qsls Width: 99
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslr Width: 99
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: cont Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsls_date Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qslr_date Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr1 Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr2 Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr3 Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr4 Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr5 Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qsl_sent Width: 60
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslsdate Width: 60
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qsl_rcvd Width: 60
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslrdate Width: 60
2012-05-25 15:39:10
OnCloseQuery - NewQSO
SaveForm: frmNewQSO
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: id_cqrlog_main Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsodate Width: 110
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: time_on Width: 77
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: time_off Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: callsign Width: 220
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: freq Width: 110
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: mode Width: 88
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_s Width: 220
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_r Width: 220
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: name Width: 440
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qth Width: 660
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_s Width: 55
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_r Width: 55
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_via Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: iota Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: pwr Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: itu Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: waz Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: loc Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: my_loc Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: county Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: award Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: remarks Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: band Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: dxcc_ref Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qso_dxcc Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: profile Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: idcall Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: state Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslsdate Width: 143
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslrdate Width: 143
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qsls Width: 99
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslr Width: 99
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: cont Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsls_date Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qslr_date Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr1 Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr2 Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr3 Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr4 Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: club_nr5 Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qsl_sent Width: 60
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslsdate Width: 60
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qsl_rcvd Width: 60
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslrdate Width: 60
1
1a
2
3
4
5
6
Section:frmTRXControl
Saving window size a position (frmTRXControl) (height|width|top|left):232|339|352|50
Section:frmDXCluster
Saving window size a position (frmDXCluster) (height|width|top|left):305|753|24|470
Closing Details window
Section:frmQSODetails
Saving window size a position (frmQSODetails) (height|width|top|left):210|266|685|82
Section:frmBandMap
Saving window size a position (frmBandMap) (height|width|top|left):276|251|24|107
Saving window size a position (height|width|top|left):634|862|255|400
Command line: killall xplanet
select count(*) from cqrlog002.cqrlog_config
Saving ini file to database
select count(*) from cqrlog002.cqrlog_config
Saving ini file to database
Closing BandMap window
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
End dmDXCC
Complete end dmDXCC
Closing dDXCC
Closing dData
/home/richard/.config/cqrlog/database/richard-LINUX.pid
Command:
kill 3527
120525 9:39:21 [Note] /usr/sbin/mysqld: Normal shutdown
120525 9:39:21 InnoDB: Starting shutdown...
Closing ini file ...
An unhandled exception occurred at $08071605 :
EAccessViolation :
$08071605
$0818AAA5
richard@richard-LINUX:~$ 120525 9:39:22 InnoDB: Shutdown completed; log sequence number 1589339
120525 9:39:22 [Note] /usr/sbin/mysqld: Shutdown complete
Hello Rich,
this is strange. There is nothing about bandmap. Please go to ~/.config/cqrlog/ and delete file bandmap.dat and bandmap.mdx if they exist. Maybe it will help.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr,
That worked! I deleted those two files, started up, and now my bandmap is working fine. Thank you very much for helping me with this problem and for your very fast technical support.
I also want to thank you for developing such great software. I have used both HRD and DxLab. Both are fine programs. But CQRLOG is more efficient, has a simpler interface, and is more stable.
I just sent a $50.00 donation via PayPal. Thank you for creating such an outstanding contribution to ham radio.
73 from Costa Rica,
Rich TI7/AA2UP
Hello Rich,
thank you for generous donation! It helps me a lot, now saving money to buy better server for HamQTH.
It's great to hear you like CQRLOG. This makes me happy. Thanks a lot!
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com