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

service mysql status command fails when run by normal user

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.5.35
        • Fix Version/s: 5.5
        • Component/s: None
        • Labels:
        • Environment:
          Ubuntu 13.10

          Description

          Command "service mysql status" fails when executed by a normal user. (It works for other services.) There are two reasons for this. First, the process id file is created with permissions 660, so it can't be read (most process id files have permissions 622). Second, the "kill -0" command used in the service file to determine if a process is active fails when executed by an arbitrary user.

          Attached are a script demonstrating the problem and its output. Also attached are the my.cnf file and the service file (/etc/init.d/mariadb). The service file is lightly modified from the distributed support-files/mysql-server.

          mariadb was installed from file mariadb-5.5.36-linux-x86_64.tar.gz

            Gliffy Diagrams

              Attachments

              1. bug_output
                1 kB
              2. mariadb
                12 kB
              3. my.cnf
                3 kB
              4. show_mariadb_bug
                0.9 kB

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                rockowitz Sanford Rockowitz added a comment -

                oops, tested platform is Ubuntu 13.10, not 13.4 as stated.

                Show
                rockowitz Sanford Rockowitz added a comment - oops, tested platform is Ubuntu 13.10, not 13.4 as stated.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Otto Kekäläinen,

                Does it also affect your packages, or is it MariaDB-packaging-specific?
                Either way, is it a bug from Debian/Ubuntu perspective, and if it is, do you have suggestions about fixing it?

                Thanks.

                Show
                elenst Elena Stepanova added a comment - Otto Kekäläinen , Does it also affect your packages, or is it MariaDB-packaging-specific? Either way, is it a bug from Debian/Ubuntu perspective, and if it is, do you have suggestions about fixing it? Thanks.
                Hide
                Permalink
                otto Otto Kekäläinen added a comment -

                Yes, this seems to affect all packaging.

                $ apt-cache showpkg mariadb-server
Versions: 5.5.41-1ubuntu0.14.04.1

$ lsb_release -d
Description:    Ubuntu 14.04.2 LTS

$ sudo service mysql status
[sudo] password for otto: 
mysql start/running, process 13687

$ service mysql status
initctl: Unable to connect to system bus: Failed to connect to socket /var/run/dbus/system_bus_socket: No such file or directory
                Show
                otto Otto Kekäläinen added a comment - Yes, this seems to affect all packaging. $ apt-cache showpkg mariadb-server Versions: 5.5.41-1ubuntu0.14.04.1 $ lsb_release -d Description: Ubuntu 14.04.2 LTS $ sudo service mysql status [sudo] password for otto: mysql start/running, process 13687 $ service mysql status initctl: Unable to connect to system bus: Failed to connect to socket /var/run/dbus/system_bus_socket: No such file or directory

                  People

                  • Assignee:
                    otto Otto Kekäläinen
                    Reporter:
                    rockowitz Sanford Rockowitz
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated: