In our DevTest UAT environment we are trying to configure our database connections with integrated security. For some reason we see errors that we are unable to make a database connection.
Instead of a SQL Server ID, we are trying to use an AD ID.
Currently we are on SP2/HF21
Here are the iam.properties settings:
Updated iam.properties
iam.db.url=jdbc:sqlserver://DBServerName\
iam.db.user=Domain\\User094003
iam.db.password=xxxxxxx
server.log:
2023-09-28 16:20:39,684 WARN [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator] (JPA Startup Thread: keycloak-default) HHH000342: Could not obtain connection to query metadata: java.sql.SQLException: Acquisition timeout while waiting for new connection
at io.agroal.pool.ConnectionPool.handlerFromSharedCache(ConnectionPool.java:320)
at io.agroal.pool.ConnectionPool.getConnection(ConnectionPool.java:248)
at io.agroal.pool.DataSource.getConnection(DataSource.java:86)
at io.quarkus.hibernate.orm.runtime.customized.QuarkusConnectionProvider.getConnection(QuarkusConnectionProvider.java:23)
at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:181)
at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68)
at io.quarkus.hibernate.orm.runtime.recording.PrevalidatedQuarkusMetadata.buildSessionFactoryOptionsBuilder(PrevalidatedQuarkusMetadata.java:68)
at io.quarkus.hibernate.orm.runtime.boot.FastBootEntityManagerFactoryBuilder.build(FastBootEntityManagerFactoryBuilder.java:72)
at io.quarkus.hibernate.orm.runtime.FastBootHibernatePersistenceProvider.createEntityManagerFactory(FastBootHibernatePersistenceProvider.java:72)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:80)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
at io.quarkus.hibernate.orm.runtime.JPAConfig$LazyPersistenceUnit.get(JPAConfig.java:165)
at io.quarkus.hibernate.orm.runtime.JPAConfig$1.run(JPAConfig.java:66)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.util.concurrent.TimeoutException
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:204)
at io.agroal.pool.ConnectionPool.handlerFromSharedCache(ConnectionPool.java:296)
... 23 more
Release : 10.7.2
The security auth dll needs to be copied to the java library classpath: (i.e. java.library.path = c:\program files\ca\devtest\jre\bin )
## MS SQL Server using Windows Authentication
Updated iam.properties
iam.db.url=jdbc:sqlserver://DBServerName\
iam.db.user=Domain\\User094003
iam.db.password=xxxxxxx
. Stop all DevTest components.
. Delete all the log files in DEVTEST_HOME/IdentityAccessManager/data/log and DEVTEST_HOME/lisatmp10.x folder
. Start all DevTest components.
Login to IAM ,ED and Portal to verify.