CQRLOG 1.3.1 released

This version doesn't have any new features. Just two bugfixes. One is for Ubuntu 12.04.
More at http://www.cqrlog.com/download

Comments

ka1oz's picture

Problem w/ QRZ.COM lookups

Hi...

Just upgraded from 0.96 to 1.3.1 XML lookups to QRZ.COM no longer works. Any suggestions?

Tnx & 73

Dick, ka1oz

Use HamQTH and dont bother

Use HamQTH and dont bother with QRZ... Tom K8WDX
BTW works with Fldigi as well...

ka1oz's picture

Reply to "Use HamQTH and don't bother"

I forgot to mention that HamQTH doesn't work either! I checked my passwords, etc. and all appears correct. I'm at a loss!

ka1oz's picture

Found problem with qrz/hamqth lookups!!

Operator error!! Operator error!!

Well, I'm embarrassed to tell you that the problem stemmed with me! I had to reinstall cqrlog when my drive died and when I did the install I did not check all the options. In particular, I forgot to enable auto-search. I apologize for the bandwidth that this issue has consumed.

I rely heavily on cqrlog. It has been rock solid because of the fine work you have been doing to keep it up to date, especially since qrz.com has been a moving target in recent months.

Again...thanks.

Dick, I cant tell you how

Dick, I cant tell you how many times I have done this, so many that when the look up does not work this is the first place I look hi hi. and you are right, CQRlog, is what I consider to be the best logging program out there. most of them are either way overkill of far to complex, I would rather be on the air than trying to figure out how to use my logging software. As far as Linux goes, I started using it in the shack, after using it for a bit there, I loaded it up on all of my PC's and I love it, I no longer have to worry about my PC crashing when trying to work that rare digital QSO, Both Linux and CQRlog with Fldigi are fantasic. Because of CQRlog, I am a 99.9% linux user. I have a netbook set aside with Windows7 to update my rigs. that is it. 73 my friend Tom K8WDX
BTW Peter, the president of our local club wants me to demonstrate Linux CQRlog and Fldigi at a meeting coming up soon. seems there is a large interest..

Peter, I have been playing

Peter, I have been playing around with HamQTH, WOW, this is fun, I loaded my log, and will update that every once in a while, what a great program, and everytime I mention CQRlog and Ham Radio, HamQTH is a large part of that, Fldigi also will auto open HamQTH in another window when I enter a call into the call look up window, fantastic...I am having way to much fun hi hi... Tom K8WDX

ka1oz's picture

Reply to "Problem w/ QRZ.COM lookups"

Hello Petr--

Sorry for the delay in responding. I've been having antenna trouble and have been off the air for a while.

Petr, I forgot to mention that I'm using Ubuntu 11.10, CQRLOG V. 1.3.1.

Here is the terminal output you requested. There is a lot of polling but did not want to remove anything from the output. I attempted a lookup of your call. Thank you for your help.

Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/libmysqlclient.so.16
Loaded 50755 LoTW users
Loaded 59668 eQSL users
*
User home directory: /home/dick/
Program home directory: /home/dick/.config/cqrlog/
Data directory: /home/dick/.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/dick/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/dick/.config/cqrlog/database/ --socket=/home/dick/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K
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

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

In inicializerig
Model:229
Port:/dev/ttyUSB0
Baudrate:38400
Databits:8
StopBits:1
Handshake:None
Parity:None
DTR:OFF
RTS:OFF
Poll:500
Loading window size a position (height|width|top|left):651|807|294|458
Section:frmGrayline
Loading window size a position (frmGrayline) (height|width|top|left):230|421|33|118
2012-03-16 19:59:42
Section:frmTRXControl
Loading window size a position (frmTRXControl) (height|width|top|left):232|339|295|117
Section:frmDXCluster
Loading window size a position (frmDXCluster) (height|width|top|left):229|436|33|540
Section:frmQSODetails
Loading window size a position (frmQSODetails) (height|width|top|left):210|338|735|117
Section:frmBandMap
Loading window size a position (frmBandMap) (height|width|top|left):230|284|33|978
Section:frmPropagation
Loading window size a position (frmPropagation) (height|width|top|left):149|337|557|118
CW init
SunDelta:-5.000000000000000000E+00
SELSFI: 111
A: 3
K: 4
GF: UNSET
SSN: 85
Time: 1425 UT 16 Mar 2012
RIG_RESULT1: RIG_OK
RIG_RESULT2: RIG_OK
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadioECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

2012-03-16 19:59:43
2012-03-16 19:59:43
adif:0
SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND ((qsl_r='Q') OR (lotw_qslr='L')) AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 LIMIT 1

select band,mode from cqrlog_main where adif=503 group by band,mode

