#1  
Old 24th September 2009, 20:58
bholt bholt is offline
Junior Member
 
Join Date: Sep 2009
Location: Georgia, USA
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Default MySQL Startup Failure

Using The Perfect Server - CentOS 5.3 x86_64 [ISPConfig 3]

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

[root@tsvr ~]#tail /var/log/mysqld.log
090924 14:27:53 mysqld started
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
090924 14:27:53 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
090924 14:27:53 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090924 14:27:54 InnoDB: Started; log sequence number 0 43655
090924 14:27:54 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
090924 14:27:54 [ERROR] Can't start server: can't create PID file: Permission denied
090924 14:27:54 mysqld ended

[root@tsvr ~]# tail /var/log/mysqld.log
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
090924 14:27:53 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090924 14:27:54 InnoDB: Started; log sequence number 0 43655
090924 14:27:54 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
090924 14:27:54 [ERROR] Can't start server: can't create PID file: Permission denied
090924 14:27:54 mysqld ended

Permissions:
drwxr-xr-x 2 mysql mysql 4096 Sep 24 10:38 mysqld

Running on: Dell PE2950 w/64bit Processor
I am also installing on an i386 machine and are not having these problems.
Thanks,
Bill
Reply With Quote
Sponsored Links
  #2  
Old 24th September 2009, 21:53
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default

What are the permissions of .pid file /var/run/mysqld/mysqld.pid ??
Reply With Quote
  #3  
Old 25th September 2009, 02:08
bholt bholt is offline
Junior Member
 
Join Date: Sep 2009
Location: Georgia, USA
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Default MySQL Startup error

[root@tsvr ~]# ls -la /var/run/mysqld/mysqld.pid
ls: /var/run/mysqld/mysqld.pid: No such file or directory

Permissions for the directory are:

[root@tsvr ~]# ls -la /var/run/mysqld
total 8
drwxr-xr-x 2 mysql mysql 4096 Sep 24 14:38 .
drwx-----T 8 root root 4096 Sep 24 13:44 ..
Reply With Quote
  #4  
Old 25th September 2009, 12:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
Default

Please do this:
Code:
chmod 755 /var/run
__________________
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
  #5  
Old 25th September 2009, 16:02
bholt bholt is offline
Junior Member
 
Join Date: Sep 2009
Location: Georgia, USA
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
 
Smile MySQL Startup Failure

Thanks Falko,
That did the trick!
Bill
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
libWand.so.10 error Taxick Installation/Configuration 8 3rd May 2009 01:27
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Howto suggestion suse PhP ver 4 + Ver 5 wwparrish Suggest HOWTO 11 7th August 2006 13:29
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 18:52.


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