12:53 p.m.
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.
9:33 a.m.
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(a)gmail.com
Date: Wed, 31 Aug 2016 10:53:20 -0700
To: keycloak-user(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user
12:25 p.m.
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(a)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(a)gmail.com
Date: Wed, 31 Aug 2016 10:53:20 -0700
To: keycloak-user(a)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(a)lists.jboss.org https://lists.jboss.org/
mailman/listinfo/keycloak-user
1:17 a.m.
Hi,
you can take a look at this example :
https://github.com/keycloak/keycloak/tree/master/examples/providers/domai...
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/...
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(a)hotmail.com <mailto:christian_hebert@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(a)gmail.com <mailto:lingvisa@gmail.com>
Date: Wed, 31 Aug 2016 10:53:20 -0700
To: keycloak-user(a)lists.jboss.org
<mailto:keycloak-user@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(a)lists.jboss.org
<mailto:keycloak-user@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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user
3046
days inactive
3052
days old
3 comments
3 participants
participants (3)
-
Christian Hebert -
Ling -
Marek Posolda