[debian-mysql] Bug#491275: mysql-server postinst should skip comments in debian.cnf

[Christian Hammers]

package: mysql-server-5.0
version: 5.0.32-7etch6
severity: minor
tags: patch

Hello

Am Tue, 15 Jul 2008 17:31:48 +0200
schrieb "Reuss, Walter, Springer DE" <Walter.Reuss at springer.com>:

> Hello Christian,
> 
> please ignore my previous email.
> 
> The errorneous behaviour comes from my understanding how the debian.cnf file is read during upgrades.
> 
> I had the automatically generated debian-sys-maint information, that is made up during the first installation commented out as follows:
> 
> user     = debian-sys-maint
> #password = p8WbpFpRSvwtA8H3
> password = <password manually set>
> socket   = /var/run/mysqld/mysqld.sock
> basedir  = /usr
> 
> I then use and set the password of the master also on the slaves.
> 
> The upgrade script seems to still take the "old password", but in the form "#p8WbpFpRSvwtA8H3" then. 

I forward this to our bug tracking system nevertheless, maybe the mysql-server-5.0.postinst
script can be adjusted from:
          pass="`sed -n 's/password *= *// p' $dc | head -n 1`"
to
          pass="`sed -n 's/^password *= *// p' $dc | head -n 1`"

bye,

-christian-


 
> I assumed it would be skipped!
> 
> Kind regards
> 
> Walter
> 
>  
> 
> -----Original Message-----
> From: Reuss, Walter, Springer DE 
> Sent: Tuesday, July 15, 2008 4:56 PM
> To: 'ch at debian.org'
> Subject: mysql-server updates
> 
> Hi Christian,
> 
> Everytime the mysql-server package is updated, the password for the "debian-sys-maint" user is changed. As I have a replication scenario here, using a copy of the database on several slaves, this password is out of sync on all the machines after updating the master server.
> 
> I would like to know if there is a possibilty to skip this password change during updating, or if it would be possible to add it in future versions of the package as it is usual for other packages to ask prior to overwriting configuration settings.
> 
> Kind regards
> 
> Walter
> 
> 
> 
> ---
> Dr. Walter Reuß
> Springer
> Reference & Database Publishing
> ---
> Tiergartenstrasse 17 | 69121 Heidelberg | Germany
> tel  +49 (0) 6221 4 87-8697
> fax  +49 (0) 6221 4 87-8795
> walter.reuss at springer.com
> www.springer.com
> ---