Client Tools cannot connect to Application server in 'connected mode' when on a Virtual Appliance

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

'Connected mode' is when the Client Tool is configured to retrieve the database credentials and details from the Web Application Server.

When using the Virtual Appliance and selecting "Request SQL credentials from a server" under Files => General Settings => SQL Connectivity tab, an error appears.

Cause: 

This is assuming that you are using the embedded database that is provided with the Virtual Appliance in demo/custom/sandbox installation.

The IG server uses internally the hostname record of “database_srv” to connect to the database.

This is an internal placeholder pointing to the IP address of the actual vApp server running the Oracle 11g express embedded database (as selected during the deployment – not necessarily the same server running IG).

When using the “Request SQL Credentials from a server” method, the IG server relays this hostname value to your workstation running IG client tools, and connectivity fails since your workstation cannot be resolve it.

This issue should not occur when using an external database.

Environment

Release: CAIDMB99000-12.6-Identity Manager-B to B
Component:

Resolution

1)  1) Run the following command on the CLI/SSH console of any vApp server belonging to the solution:
grep database_srv /etc/hosts

2) Copy and paste the returned record to the hosts file: C:\Windows\System32\drivers\etc\hosts
e.g. 

10.0.0.169 database_srv

3) You should now be able to make the connection using IG client tools (you may need to close and re-open the IG client tools for this configuration to take effect)