Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 24th April 2007, 11:26
gavino gavino is offline
Junior Member
 
Join Date: Apr 2007
Location: Brisbane Australia
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default LAMP System Fedora Core 6 MySQL start error

Hi
I was following the tutorial by Falko A LAMP System With Fedora Core 6 and I get to paragraph 9 MySQL (5.0) and try to start mysqld as follows:

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

I have google for days but still don't know what to do. I am newbie. I think
I am root, I only have root user as far as I know. I don't know where to
find the <hostname>.err log. or the sqld data directory. I used locate command ie locate / -name mysql*.err but nothing.

Any suggestions appreciated.
Thanks..gavino
Reply With Quote
Sponsored Links
  #2  
Old 25th April 2007, 13:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

What's the output of
Code:
netstat -tap
? Do you find any MySQL errors in the logs in /var/log/?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 26th April 2007, 08:14
gavino gavino is offline
Junior Member
 
Join Date: Apr 2007
Location: Brisbane Australia
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hi there

What's the output of netstat -tap
Typed up as follows:

[root@aimsafe ~]# netstat -tap

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address Stat
e PID/Program name
tcp 0 0 *:sunrpc *:* List
EN 1594/portmap
tcp 0 0 *:946 *:* List
EN 1612/rpc.statd
tcp 0 0 localhost.localdomai:domain *:* List
EN 1572/named
tcp 0 0 localhost.localdomain:ipp *:* List
EN 1769/cupsd
tcp 0 0 localhost.localdomain:smtp *:* List
EN 2040/sendmail: acce
tcp 0 0 localhost.localdomain:rndc *:* List
EN 1572/named
tcp 0 0 aimsafe.programs.com:domain *:* List
EN 1572/named
tcp 0 0 *:ssh *:* List
EN 1777sshd
tcp 0 0 aimsafe.programs.com:ipp *:* List
EN 1769/cupsd
tcp 0 0 aimsafe.programs.com:rndc *:* List
EN 1572/named

---------------------------------------------------
Do you find any MySQL errors in the logs in /var/log/?
Yes. I have typed log out as follows:

070427 01:55:50 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/ib2AsGQr' (Errcode: 13)
070427 1:55:51 InnoDB: Error: unable to create temporary file; errno: 13
070427 1:55:51 [ERROR] bdb: /var/lib/mysql: Permission denied
070427 1:55:51 [ERROR] bdb: /var/lib/mysql/log.0000000001: Permission denied
070427 1:55:51 [ERROR] bdb: PANIC: Permission denied
070427 1:55:51 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
070427 1:55:51 [ERROR] bdb: fatal region error detected; run recovery
070427 1:55:51 [ERROR] bdb: /var/lib/mysql: Permission denied
070427 1:55:51 [ERROR] Can't start server : Bind on unix socket: Permission denied
070427 1:55:51 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070427 1:55:51 [ERROR] Aborting

070427 1:55:51 [Note] /usr/libexec/mysqld: Shutdown complete

070427 01:55:51 mysqld ended

Regards..Gavino
Reply With Quote
  #4  
Old 26th April 2007, 10:29
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,503
Thanks: 813
Thanked 5,265 Times in 4,129 Posts
Default

Your /tmp directory seems to be not writable or full. Please post the output of:

df -h

and

ls -la /tmp
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 27th April 2007, 05:14
gavino gavino is offline
Junior Member
 
Join Date: Apr 2007
Location: Brisbane Australia
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thanks Till, Here are output of [df -h] & [ls -la /tmp]:

# df -h
-------
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
72G 2.3G 66G 4% /
/dev/hda1 99M 11M 84M 12% /boot
tmpfs 125M 0 125M 0% /dev/shm

# ls -la /tmp
----------
total 32
drwxrwxrwt 4 root root 4096 Apr 27 19:33 .
d-w-------23 root root 4096 Apr 27 19:32 ..
drwxrwxrwt 2 root root 4096 Apr 27 19:33 .font-unix
drwxrwxrwt 2 root root 4096 Apr 27 19:32 .ICE-unix
d-w------- 1 root root 1024 Apr 27 19:30 .rnd


