Couple of issues with LOTW/EQSL

7 posts / 0 new
Last post
W7PSK
Couple of issues with LOTW/EQSL

Im trying to transfer over to Linux and your software is highly recommended, however Ive a couple issues.
 
Ive to 10,000+ contacts and Ive imported them fine from DXKeeper.  I then did a download from EQSL/LOTW however if I do
an upload and select only those not on LOTW/EQSL it tries to send the whole log ?
 
Also I decided to bite the bullet and just upload them but the progam hangs on the Signing log on LOTW.
 
What did I miss.  Does not CQRLOG sync with LOTW/EQSL like DXKeeper?
 

W7PSK
Got LOTW fixed

but EQSL hangs. Also if I try to set the FLDIGI path as I scroll through the directories I keep getting access violation and a crash.

Scotty W7PSK
Everett, Washington

ok2cqr
ok2cqr's picture
Re: Here is the print out of the access violation when scrolling

Hi Scotty,
this is bug in CQRLOG. It marks QSO uploaded to LoTW/eQSL only if ADIF contains LOTWQSLS_DATE/EQSL_SENT_DATE fileds. 
You can solve this issue by hand in SQL console. Open QSO list window, go to Filter menu and open SQL console. Copy SQL commands one by one and always click to green right arrow on the toolbar.
 
UPDATE CQRLOG_MAIN SET lotw_qslsdate = '2013-12-16'
UPDATE CQRLOG_MAIN SET lotw_qsls = 'Y'
UPDATE CQRLOG_MAIN SET eqsl_qslsdate = '2013-12-16'
UPDATE CQRLOG MAIN SET eqsl_qsl_sent = 'Y'
 
These commands make all QSO marked as uploaded both to LoTW and eQSL. This bug is already fixed in souce code and will be part od next release.
 
73 Petr, OK2CQR
 
 

ky4j
I have simular issue with my

I have simular issue with my logs.  I importd from Jlog, but the LoTW info did not come through.  On the sql command you gave, how does it relate to the name of the database in MySQL?  Put another way, I am useing Log002 with a name of 'Main', what would the correct syntax be?
Thanks!!
73,
Tim
KY4J

ok2cqr
ok2cqr's picture
Re: I have simular issue with my

Tim,
 
SQL commands are still the same because when you select database from the list, all queries in the app are automaticaly switched to new database. There is no need to add database name before table name.
 
73 Petr, OK2CQR
 

W7PSK
Here is the print out of the access violation when scrolling

