Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17637

New systemd-aware script to re-create datadir

Details

    Description

      When creating the data directories with the mysql_install_db script, UMASK settings in /etc/systemd/system/mariadb.service.d/ are ignored.

      Setting UMASK in the environment works correctly, but setting /etc/systemd/system/mariadb.service.d/ as instructed in https://mariadb.com/kb/en/library/specifying-permissions-for-schema-data-directories-and-tables/ has no effect on the mysql_install_db script.

      Note that UMASK settings are respected by the server itself. This is only an issue when invoking mysql_install_db manually on systemd distributions.

      Attachments

        Issue Links

          Activity

            juan.vera Juan created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Labels installation
            elenst Elena Stepanova made changes -
            Labels need_feedback
            elenst Elena Stepanova made changes -
            Component/s Packaging [ 10700 ]
            Component/s OTHER [ 10125 ]
            juan.vera Juan made changes -
            Description When creating the data directories with the mysql_install_db script, UMASK settings in /etc/systemd/system/mariadb.service.d/ are ignored.

            Setting UMASK in the environment works correctly, but setting /etc/systemd/system/mariadb.service.d/ as instructed in /etc/systemd/system/mariadb.service.d/ has no effect on the mysql_install_db script.
            When creating the data directories with the mysql_install_db script, UMASK settings in /etc/systemd/system/mariadb.service.d/ are ignored.

            Setting UMASK in the environment works correctly, but setting /etc/systemd/system/mariadb.service.d/ as instructed in /etc/systemd/system/mariadb.service.d/ has no effect on the mysql_install_db script.

            Note that UMASK settings are respected by the server itself. This is only an issue when invoking mysql_instal_db manually on systemd distributions.
            elenst Elena Stepanova made changes -
            Affects Version/s 10.3.10 [ 23140 ]
            Environment CentOS
            Issue Type Bug [ 1 ] Task [ 3 ]
            elenst Elena Stepanova made changes -
            Labels need_feedback
            elenst Elena Stepanova made changes -
            Summary mysql_install_db ignores configuration directives from /etc/systemd/system/mariadb.service.d/ New systemd-aware script to re-create datadir
            elenst Elena Stepanova made changes -
            julien.fritsch Julien Fritsch made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            julien.fritsch Julien Fritsch made changes -
            Labels need_feedback
            juan.vera Juan made changes -
            Description When creating the data directories with the mysql_install_db script, UMASK settings in /etc/systemd/system/mariadb.service.d/ are ignored.

            Setting UMASK in the environment works correctly, but setting /etc/systemd/system/mariadb.service.d/ as instructed in /etc/systemd/system/mariadb.service.d/ has no effect on the mysql_install_db script.

            Note that UMASK settings are respected by the server itself. This is only an issue when invoking mysql_instal_db manually on systemd distributions.
            When creating the data directories with the mysql_install_db script, UMASK settings in /etc/systemd/system/mariadb.service.d/ are ignored.

            Setting UMASK in the environment works correctly, but setting /etc/systemd/system/mariadb.service.d/ as instructed in https://mariadb.com/kb/en/library/specifying-permissions-for-schema-data-directories-and-tables/ has no effect on the mysql_install_db script.

            Note that UMASK settings are respected by the server itself. This is only an issue when invoking mysql_instal_db manually on systemd distributions.
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Description When creating the data directories with the mysql_install_db script, UMASK settings in /etc/systemd/system/mariadb.service.d/ are ignored.

            Setting UMASK in the environment works correctly, but setting /etc/systemd/system/mariadb.service.d/ as instructed in https://mariadb.com/kb/en/library/specifying-permissions-for-schema-data-directories-and-tables/ has no effect on the mysql_install_db script.

            Note that UMASK settings are respected by the server itself. This is only an issue when invoking mysql_instal_db manually on systemd distributions.
            When creating the data directories with the mysql_install_db script, UMASK settings in /etc/systemd/system/mariadb.service.d/ are ignored.

            Setting UMASK in the environment works correctly, but setting /etc/systemd/system/mariadb.service.d/ as instructed in https://mariadb.com/kb/en/library/specifying-permissions-for-schema-data-directories-and-tables/ has no effect on the mysql_install_db script.

            Note that UMASK settings are respected by the server itself. This is only an issue when invoking mysql_install_db manually on systemd distributions.
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels need_feedback documentation
            juan.vera Juan made changes -
            serg Sergei Golubchik made changes -
            Labels documentation documentation systemd
            julien.fritsch Julien Fritsch made changes -
            Assignee Kenneth Geiselhart [ ken.geiselhart@mariadb.com ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Kenneth Geiselhart [ ken.geiselhart@mariadb.com ] Kenneth Dyer [ kennethdyer ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Kenneth Dyer [ kennethdyer ] Jacob Moorman [ jacob.moorman ]
            jacob.moorman Jacob Moorman (Inactive) made changes -
            Assignee Jacob Moorman [ jacob.moorman ] Juan [ juan.vera ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            julien.fritsch Julien Fritsch made changes -
            Labels documentation systemd documentation need_feedback systemd
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s N/A [ 14700 ]
            Resolution Won't Do [ 10201 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 90481 ] MariaDB v4 [ 133740 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 154291

            People

              juan.vera Juan
              juan.vera Juan
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.