Preferences

13 posts / 0 new
Last post
iz3npz
Preferences

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

ok2cqr
ok2cqr's picture
Re: Proferences

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

iz3npz
Preferences

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

iz3npz
Preferences

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

ok1dtm
Re: Proferences

Hi Ferdinando
I also using kubuntu 13.10 but without problem. Permissions file in cqrlog?

iz3npz
Preferences

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

ok2cqr
ok2cqr's picture
RE: Preferences

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
 
 

iz3npz
Preferences

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

ok2cqr
ok2cqr's picture
Re: Preferences

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

ok2cqr
ok2cqr's picture
RE: Preferences

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

IU5FHF
Hi Petr, I have the same

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

IU5FHF Roby

oh1kh
.Have you tried:

.Have you tried:

"Utils"/"Repair log database" button in "Database Connection" window (at start of Cqrlog)?

--
Saku
OH1KH

IU5FHF
Hi Saku,

Hi Saku,
I did It and the data changed on "Preferences" now are fixed and saved.
Many thanks for the help!

73 Roby IU5FHF

IU5FHF Roby