Where are Database and LDAP Configurations Stored in IAM and VS Catalog

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

Where are database properties and LDAP configurations stored in vscatalog/IAM?

Environment

Release: All supported DevTest releases
Component: ITKOVS

Resolution

The database connection information is store in this file: 

\IdentityAccessManager\standalone\configuration\standalone.xml 

Look for pool-name="KeyClocksDs" 

See my below example, targeting SQL Server: 

<datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true"> 
<connection-url>jdbc:sqlserver://mysqlserver:1433;databaseName=vscatalog</connection-url> 
<driver>mssql</driver> 
<security> 
<security-domain>EncryptDBPassword</security-domain> 
</security> 
</datasource> 

LDAP details are stored in 2 tables. The following query fetches the details about the LDAP server configuration. 

select c.name,cc.name,cc.value,cc.id,cc.component_id from component_config cc,component c where cc.component_id=c.id and c.provider_id='ldap' order by c.name asc