HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   MySQL-related problem (http://www.howtoforge.com/forums/showthread.php?t=58979)

destinedjagold 5th October 2012 12:35

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.

falko 6th October 2012 10:57

Can you run
Code:

df -h
to check if any of your partitions is full?

destinedjagold 8th October 2012 04:15

Quote:

Originally Posted by falko (Post 286359)
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.

falko 8th October 2012 13:24

Can you post the output of
Code:

ls -la /tmp/
?

destinedjagold 9th October 2012 04:09

Quote:

Originally Posted by falko (Post 286407)
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


falko 9th October 2012 17:40

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?

destinedjagold 10th October 2012 04:04

Quote:

Originally Posted by falko (Post 286468)
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?

Thanks for the reply, and for your questions, yes, I think I did.
Should I return it to root? If so, what would be the proper code to use?

Thanks~

---edit---

Okay, so I used
Code:

chmod 755 /
and now it displays this...
Code:

total 354844
drwxrwxrwx.  8 root      root            4096 Oct 10 11:22 .
drwxr-xr-x.  28 root      root            4096 Oct 10 09:34 ..

Is this okay now?
I still cannot run MySQL...
Code:

MySQL Daemon failed to start.
Starting mysqld: [FAILED]

---edit 2---

Okay, I think I have fixed it. MySQL will now start when I type
Code:

service mysqld start
.
I think I should post here the things I did, for future reference?

The first thing I did was reinstall both mysql and mysql-server through yum.
And then, after reinstalling was done, I typed these following codes...
Code:

chown -R mysql.mysql /var/lib/mysql
Code:

su - mysql
I am not sure if those set of codes really fixed it, but those are the ones I used, and the MySQL Daemon error message is no longer appearing, and MySQL is starting with no problems.


All times are GMT +2. The time now is 05:16.

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