mysql fails to start if debian-start has the wrong permission - package mysql-server-5.0 5.1.30really5.0.75-0ubuntu10.2 failed to install/upgrade: subprocess post-installation script returned error exit status 126

Update manager quit giving information about update at:

 * Starting MySQL database server mysqld
   ...done.
/etc/init.d/mysql: line 115: /etc/mysql/debian-start: Permission denied
invoke-rc.d: initscript mysql, action "start" failed.

I rebooted computer, checked update manager for more updates and no updates were reported.

I started mysql and:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.75-0ubuntu10.2-log (Ubuntu)

it seems 5.075 was installed (I hope)

I chmod 755 /etc/mysql/debian-start and apt-get upgrade completed the previous upgrade successfully. /etc/mysql/debian-start permissions was previously 600.

On Tue, Jun 02, 2009 at 12:16:15PM -0000, jfulton3 wrote:
> I chmod 755 /etc/mysql/debian-start and apt-get upgrade completed the
> previous upgrade successfully. /etc/mysql/debian-start permissions was
> previously 600.

Do you have any idea what changed the default permission of
/etc/mysql/debian-start?

  status incomplete

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com

I have no idea. I doubt I did.

Did you make a restore from a backup at some point that could have messed up the permission on /etc/mysql/debian-start?

In any case, the init script should check if debian-start can be executed before running it:

                # Now start mysqlcheck or whatever the admin wants.
                output=$(/etc/mysql/debian-start)

No I haven't restarted from backup. The OS has only been installed since Fall of 2008. The line you mentioned is included in the initd./mysql script.

The rest of my /etc/mysql directory is:

drw-r----- 2 root root 4096 2009-04-26 08:06 conf.d
-rw------- 1 root root 312 2008-11-29 07:56 debian.cnf
-rwxr-xr-x 1 root root 1198 2008-09-19 09:24 debian-start
-rw-r----- 1 root root 4228 2009-04-04 19:07 my.cnf
-rw-r----- 1 root root 4226 2008-12-12 16:29 my.cnf~
-rw-r----- 1 root root 4088 2009-03-30 16:18 my.cnf.dpkg-dist