On 2006-02-07 sean finney wrote: > hi christian, ryan, > > On Mon, Feb 06, 2006 at 07:27:11PM -0600, Ryan Underwood wrote: > > I'm not sure. I'm having this problem where we use cron-apt for > > security upgrades, and whenever dpkg wants to ask the question "This > > config file has been modified, want to overwrite or leave it alone", it > > aborts the upgrade since no tty is available, and leaves the server > > stopped. > > > > All I had been changing in my.cnf was removing skip-networking, and > > later changing bind-address from 127.0.0.1 to 0.0.0.0. I admit that > > this hasn't happened for a while, but I only revisited this because I > > found that mysql was stopped on that machine due to this happening > > several months ago during a security upgrade. > > > > Does this make sense? > > yes... but if i understand correctly then the problem is not with mysql > but instead with your system for applying upgrades. for example, if > we were to create an /etc/default/mysql with the options you request, > and you change them, then we at a later point change the defaults in > the file, you'll have the same problem as before. ... and even more, if we change the default config file then it will very unlike be bind-address again but any other option. And then having a /etc/default/mysql would gain nothing as dpkg again would request what to do. Also I would guess that most admins change something in my.cnf to optimize their server, turn on innodb etc..
So the problem is not only with bind-address but a general one. > instead, you should possibly file a bug against cron-apt, or > maybe apt/dpkg if there is not a way to do what you want. The only possible suggestion here would let dpkg have a default answer of "n" to the question if the config file should be replaced by the maintainer. Maybe something in /etc/dpkg/dpkg.cfg. But apart from that I would strongly discourage actually doing updates with cron-apt. Use it to notify yourself by mail but never let the system restart your services unattended if it's not absulutely necessary. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
