CQRLOG doesn't startup with DB issues after mysql-update

6 posts / 0 new
Last post
DL4PD
CQRLOG doesn't startup with DB issues after mysql-update

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

DL8BH
Hi Patrick,

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/

DL4PD
Hm, looks good:

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...
 

DL4PD
Maybe this helps:

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 ...
 

DL4PD
Good evening together,

Good evening together,
problem solved: ich changed back to mariadb and now it works.
 

DL8BH
ok, switching from mariadb to

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/