3:01 p.m.
Hello,
We have KeyCloak setup with SQL Server.
Whenever we restart SQL Server service, KeyCloak does not work anymore
until it is restarted too. Is this expected behavior?
Ideally, KeyCloak should automatically connect once the server is up?
Regards, Ushanas.
4:19 p.m.
This is a Wildfly/JBoss issue so check Wildfly/JBoss manual. There
should be settings on datasource configuration to handle this scenario.
On 12/1/16 9:01 AM, Ushanas Shastri wrote:
Hello,
We have KeyCloak setup with SQL Server.
Whenever we restart SQL Server service, KeyCloak does not work anymore
until it is restarted too. Is this expected behavior?
Ideally, KeyCloak should automatically connect once the server is up?
Regards, Ushanas.
_______________________________________________
keycloak-user mailing list
keycloak-user(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user
5:22 p.m.
Hello,
the following jboss-cli script fragment works for me (for postgres):
echo SETUP: Configure Keycloak Datasource KeycloakDS
/subsystem=datasources/data-source=KeycloakDS/:remove
data-source add --jndi-name=java:jboss/datasources/KeycloakDS
--name=KeycloakDS --connection-url=${env.JDBC_URL}
--driver-name=${env.JDBC_DRIVERNAME:postgres}
--user-name=${env.JDBC_USER:keycloak}
--password=${env.JDBC_PASSWORD:keycloak}
/subsystem=datasources/data-source=KeycloakDS/:write-attribute(name=min-pool-size,value=5)
/subsystem=datasources/data-source=KeycloakDS/:write-attribute(name=max-pool-size,value=20)
/subsystem=datasources/data-source=KeycloakDS/:write-attribute(name=background-validation,value=true)
/subsystem=datasources/data-source=KeycloakDS/:write-attribute(name=check-valid-connection-sql,value="select
1")
/subsystem=datasources/data-source=KeycloakDS/:write-attribute(name=background-validation-millis,value=120000)
Cheers,
Thomas
2016-12-01 16:19 GMT+01:00 Bill Burke <bburke(a)redhat.com>:
This is a Wildfly/JBoss issue so check Wildfly/JBoss manual. There
should be settings on datasource configuration to handle this scenario.
On 12/1/16 9:01 AM, Ushanas Shastri wrote:
> Hello,
>
> We have KeyCloak setup with SQL Server.
>
> Whenever we restart SQL Server service, KeyCloak does not work anymore
> until it is restarted too. Is this expected behavior?
>
> Ideally, KeyCloak should automatically connect once the server is up?
>
> Regards, Ushanas.
> _______________________________________________
> keycloak-user mailing list
> keycloak-user(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
_______________________________________________
keycloak-user mailing list
keycloak-user(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user
2708
days inactive
2708
days old
2 comments
3 participants
participants (3)
-
Bill Burke -
Thomas Darimont -
Ushanas Shastri