Systemctl hates mysqld: refuses to start Fedora 16 (LONG)

[Dale Dellutri]

On Mon, Jul 2, 2012 at 8:55 AM, R. G. Newbury <newbury at mandamus.org> wrote:
>...
>  **** Systemctl startup:
>
>  20701 12:23:23 mysqld_safe Starting mysqld daemon with databases from
>  /var/lib/mysql
>  120701 12:23:23 [Note] Plugin 'FEDERATED' is disabled.
>  120701 12:23:23 InnoDB: The InnoDB memory heap is disabled
>  120701 12:23:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
>  120701 12:23:23 InnoDB: Compressed tables use zlib 1.2.5
>  120701 12:23:23 InnoDB: Using Linux native AIO
>
>  ********** HERE IS THE ERROR
>
>  ^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ibVcsIip'
>  (Errcode: 13)
>  120701 12:23:23  InnoDB: Error: unable to create temporary file; errno: 13
>  120701 12:23:23 [ERROR] Plugin 'InnoDB' init function returned error.
>  120701 12:23:23 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
>  failed.
>  120701 12:23:23 [ERROR] Unknown/unsupported storage engine: InnoDB
>  120701 12:23:23 [ERROR] Aborting
>
>  120701 12:23:23 [Note] /usr/libexec/mysqld: Shutdown complete

Did you see this bugzilla?
  https://bugzilla.redhat.com/show_bug.cgi?id=782513
  Bug 782513 - Propose that you turn on PrivateTmp=true in service
file for mysql
The workaround is:
  I've edited the unit file to remove PrivateTmp, after which mysql starts
  #PrivateTmp=true
Relevant?

-- 
Dale Dellutri