[keycloak-user] How to integrate or make use of KeyCloak user database in my own application?

[Marek Posolda]

Hi,

you can take a look at this example : 
https://github.com/keycloak/keycloak/tree/master/examples/providers/domain-extension
which uses this feature (especially look at the bottom for custom JPA 
entities): 
https://keycloak.gitbooks.io/server-developer-guide/content/v/2.1/topics/extensions.html

It allows to extend Keycloak database schema with your own entities.

Marek

On 01/09/16 19:25, Ling wrote:
> hi, Christian:
>
> Are you suggesting using two databases, one is MyKeycloakDS to store 
> keycloak data, and the other MyApplicationDS to store my application 
> data? Or you mean just use one database MyKeycloakDS to store both 
> keycloak user data and my application data? You said you don't 
> recommend mixing the keycloak tables with my own, then is it possible 
> to create a connection between the User_Entity table in KeyCloak 
> database, and the Post table in my own database? Not an database expert :)
>
> Thank you.
>
> On Thu, Sep 1, 2016 at 7:33 AM, Christian Hebert 
> <christian_hebert at hotmail.com <mailto:christian_hebert at hotmail.com>> 
> wrote:
>
>     Hi Ling,
>
>     I wouldn't recommend mixing the keycloak tables with your own but
>     here is how you could do it. First, you should store the keycloak
>     data in your database instead of using the default H2 database. We
>     are using Oracle in our organization.
>
>     To do so, you need to create a new datasource in your jboss server
>     (I will not cover how to create this, assuming that you know how)
>     that you will name, let's say "java:jboss/datasources/MyKeycloakDS".
>
>     In your keycloak-server.json file, change the datasource under
>     "connectionsJpa" for this new datasource.On the startup, keycloak
>     will create all the tables required.
>
>     Please note that your current data (realm, users, roles, ...) will
>     not be there. You will start as a fresh installation of Keycloak.
>
>     From this point, the table you are looking for is "USER_ENTITY".
>
>     Hope this can help you!
>
>     Christian
>
>     ------------------------------------------------------------------------
>     From: lingvisa at gmail.com <mailto:lingvisa at gmail.com>
>     Date: Wed, 31 Aug 2016 10:53:20 -0700
>     To: keycloak-user at lists.jboss.org
>     <mailto:keycloak-user at lists.jboss.org>
>     Subject: [keycloak-user] How to integrate or make use of KeyCloak
>     user database in my own application?
>
>
>     Hi, All:
>
>     So far I have been playing with KeyCloak and been able to set it
>     up and running the customer-portal example successfully. Now I
>     need to actually use it in my application, and I am not totally
>     sure whether KeyCloak is the thing that I am looking for, but I
>     believe my need is just a common use case and hopefully KeyCloak
>     is the right software that I am looking for..
>
>     When a user comes to my website, he registers and makes a post.
>     Both the post and the user information is stored into databases,
>     and the link between the user and post, i.e. who made which post?
>     So I have two tables in my database: Post(id, post) and
>     User(id,name), and another table UserPost(PostID, UserID) to store
>     linking information. This is all fine in my own database.
>
>     But now when KeyCloak comes into play, the user first registers in
>     KeyCloak server and user information are stored in its own
>     database there, which seems unrelated to the database (Post and
>     User) in my application. I don't want to duplicate two User
>     databases in two servers, right? Even if I can tolerate the
>     duplication, how to make the connection between KeyCloak database
>     and my application database? I am using JBoss, Hibernate/JPA in my
>     application.
>
>     Maybe I am missing something in the way how to connect KeyCloak
>     with my own application. Is there any tutorial or documentation
>     that I can read?
>
>     Thank you.
>
>
>
>
>     _______________________________________________ keycloak-user
>     mailing list keycloak-user at lists.jboss.org
>     <mailto:keycloak-user at lists.jboss.org>
>     https://lists.jboss.org/mailman/listinfo/keycloak-user
>     <https://lists.jboss.org/mailman/listinfo/keycloak-user>
>
>
>
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20160906/5dff2ad7/attachment.html