Comment 5 for bug 1012058

Revision history for this message
Brian R. Hellman (brian-linbit) wrote :

This workaround didn't work for me... I tried running it from the command line and got this:

root@w3:/etc/init# mysqld --config /etc/mysql/my.cnf --user=mysql --verbose
120612 9:17:07 [Note] Plugin 'FEDERATED' is disabled.
120612 9:17:07 InnoDB: The InnoDB memory heap is disabled
120612 9:17:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120612 9:17:07 InnoDB: Compressed tables use zlib 1.2.3.4
mysqld: Can't create/write to file '/tmp/ibwIP7DX' (Errcode: 13)
120612 9:17:07 InnoDB: Error: unable to create temporary file; errno: 13
120612 9:17:07 [ERROR] Plugin 'InnoDB' init function returned error.
120612 9:17:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120612 9:17:07 [ERROR] mysqld: unknown option '--config'
120612 9:17:07 [ERROR] Aborting

Obviously the --config option is wrong, but the important line is:
mysqld: Can't create/write to file '/tmp/ibwIP7DX' (Errcode: 13)

After using: 'setfacl -m u:mysql:rwx /tmp' I can now start mysql I tried adding /tmp/** rwk, to the apparmor profile but that didn't work.

Hopefully this helps someone figure out what the real issue is, but in the meantime for anyone that got bit by this, that's the workaround that did it for me.