jgroupsping table is created in public schema when DB_SCHEMA is different from DB_USER

[goooogs]

Descripition

• docker image: ivanfranchin/keycloak-clustered:12.0.4
• database: postgresql 12.0
  • user: hello
  • schema: world
• command:

  docker run --rm --name keycloak1 \
  --net mynetwork --ip 172.18.0.2 \
  -p 8080:8080 \
  -p 8443:8443 \
  -p 8009:8009 \
  -p 9990:9990 \
  -p 7600:7600 \
  -p 57600:57600 \
  -e KEYCLOAK_USER=admin \
  -e KEYCLOAK_PASSWORD=admin \
  -e DB_VENDOR=postgres \
  -e DB_ADDR=192.168.64.2 \
  -e DB_PORT=5432 \
  -e DB_DATABASE=hello \
  -e DB_SCHEMA=world \
  -e DB_USER=hello \
  -e DB_PASSWORD=hello \
  -e JGROUPS_DISCOVERY_PROTOCOL=JDBC_PING \
  -e JGROUPS_DISCOVERY_EXTERNAL_IP=172.18.0.2 \
  -e JGROUPS_DISCOVERY_PROPERTIES=datasource_jndi_name=java:jboss/datasources/KeycloakDS \
  -e PROXY_ADDRESS_FORWARDING=true \
  -e KEYCLOAK_FRONTEND_URL=http://192.168.64.2:8080/auth/ \
  ivanfranchin/keycloak-clustered:12.0.4

  ---

  Question

  If DB_SCHEMA is different from DB_USER, all tables are located in DB_SCHEMA (world for this example), except jgroupsping.

Where is jgroupsping ? If there is a schema has the same name as DB_USER(hello for this example), jgroupsping will be located in that schema. If there is no schema named as DB_USER, jgroupsping will be located in public schema.

---

Requirement or improvement

jgroupsping table should be created in DB_SCHEMA schema.

[ivangfr]

Thanks @goooogs ! I will have a look at it as soon as I have some free time.

[ivangfr]

@goooogs now jgroupsping table is created in DB_SCHEMA schema (in case DB_SCHEMA is provided). It's fixed in version ivanfranchin/keycloak-clustered:12.0.4. Could you please try it and give me your feedback? Thanks!

[ivangfr]

@goooogs due to no response, I am closing this issue. Please, open it if the problem still persists.