select band,mode,qsl_r,lotw_qslr,eqsl_qsl_rcvd from cqrlog_main where adif=503 and ((qsl_r='Q') or (lotw_qslr = 'L') or (eqsl_qsl_rcvd='E')) group by band,mode,qsl_r,lotw_qslr,eqsl_qs
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.185000000l_rcvd

2012-03-16 19:59:49
Nalezeno - OK2CQR
adif:503
SELECT * FROM view_cqrlog_main_by_qsodate WHERE callsign = 'OK2CQR' ORDER BY qsodate,time_on

LoadForm: frmNewQSO
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: id_cqrlog_main Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsodate Width: 100
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: time_on Width: 70
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: time_off Width: 80
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: callsign Width: 200
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: freq Width: 100
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: mode Width: 80
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_s Width: 200
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_r Width: 200
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: name Width: 400
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qth Width: 600
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_s Width: 50
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_r Width: 50
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: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslrdate Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qsls Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslr Width: 0
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: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslsdate Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qsl_rcvd Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslrdate Width: 0
Loading: Section: frmNewQSO_dbgrdQSOBefore Ident: qslr Width: 0
SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND ((qsl_r='Q') OR (lotw_qslr='L')) AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 LIMIT 1

2012-03-16 19:59:52
select * from cqrlog_common.qslmgr where (callsign = 'OK2CQR') and (fromDate <= '2012-03-16') order by fromDate

GetIOTAForDXCC
SELECT iota_nr,pref FROM cqrlog_common.iota_list WHERE dxcc_ref = 'OK' ORDER BY iota_nr

select id_cqrlog_main FROM cqrlog_main WHERE waz = 15 AND band = '40M' AND QSL_R = 'Q' LIMIT 1

select id_cqrlog_main FROM cqrlog_main WHERE waz = 15 AND band = '40M' LIMIT 1

select id_cqrlog_main FROM cqrlog_main WHERE itu = 28 AND band = '40M' AND QSL_R = 'Q' LIMIT 1

select id_cqrlog_main FROM cqrlog_main WHERE itu = 28 AND band = '40M' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND ((qsl_r='Q') OR (lotw_qslr='L')) AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_00000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: main WHERE adif=503 LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND ((qsl_r='Q') OR (lotw_qslr='L')) AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND mode='SSB' LIMIT 1

SELE7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND ((qsl_r='Q') OR (lotw_qslr='L')) AND mode='SSB_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.18500000000000E+006
PollRadio
fRigMode:RIG_MODE_LSB
fRigFrequency: 7.1850000' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 AND band='40M' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=503 LIMIT 1

OnCloseQuery - NewQSO
SaveForm: frmNewQSO
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: id_cqrlog_main Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsodate Width: 100
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: time_on Width: 70
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: time_off Width: 80
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: callsign Width: 200
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: freq Width: 100
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: mode Width: 80
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_s Width: 200
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: rst_r Width: 200
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: name Width: 400
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qth Width: 600
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_s Width: 50
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qsl_r Width: 50
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: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslrdate Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qsls Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: lotw_qslr Width: 0
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: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslsdate Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qsl_rcvd Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: eqsl_qslrdate Width: 0
Saving: Section: frmNewQSO_dbgrdQSOBefore Ident: qslr Width: 0
Section:frmGrayline
Saving window size a position (frmGrayline) (height|width|top|left):230|421|33|118
Section:frmTRXControl
Saving window size a position (frmTRXControl) (height|width|top|left):232|339|295|117
Section:frmDXCluster
Saving window size a position (frmDXCluster) (height|width|top|left):229|436|33|540
Closing Details window
Section:frmQSODetails
Saving window size a position (frmQSODetails) (height|width|top|left):210|338|735|117
Section:frmBandMap
Saving window size a position (frmBandMap) (height|width|top|left):230|284|33|978
Section:frmPropagation
Saving window size a position (frmPropagation) (height|width|top|left):149|337|557|118
Saving window size a position (height|width|top|left):651|807|294|458
select count(*) from cqrlog001.cqrlog_config

Saving ini file to database
SELECT COUNT(*) FROM cqrlog_main

select * from profiles order by nr

SELECT * FROM view_cqrlog_main_by_qsodate

Command line: tar -cvzf KA1OZ_2012-03-16_15-0KA1OZ_2012-03-16_15-00-16.adi
0-16.tar.gz KA1OZ_2012-03-16_15-00-16.adi
select couTApplication.HandleException Access violation
Stack trace:
$exception at 00C1D9A0:
Access violation.
Closing BandMap window
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
/home/dick/.config/cqrlog/database/DICK.pid
Command:
kill 29262
Closing ini file ...
An unhandled exception occurred at $08071AC5 :
EAccessViolation :
$08071AC5
$08189945

I use the qrz.com lookups,

I use the qrz.com lookups, with xml membership, with 1.3.1 with no issue. You do have to ensure that your login info is correct, of course. For some reason, it took a couple of times entering it in CQRLOG to make it "stick"