OK, good idea, this gets me a bit further: USERNAME@HOST:~/.local/share/akonadi$ /usr/sbin/mysqld --defaults- file=/tmp/mysql.conf --datadir=/home/USERNAME/.local/share/akonadi/db_data/ -- socket=/tmp/akonadi-USERNAME.gzrNgH/mysql.socket 161110 13:28:37 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 161110 13:28:37 [Note] /usr/sbin/mysqld (mysqld 5.5.53-0+deb8u1) starting as process 2783 ... 161110 13:28:37 [Warning] Can't create test file /home/USERNAME/.local/share/akonadi/db_data/HOST.lower-test 161110 13:28:37 [Warning] Can't create test file /home/USERNAME/.local/share/akonadi/db_data/HOST.lower-test 161110 13:28:37 [Note] Plugin 'FEDERATED' is disabled. 161110 13:28:37 InnoDB: The InnoDB memory heap is disabled 161110 13:28:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 161110 13:28:37 InnoDB: Compressed tables use zlib 1.2.8 161110 13:28:37 InnoDB: Using Linux native AIO 161110 13:28:37 InnoDB: Initializing buffer pool, size = 80.0M 161110 13:28:37 InnoDB: Completed initialization of buffer pool 161110 13:28:37 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 ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation.
It seems that the path to the datadir is also restricted, as this directory is also writeable by USERNAME... I see this as a bug in mysql, especially as it is not described in the changelog, any other opinions on that? Cheers, Johannes Am Donnerstag, 10. November 2016, 13:07:40 schrieb Sandro Knauß: > Hey, > > just try tp copy the file to /tmp/ and than try to start the server? > > /usr/sbin/mysqld --defaults-file=/tmp/mysql.conf --datadir=[...] > > maybe you have strange permission in one folder? > > But mysqld is runas normal <USERNAME> so if this user can read the file this > should be enough. Does 5.5.23 somehow also limit the paths to load > defaults- file from? Doesn't seems so from changelog > > https://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-53.html > > Best regards, > > sandro > > -- > > Am Donnerstag, 10. November 2016, 12:51:59 CET schrieb Johannes Ranke: > > When I run the same command using strace, I get > > > > ... > > > > getcwd("/home/USERNAME/.local/share/akonadi", 510) = 34 > > stat("/home/USERNAME/.local/share/akonadi/mysql.conf", > > {st_mode=S_IFREG|0644, st_size=3486, ...}) = 0 > > open("/home/USERNAME/.local/share/akonadi/mysql.conf", O_RDONLY) = -1 > > EACCES (Permission denied) > > write(2, "Could not open required defaults"..., 84Could not open required > > defaults file: /home/USERNAME/.local/share/akonadi/mysql.conf > > ) = 84 > > write(2, "Fatal error in defaults handling"..., 50Fatal error in defaults > > handling. Program aborted > > ) = 50 > > exit_group(1) = ? > > +++ exited with 1 +++ -- PD Dr. Johannes Ranke Kronacher Str. 12 79639 Grenzach-Wyhlen
signature.asc
Description: This is a digitally signed message part.
