Re: [keycloak-user] Managing Mysql relational database setup

Hello Dmitry, Can you please provide link of any source that i could refer for importing user credentials from existing mysql user table to keycloak "credentials" table! Regards, Deepa M G On Monday 15 October 2018 03:42 PM, Dmitry Telegin wrote: > Hello Deepa, > > On Mon, 2018-10-15 at 15:14 +0530, Deepa Gaddigoudar wrote: > > Hello All, > > > > > > I have configured keycloak DB from H2 to Mysql. My applications are  > > working fine too. What i want is, > > > >  1. Can i manage the user credentials? (Because i want to import > >     existing users credentials generated before integrating application > >     with keycloak, as we dont want to create new user credentials and > >     make it difficult for end users). > > The answer is "yes" provided that the hash algorithm is known. > > There are three hash algorithms supported out of the box, namely PBKDF2-{SHA1,SHA256,SHA512} > If your legacy hash format/algorithm is different from that, you'll need to implement a PasswordHashProvider. > Here's the example of how this was done for BCrypt: https://github.com/leroyguillaume/keycloak-bcrypt > > >  2. If i could import a existing credentials(username and password) to > >     keycloak mysql , then to which table?(Because i am not finding the > >     passwords) anywhere in table. > > The table is called "credential". > > Good luck! > Dmitry Telegin > CTO, Acutus s.r.o. > Keycloak Consulting and Training > > Pod lipami street 339/52, 130 00 Prague 3, Czech Republic > +42 (022) 888-30-71 > E-mail: info(a)acutus.pro > > > Thanks you   --  Deepa M Gaddigoudar | Software Developer Aissel Technologies Pvt. Ltd. A Block, Floor 2, IT Park, Hubli – 580029. India Ph (Ind) : +91 836-235-1011 l Ph: +1 347-966-8181 Cell: +91 8951519616 E-Mail: deepag(a)aissel.com