On 21 June 2016 at 15:38, Daniele Capasso Barbato <daniele.capasso@dnshosting.it> wrote:

Hi,

I want to use in the same keycloak, different datasource to store in
different database the eventsStore, realm and user data.

I configure 3 different mysql connections KeycloakDS, KeycloakLocal and
KeycloakRemote jndi source in standalone.xml for wildfly and it works
correctly.

In the keycloak-server.json there are this line for definition

"eventsStore": {
         "provider": "jpa",
         "jpa": {
             "exclude-events": [ "REFRESH_TOKEN" ]
         }
     },

     "realm": {
         "provider": "jpa"
     },

     "user": {
         "provider": "jpa"
     },

and for connections

"connectionsJpa": {
         "default": {
             "dataSource": "java:jboss/datasources/KeycloakDS",
             "databaseSchema": "update"
         } ,

     },

but how is possible specify a different connectionsJpa and use it for
realm,user and eventsStore ?

I try to modify the jpa connections declaration like this

"connectionsJpa": {
         "default": {
             "dataSource": "java:jboss/datasources/KeycloakDS",
             "databaseSchema": "update"
         } ,
         "second": {
             "dataSource": "java:jboss/datasources/KeycloakLocal",
             "databaseSchema": "update"
         },
         "third": {
             "dataSource": "java:jboss/datasources/KeycloakRemote",
             "databaseSchema": "update"
         }

     },

and no errors appears but all data and table are created in KeycloakDS only.

How can I configure to use the second a jpa connection for "realm data"
and to use third jpa connection for "users data" ?

Thank you very much

_______________________________________________
keycloak-user mailing list
keycloak-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user