[Bug 478904] New: MySQL fails to initialize DB when silly hostname chosen (first execution of /etc/init.d/mysql)
https://bugzilla.novell.com/show_bug.cgi?id=478904 Summary: MySQL fails to initialize DB when silly hostname chosen (first execution of /etc/init.d/mysql) Classification: openSUSE Product: openSUSE 11.1 Version: Final Platform: All OS/Version: openSUSE 11.1 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: jo@feuersee.de QAContact: qa@suse.de Found By: --- User-Agent: Mozilla/5.0 (compatible; Konqueror/3.5; Linux) KHTML/3.5.10 (like Gecko) SUSE A lot of different openSUSE (and other Linux dists or UN*X like systems) related forums have threads like "Can't connect to MySQL" "What's the default password to MySQl" "Can't install MySQL" etc. When trying to reproduce everything went fluid and MySQL is up and running, so WTF are these guys doing wrong? As they state nothing. But: a lot of MySQL depends on a unique well chosen hostname. "If the hostname of the machine is accidentally set to ‘hostname’ or ‘localhost’, it results in a duplicate entry." Yes, it's really stupid to call a machine 'hostname' or even 'localhost' but ppl do that. In this case MySQL will fail to init it's DB and won't allow any access (due to missing DB permissions). Reproducible: Always Steps to Reproduce: 1. 2. 3. Thread in german forum: http://www.linux-club.de/viewtopic.php?f=36&t=99169 The script /etc/init.d/mysql should check if the hostname is properly set (!= localhost or hostname), fail with a clear message if so (eg. "Unable to continue due to silly hostnane. Please set a proper hostname") -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=478904
User cyhan@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=478904#c1
Chuanye Han
https://bugzilla.novell.com/show_bug.cgi?id=478904
User mhrusecky@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=478904#c2
Michal Hrusecky
https://bugzilla.novell.com/show_bug.cgi?id=478904
User mhrusecky@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=478904#c3
Michal Hrusecky
https://bugzilla.novell.com/show_bug.cgi?id=478904
User jo@feuersee.de added comment
https://bugzilla.novell.com/show_bug.cgi?id=478904#c4
--- Comment #4 from Jo Schulze
https://bugzilla.novell.com/show_bug.cgi?id=478904
User mhrusecky@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=478904#c5
--- Comment #5 from Michal Hrusecky
participants (1)
-
bugzilla_noreply@novell.com