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

init scripts use a special user

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.5.34-galera, 5.5.34
    • Fix Version/s: 5.5
    • Component/s: None
    • Labels:
    • Environment:
      Debian/Ubuntu

      Description

      The init scripts for debian and ubuntu rely on a special user:
      'debian-sys-maint'@'localhost'
      MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"

      It has three tasks:
      1. Doing some local checks starting the mysqld.
      2. Some fancy status reporting.
      3. As mysqladmin is used to shutdown, the user is used to shutdown the mysqld.

      The problem with this approach is the credentials has to be stored disjunct in the filesystem (/etc/init.d/debian.cnf). So everytime the data in the schema changes you got to fix it in the configfile.
      So at least when you i.e.

      • Create a slave from a master dump
      • After an (initial) SST in Galera
        When you miss this, the most important thing is, you are not going to stop the mysqld.
        This is some kind of silly, as you don't even need mysqladmin to stop mysqld, as SIGTERM is sufficient.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              otto Otto Kekäläinen
              Reporter:
              erkules erkan yanar
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated: