What is your database ? On Fri, Nov 17, 2017 at 12:11 PM, Kevin Hirschmann <khirschmann(a)huebinet.de&gt; 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-sc... --Hynek On Mon, Nov 20, 2017 at 3:36 PM, Kevin Hirschmann <khirschmann(a)huebinet.de&gt; wrote: -- --Hynek

Sorry, I have to ask it: You have set the schema in your standalone.xml to a schema which is not the “public” schema? Without the last property it works. No doubt about that. If I set the schema property the “keycloak” schema gets populated with 91 tables till it exits with the error below. <properties> <property name="dataSource" value="java:/KeycloakDS"/> <property name="initializeEmpty" value="true"/> <property name="migrationStrategy" value="update"/> <property name="migrationExport" value="${jboss.home.dir}/keycloak-database-update.sql"/> <property name="schema" value="keycloak"/> </properties> @Hynek: Thanks, I will give that a try. Von: Pedro Igor Silva [mailto:psilva@redhat.com] Gesendet: Dienstag, 21. November 2017 13:17 An: Hynek Mlnarik <hmlnarik(a)redhat.com&gt; Cc: Kevin Hirschmann <khirschmann(a)huebinet.de>; keycloak-user <keycloak-user(a)lists.jboss.org&gt; Betreff: Re: [keycloak-user] keycloak 3.4.0 - Missing relation 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 <mailto:hmlnarik@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-sc... --Hynek On Mon, Nov 20, 2017 at 3:36 PM, Kevin Hirschmann <khirschmann(a)huebinet.de <mailto:khirschmann@huebinet.de> > wrote: Hi, It is postgres. Von: Pedro Igor Silva [mailto:psilva@redhat.com <mailto:psilva@redhat.com> ] Gesendet: Freitag, 17. November 2017 16:07 An: Kevin Hirschmann <khirschmann(a)huebinet.de <mailto:khirschmann@huebinet.de> <mailto:khirschmann@huebinet.de <mailto:khirschmann@huebinet.de> > > Cc: keycloak-user(a)lists.jboss.org <mailto:keycloak-user@lists.jboss.org> <mailto:keycloak-user@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> <mailto:khirschmann@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@gmail.com> <mailto:jpa-changelog-authz-3.4.0.CR1.xml%3A%3Aauthz-3.4.0.CR1-resource-server-pk-change-part2%3A%3Aglavoie@gmail.com <mailto:jpa-changelog-authz-3.4.0.CR1.xml%253A%253Aauthz-3.4.0.CR1-resource-server-pk-change-part2%253A%253Aglavoie@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> <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@huebinet.de> > <mailto:kevin.hirschmann@huebinet.de <mailto:kevin.hirschmann@huebinet.de> <mailto:kevin.hirschmann@huebinet.de <mailto:kevin.hirschmann@huebinet.de> > > Internet: www.huebinet.de <http://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> <mailto:keycloak-user@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 <mailto:keycloak-user@lists.jboss.org> https://lists.jboss.org/mailman/listinfo/keycloak-user -- --Hynek