Repository navigation
Roles without name #38447
|
Hi, I have a LDAP Server and I tried to add the group names to role names, using role-ldap-mapper. Somehow I did a wrong configuration and now I have 45 roles without any name. And I can't delete them, it shows an error. Mär 26 14:03:27 keycloak.example.com kc.sh[8184]: 2025-03-26 14:03:27,604 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (executor-thread-13) Uncaught server error: java.lang.NullPointerException
Mär 26 14:03:27 keycloak.example.com kc.sh[8184]: at java.base/java.util.Objects.requireNonNull(Objects.java:233)How can I delete all these roles without a name? Thanks! |
Replies: 2 comments
|
Any idea? |
|
I dumped the postgresql database to a file, deleted the wrong entries. Dropped the old database and imported the correct dump file. Backup[root@keycloak ~]# su - postgres Restore[root@keycloak ~]# su - postgres All good. |
I dumped the postgresql database to a file, deleted the wrong entries. Dropped the old database and imported the correct dump file.
Backup
[root@keycloak ~]# su - postgres
[postgres@keycloak ~]$ pg_dump keycloakdb > 2024-10-18_keycloakdb.psql.dump
Restore
[root@keycloak ~]# su - postgres
[postgres@keycloak ~] createuser keycloak
[postgres@keycloak ~] createdb keycloakdb
[postgres@keycloak ~] psql
$ alter user keycloak with encrypted password 'password';
$ grant all privileges on database keycloakdb to keycloak;
$ GRANT ALL ON DATABASE keycloakdb TO keycloak;
$ ALTER DATABASE keycloakdb OWNER TO keycloak;
$ GRANT USAGE, CREATE ON SCHEMA PUBLIC TO keycloak;
$ \q
$ logout
[postgres@keycloak …