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

CREATE ROLE blocked by password validation plugin

Details

    • 10.1.14

    Description

      Apparently, CREATE ROLE is blocked when using a password validation plugin. It's not clear why this should be the case, or how to avoid this, as there is no way to provide a password when creating a role.

      > install soname 'simple_password_check';
      		 
      Query OK, 0 rows affected (0.00 sec)
      		 
      > create role 'myrole';
      		 
      ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9908 cracklib plugin crashes server on CREATE ROLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            kolbe Kolbe Kegel (Inactive) created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Issue Type Task [ 3 ] Bug [ 1 ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Component/s Authentication and Privilege System [ 13101 ]
            Fix Version/s 10.1 [ 16100 ]
            Affects Version/s 10.1 [ 16100 ]
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Sprint 10.1.14 [ 51 ]
            serg Sergei Golubchik made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1.14 [ 21804 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 75381 ] MariaDB v4 [ 150339 ]

            People

              serg Sergei Golubchik
              kolbe Kolbe Kegel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.