[keycloak-user] Managing Mysql relational database setup

[Dmitry Telegin]

Deepa,

The importing process itself should be trivial, but before that you need to sort out the hash algorithm issue.

Could you please show us some sample records from your MySQL user table? (provided that there's no sensitive info there; you can create a test user for that)

Dmitry

On Mon, 2018-10-15 at 16:00 +0530, Deepa Gaddigoudar wrote:
> 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 at 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 at aissel.com