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

MariaDB server Access denied for AD user

    XMLWordPrintable

    Details

      Description

      Hi,

      I am trying to access the MariaDB server for both local and AD users. Successful in accessing local user, but failed with an AD user. Configuration carried out below for MariaDB access for the AD user.

      Please help to fix this error.

      MariaDB Version : 10.5.11

      >> Error from AD User>>>>
      mysql -u hssn_ms -p
      Enter password:
      ERROR 1045 (28000): Access denied for user 'hssn_ms'@'localhost' (using password: NO)

      <<<< USER Table Detail>>>>>

      MariaDB [mysql]> select Host, User, Password, plugin from user where User = 'hssn_ms';
      +---------------------+---------+----------+--------+
      | Host                | User    | Password | plugin |
      +---------------------+---------+----------+--------+
      | db104.xyzz.xyz | hssn_ms |          | pam    |
      | %                   | hssn_ms |          | pam    |
      | localhost           | hssn_ms |          | pam    |
      +---------------------+---------+----------+--------+
      3 rows in set (0.001 sec)
      

      <<< pam Configuration for MariaDB >>>

      $ cat /etc/pam.d/maraidb
      auth required pam_unix.so audit
      auth required pam_user_map.so debug
      account required pam_unix.so audit
      

      Thanks,
      Shamshad

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            msam0786@gmail.com MOHAMMAD SAMSAD HUSSAIN
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration