[opensuse] 13.1 - MariaDB: Why is /etc/my.cnf chmod 0640 and why is /etc/my.cnf.d/ 0750?
All, After trying to determine why mysql (MariaDB) /etc/my.cnf settings are only seen in mysql is run by linux root user, I've stumbled on to a permission problem with Andrey's help 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 -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. What says the brain-trust? Intentional or bug? -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 07/26/2014 12:09 PM, David C. Rankin wrote:
All,
After trying to determine why mysql (MariaDB) /etc/my.cnf settings are only seen in mysql is run by linux root user, I've stumbled on to a permission problem with Andrey's help 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 -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.
What says the brain-trust? Intentional or bug?
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? -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On July 26, 2014 1:09:18 PM EDT, "David C. Rankin"
All,
After trying to determine why mysql (MariaDB) /etc/my.cnf settings are only seen in mysql is run by linux root user, I've stumbled on to a permission problem with Andrey's help 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 -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.
What says the brain-trust? Intentional or bug?
I say, file a bug. I fear a lot of maintainers do very little testing before the push a new package to factory. Greg -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 07/26/2014 08:29 PM, Greg Freemyer wrote:
I say, file a bug. I fear a lot of maintainers do very little testing before the push a new package to factory.
Greg
Done, MariaDB config files not seen by Unix non-root users. Permission Problem in Package https://bugzilla.novell.com/show_bug.cgi?id=889126 -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (2)
-
David C. Rankin
-
Greg Freemyer