Hey Petr,
I tried every hint I could find in the net, but nothing works.
Here ist my ~/.config/cqrlog/database/mysql.log
<code>
150721 13:17:27 [Note] Plugin 'FEDERATED' is disabled.
150721 13:17:27 InnoDB: The InnoDB memory heap is disabled
150721 13:17:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150721 13:17:27 InnoDB: Compressed tables use zlib 1.2.8
150721 13:17:27 InnoDB: Using Linux native AIO
150721 13:17:27 InnoDB: Initializing buffer pool, size = 80.0M
150721 13:17:27 InnoDB: Completed initialization of buffer pool
150721 13:17:27 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150721 13:17:27 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
150721 13:17:27 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name .
InnoDB: File operation call: 'opendir'.
InnoDB: Cannot continue operation.
pd@oldbook:~$
</code>
Thanks in advance,
Patrick
Tue, 2015-07-21 12:22
#1
CQRLOG doesn't startup with DB issues after mysql-update
Hi Patrick,
looks like there is a permission problem. Check the file permissions in ~/.config/cqrlog/database/ (should be read/writable by your local user) and check, if the following line is still in your /etc/apparmor.d/usr.sbin.mysqld (might got overwritten during the mysqld update):
@{HOME}/.config/cqrlog/database/** rwk,
73, Bernd
a simple webinterface for cqrlog, screenshots over here: http://www.dl8bh.de/cqrweblog/
Hm, looks good:
[..]
# Site-specific additions and overrides. See local/README for details.
#include <local/usr.sbin.mysqld>
@{HOME}/.config/cqrlog/database/** rwk,
}
and:
drwxrwxr-x 5 pd pd 4096 Jul 21 13:17 .
drwxrwxr-x 11 pd pd 4096 Jul 21 12:49 ..
-rw-rw---- 1 pd pd 16384 Jul 20 22:11 aria_log.00000001
-rw-rw---- 1 pd pd 52 Jul 20 22:11 aria_log_control
drwx------ 2 pd pd 12288 Sep 21 2014 cqrlog001
drwx------ 2 pd pd 12288 Jul 20 22:12 cqrlog002
drwx------ 2 pd pd 4096 Sep 21 2014 cqrlog_common
-rw-rw---- 1 pd pd 18874368 Jul 21 05:20 ibdata1
-rw-rw---- 1 pd pd 5242880 Jul 21 05:20 ib_logfile0
-rw-rw---- 1 pd pd 5242880 Sep 21 2014 ib_logfile1
-rw-rw-r-- 1 pd pd 34 Sep 21 2014 my.cnf
-rw-rw-r-- 1 pd pd 1863 Jul 19 19:02 mysql.cnf
-rw-rw---- 1 pd pd 31880 Jul 21 13:17 mysql.err
pd@oldbook:~$
It looks as if there is a problem inside mysql, but I'm not that specialist...
Maybe this helps:
pd@oldbook:~$ cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.500000000000000000E+00
**********************************
Loaded 85130 LoTW users
Loaded 91827 eQSL users
Loaded 46121 SCP calls
IniFile:/home/pd/.config/cqrlog/cqrlog.cfg
LocalIniFile:/home/pd/.config/cqrlog/local.cfg
*
User home directory: /home/pd/
Program home directory: /home/pd/.config/cqrlog/
Data directory: /home/pd/.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
*
Trying to connect to database
150721 19:58:49 [Note] /usr/sbin/mysqld (mysqld 5.5.43-0ubuntu0.14.04.1) starting as process 2494 ...
Server connect failed.
Trying:1
Trying to connect to database
Server connect failed.
Trying:2
Trying to connect to database
Server connect failed.
Trying:3
Trying to connect to database
Server connect failed.
Trying:4
Trying to connect to database
Server connect failed.
Trying:5
Trying to connect to database
Server connect failed.
Trying:6
Trying to connect to database
Server connect failed.
Trying:7
Trying to connect to database
Server connect failed.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Invalid file handle
Closing dData
(cqrlog:2490): GLib-CRITICAL **: Source ID 11 was not found when attempting to remove it
(cqrlog:2490): GLib-CRITICAL **: Source ID 10 was not found when attempting to remove it
(cqrlog:2490): GLib-CRITICAL **: Source ID 43 was not found when attempting to remove it
(cqrlog:2490): GLib-CRITICAL **: Source ID 42 was not found when attempting to remove it
(cqrlog:2490): GLib-CRITICAL **: Source ID 48 was not found when attempting to remove it
(cqrlog:2490): GLib-CRITICAL **: Source ID 47 was not found when attempting to remove it
Closing ini file ...
Good evening together,
problem solved: ich changed back to mariadb and now it works.
ok, switching from mariadb to mysql is not recommended ;)
if you want to switch back to mysql, you could do a sql-dump (see mysqldump command) and re-import this in mysql instead of using the binary data.
a simple webinterface for cqrlog, screenshots over here: http://www.dl8bh.de/cqrweblog/