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

CREATE USER replicated with clear text password

    XMLWordPrintable

Details

    Description

      I had Simple Password Check Plugin on 3 node cluster setup with below settings.

      simple_password_check_digits  1
      simple_password_check_letters_same_case 1
      simple_password_check_minimal_length  8
      simple_password_check_other_characters  1
      

      However, when tried to create user failed to meet simple password check plugin criteria it still replicated with clear text password.

      MariaDB [(none)]> CREATE USER TestUser@localhost IDENTIFIED BY 'mariadb';
      ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
      

      It seems like clear text password is logged into binary log and below error/warning from rest of cluster nodes.

      2022-03-07 13:25:13 2 [ERROR] Slave SQL: Error 'Your password does not satisfy the current policy requirements' on query. Default database: ''. Query: 'CREATE USER TestUser@localhost IDENTIFIED BY 'mariadb'', Internal MariaDB error code: 1819
      2022-03-07 13:25:13 2 [Warning] WSREP: Ignoring error 'Your password does not satisfy the current policy requirements' on query. Default database: ''. Query: 'CREATE USER TestUser@localhost IDENTIFIED BY 'mariadb'', Error_code: 1819
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              muhammad.irfan Muhammad Irfan
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.