[keycloak-user] Keycloak latest beta version for Sql server support

[Athulya Pillai]

Hi Stian,

Final version of keycloak 3.4.3 doesnt support sql out of box, for that purpose the repo from we got https://github.com/stocksoftware/docker-keycloak-sqlserver  has some customization to include sql server and have created the docker image.   But however in beta version of keycloak ie 4.0.0 beta2 , there is a parameter Db_Vendor in docker image which doesnt supports sql server. So even though the customization are in place to support sql server , this parameter value overrides to use H2 Database therby ignoring customization for sql .

Any help/suggestions

Thanks and Regards
Athulya Pillai

From: Stian Thorgersen [mailto:sthorger at redhat.com]
Sent: Thursday, June 07, 2018 7:15 PM
To: Athulya Pillai
Cc: Raphael Favier; keycloak-user at lists.jboss.org
Subject: Re: [keycloak-user] Keycloak latest beta version for Sql server support

The image does not support SQL Server, only MySQL and PostgreSQL. To use SQL Server you will have to extend the image to add the JDBC drivers and datasource configuration yourself.

On 7 June 2018 at 12:14, Athulya Pillai <Athulya.Pillai at cybertech.com<mailto:Athulya.Pillai at cybertech.com>> wrote:

Hi Raphael,
The link which you shared  seems to keycloak using MYSQL as database. However, in my case it is MS Sql Server.

This seems to be a bug in 4.0.0. Beta2
Thanks and Regards
Athulya Pillai

From: Raphael Favier [mailto:r.favier at tkhinnovations.com<mailto:r.favier at tkhinnovations.com>]
Sent: Thursday, June 07, 2018 3:41 PM
To: Athulya Pillai
Subject: Re: [keycloak-user] Keycloak latest beta version for Sql server support

Hi Athulya,
According to
http://lists.jboss.org/pipermail/keycloak-user/2017-November/012377.html
I guess it should be MYSQL

with kind regards
Raphael

On Thu, Jun 7, 2018 at 11:23 AM, Athulya Pillai <Athulya.Pillai at cybertech.com<mailto:Athulya.Pillai at cybertech.com><mailto:Athulya.Pillai at cybertech.com<mailto:Athulya.Pillai at cybertech.com>>> wrote:
Hi Team,
Latest verson for keycloak  is 4.0.0 beta2. When we deploy this version as a docker images, there is a a mandatory environment variable to  be set. The variable is DB_VENDOR which accepts only 4 values -H2, POSTGRES,MYSQL and MARIADB.

Please let me know the value for above parameter DB_VENDOR to deploy this keycloak image with microsoft sql server

Thanks and Regards
Athulya Pillai
_______________________________________________
keycloak-user mailing list
keycloak-user at lists.jboss.org<mailto:keycloak-user at lists.jboss.org><mailto:keycloak-user at lists.jboss.org<mailto:keycloak-user at lists.jboss.org>>
https://lists.jboss.org/mailman/listinfo/keycloak-user

_______________________________________________
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