Lars Müller - 11:29 5.06.09 wrote:
On Fri, Jun 05, 2009 at 02:09:51AM -0500, David C. Rankin wrote:
Where in openSuSE is the disconnect between the mouth and the brain? We have open bug reports on the horrors caused by somebody's decision to move the mysql socket and
While talking about bugs never ever quote the bug ID. NEVER, EVER! ;)
bnc#496196: https://bugzilla.novell.com/show_bug.cgi?id=496196
pid file from /var/lib/mysql to /var/run/mysql and how that will BREAK every installed database application on openSuSE servers from at least 9.0 to the present.
How does a different location of the pid directory cause this?
It's because of different location of socket file.
"First of them is that mysql socket file and pid file were moved by default from /var/lib/mysql to more reasonable location ( /var/run/mysql ). Second change is that mysql log file is again back in /var/log. These changes should make MySQL more LSB friendly and help people with their MySQL administration. All these changes can be reverted by changing MySQL configuration file so if you don't like it, you can move them anywhere you want (face-wink.png)"
Yes, that really is a stupid smiley face icon at the end of his paragraph. An honest answer would have at least included telling admins that "you *will* have to manually edit the config files to change the paths back to what they have been for the past 5 years if you want your databases to work."
As /etc/my.cnf is packaged as %config with_out_ noreplace this change is calling to cause trouble. :(
This report was about mysql from server:database repository and /etc/my.cnf is there packaged as %config(noreplace) -- Michal Hrusecky Package Maintainer SUSE LINUX, s.r.o e-mail: mhrusecky@suse.cz