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-WyhlenAttachment:
signature.asc
Description: This is a digitally signed message part.