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

skip-name-resolve mode doesn't work with user@localhost

    XMLWordPrintable

Details

    Description

      The documentation for skip-name-resolve says:
      > All host values in the GRANT tables must be IP addresses (or localhost).
      (https://mariadb.com/kb/en/server-system-variables/#skip_name_resolve)
      However, "localhost" doesn't work with said variable set to 1 (I've only tested it on Windows).

      I have a user repl_status@localhost configured. This works fine with skip-name-resolve=0. With skip-name-resolve=1, I get one of the following warnings in the log file (depending what IP version is used):
      >[Warning] Access denied for user 'repl_status'@'::1' (using password: YES)
      >[Warning] Access denied for user 'repl_status'@'127.0.0.1' (using password: YES)

      Also note that the log file has warnings during startup for ignored entries like this:
      > [Warning] 'user' entry 'root@c-2tcmqb3' ignored in --skip-name-resolve mode.
      (Where c-2tcmqb3 is the host name.)
      There is no such warning for @localhost.

      Option 1: localhost isn't supposed to work: Then the documentation is wrong and the warning is missing.
      Option 2: localhost is supposed to work: Well, it doesn't.

      Side note: HeidiSQL has a dialog window for user accounts, in which it displays lines with host names in grey color when skip-name-resolve=1. It doesn't do that for localhost.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            sweiser Sebastian Weiser
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.