[keycloak-user] Corrupted policies

[Corentin Dupont]

Ohhh OK it works without any login/password...

On Fri, Nov 24, 2017 at 3:42 PM, Corentin Dupont <corentin.dupont at gmail.com>
wrote:

> 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
>>>
>>
>>
>