[keycloak-user] Managing Mysql relational database setup

[Deepa Gaddigoudar]

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