mysql50-server unable to start

[Jeremy Chadwick]

On Tue, Mar 06, 2007 at 01:29:12PM +0100, ml at sd2i.com wrote:
> I just update my port tree and add mysql50-server with portinstall 
> database/mysql50-server
> # $FreeBSD: ports/databases/mysql50-server/Makefile,v 1.223 2007/01/26 
> 22:39:58 ale Exp $
> 
> but mysql don't want to start :
> 
> 070306 13:23:53  mysqld started
> ^G/usr/local/libexec/mysqld: Can't create/write to file 
> '/var/tmp/ibNI5XcU' (Err
> code: 13)
> 070306 13:23:53  InnoDB: Error: unable to create temporary file; errno: 13

It looks like /var/tmp is missing, or has some permissions which are
incorrect.  errno 13 = Permission denied.  /var/tmp should be perm 1777
(the stickybit is important):

drwxrwxrwt    3 root      wheel     512  4 Mar 21:56 /var/tmp/

You may also want to check permissions of things from the root
filesystem all the way up, e.g. ls -ld / && ls -ld /var && ls -ld
/var/tmp.

> 070306 13:23:53 [ERROR] Can't start server : Bind on unix socket: 
> Permission den
> ied
> 070306 13:23:53 [ERROR] Do you already have another mysqld server 
> running on soc
> ket: /tmp/mysql.sock ?

Possibly related to the previous error.  If not, possibly you have
something listening on port 3306 already.  If not, check your
permissions on /tmp (should be the same as /var/tmp).  If those are
fine, possibly you have some ipfw/pf rules which are denying something
to bind to port 3306?

-- 
| Jeremy Chadwick                                 jdc at parodius.com |
| Parodius Networking                        http://www.parodius.com/ |
| UNIX Systems Administrator                   Mountain View, CA, USA |
| Making life hard for others since 1977.               PGP: 4BD6C0CB |