Mysql fails to start - please help

[Huw Dixon]

Hi - mysql will no longer start on my system. The log file shows:

080401 19:16:08 mysqld started
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib6hnIpA' (Errcode: 13)
080401 19:16:08 InnoDB: Error: unable to create temporary file; errno: 13
080401 19:16:08 [ERROR] bdb: /var/lib/mysql: Permission denied
080401 19:16:08 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
080401 19:16:08 [ERROR] bdb: PANIC: Permission denied
080401 19:16:08 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
080401 19:16:08 [ERROR] bdb: fatal region error detected; run recovery
080401 19:16:08 [ERROR] bdb: /var/lib/mysql: Permission denied
080401 19:16:08 [ERROR] Can't start server : Bind on unix socket: Permission denied
080401 19:16:08 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
080401 19:16:08 [ERROR] Aborting

080401 19:16:08 [Note] /usr/libexec/mysqld: Shutdown complete

080401 19:16:08 mysqld ended

I've checked the perms, owners, groups on /tmp and /var/tmp and make sure they were set with:
chmod 1777 /tmp; chmod 1777 /var/tmp

/var/lib/mysql directory is set to mysql:mysql
The permissions are all as you see below:

drwxrwxrwt 3 root root 4096 2008-04-01 17:48 /tmp
drwxrwxrwt 2 root root 4096 2008-03-31 09:15 /var/tmp
drwxr-xr-x 7 mysql mysql 4096 2008-04-01 19:16 /var/lib/mysql

The perms within the /var/lib/mysql directory are:

drwx------ 2 mysql mysql 4096 2008-04-01 13:19 school
drwx------ 2 mysql mysql 4096 2008-01-26 11:14 gallery2
-rw-rw---- 1 mysql mysql 18874368 2008-04-01 13:43 ibdata1
-rw-rw---- 1 mysql mysql 5242880 2008-04-01 13:43 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2008-01-26 07:56 ib_logfile1
drwx------ 2 mysql mysql 4096 2008-01-26 07:56 mysql
drwx------ 2 mysql mysql 4096 2008-01-26 07:56 test


df -h reports:
]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
80G 12G 65G 16% /
/dev/cciss/c0d0p1 193M 13M 171M 7% /boot
tmpfs 1014M 0 1014M 0% /dev/shm

Selinux is disabled.

The log points to a permissions problem but I dont know where else to look
for possible permission problems.

Any suggestions?

Thanks



Edited 1 time(s). Last edit at 04/02/2008 08:31AM by Huw Dixon.