#1  
Old 5th October 2012, 13:35
destinedjagold destinedjagold is offline
Junior Member
 
Join Date: Aug 2012
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
Default MySQL-related problem

I don't understand what happened. I haven't touched the server in a while, and when I typed the code
Code:
service mysqld start
CentOS 6.3 replies with an
Code:
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
I looked though the log files, and it gave me this...
Code:
121005 18:05:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121005 18:05:42 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
121005 18:05:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121005 18:05:42 InnoDB: The InnoDB memory heap is disabled
121005 18:05:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121005 18:05:42 InnoDB: Compressed tables use zlib 1.2.3
121005 18:05:42 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibwnGp95' (Errcode: 13)
121005 18:05:43  InnoDB: Error: unable to create temporary file; errno: 13
121005 18:05:43 [ERROR] Plugin 'InnoDB' init function returned error.
121005 18:05:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121005 18:05:43 [ERROR] Unknown/unsupported storage engine: InnoDB
121005 18:05:43 [ERROR] Aborting
I have been searching around Google for a day now, and every single solution I land upon, it didn't help me with my problem.

Additional note...
- typing mysql_upgrade results in this...
Code:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Another note...
- the latest version of MySQL is version 5.5.28. Is there a way to let CentOS download and install MySQL version 5.5.25* ?

Any help would be greatly appreciated. Thank you.
Reply With Quote
Sponsored Links
  #2  
Old 6th October 2012, 11:57
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

Can you run
Code:
df -h
to check if any of your partitions is full?
__________________
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 8th October 2012, 05:15
destinedjagold destinedjagold is offline
Junior Member
 
Join Date: Aug 2012
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
Can you run
Code:
df -h
to check if any of your partitions is full?
Thank you for the reply.
And yes, I can check the partitions, but none of them are full. None are even beyond 20% of usage as of this moment.
Reply With Quote
  #4  
Old 8th October 2012, 14:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

Can you post the output of
Code:
 ls -la /tmp/
?
__________________
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 9th October 2012, 05:09
destinedjagold destinedjagold is offline
Junior Member
 
Join Date: Aug 2012
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
Can you post the output of
Code:
 ls -la /tmp/
?
Thanks for the reply, and yes, here it is.
Quite long though...

