[Bug 889126] New: MariaDB config files not seen by Unix non-root users. Permission Problem in Package
https://bugzilla.novell.com/show_bug.cgi?id=889126 https://bugzilla.novell.com/show_bug.cgi?id=889126#c0 Summary: MariaDB config files not seen by Unix non-root users. Permission Problem in Package Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: x86-64 OS/Version: openSUSE 13.1 Status: NEW Severity: Major Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: drankinatty@suddenlinkmail.com QAContact: qa-bugs@suse.de Found By: --- Blocker: --- After trying to determine why mysql (MariaDB) /etc/my.cnf settings are only seen in mysql is run by unix root user, I've stumbled on to a permission problem with the mariadb package for 13.1 that makes NO sense at all. The problem with normal unix users not getting the system-wide setting in /etc/my.cnf is because /etc/my.cnf cannot be read by normal users. That's nuts. In fact, the whole system-wide conf scheme for mysql can only be read by 'root' or members of the 'mysql' group. Specifically: # l /etc/my.cnf -rw-r----- 1 root mysql 3429 Jul 25 19:37 my.cnf # l /etc/my.cnf.d total 20 drwxr-x--- 2 root mysql 4096 Jul 25 18:56 . drwxr-xr-x 153 root root 12288 Jul 25 23:45 .. -rw-r----- 1 root mysql 119 Sep 19 2013 default_plugins.cnf Why should users have to be members of the mysql group to see settings in the config files?? This is completely Linux backwards from eliminating the need for users to be members of special groups to use the system. setting: /etc/my.cnf 0644 /etc/my.cnf.d 0755 /etc/my.cnf.d/my.cnf.d/default_plugins.cnf 0644 Solves this problem. mysql works as expected for non-root users. Why is mariadb not packaged this way for 13.1? -- 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=889126 https://bugzilla.novell.com/show_bug.cgi?id=889126#c1 Bernhard Wiedemann <bwiedemann@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bwiedemann@suse.com, | |meissner@suse.com AssignedTo|bnc-team-screening@forge.pr |michal.hrusecky@opensuse.or |ovo.novell.com |g --- Comment #1 from Bernhard Wiedemann <bwiedemann@suse.com> 2014-08-11 17:04:23 CEST --- There might be security reasons for those permissions, in case there are passwords contained in the files. -- 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=889126 https://bugzilla.novell.com/show_bug.cgi?id=889126#c2 --- Comment #2 from David Rankin <drankinatty@suddenlinkmail.com> 2014-08-13 04:35:06 UTC --- Bernhard, I don't think so. Any passwords for accessing mysql go in the user '.my.cnf', including root (e.g. /root/.my.cnf) So there are no passwords in the system-wide /etc/my.cnf. This is just a pure break in packaging. I have used mysql since Mandrake, SuSE 8.0 pro, as well as on Archlinux. For the past decade and a half all distributions (and documentation) have /etc/my.cnf handle system-wide config setting for mysql (mariadb). That is the only way it can work, unless every user is now responsible for writing a ~/.my.cnf before using mysql -- that makes zero sense... See: http://dev.mysql.com/doc/refman/5.1/en/option-files.html /etc/my.cnf provides: GLOBAL options -- 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.
participants (1)
-
bugzilla_noreply@novell.com