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

max_password_errors not working

    XMLWordPrintable

Details

    Description

      We have a requirement to block a user after maximum permitted number of failed connection.

      We use max_password_errors Variable but it doesn't seem to take affect. The version of Mariadb we have is Server version: 10.4.6-MariaDB MariaDB Server.

      We set this variable in /etc/my.cnf.d/server.cnf file under mariadb section.

      1. This group is only read by MariaDB servers, not by MySQL.
      2. If you use the same .cnf file for MySQL and MariaDB,
      3. you can put MariaDB-only options here
        [mariadb]
        max_password_errors=2

      Packages we installed are as below:

      rpm -qa|grep -i maria
      MariaDB-compat-10.4.6-1.el7.centos.x86_64
      MariaDB-cracklib-password-check-10.4.6-1.el7.centos.x86_64
      MariaDB-devel-10.4.6-1.el7.centos.x86_64
      MariaDB-client-10.4.6-1.el7.centos.x86_64
      MariaDB-cracklib-password-check-debuginfo-10.4.6-1.el7.centos.x86_64
      MariaDB-common-10.4.6-1.el7.centos.x86_64
      MariaDB-server-10.4.6-1.el7.centos.x86_64
      galera-4-26.4.2-1.rhel7.el7.centos.x86_64

      Attachments

        Activity

          People

            Unassigned Unassigned
            Ayshkanta Ayshkanta
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.