1 Reply Latest reply on Dec 4, 2019 8:37 AM by mayerw01

    wildfly-18.0.1.Final: Not all attributes are listed via console

    mayerw01

      When opening

       

      Configuration => Subsystems => Configuration => Security (Elytron) => Security Realms => JDBC Realm => Principal Query

       

      the field "Attribute Mapping" shows only the first attribute

      Query

       

      via cli this looks correct

       

      /subsystem=elytron/jdbc-realm=MySqlJDBCRealm:read-resource

      {

          "outcome" => "success",

          "result" => {"principal-query" => [{

              "sql" => "SELECT u.password, r.role FROM users u, roles r WHERE u.userna

      me =? AND u.username = r.username",

              "data-source" => "MySQLTestDS",

              "attribute-mapping" => [{

                  "to" => "groups",

                  "index" => 2

              }],

              "clear-password-mapper" => {"password-index" => 1}

          }]}

      }

       

      Console