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:
--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.
CR1-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@
huebinet.de> <mailto:kevin.hirschmann@huebinet.de <mailto:
kevin.hirschmann(a)huebinet.de> >
Internet:
www.huebinet.de <
http://www.huebinet.de> <
http://www.huebinet.de/>
HUEBINET Informationsmanagement GmbH & Co. KG
An der Königsbach 8
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