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

[jfulton3]

failed to install from update from update manager

ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 9.04
ErrorMessage: subprocess post-installation script returned error exit status 126
Package: mysql-server-5.0 5.1.30really5.0.75-0ubuntu10.2
SourcePackage: mysql-dfsg-5.0
Title: 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
Uname: Linux 2.6.28-11-generic i686

[jfulton3 (jfulton3)]

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)

[jfulton3 (jfulton3)]

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

[Mathias Gug (mathiaz)]

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

[jfulton3 (jfulton3)]

I have no idea. I doubt I did.

[Mathias Gug (mathiaz)]

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

[Mathias Gug (mathiaz)]

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)

[jfulton3 (jfulton3)]

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