[Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Henning Sprang
setting status to confirmed, as I don't see what more info could be
provided, and it's thoroughly tested now.

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Henning Sprang
O.k. I checked this again.

I went through the steps mentioned before to reproduce the problem.

After installation of mysql-server-5.0 from the apt repository _without_
security updates, the directory conf.d and a file in it,
old_passwords.cnf EXISTS!

Adding the security repository and then upgrading the package, makes the
directory conf.d be DELETED, seemingly be the upgrade/postinstall
script, and then, the server fails to start!

Nnot only is it wrong in my opinion that a sertver fails to start when
an optional directory is missing, that the upgrade process even deletes
this directory, without which the server cannot start... strange.


Additional info: I made a default desktop install from live cd, not a server 
install.  marking the bug confirmed, as I thoroughly tested it on a clean 
install.

The simplest fix I can imagine would be to change the mysqld start
script to ignore the optional directory if not there.


** Changed in: mysql-dfsg-5.0 (Ubuntu)
   Status: Incomplete = Confirmed

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Marc Deslauriers
Also, in your first comment, you are getting open: Permission denied.
What user are you using to restart the mysql daemon?

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Marc Deslauriers
I can't reproduce this issue. Here's what I've done:

- Installed Hardy
- Disabled -updates and -security in /etc/apt/sources.list
- sudo apt-get install mysql-server-5.0
- Directory /etc/mysql/conf.d exists with old_passwords.cnf in it
- Enabled -updates and -security in /etc/apt/sources.list
- sudo apt-get dist-upgrade
- Directory /etc/mysql/conf.d still exists (with no files in it)
- Mysql starts fine

Also, I took a look at all the scripts in the mysql package, and I don't
see where any of them could remove that directory.

I am not sure why you're getting this issue. Is there anything else you
are installing or doing to reproduce it?

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


Re: [Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Henning Sprang
On Fri, Dec 5, 2008 at 10:20 PM, Marc Deslauriers
[EMAIL PROTECTED] wrote:
 Also, in your first comment, you are getting open: Permission denied.
 What user are you using to restart the mysql daemon?

the script /etc/init.d/mysql restart

I'm checking everything again...

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


Re: [Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Henning Sprang
On Fri, Dec 5, 2008 at 10:15 PM, Marc Deslauriers
[EMAIL PROTECTED] wrote:
 I am not sure why you're getting this issue. Is there anything else you
 are installing or doing to reproduce it?

Strange.
I'm checking again - it will take a while.

About the only thing that I did additionally before installing, to
better track changes, is that I installed etckeeper and did

git init-db
git add .
git commit -m init

in /etc

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


Re: [Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Henning Sprang
On Fri, Dec 5, 2008 at 10:15 PM, Marc Deslauriers
[EMAIL PROTECTED] wrote:
 You received this bug notification because you are a direct subscriber
 of the bug.

You're right!
When I don't do any git / etckeeper stuff, the empty directory remains.
When I do

apt-get install etckeeper
etckeeper init

the conf.d directory is deleted and mysql cannot start.
I did not think that could be causing the error

So we have really two bugs:

1) for etckeeper: it should not delete empty directories after a
system upgrade (in general, don't apply any changes on upgrades,
unless being explicitly told to clean something up)
2) In any case, the issue of the daemon not starting just because a
missing optional directory remains here for mysql

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 305107] Re: mysql refuses to start after security update

2008-12-05 Thread Henning Sprang
reported for etckeeper as bug 305642

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 305107] Re: mysql refuses to start after security update

2008-12-04 Thread Augusto Cezar Amaral
Thank you for taking the time to report this bug and helping to make Ubuntu 
better. This bug did not have a package associated with it, which is important 
for ensuring that it gets looked at by the proper developers. You can learn 
more about finding the right package at 
https://wiki.ubuntu.com/Bugs/FindRightPackage . I have classified this bug as a 
bug in mysql-dfsg-5.0.
For future reference you might be interested to know that a lot of applications 
have bug reporting functionality built in to them. This can be accessed via the 
Report a Problem option in the Help menu for the application with which you are 
having an issue. You can learn more about this feature at 
https://wiki.ubuntu.com/ReportingBugs.

