Cqrlog has I/O error on startup? Cqrlog and rig not talking now.

4 posts / 0 new
Last post
K5KV
Cqrlog has I/O error on startup? Cqrlog and rig not talking now.

My unbuntu crashed and 12.10 was reloaded along with cqrlog 1.5.4.  Cqrlog is showing an I/O error on startup.  The settings are the same as before the crash.  My terminal output is below.  Any help is greatly appreciated.
73
Benny K5KV
 
benny@ubuntu:~$ cqrlogLoading libssl: /usr/lib/i386-linux-gnu/libssl.soLoading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.soLoading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18Loaded 62423 LoTW usersLoaded 71249 eQSL usersLoaded 44221 SCP calls*User home directory:    /home/benny/Program home directory: /home/benny/.config/cqrlog/Data directory:         /home/benny/.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*/usr/sbin/mysqld --defaults-file=/home/benny/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/benny/.config/cqrlog/database/ --socket=/home/benny/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K130426 23:53:33 [Note] Plugin 'FEDERATED' is disabled.130426 23:53:33 InnoDB: The InnoDB memory heap is disabled130426 23:53:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins130426 23:53:33 InnoDB: Compressed tables use zlib 1.2.7130426 23:53:33 InnoDB: Using Linux native AIO130426 23:53:33 InnoDB: Initializing buffer pool, size = 128.0M130426 23:53:33 InnoDB: Completed initialization of buffer pool130426 23:53:33 InnoDB: highest supported file format is Barracuda.130426 23:53:34  InnoDB: Waiting for the background threads to start130426 23:53:35 InnoDB: 1.1.8 started; log sequence number 1595675130426 23:53:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000130426 23:53:35 [Note]   - '0.0.0.0' resolves to '0.0.0.0';130426 23:53:35 [Note] Server socket created on IP: '0.0.0.0'.130426 23:53:35 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them130426 23:53:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist130426 23:53:35 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure130426 23:53:35 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure130426 23:53:35 [Note] /usr/sbin/mysqld: ready for connections.Version: '5.5.27-0ubuntu2'  socket: '/home/benny/.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_nruse cqrlog001use cqrlog001SELECT * FROM cqrlog_configselect * from db_versionSELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIFSELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIFIn createAll objects createdSettings:-----------------------------------------------------RigCtldPath:/usr/bin/rigctldRigCtldArgs:-m 1611 -r /dev/ttyUSB0 -t 4532  -s 57600 RunRigCtld: TRUERigDevice:  /dev/ttyUSB0RigCtldPort:4532RigCtldHost:localhostRigPoll:    2000RigSendCWR: FALSERigId:      1611Starting RigCtld .../usr/bin/rigctld -m 1611 -r /dev/ttyUSB0 -t 4532  -s 57600 rig_open: error = IO error rigctld started!Result0:NResult1:YResult2:YConnected to localhost:4532CW initSELECT * FROM profiles WHERE visible > 0 ORDER BY nrSELECT * FROM profiles WHERE visible > 0 ORDER BY nrselect * from view_cqrlog_main_by_qsodate where qsodate >= '2013-04-21' order by qsodate,time_onLoadForm: frmNewQSO2013-04-27 04:53:39

K5KV
Thanks to a previous post

Thanks to a previous post from K8WDX, I found the problem with group/port permission and added by username to the dialout port or group in the /etc/group file.  After a reboot, it worked.
My first installation of Cqrlog 1.5.4 worked without this.  Anyway it worked.  What does dialup mean and did I do something wrong adding my username to it?
 
73
Benny K5KV

k8wdx
k8wdx's picture
Adding yourself to the dial

Adding yourself to the dial out group, will allow you, as a user of Ubuntu to use the serial/USB port, I believe this is the case, by default or not adding yourself to the dialout group, the OS will not allow you to use the port. Tom K8WDX
Hope I am right on that one, I am no expert.....

Tom K8WDX

K5KV
THANKS TOM

IT WORKED

73
BENNY K5KV