[keycloak-user] Corrupted policies

[Corentin Dupont]

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=8257adbe62f2518bc2ca736c29de937b#>:
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 at 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 at 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
>>
>
>