** Changed in: mysql-dfsg-5.0 (Ubuntu)
Sourcepackagename: None = mysql-dfsg-5.0
   Status: New = Incomplete

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 305107] Re: mysql refuses to start after security update

2008-12-04 Thread Augusto Cezar Amaral
Could you also, please, answer these questions:

* Is this reproducible?
* If so, what specific steps should we take to recreate this bug?

This will help us to find and resolve the problem. Thank you again.

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


Re: [Bug 305107] Re: mysql refuses to start after security update

2008-12-04 Thread Henning Sprang
On Thu, Dec 4, 2008 at 4:22 PM, Augusto Cezar Amaral
[EMAIL PROTECTED] wrote:
 Thank you for taking the time to report this bug and helping to make Ubuntu 
 better. This bug did not have a package associated
 with it, which is important for ensuring that it gets looked at by the proper 
 developers.

oops, sorry, I obviously forgot that...

Maybe launchpad should get an extra field for this, and ask people one
extra time if they forget to fill it in (but still let them save if
they, for some reason, don't know which package it is.

  You can learn more about finding the right package at 
 https://wiki.ubuntu.com/Bugs/FindRightPackage . I have classified this
 bug
 as a bug in mysql-dfsg-5.0.

seems correct:

The script in error seems to be /usr/sbin/mysqld

dpkg -S /usr/sbin/mysqld
mysql-server-5.0: /usr/sbin/mysqld

source of this is the package you mentioned.

Thanks for setting it right!


 For future reference you might be interested to know that a lot of 
 applications have bug reporting functionality built in to them.
This can be accessed via the Report a Problem option in the Help menu for the 
application with which you are having an issue.
 You can learn more about this feature at 
 https://wiki.ubuntu.com/ReportingBugs.

Yeah, I think I already saw that somewhere.

But now I searched for two hours for the help menu of
mysql-server.5.0, and I cannot find it - do you have an idea?
No, just joking, I think that hint doesn't work for server daemons :)

Anyway, hope that thing get's fixed soon - I believe that is a very
grave error to happen - a security update that breaks the abilty of a
server daemon to start is no fun at all!
I'm happy that I don't use Ubuntu on servers, this would have been a
major catastrophe.

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 305107] Re: mysql refuses to start after security update

2008-12-04 Thread Henning Sprang
I'm trying to start up a VM installation and see if I can reproduce the
problem!

(maybe it even works from the live cd?!)

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


Re: [Bug 305107] Re: mysql refuses to start after security update

2008-12-04 Thread Henning Sprang
On Thu, Dec 4, 2008 at 5:32 PM, Mathias Gug [EMAIL PROTECTED] wrote:
 On Thu, Dec 04, 2008 at 04:02:35PM -, Henning Sprang wrote:
 * check if the is a directory /etc/mysql/conf.d - it should NOT be
 there - if it is there, the error will not be reproducable, and this
 directory has been deleted from my system for some strange reason

 Are you able to start mysql-server if you re-create /etc/mysql/conf.d/
 as an empty directory?

yes, see my second post :)

Strange, I installed the mysql-server-5.0 package in a hardy live cd,
but here, the directory /etc/mysql/conf.d is created and it contains
the file old_passwirds.conf. I have no idea how this file could be
removed from my system.

Still, a daemon should definitely not fail to start because a
directory that contains optional, additional configs is not there.

I'm checkin further to find out
* whether maybe even the package install script itself is responsible
for removing the file/directory
* whether previous versions of the mysql package also are unable to
start when the directory is missing.

and get back with more info...

-- 
mysql refuses to start after security update
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs