Forwarding issue to pkg-mysql-maint as requested by Robie Basak. If there are 
any questions, feel free to ask.

Hey,

I have no glue why mysql refuses to start. Did you tried to copy the data dir 
to tmp and try again?

Maybe mysql maintainer can help here, why mysqld doesn't want to start.
mysqld tells us, that the defaults-file and data dir is not accessable anymore 
with the new version. But if we use ls to show file permissions it tells us, 
that the permissions are okay (644/755).
The background is, that akonadi starts an mysqld with datadir= /home/
<USER>/.local/share/akonadi/db_data/
as <USER>. 

You can see the complete mysql.cnf in the bugreport https://bugs.debian.org/
cgi-bin/bugreport.cgi?bug=843534#55 (Test 8)

Best Regards,

sandro

--
Am Donnerstag, 10. November 2016, 13:33:44 CET schrieb Johannes Ranke:
> 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 +++

Attachment: signature.asc
Description: This is a digitally signed message part.

Reply via email to