This is written On Status of log upload
ClubLog: Uploading Z6/LZ1BJ
ClubLog: Rejected: 'Z6/LZ1BJ' does not map by prefix or exception to any DXCC on the date in question. Skipping QSO.
This process remains in cqrlog with each update online QSO and prevents the subsequent addition of new QSO on clublog. How can I eliminate this action by cqrlog and allow the regular upload of new QSO?
73 de IK0DWJ
Could you paste here the output from terminal, please? Run cqrlog with --debug=1 parameter. I'm interested in http result code from ClubLog. Truth is, I don't understand why clublog should refuse this QSO.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr, thanks for the reply, this is the output for the command you asked me:
$ cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0
Loaded 70628 LoTW users
Loaded 80444 eQSL users
Loaded 45646 SCP calls
*
User home directory: /home/giuseppe/
Program home directory: /home/giuseppe/.config/cqrlog/
Data directory: /home/giuseppe/.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/
TConnection to MySQL: 5.5
*
140320 11:10:44 [Note] Plugin 'FEDERATED' is disabled.
140320 11:10:44 InnoDB: The InnoDB memory heap is disabled
140320 11:10:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140320 11:10:44 InnoDB: Compressed tables use zlib 1.2.8
140320 11:10:44 InnoDB: Using Linux native AIO
140320 11:10:44 InnoDB: Initializing buffer pool, size = 128.0M
140320 11:10:44 InnoDB: Completed initialization of buffer pool
140320 11:10:44 InnoDB: highest supported file format is Barracuda.
140320 11:10:44 InnoDB: Waiting for the background threads to start
140320 11:10:45 InnoDB: 5.5.35 started; log sequence number 1595675
140320 11:10:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000
140320 11:10:45 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140320 11:10:45 [Note] Server socket created on IP: '0.0.0.0'.
140320 11:10:45 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
140320 11:10:45 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140320 11:10:45 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140320 11:10:45 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140320 11:10:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.35-2' socket: '/home/giuseppe/.config/cqrlog/database/sock' port: 64000 (Debian)
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
--
cqrlog version: 1.7.3-1 i386
73 Giuseppe, IK0DWJ
--
Giuseppe
IKØDWJ
Hi Giuseppe,
I'm sorry, I didn't describe what I exactly mean. Please run cqrlog with --debug=1 parameter and try to upload QSO to ClubLog - click to Online Log -> ClubLog -> Upload all changes.
What I need is info returned from ClubLog. It will appear in the console with the Z6 callsign.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr,
I have isolated only the relevant part of what appears in the console,
about clublog and Z6 calsign.
In an attempt to solve, I forgot to say that I had previously tried deleting
Z6 calsign, then two processes are queued on ClubLog.
**** DEBUG LEVEL 1 ****
[cut]
select * from upload_status where logname='ClubLog'
select * from log_changes where id > 863 order by id
SyncUpdate:
SyncMsg :ClubLog: Uploading Z6/LZ1BJ
select * from log_changes where id = 864
select * from cqrlog_main where id_cqrlog_main = 6421
GetQSOInAdif: QSO not found in the log. ID:6421
data.Text:
[cut]
adif=<QSO_DATE:8>20140319<TIME_ON:4>1637<CALL:8>Z6/LZ1BJ<BAND:3>
20M<MODE:2>CW<FREQ:7>14.0123<EOR>
-----------
Response :Rejected: 'Z6/LZ1BJ' does not map by prefix or exception to any DXCC on the date in question. Skipping QSO.
ResultCode:400
-----------
SyncUpdate:
SyncMsg :ClubLog: Rejected: 'Z6/LZ1BJ' does not map by prefix or exception to any DXCC on the date in question. Skipping QSO.
--
73 Giuseppe, IK0DWJ
--
Giuseppe
IKØDWJ
I have circumvented the problem in subject. In my situation it was necessary export and upload manually my log.adi on clublog and mark in cqrlog all QSOs as uploaded. Here is configured that saving a QSO on log, it is upload on ClubLog immediately; if this QSO is rejected for some reason by clublog, before recording new contacts, should be marked immediately all QSO as uploaded. This procedure resolves immediately the problem but on ClubLog this contact is not recorded. It is a problem of clublog, not of cqrlog, but to realize this we must, all the time, monitor the window "Online log upload status", otherwise don't know what happens, and can complicate the situation.
73 Giuseppe
--
Giuseppe
IKØDWJ
For me, it works exactly.
There is one situation where I do not understand, but Petr knows about it.
Example:
You have saved some QSOs
You get a QSL card and editing this QSO that you receive the card. Then you do upload to clublog
And all the changes in the log, along with the QSO will be sent.
Sending involves the removal of the QSO and save the new.
And here is the crux of the matter.
Sometimes I do not know why, after the QSO removal occurs communication error.
You see this error in this window, and you will try retry upload log to clublog.
Unfortunately clublog reports that there is no such QSOs and upload stop. - :(
Then I do as you wrote Giuseppe.
The new version supposedly will include changes that affect this problem. :) - It would be cool.
73! Pawel
Ho Pawel and Giuseppe,
I'll fix the bug in new version. I'm sorry but it will take a while to release it. There is one bug/missing feature in current free pascal version and I have to deal with it somehow. There are a few option and I have to make some experiments first. I suppose new version of cqrlog will be released after new UIbuntu will be out.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com