Navigation

destinedjagold · #1 5th October 2012, 12:35

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 · #2 6th October 2012, 10:57

Can you run

Code:

df -h

to check if any of your partitions is full?

destinedjagold · #3 8th October 2012, 04:15

Quote:

Originally Posted by falko

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 · #4 8th October 2012, 13:24

Can you post the output of

Code:

 ls -la /tmp/

?

destinedjagold · #5 9th October 2012, 04:09

Quote:

Originally Posted by falko

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 · #6 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 · #7 10th October 2012, 04:04

Quote:

Originally Posted by falko

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.

Navigation

Facebook

News

Recent comments

Newsletter