View Single Post
  #10  
Old 19th November 2007, 16:41
brainz brainz is offline
Senior Member
 
Join Date: Feb 2006
Location: Sydney, Australia
Posts: 165
Thanks: 9
Thanked 3 Times in 1 Post
Default

Hi Guys,

i have problem with mysqld as well and it will not start...

the mysqld.log has this in it
Quote:
071120 01:54:25 mysqld started
^G/usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13)
^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ibfOkm25' (Errcode: 13)
071120 1:54:26 InnoDB: Error: unable to create temporary file; errno: 13
071120 1:54:26 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 1:54:26 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
071120 1:54:26 [ERROR] bdb: PANIC: Permission denied
071120 1:54:26 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
071120 1:54:26 [ERROR] bdb: fatal region error detected; run recovery
071120 1:54:26 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 1:54:26 [ERROR] Can't start server : Bind on unix socket: Permission denied
071120 1:54:26 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
071120 1:54:26 [ERROR] Aborting

071120 1:54:26 [Note] /usr/libexec/mysqld: Shutdown complete

071120 01:54:26 mysqld ended
here is the output of df -h

Quote:
[root@xxxx log]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda2 72G 6.8G 62G 10% /
/dev/hda1 99M 13M 81M 14% /boot
tmpfs 221M 0 221M 0% /dev/shm
here is the output of ls -la /

Quote:
[root@xxxxx]# ls -la /
total 254
drwxr-xr-x 24 109 112 4096 Nov 20 01:54 .
drwxr-xr-x 24 109 112 4096 Nov 20 01:54 ..
-rw------- 1 root root 16384 Nov 20 02:06 aquota.group
-rw------- 1 root root 17408 Nov 20 02:06 aquota.user
-rw-r--r-- 1 root root 0 Nov 20 01:54 .autofsck
drwxr-x--- 2 109 112 4096 Nov 18 22:02 .automount
-rw-r--r-- 1 root root 0 May 22 20:27 .autorelabel
drwxr-x--- 2 109 112 4096 Nov 18 22:02 bin
drwxr-xr-x 4 root root 1024 Jun 24 17:22 boot
drwxr-xr-x 11 root root 4180 Nov 20 02:20 dev
drwxr-xr-x 101 root root 12288 Nov 20 01:54 etc
drwxr-xr-x 4 root root 4096 Jun 18 23:21 home
drwxr-xr-x 11 root root 4096 Jul 2 05:00 lib
drwx------ 2 root root 16384 May 23 05:54 lost+found
drwxr-xr-x 2 root root 4096 May 26 14:37 media
drwxr-xr-x 2 root root 4096 Oct 25 2006 misc
drwxr-xr-x 2 root root 4096 Feb 12 2006 mnt
drwxr-xr-x 2 root root 0 Nov 20 01:54 net
drwxr-xr-x 2 root root 4096 Feb 12 2006 opt
dr-xr-xr-x 113 root root 0 Nov 20 2007 proc
-rw------- 1 root root 1024 Nov 10 06:45 .rnd
drwxr-x--- 17 root root 4096 Nov 20 01:18 root
drwxr-xr-x 2 root root 12288 Nov 19 04:59 sbin
drwxr-xr-x 2 root root 4096 May 22 19:54 selinux
drwxr-xr-x 2 root root 4096 Feb 12 2006 srv
drwxr-xr-x 11 root root 0 Nov 20 2007 sys
drwxr-xr-x 27 root root 36864 Nov 20 02:31 tmp
drwxr-xr-x 14 root root 4096 May 22 20:00 usr
drwxr-x--- 29 109 112 4096 Nov 14 22:47 var
-rw-r--r-- 1 root root 2085 Jun 24 20:36 webmin-setup.out




i try to start mysqld but i get this...

Quote:
[root@xxxxx]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

I also did this chmod 755 /
What is did is brought up the ispconfig login page but when i try to login i get all sorts of mysqld errors due to it not being able to start..

Please help.....

hi the mysqld.log seems to have updated itself to

Quote:
071120 08:57:12 mysqld started
071120 8:57:12 InnoDB: Started; log sequence number 0 43685
071120 8:57:12 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 8:57:12 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
071120 8:57:12 [ERROR] bdb: PANIC: Permission denied
071120 8:57:12 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
071120 8:57:12 [ERROR] bdb: fatal region error detected; run recovery
071120 8:57:12 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 8:57:12 [ERROR] Can't start server : Bind on unix socket: Permission denied
071120 8:57:12 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
071120 8:57:12 [ERROR] Aborting

071120 8:57:12 InnoDB: Starting shutdown...
071120 8:57:14 InnoDB: Shutdown completed; log sequence number 0 43685
071120 8:57:14 [Note] /usr/libexec/mysqld: Shutdown complete

071120 08:57:14 mysqld ended
please any help would be appreciated...


regards
brainz
__________________
www.baktim.com

Last edited by brainz; 19th November 2007 at 23:09.
Reply With Quote