Hi Petr,
I installed the current "cqrlog 2.0.5-1" and imported backup adi and the configuration file.
It works regularly except in a function.
Although in the "preferences" for ClubLog and HRDLog, "Upload QSO date immediately after save, update or delete" is enable, no automatic upload is executed. How can I fix?
This is the log mysql.err
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Using Linux native AIO
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Using generic crc32 instructions
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Completed initialization of buffer pool
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Waiting for purge to start
2017-03-25 17:14:56 140217918638336 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 20549407
2017-03-25 17:14:56 140217918638336 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-25 17:14:56 140217289787136 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-25 17:14:56 140217918638336 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2017-03-25 17:14:56 140217918638336 [Note] Server socket created on IP: '::'.
2017-03-25 17:14:56 140217918638336 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2017-03-25 17:14:56 140217918212864 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2017-03-25 17:14:56 140217918638336 [Note] Reading of all Master_info entries succeded
2017-03-25 17:14:56 140217918638336 [Note] Added new Master_info '' to hash table
2017-03-25 17:14:56 140217918638336 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.22-MariaDB-1~stretch' socket: '/home/giuseppe/.config/cqrlog/database/sock' port: 64000 mariadb.org binary distribution
2017-03-25 17:14:56 7f8707302b00 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-03-25 17:15:16 140217866521344 [Note] /usr/sbin/mysqld: Normal shutdown
2017-03-25 17:15:16 140217273001728 [Note] InnoDB: FTS optimize thread exiting.
2017-03-25 17:15:16 140217866521344 [Note] InnoDB: Starting shutdown...
2017-03-25 17:15:16 140217866521344 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-03-25 17:15:18 140217866521344 [Note] InnoDB: Shutdown completed; log sequence number 20624245
2017-03-25 17:15:18 140217866521344 [Note] /usr/sbin/mysqld: Shutdown complete
This is the log "cqrlog debug=1 >> log.txt"
**** DEBUG LEVEL 1 ****
SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.2
Loading libmysqlclient: /usr/lib/libmysqlclient.so
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 101655 LoTW users
Loaded 105163 eQSL users
Loaded 44840 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.6
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/giuseppe/.config/cqrlog/database/mysql.cnf --datadir=/home/giuseppe/.config/cqrlog/database/ --socket=/home/giuseppe/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:1
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
select * from cqrlog_common.db_version
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 231 -r /dev/ttyUSB0 -t 4532 -s 115200
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 231
Starting RigCtld ...
/usr/bin/rigctld -m 231 -r /dev/ttyUSB0 -t 4532 -s 115200
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
Sending: fmv
CW init
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
Msg from rig: 50090000
CW
500
VFOA
select id,freq,mode,bandwidth from freqmem where (mode = 'CW') order by id
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from riselect * from upload_status where logname='HRDLog'
select * from log_changes where id > 1 order by id
g: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
SyncUpdate:
SyncMsg :HRDLog: All QSO already uploaded
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from select * from upload_status where logname='ClubLog'
select * from log_changes where id > 1 order by id
rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
SyncUpdate:
SyncMsg :ClubLog: All QSO already uploaded
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
Sending: fmv
Msg from rig: 50090000
Msg from rig: CW
500
Msg from rig: VFOA
SELECT COUNT(*) FROM cqrlog_main
select * from profiles order by nr
SELECT * FROM view_cqrlog_main_by_qsodate
Sending: fmv
Msg from rig: 50090000
CW
500
VFOA
Sending: fmv
Msg from rig: 50090000
CW
500
VFOA
Sending: fmv
Msg from rig: 50090000
CW
500
VFOA
Sending: fmv
Msg from rig: 50090000
CW
500
VFOA
Sending: fmv
Msg from rig: 5009IK0DWJ_2017-03-25_17-26-02.adi
0000
CW
500
VFOA
Sending: fmv
Msg from rig: 50090000
CW
500
VFOA
Sending: fmv
Msg from rig: 50090000
CW
500
VFOA
Command line: tar -cvzf IK0DWJ_2017-03-25_17-26-02.tar.gz IK0DWJ_2017-03-25_17-26-02.adi
1
1a
2
3
4
5
6
Closing rigs...
select count(*) from cqrlog001.cqrlog_config
Saving ini file to database
select count(*) from cqrlog001.cqrlog_config
Saving ini file to database
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: 1cqrlInvalid file handle
og.cfg
Deleting config file: cqrlog.cfg
Closing dData
/home/giuseppe/.config/cqrlog/database/debian.pid
Command:
kill 12394
Closing ini file ...
Open QSO list window, choose Online log menu and click to Mark QSO as uploaded to all logs. Now please try to add a QSO.
It may solve the problem.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr
I had already done and try to add a new QSO, but unfortunately it does not work.
--
Giuseppe
IKØDWJ
I simply reset "Enable to upload to HRDLog.net" and "Enable to upload to clublog" in "Preferences". Evidently import the .ini configuration file had blocked the feature.
73 Giuseppe
--
Giuseppe
IKØDWJ
Thank you for information, Giuseppe!
Importing configuration may cause the problem, because when the log upload function is disabled, there are no triggers connected to main table. When you enable log upload, the triggers (after insert, before update, before delete) are created. Without these triggers log upload won't work because it doesn't see the changes in the main cqrlog logbook table.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com