Code:
total 354772
drwxrwxrwx.  8 root       root            4096 Oct  9 09:54 .
drwx------. 28 apache     root            4096 Oct  9 09:54 ..
-rw-r--r--.  1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm
-rw-r--r--   1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm.1
-rw-r--r--   1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm.2
drwx------.  2 devuser    devuser         4096 Aug 17 12:05 .esd-500
drwxrwxrwt   2 root       root            4096 Oct  9 09:54 .ICE-unix
drwxr-xr-x.  8 root       root            4096 Jun 18 22:31 ispconfig3_install
-rw-r--r--   1 root       root         2711250 Jun 18 22:31 ISPConfig-3-stable.tar.gz
-rw-r--r--   1 root       root         2711250 Jun 18 22:31 ISPConfig-3-stable.tar.gz.1
-rw-r--r--   1 root       root       357283840 Oct  4 18:36 mysql-5.5.2-m2-linux-i686-glibc23.tar
drwxr-xr-x   6 root       root            4096 Oct  3 17:56 mysql_backup_oct3
drwx------.  2 gdm        gdm             4096 Oct  2 09:14 pulse-DkNw0mZCgMcC
-rw-r--r--   1 root       root           12700 Nov 13  2010 rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
-rw-r--r--   1 root       root           12700 Nov 13  2010 rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm.1
-r--r--r--   1 root       root              11 Oct  9 09:54 .X0-lock
drwxrwxrwt   2 root       root            4096 Oct  9 09:54 .X11-unix
-rw-------   1 root       root             303 Aug 31 12:01 yum_save_tx-2012-08-31-12-01QAuEn6.yumtx
-rw-------   1 root       root             299 Sep 10 11:02 yum_save_tx-2012-09-10-11-02VjE7Sv.yumtx
-rw-------   1 root       root             289 Sep 12 18:11 yum_save_tx-2012-09-12-18-11cqsiXI.yumtx
-rw-------   1 root       root             304 Sep 13 12:39 yum_save_tx-2012-09-13-12-39bk4ED3.yumtx
-rw-------   1 root       root            2841 Sep 20 14:32 yum_save_tx-2012-09-20-14-32E3Xg9z.yumtx
-rw-------   1 root       root             300 Sep 20 16:14 yum_save_tx-2012-09-20-16-14kioNyQ.yumtx
-rw-------   1 root       root           11322 Sep 21 11:16 yum_save_tx-2012-09-21-11-16Tl7fC8.yumtx
-rw-------   1 root       root             299 Sep 21 13:02 yum_save_tx-2012-09-21-13-0222AwND.yumtx
-rw-------   1 root       root             516 Sep 21 15:08 yum_save_tx-2012-09-21-15-08R9GxT6.yumtx
-rw-------   1 root       root             516 Sep 21 15:10 yum_save_tx-2012-09-21-15-10YDd07F.yumtx
-rw-------   1 root       root             516 Sep 21 15:13 yum_save_tx-2012-09-21-15-13sB_26z.yumtx
-rw-------   1 root       root            1451 Sep 21 15:16 yum_save_tx-2012-09-21-15-16HXR_sp.yumtx
-rw-------   1 root       root             516 Sep 21 15:17 yum_save_tx-2012-09-21-15-17ljS4V5.yumtx
-rw-------   1 root       root           56199 Sep 21 15:22 yum_save_tx-2012-09-21-15-22tNzfmH.yumtx
-rw-------   1 root       root            8131 Sep 28 11:56 yum_save_tx-2012-09-28-11-56RwBhCi.yumtx
-rw-------   1 root       root            8343 Oct  3 16:22 yum_save_tx-2012-10-03-16-22yNzUUd.yumtx
-rw-------   1 root       root            8343 Oct  3 16:31 yum_save_tx-2012-10-03-16-31RuiN93.yumtx
-rw-------   1 root       root            8343 Oct  3 16:32 yum_save_tx-2012-10-03-16-32uOjqn2.yumtx
-rw-------   1 root       root            8283 Oct  3 16:51 yum_save_tx-2012-10-03-16-51yGBWpl.yumtx
-rw-------   1 root       root            8343 Oct  3 16:52 yum_save_tx-2012-10-03-16-52_0COYu.yumtx
-rw-------   1 root       root            8307 Oct  3 16:55 yum_save_tx-2012-10-03-16-55ZmuVSv.yumtx
-rw-------   1 root       root            8343 Oct  3 17:05 yum_save_tx-2012-10-03-17-05xDzPMJ.yumtx
-rw-------   1 root       root            8307 Oct  3 17:18 yum_save_tx-2012-10-03-17-18eWeaxV.yumtx
-rw-------   1 root       root           14991 Oct  3 17:31 yum_save_tx-2012-10-03-17-31E6pP33.yumtx
-rw-------   1 root       root            8343 Oct  4 10:27 yum_save_tx-2012-10-04-10-27oVQjbA.yumtx
-rw-------   1 root       root            8343 Oct  4 10:45 yum_save_tx-2012-10-04-10-452GW5ka.yumtx
-rw-------   1 root       root            8307 Oct  4 12:01 yum_save_tx-2012-10-04-12-01WnzpoY.yumtx
-rw-------   1 root       root           14991 Oct  4 12:02 yum_save_tx-2012-10-04-12-027MBN6v.yumtx
-rw-------   1 root       root            8283 Oct  4 15:45 yum_save_tx-2012-10-04-15-45HTNkJA.yumtx
-rw-------   1 root       root             291 Oct  4 16:31 yum_save_tx-2012-10-04-16-31eCnxtg.yumtx
-rw-------   1 root       root            8283 Oct  4 18:21 yum_save_tx-2012-10-04-18-21DeCo1h.yumtx
-rw-------   1 root       root            8283 Oct  4 18:25 yum_save_tx-2012-10-04-18-25xEeehY.yumtx
-rw-------   1 root       root            8283 Oct  4 18:26 yum_save_tx-2012-10-04-18-26Ce2_pV.yumtx
-rw-------   1 root       root             299 Oct  5 12:35 yum_save_tx-2012-10-05-12-35MyY3Rz.yumtx
-rw-------   1 root       root             977 Oct  5 12:35 yum_save_tx-2012-10-05-12-35TDvVRy.yumtx
-rw-------   1 root       root             995 Oct  5 13:56 yum_save_tx-2012-10-05-13-56qbqbCD.yumtx
-rw-------   1 root       root             456 Oct  5 13:56 yum_save_tx-2012-10-05-13-56yrfhyR.yumtx
-rw-------   1 root       root             890 Oct  5 14:00 yum_save_tx-2012-10-05-14-00BpI1J_.yumtx
-rw-------   1 root       root            1548 Oct  5 14:02 yum_save_tx-2012-10-05-14-02AZmN9r.yumtx
-rw-------   1 root       root             757 Oct  5 14:03 yum_save_tx-2012-10-05-14-03VN72l7.yumtx
-rw-------   1 root       root             757 Oct  5 14:08 yum_save_tx-2012-10-05-14-08UIfLnN.yumtx
-rw-------   1 root       root             522 Oct  5 14:11 yum_save_tx-2012-10-05-14-11wOufX9.yumtx
-rw-------   1 root       root            3138 Oct  5 14:13 yum_save_tx-2012-10-05-14-13OUvUsz.yumtx
-rw-------   1 root       root             634 Oct  8 12:50 yum_save_tx-2012-10-08-12-507pu1F7.yumtx
-rw-------   1 root       root             616 Oct  8 12:55 yum_save_tx-2012-10-08-12-55x6nAlq.yumtx
-rw-------   1 root       root             990 Oct  8 12:57 yum_save_tx-2012-10-08-12-57tfkVG2.yumtx
-rw-------   1 root       root            2321 Oct  8 12:58 yum_save_tx-2012-10-08-12-58fbDbqH.yumtx
-rw-------   1 root       root            1636 Oct  8 12:58 yum_save_tx-2012-10-08-12-58j1XSwY.yumtx
-rw-------   1 root       root            2346 Oct  8 12:58 yum_save_tx-2012-10-08-12-58ZlMesz.yumtx
-rw-------   1 root       root            2321 Oct  8 13:00 yum_save_tx-2012-10-08-13-007CNuna.yumtx
-rw-------   1 root       root             990 Oct  8 13:00 yum_save_tx-2012-10-08-13-00PqUhTT.yumtx
-rw-------   1 root       root             949 Oct  8 15:18 yum_save_tx-2012-10-08-15-18DNzsyi.yumtx
-rw-------   1 root       root             585 Oct  8 15:33 yum_save_tx-2012-10-08-15-33hu4El1.yumtx
-rw-------   1 root       root             585 Oct  8 15:33 yum_save_tx-2012-10-08-15-33ztJa1Z.yumtx
-rw-------   1 root       root             586 Oct  8 15:56 yum_save_tx-2012-10-08-15-56oZDvnT.yumtx
-rw-------   1 root       root             891 Oct  8 15:56 yum_save_tx-2012-10-08-15-56y1avnT.yumtx
-rw-------   1 root       root             586 Oct  8 16:06 yum_save_tx-2012-10-08-16-06M6cEFl.yumtx
-rw-------   1 root       root             586 Oct  8 16:40 yum_save_tx-2012-10-08-16-402COFDC.yumtx
-rw-------   1 root       root             522 Oct  8 16:47 yum_save_tx-2012-10-08-16-47hx578d.yumtx
-rw-------   1 root       root             522 Oct  8 16:47 yum_save_tx-2012-10-08-16-47KtluB1.yumtx
Reply With Quote
  #6  
Old 9th October 2012, 18:40
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

Quote:
drwx------. 28 apache root 4096 Oct 9 09:54 ..
Your / directory is owned by the user apache and has 700 permissions which is wrong. For me it looks like this:

Code:
drwxr-xr-x 22 root  root      4096 Oct  8 17:00 ..
Did you do a chmod and chown on the / directory?
__________________
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
The Following User Says Thank You to falko For This Useful Post:
destinedjagold (10th October 2012)
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
MySQL problem - Sometimes cann't connect to MySQL Ronniea Server Operation 2 16th July 2012 22:01
Sending mails: fine > recive: bad Moundy General 1 20th June 2012 00:40
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 02:05
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 19:40


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


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