#1  
Old 20th November 2007, 01:46
brainz brainz is offline
Senior Member
 
Join Date: Feb 2006
Location: Sydney, Australia
Posts: 165
Thanks: 9
Thanked 3 Times in 1 Post
Default mysql problem ???

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
Reply With Quote
Sponsored Links
  #2  
Old 20th November 2007, 06:09
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 typed this command and this is a the output i got.

[root@xxxxx ]# mysqladmin shutdown

Quote:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
i also did this and what is funny it mysql -p


and i got this... enter password:

i enter the password and get this

Quote:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
please any help would be apreciated...

regards
brainz
__________________
www.baktim.com
Reply With Quote
  #3  
Old 20th November 2007, 10:00
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,372
Thanks: 833
Thanked 5,478 Times in 4,313 Posts
Default

Please run:

chmod 777 /tmp
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 20th November 2007, 10:14
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 Till,

I have dont this command Till but it still does not allow me to start mysqld.

this is what i get..

Quote:
[root@xxxxx ~]# chmod 777 /tmp
[root@xxxxx ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
Ohh yes and Till did you get my email ???

regards
brainz
__________________
www.baktim.com

Last edited by brainz; 20th November 2007 at 10:17.
Reply With Quote
  #5  
Old 20th November 2007, 10:17
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,372
Thanks: 833
Thanked 5,478 Times in 4,313 Posts
Default

Ok, then check which error you get now in the mysqld.log
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 20th November 2007, 10:24
brainz brainz is offline
Senior Member
 
Join Date: Feb 2006
Location: Sydney, Australia
Posts: 165
Thanks: 9
Thanked 3 Times in 1 Post
Default

Till hi,

This what i did..

I deleted /var/log/mysqld.log

then i tried to start mysqld and got this
Quote:
[root@xxxxx ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
then i checked the /var/log/mysqld.log and got this...


Quote:
071120 20:21:28 mysqld started
071120 20:21:28 InnoDB: Started; log sequence number 0 43685
071120 20:21:28 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 20:21:28 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
071120 20:21:28 [ERROR] bdb: PANIC: Permission denied
071120 20:21:28 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
071120 20:21:28 [ERROR] bdb: fatal region error detected; run recovery
071120 20:21:28 [ERROR] bdb: /var/lib/mysql: Permission denied
071120 20:21:28 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
071120 20:21:28 [ERROR] Can't start server: can't create PID file: Permission denied
071120 20:21:28 mysqld ended
regards
brainz
__________________
www.baktim.com
Reply With Quote
  #7  
Old 20th November 2007, 10:27
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,372
Thanks: 833
Thanked 5,478 Times in 4,313 Posts
Default

Looks as if you changed permissions of folders on your system recursively. Please post the output of:

ls -la /var/lib/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 20th November 2007, 10:39
brainz brainz is offline
Senior Member
 
Join Date: Feb 2006
Location: Sydney, Australia
Posts: 165
Thanks: 9
Thanked 3 Times in 1 Post
Default

Till here is the output of

ls -la /var/lib/

Quote:
[root@xxxxx gdm]# ls -la /var/lib/
total 212
drwxrwxr-x 29 root root 4096 Nov 20 15:43 .
drwxr-x--- 29 109 112 4096 Nov 14 22:47 ..
drwx------ 2 root root 4096 Mar 13 2006 aide
drwxr-xr-x 2 root root 4096 May 28 07:35 alternatives
drwxr-xr-x 3 amanda disk 4096 May 22 20:05 amanda
drwxr-xr-x 3 root root 4096 Jun 3 19:45 apt
drwxr-xr-x 3 root root 4096 Jun 19 08:17 backuppc
drwxr-xr-x 2 root root 4096 Aug 24 2006 cs
drwx------ 2 apache apache 4096 Jun 27 00:23 dav
drwx------ 2 root root 4096 Oct 5 00:58 denyhosts
drwxr-xr-x 2 root root 4096 Jun 9 2006 dhclient
drwxr-x--- 2 root root 4096 Feb 11 2006 dhcpv6
drwxr-xr-x 2 root root 4096 Feb 12 2006 games
drwxr-xr-x 2 root root 4096 Feb 12 2006 htdig
drwx------ 2 root root 4096 Sep 12 20:01 iptraf
-rw-r--r-- 1 root root 1989 Nov 20 05:27 logrotate.status
drwxr-xr-x 2 root root 4096 May 22 22:33 misc
drwxr-x--- 2 root slocate 4096 Nov 20 05:27 mlocate
drwxr-xr-x 2 root root 4096 Mar 30 2006 mrtg
drwxr-xr-x 15 mysql mysql 4096 Nov 20 20:30 mysql
drwxr-xr-x 4 mysql mysql 4096 Nov 20 16:00 mysqld
drwxr-xr-x 5 root root 4096 May 25 00:09 nfs
drwxr-xr-x 2 ntp ntp 4096 Nov 14 22:42 ntp
drwxr-xr-x 3 root root 4096 May 10 2007 php
-rw------- 1 root root 512 Nov 20 20:06 random-seed
drwxr-xr-x 2 rpm rpm 4096 Nov 20 09:42 rpm
drwxr-xr-x 36 root root 4096 May 28 07:31 scrollkeeper
drwxr-xr-x 2 root root 4096 Jun 13 06:28 spamassassin
drwxrwxrwt 2 root root 4096 May 26 01:53 texmf
drwxr-xr-x 2 webalizer root 4096 May 24 04:02 webalizer
drwxr-xr-x 2 root root 4096 Nov 20 20:07 xkb
ohhh and this...

drwxr-xr-x 15 mysql mysql 4096 Nov 20 20:30 mysql
drwxr-xr-x 4 mysql mysql 4096 Nov 20 16:00 mysqld

i think i did this by changing the /etc/my.cnf

datadir=/var/lib/mysql

to

datadir=/var/lib/mysqld

but this didnt work...

so i changed it back and now have deleted the

drwxr-xr-x 4 mysql mysql 4096 Nov 20 16:00 mysqld

folder


regards
brainz
__________________
www.baktim.com

Last edited by brainz; 20th November 2007 at 10:43.
Reply With Quote
  #9  
Old 20th November 2007, 10:50
brainz brainz is offline
Senior Member
 
Join Date: Feb 2006
Location: Sydney, Australia
Posts: 165
Thanks: 9
Thanked 3 Times in 1 Post
 
Default

Also Till,

I have a monitor connected to the server and when i turn the monitor on it has this following message...

Quote:
SERVER AUTHORIZATION Directory (daemon/ServAuthDir) is set to /var/gdm but this does not exist.

Please correct GDM Configuration and restart GDM.
with this one i checked the /var/gdm and it does exist... but the daemon/ServAuthDir i have no idea what this means...

regards
brainz
__________________
www.baktim.com
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
postfix mysql on fedora core5 igongora Installation/Configuration 7 17th April 2007 04:40
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 10:39.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.