Ask Your Question
0

icehouse : mysql will not start!

asked 2014-04-24 12:59:43 -0500

TD-Roy gravatar image

Im running through the Installation guide for icehouse.

I install mysql, start it and chkconfig and all is good. Now, Ive been snapshotting the VMs both when off and while on, and going back into the installation.

Now, when I try to start mysql (because it doesnt restart at power on) or when I go to install/configure keystone I get the following:

Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory failed

I have no idea whats going on here. I tried to revert to snapshot right after mysql install but to no avail its still broken

Assistance would be greatly appreciated!

edit retag flag offensive close merge delete

Comments

Do you see any errors in your logs? You didn't mention what platform you're on, but you would typically want to check wherever syslog is writing (possibly /var/log/messages) as well as any logs generated directly by MySQL (possibly /var/log/mysql.log).

larsks gravatar imagelarsks ( 2014-04-25 13:41:13 -0500 )edit

1 answer

Sort by ยป oldest newest most voted
0

answered 2015-01-05 11:24:04 -0500

Issue definetely with your mysql instance or you has wrong owner to db or pid file directory, please check owner of files under /var/lib/mysql directory and ensure that you have needed rights to start it directly, another way to debug problem it is run your mysqld script manually with debug params. Simplest way it is remove mylsq server package with all files and reinstall it, and don't forget make a backup of db

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-04-24 12:59:43 -0500

Seen: 2,072 times

Last updated: Jan 05 '15