I'm using kubuntu 13.10 but the program does not retain the data entered in the preferences. Once you close the program and reopen, all data are erased. This happens both with the latest version (1.7) than with previous versions. What can I do? Do you have any suggestions?
Tanks and best 73
iz3npz Ferdinando
Fri, 2014-01-24 18:07
#1
Preferences
Hi Ferdinando,
I've never seen this before. I've neved had this problem. Open the console, run cqrlog with --debug=1 parameter and paste here what it writes down. I have no idea what could be wrong.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi dear Petr
tanks for your answer. Here is what is writed on the console
Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0
Loaded 68668 LoTW users
Loaded 78590 eQSL users
Loaded 43156 SCP calls
*
User home directory: /home/ferdinando/
Program home directory: /home/ferdinando/.config/cqrlog/
Data directory: /home/ferdinando/.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
*
140125 15:55:34 [Note] Plugin 'FEDERATED' is disabled.
140125 15:55:34 InnoDB: The InnoDB memory heap is disabled
140125 15:55:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140125 15:55:34 InnoDB: Compressed tables use zlib 1.2.8
140125 15:55:34 InnoDB: Using Linux native AIO
140125 15:55:34 InnoDB: Initializing buffer pool, size = 128.0M
140125 15:55:34 InnoDB: Completed initialization of buffer pool
140125 15:55:34 InnoDB: highest supported file format is Barracuda.
140125 15:55:34 InnoDB: Waiting for the background threads to start
140125 15:55:35 InnoDB: 5.5.35 started; log sequence number 1595675
140125 15:55:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000
140125 15:55:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140125 15:55:35 [Note] Server socket created on IP: '0.0.0.0'.
140125 15:55:35 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
140125 15:55:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140125 15:55:35 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.35-0ubuntu0.13.10.1' socket: '/home/ferdinando/.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 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:
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1
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
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
Tanks for your help. Best 73
iz3npz Ferdinando
IZ3NPZ
Hi dear Petr,
in my previous post I forgot to write the final two lines. Here's the full debug it appears on the console.
ferdinando@studio:~$ cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0
Loaded 68668 LoTW users
Loaded 78590 eQSL users
Loaded 43156 SCP calls
*
User home directory: /home/ferdinando/
Program home directory: /home/ferdinando/.config/cqrlog/
Data directory: /home/ferdinando/.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
*
140125 15:55:34 [Note] Plugin 'FEDERATED' is disabled.
140125 15:55:34 InnoDB: The InnoDB memory heap is disabled
140125 15:55:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140125 15:55:34 InnoDB: Compressed tables use zlib 1.2.8
140125 15:55:34 InnoDB: Using Linux native AIO
140125 15:55:34 InnoDB: Initializing buffer pool, size = 128.0M
140125 15:55:34 InnoDB: Completed initialization of buffer pool
140125 15:55:34 InnoDB: highest supported file format is Barracuda.
140125 15:55:34 InnoDB: Waiting for the background threads to start
140125 15:55:35 InnoDB: 5.5.35 started; log sequence number 1595675
140125 15:55:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000
140125 15:55:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140125 15:55:35 [Note] Server socket created on IP: '0.0.0.0'.
140125 15:55:35 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
140125 15:55:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140125 15:55:35 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140125 15:55:35 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.35-0ubuntu0.13.10.1' socket: '/home/ferdinando/.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 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:
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1
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
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
DBPing - select * from cqrlog001.db_version
DBPing - select * from cqrlog001.db_version
Best 73
IZ3NPZ
Hi Ferdinando
I also using kubuntu 13.10 but without problem. Permissions file in cqrlog?
Hi dr Josef OK1DTM,
I have changed the permissione and the owner, and now these are :
-rwxrwxrwx 1 ferdinando root 13797264 gen 15 20:24 /usr/bin/cqrlog.
I turned off and on again the computer, but cqrlog does not retain the data entered in the preferences. Thank you for your interest and if you think of something else ....
Best 73
iz3npz Ferdinando
IZ3NPZ
Hi Ferdinando,
it has nothing to do with rights to cqrlog binary file. The rights to database, which is stored in ~/.confog/cqrlog, has to be right because without right rights mysqld woudn't start at all.
I have no idea why changes in Preferences wouldn't be save. What is not saved? Enterire options or one/two specific? Did you try to fill only callsign, QTH and name?
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr
I did the test that you suggest, but do not record anything. All information entered in the preferences are deleted at the next reboot. If I insert the locator with CTR-L, this also is lost.
I regret the inconvenience, but I do not know what to do.
Best 73
iz3npz Ferdinando
IZ3NPZ
Hi Ferdinando,
are you using Jabber? If yes, could you contact me? My jabber ID is petr@ok2cqr.com. I could connect to your computer using TeamViewer or could you record a video what are you exactly doing, please? I've never seen this problem before. Thank you!
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Finally, we solved the problem. I connected to Ferdinand's computer using TeamViewer and found out, that table, where is configuration stored, is corruped. No, problem, it's easy to fix, I did it from command line. After all, I realized CQRLOG has build-in function for that. There is no need to use command line, just two or three clicks and done. CQRLOG has too many features to remember, even for me :).
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr, I have the same problem: can you tell me the name of the configuration file where the table is stored?
Where did you click?
Thanks in advance.
73 Roby IU5FHF
73, IU5FHF Roby
.Have you tried:
"Utils"/"Repair log database" button in "Database Connection" window (at start of Cqrlog)?
--
Saku
OH1KH
Hi Saku,
I did It and the data changed on "Preferences" now are fixed and saved.
Many thanks for the help!
73 Roby IU5FHF
73, IU5FHF Roby
Hi Saku,
I noticed that however the preferences changes are only saved for the same log; if I open a different log or a new one, the preferences are the default ones: is this intentional?
Roby IU5FHF
73, IU5FHF Roby
HI Roby!
Every log has it's own preferences.
You can export(import) preferences in Database connection window/Utils/configuration/export (import).
When you create new log you can import preferences from saved file before you open new log.
Or you can select existing log number from where preferences are copied to new log when you create it.
--
Saku
OH1KH
Thanks Saku for the quick reply.
I have to discover many things again about Cqrlog settings!
73 Roby IU5FHF
73, IU5FHF Roby