[off topic..I can't use the tab key to line up columns, so its jumbled, how to do it?]
Regards..gavino

Last edited by gavino; 27th April 2007 at 05:30.
Reply With Quote
  #6  
Old 27th April 2007, 14:21
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

What's the output of
Code:
ls -la /
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 28th April 2007, 04:19
gavino gavino is offline
Junior Member
 
Join Date: Apr 2007
Location: Brisbane Australia
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default

thanks for reply Falko

output of (ls -la /) is:

total 178
d-w------- 23 root root 4096 Apr 28 20:24 .
d-w------- 23 root root 4096 Apr 28 20:24 ..
-rw------- 1 root root 7168 Apr 28 20:24 aquota.group
-rw------- 1 root root 6144 Apr 28 21:30 aquota.user
-rw-r--r-- 1 root root 0 Apr 28 20:24 .autofsck
-rw-r--r-- 1 root root 0 Apr 22 04:53 .autorelabel
drwxr-xr-x 2 root root 4096 Apr 23 23:43 bin
drwxr-xr-x 4 root root 1024 Apr 22 03:59 boot
drwxr-xr-x 12 root root 4000 Apr 28 20:25 dev
drwxr-xr-x 91 root root 12288 Apr 28 20:24 etc
drwxr-xr-x 2 root root 4096 Oct 11 2006 home
drwxr-xr-x 14 root root 4096 Apr 23 23:41 lib
drwx------ 2 root root 16384 Apr 22 03:43 lost+found
drwxr-xr-x 2 root root 4096 Apr 22 04:39 media
drwxr-xr-x 2 root root 0 Apr 28 20:24 misc
drwxr-xr-x 2 root root 4096 Oct 11 2006 mnt
drwxr-xr-x 2 root root 0 Apr 28 20:24 net
drwxr-xr-x 2 root root 4096 Oct 11 2006 opt
dr-xr-xr-x 65 root root 0 Apr 28 20:23 proc
-rw-r--r-- 1 root root 0 Apr 24 01:28 quota.group
-rw-r--r-- 1 root root 0 Apr 24 02:42 quota.user
drwxr-x--- 2 root root 4096 Apr 27 00:43 root
drwxr-xr-x 2 root root 12288 Apr 24 02:52 sbin
drwxr-xr-x 2 root root 4096 Apr 22 03:44 selinux
drwxr-xr-x 2 root root 4096 Oct 11 2006 srv
drwxr-xr-x 11 root root 0 Apr 28 20:23 sys
drwxrwxrwt 4 root root 4096 Apr 28 21:45 tmp
drwxr-xr-x 14 root root 4096 Apr 22 03:52 usr
drwxr-xr-x 25 root root 4096 Apr 22 04:15 var

regards ..gavino
Reply With Quote
  #8  
Old 28th April 2007, 18:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Quote:
Originally Posted by gavino
thanks for reply Falko

output of (ls -la /) is:

total 178
d-w------- 23 root root 4096 Apr 28 20:24 .
d-w------- 23 root root 4096 Apr 28 20:24 ..
This looks wrong. Did you accidentally do a chmod on /?
It should look like this instead:
Code:
mh1:~# ls -la /
insgesamt 4317
drwxr-xr-x   20 root     root         4096  7. Mär 13:47 .
drwxr-xr-x   20 root     root         4096  7. Mär 13:47 ..
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 29th April 2007, 13:59
gavino gavino is offline
Junior Member
 
Join Date: Apr 2007
Location: Brisbane Australia
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thanks Falko and Till, it's fixed, ok now, SQL starts without error.
I did this (chmod 755 /) and the (ls -la /) is now ok.
drwxr-xr-x 23 root root 4096 Apr 28 20:24 .
drwxr-xr-x 23 root root 4096 Apr 28 20:24 ..
Thanks again...gavino

-------------
Quote:
Originally Posted by falko
This looks wrong. Did you accidentally do a chmod on /?
It should look like this instead:
Code:
mh1:~# ls -la /
insgesamt 4317
drwxr-xr-x   20 root     root         4096  7. Mär 13:47 .
drwxr-xr-x   20 root     root         4096  7. Mär 13:47 ..
Reply With Quote
  #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
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
configuring IPTABLES firewall adityavpratap HOWTO-Related Questions 9 27th May 2006 21:42
Frustrated with ISPConfig install! woozyerdaddee Installation/Configuration 4 19th May 2006 03:38
Installation Fails... :( cyberstorm Installation/Configuration 1 15th January 2006 18:07
Could not make OpenSSL yontengyatso Installation/Configuration 3 3rd November 2005 10:50
Install stop at uuwish, UUDeview SeaWolf Installation/Configuration 6 4th October 2005 23:53


All times are GMT +2. The time now is 20:06.


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