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

Password policy causes replication failure

    XMLWordPrintable

Details

    • 10.2.11, 10.1.30

    Description

      simple_password_check settings on both master and slave

      [mariadb]
      plugin-load-add=simple_password_check.so
       
      simple_password_check_minimal_length    = 10
      simple_password_check_other_characters  = 1
      simple_password_check_letters_same_case = 1
      simple_password_check_digits            = 1
      

      On master side, create an user with invalid password
      CREATE USER USR_RO@'10.1.1.26' IDENTIFIED BY 'bsg9#d.cem#!85'; – No Upper Case Letter
      ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

      The user was not created on master server, but for some reason binlog has written to disk.

      On slave side, replication slave stops
      Query caused different errors on master and slave. Error on master: message (format)='Your password does not satisfy the current policy requirements' error code=1819 ; Error on slave: actual message='no error', error code=0. Default database: ''. Query: 'CREATE USER USR_RO@'10.1.1.26' IDENTIFIED BY 'bsg9#d.cem#!85''

      Meanwhile, I can see the new user has been created on slave server, the behaviour is strange.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              mxu Michael Xu
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.