[Bug 613032] Re: Install broken, won't start
Clint Byrum
clint at fewbar.com
Wed Aug 4 16:47:22 BST 2010
Zash, thanks for the update. It sounds like this system was pretty
seriously damaged at one time, and may need to have a fresh install.
However there are a few things to check:
In the grep I notice this:
Aug 3 16:51:40 gladius mysqld[22873]: 100803 16:51:40 InnoDB: Started; log sequence number 0 0
Aug 3 16:51:40 gladius mysqld[22873]: 100803 16:51:40 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
Aug 3 16:51:40 gladius mysqld[22873]: ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
errno: 13 is "permission denied". You may need to check the permissions
on the /var/lib/mysql folders to make sure the directories are owned
and/or writable by the 'mysql' user.
The "hang" you're experiencing appears to be mysqld restarting over and
over because of this issue.
One thing to try is the following steps:
1. make sure all mysqld's are dead (stop mysql, killall mysqld, etc, verify with ps auxw | grep mysqld)
2. sudo mv /var/lib/mysql /var/lib/mysql.old ; sudo mv /etc/mysql /etc/mysql.old
3. sudo dpkg --purge mysql-server-5.1
4. sudo apt-get install mysql-server-5.1
5. stop mysql
6. mv /var/lib/mysql /var/lib/mysql.empty
7. mv /var/lib/mysql.old /var/lib/mysql
8. start mysql
If you get the same errno: 13 errors, try
chown mysql.root /var/lib/mysql/mysql
chmod 700 /var/lib/mysql/mysql
chown mysql.mysql /var/lib/mysql/mysql/*
chmod 660 /var/lib/mysql/mysql/*
Now, if mysql starts and sees your data, then you know the problem was
probably a configuration issue from the /etc/mysql.old directory.
However, if it still fails, then there may be some serious issues with
your data. Upon failure or success, please come back and post the
results, maybe another log file showing what happened.
--
Install broken, won't start
https://bugs.launchpad.net/bugs/613032
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
More information about the Ubuntu-server-bugs
mailing list