[keycloak-user] keycloak 3.4.0 - Missing relation

[Pedro Igor Silva]

Although I just run a container with KC + PG (v10) and it just boots fine
...

On Mon, Nov 20, 2017 at 2:46 PM, Hynek Mlnarik <hmlnarik at redhat.com> wrote:

> You might be able to set Postgres schema search_path
> via new-connection-sql property set to "SET search_path TO
> <your_schema_name>" on Keycloak datasource (untested).
>
> You can set the default schema search path database-wise as per this
> article: https://stackoverflow.com/questions/2875610/permanently-
> set-postgresql-schema-path
>
> --Hynek
>
> On Mon, Nov 20, 2017 at 3:36 PM, Kevin Hirschmann <khirschmann at huebinet.de
> > wrote:
>
>> Hi,
>>
>>
>>
>> It is postgres.
>>
>>
>>
>> Von: Pedro Igor Silva [mailto:psilva at redhat.com]
>> Gesendet: Freitag, 17. November 2017 16:07
>> An: Kevin Hirschmann <khirschmann at huebinet.de <mailto:
>> khirschmann at huebinet.de> >
>> Cc: keycloak-user at lists.jboss.org <mailto:keycloak-user at lists.jboss.org>
>> Betreff: Re: [keycloak-user] keycloak 3.4.0 - Missing relation
>>
>>
>>
>> What is your database ?
>>
>>
>>
>> On Fri, Nov 17, 2017 at 12:11 PM, Kevin Hirschmann <
>> khirschmann at huebinet.de <mailto:khirschmann at huebinet.de> > wrote:
>>
>> Hello everybody,
>>
>> I am setting up a new keycloak instance (3.4.0) resulting in the
>> following error (Relation does not exist):
>>
>> INFO  [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider]
>> (ServerService Thread Pool -- 78) Updating database. Using changelog
>> META-INF/jpa-changelog-master.xml
>> ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider]
>> (ServerService Thread Pool -- 78) Change Set META-INF/
>> jpa-changelog-authz-3.4.0.CR1.xml::authz-3.4.0.CR1-
>> resource-server-pk-change-part2::glavoie at gmail.com <mailto:
>> jpa-changelog-authz-3.4.0.CR1.xml%3A%3Aauthz-3.4.0.C
>> R1-resource-server-pk-change-part2%3A%3Aglavoie at gmail.com>  failed.
>> Error: FEHLER: Relation Ųesource_server_policyӠexistiert nicht
>>   Position: 8 [Failed SQL: UPDATE RESOURCE_SERVER_POLICY p SET
>> RESOURCE_SERVER_CLIENT_ID = (SELECT CLIENT_ID FROM RESOURCE_SERVER s WHERE
>> s.ID = p.RESOURCE_SERVER_ID)]: liquibase.exception.DatabaseException:
>> FEHLER: Relation Ųesource_server_policyӠexistiert nicht
>>   Position: 8 [Failed SQL: UPDATE RESOURCE_SERVER_POLICY p SET
>> RESOURCE_SERVER_CLIENT_ID = (SELECT CLIENT_ID FROM RESOURCE_SERVER s WHERE
>> s.ID = p.RESOURCE_SERVER_ID)]
>>
>>
>> The problem only occurs, if I do NOT use the default schema. If I use the
>> default schema everything is great.
>> How can I work around this problem?
>>
>> Thx for your help
>>
>> Kevin Hirschmann
>>
>> HUEBINET Informationsmanagement GmbH & Co. KG
>>
>>
>> Telefon:           +49 (0) 261 / 5 00 86 - 17
>> <tel:%2B49%20%280%29%20261%20%2F%205%2000%2086%20-%2017>
>> Telefax:           +49 (0) 261 / 5 00 86 - 29
>> <tel:%2B49%20%280%29%20261%20%2F%205%2000%2086%20-%2029>
>> E-Mail:             kevin.hirschmann at huebinet.de <mailto:
>> kevin.hirschmann at huebinet.de> <mailto:kevin.hirschmann at huebinet.de
>> <mailto:kevin.hirschmann at huebinet.de> >
>> Internet:            www.huebinet.de <http://www.huebinet.de> <
>> http://www.huebinet.de/>
>>
>>  HUEBINET Informationsmanagement GmbH & Co. KG
>> An der Königsbach 8
>> <https://maps.google.com/?q=An+der+K%C3%B6nigsbach+8+%0D+56075+Koblenz&entry=gmail&source=g>
>> 56075 Koblenz
>>
>> Sitz und Registergericht: Koblenz HRA 5329
>>
>> Persönlich haftender Gesellschafter der KG:
>> HUEBINET GmbH;
>> Sitz und Registergericht: Koblenz HRB 6857
>>
>> Geschäftsführung:
>> Dr. Carsten Schöpp; Michael Biemer; Michael Ewertz
>> ------------------------------------------------------------
>> ------------------------------------------------------------
>> ------------------------------------------------
>>
>> Der Nachrichtenaustausch mit HUEBINET Informationsmanagement GmbH & Co.
>> KG, Koblenz via E-Mail dient lediglich zu Informationszwecken.
>> Rechtsgeschäftliche Erklärungen mit verbindlichem Inhalt können über dieses
>> Medium nicht ausgetauscht werden, da die Manipulation von E-Mails durch
>> Dritte nicht ausgeschlossen werden kann.
>>
>> Email communication with HUEBINET Informationsmanagement GmbH & Co. KG is
>> only intended to provide information of a general kind, and shall not be
>> used for any statement with binding contents in respect to legal relations.
>> It is not totally possible to prevent a third party from manipulating
>> emails and email contents.
>>
>> _______________________________________________
>> keycloak-user mailing list
>> keycloak-user at lists.jboss.org <mailto:keycloak-user at lists.jboss.org>
>> https://lists.jboss.org/mailman/listinfo/keycloak-user
>>
>>
>>
>> _______________________________________________
>> keycloak-user mailing list
>> keycloak-user at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/keycloak-user
>>
>
>
>
> --
>
> --Hynek
>