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

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@redhat.com] Sent: Thursday, June 07, 2018 7:15 PM To: Athulya Pillai Cc: Raphael Favier; keycloak-user(a)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@cybertech.com<mailto:Athulya.Pillai@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@tkhinnovations.com<mailto:r.favier@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@cybertech.com<mailto:Athulya.Pillai@cybertech.com><mailto:Athulya.Pillai@cybertech.com<mailto:Athulya.Pillai@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@lists.jboss.org<mailto:keycloak-user@lists.jboss.org><mailto:keycloak-user@lists.jboss.org<mailto:keycloak-user@lists.jboss.org>> https://lists.jboss.org/mailman/listinfo/keycloak-user _______________________________________________ keycloak-user mailing list keycloak-user@lists.jboss.org<mailto:keycloak-user@lists.jboss.org> https://lists.jboss.org/mailman/listinfo/keycloak-user