<p>When trying to scroll through to get fldigi path set (which it wont list bins)</p>
<p>&nbsp;</p>
<p>cqrlog<br />Loading libssl: /usr/lib/i386-linux-gnu/libssl.so<br />Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so<br />Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0<br />Loaded 67833 LoTW users<br />Loaded 77648 eQSL users<br />*<br />User home directory:&nbsp;&nbsp;&nbsp; /home/ricky/<br />Program home directory: /home/ricky/.config/cqrlog/<br />Data directory:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /home/ricky/.config/cqrlog/database/<br />Memebers directory:&nbsp;&nbsp;&nbsp;&nbsp; /usr/share/cqrlog/members/<br />ZIP code directory:&nbsp;&nbsp;&nbsp;&nbsp; /usr/share/cqrlog/zipcodes/<br />Binary dir:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/bin/<br />Share dir:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/share/cqrlog/<br />TConnection to MySQL:&nbsp;&nbsp; 5.5<br />*<br />/usr/sbin/mysqld --defaults-file=/home/ricky/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/ricky/.config/cqrlog/database/ --socket=/home/ricky/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K<br />131213 10:12:26 [Note] Plugin 'FEDERATED' is disabled.<br />131213 10:12:26 InnoDB: The InnoDB memory heap is disabled<br />131213 10:12:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins<br />131213 10:12:26 InnoDB: Compressed tables use zlib 1.2.8<br />131213 10:12:26 InnoDB: Using Linux native AIO<br />131213 10:12:26 InnoDB: Initializing buffer pool, size = 128.0M<br />131213 10:12:26 InnoDB: Completed initialization of buffer pool<br />131213 10:12:26 InnoDB: highest supported file format is Barracuda.<br />131213 10:12:26&nbsp; InnoDB: Waiting for the background threads to start<br />131213 10:12:27 InnoDB: 5.5.34 started; log sequence number 1595675<br />131213 10:12:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000<br />131213 10:12:27 [Note]&nbsp;&nbsp; - '0.0.0.0' resolves to '0.0.0.0';<br />131213 10:12:27 [Note] Server socket created on IP: '0.0.0.0'.<br />131213 10:12:27 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them<br />131213 10:12:27 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure<br />131213 10:12:27 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure<br />131213 10:12:27 [Note] /usr/sbin/mysqld: ready for connections.<br />Version: '5.5.34-0ubuntu0.13.10.1'&nbsp; socket: '/home/ricky/.config/cqrlog/database/sock'&nbsp; port: 64000&nbsp; (Ubuntu)<br />select * from tables where table_schema = 'cqrlog_common'<br /><br />SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr<br /><br />use cqrlog001<br /><br />use cqrlog001<br /><br />SELECT * FROM cqrlog_config<br /><br />select * from db_version<br /><br />SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF<br /><br />SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF<br /><br />In create<br />All objects created<br /><br />Settings:<br />-----------------------------------------------------<br />RigCtldPath:/usr/bin/rigctld<br />RigCtldArgs:-m 346 -r /dev/ttyS0 -t 4532&nbsp; -s 4800 <br />RunRigCtld: FALSE<br />RigDevice:&nbsp; /dev/ttyS0<br />RigCtldPort:4532<br />RigCtldHost:localhost<br />RigPoll:&nbsp;&nbsp;&nbsp; 500<br />RigSendCWR: FALSE<br />RigId:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 346<br /><br />rigctld started!<br />Result0:N<br />Result1:Y<br />Result2:Y<br />Connected to localhost:4532<br />CW init<br />SELECT * FROM profiles WHERE visible &gt; 0 ORDER BY nr<br /><br />SELECT * FROM profiles WHERE nr = 1<br /><br />SELECT * FROM profiles WHERE visible &gt; 0 ORDER BY nr<br /><br />SELECT * FROM profiles WHERE nr = 1<br /><br />select locator from profiles where nr = 1<br /><br />select locator from profiles where nr = 1<br /><br />1-Everett, Washington;<br />select * from view_cqrlog_main_by_qsodate where qsodate &gt;= '2013-11-23' order by qsodate,time_on<br /><br />LoadForm: frmNewQSO<br />2013-12-13 18:12:32<br />SELECT * FROM profiles WHERE visible &gt; 0 ORDER BY nr<br /><br />SELECT * FROM profiles WHERE nr = 1<br /><br />SELECT * FROM profiles WHERE visible &gt; 0 ORDER BY nr<br /><br />TApplication.HandleException Access violation<br />&nbsp; Stack trace:<br />&nbsp; $B698164A<br />Closing BandMap window<br />Closing DXCluster window<br />Closing TRXControl window<br />Closing GrayLine window<br />End dmDXCC<br />Complete end dmDXCC<br />Closing dDXCC<br />Closing dData<br />/home/ricky/.config/cqrlog/database/Mine.pid<br />Command: <br />kill 4217<br />131213 10:12:54 [Note] /usr/sbin/mysqld: Normal shutdown<br /><br />131213 10:12:54&nbsp; InnoDB: Starting shutdown...<br />WARNING: TLCLComponent.Destroy with LCLRefCount&gt;0. Hint: Maybe the component is processing an event?<br />WARNING: TLCLComponent.Destroy with LCLRefCount&gt;0. Hint: Maybe the component is processing an event?<br />Closing ini file ...<br />[TGtk2WidgetSet.Destroy] WARNING: There are 1 TimerInfo structures left, I'll free them<br />An unhandled exception occurred at $08FDFBB0 :<br />EAccessViolation : <br />&nbsp; $08FDFBB0<br />&nbsp; $08198253<br />&nbsp; $0808C0F5<br />&nbsp; $0805E17F<br /><br />ricky@Mine ~ $ 131213 10:12:55&nbsp; InnoDB: Shutdown completed; log sequence number 1595675<br />131213 10:12:55 [Note] /usr/sbin/mysqld: Shutdown complete</p>

Scotty W7PSK
Everett, Washington

k8wdx
I am not sure what you are

I am not sure what you are asking, if you import your log from dxkeeper, you should see that eqsl or lotw, should have check markes in the lotw or eqsl sent column, then if you log some qso's with CQRlog, when you do an upload to lotw or eqsl, CQRlog should only upload the new ones not the whole log, If you try and upload 10K qso's to lotw or eqsl, I would think that it will hang, now if those qso's are uploaled already but do not show in CQRlog, "not sure why they would not be checked" then what you can do is go to QSO list and click on filter then create, in the date fields begining date would be the first qso date, then today's date, then hit ok, then go to file and click on group edit, field, LOTW Sent value "Y" then hit apply, and all you qso's will have a Y for LOTW sent, you can do the same thing for EQSL. remember always back up your log before making any changes... as far as Fldigi, I have not had setting the path work either, I just simply put CQRlog in Fldigi mode and away I go, I also take rig control away from CQRlog, by selecting radio 2 "there is no rig there" and let fldigi take the rig control, HTH Tom...

Tom K8WDX