Re: [keycloak-user] Corrupted policies
OK thanks I updated keycloak.
From the standalone.xml, the default passwords seems to be sa/sa.
But this login/password is rejected when I try to connect to the data base.
I use:
Driver class: org.h2.Driver
JDBC URL
<http://localhost:8082/login.jsp?jsessionid=8257adbe62f2518bc2ca736c29de93...;:
jdbc:h2:<folder containing my keycloak.h2.db>
username: sa
password: sa
On Fri, Nov 24, 2017 at 2:18 PM, Pedro Igor Silva <psilva(a)redhat.com> wrote:
Hi,
My suggestion is upgrade to latest version of Keycloak. This issues was
already fixed.
The issue is all about role policies (and I think user policies too)
getting corrupted after exporting settings given that the policy is updated
in the database with the name of the role instead of its ID.
For login/password to access H2, check
${KEYCLOAK_HOME}/standalone/configuration/standalone.xml.
There you will find the datasource configuration used by Keycloak
(KeycloakDS).
Regards.
On Fri, Nov 24, 2017 at 10:18 AM, Corentin Dupont <
corentin.dupont(a)gmail.com> wrote:
> I guys,
> I encountered this bug:
> https://issues.jboss.org/browse/KEYCLOAK-4340
>
> Basically after exporting, my policies are inaccessible.
> My keycloak version is 3.1.0.Final.
> Is there a workaround?
> Can I delete the policies via API?
> Should I edit the database?
> I connected to H2 database but there is no tables.
> What is the login/password when logging to H2?
>
> Cheers
>