6:16 a.m.
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(a)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(a)huebinet.de
> wrote:
> Hi,
>
>
>
> It is postgres.
>
>
>
> Von: Pedro Igor Silva [mailto:psilva@redhat.com]
> Gesendet: Freitag, 17. November 2017 16:07
> An: Kevin Hirschmann <khirschmann(a)huebinet.de <mailto:
> khirschmann(a)huebinet.de> >
> Cc: keycloak-user(a)lists.jboss.org <mailto:keycloak-user@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(a)huebinet.de <mailto:khirschmann@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@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(a)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(a)huebinet.de <mailto:
> kevin.hirschmann(a)huebinet.de> <mailto:kevin.hirschmann@huebinet.de
> <mailto:kevin.hirschmann@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&...
> 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(a)lists.jboss.org <mailto:keycloak-user@lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>
>
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>
--
--Hynek