Step "database setup" – failed test-connections – Cloudera set up

During Database set up phase, you did a “Test Connection” and you encounter ‘Unknown host:7432’ (or) wrongHostname:7432 error!
Either you have changed the hostname during the process and the oldHostname remained in the file /etc/cloudera-scm-server/db.mgmt.properties or cloudera manager left it blank.

In either case, go to the file /etc/cloudera-scm-server/db.mgmt.properties and check whether all the below 4 hostnames are properly mapped. If not, change it to the appropriate hostname

#vim /etc/cloudera-scm-server/db.mgmt.properties
#Edit these properties and map to appropriate hostname
com.cloudera.cmf.ACTIVITYMONITOR.db.host=yourHostname:7432
com.cloudera.cmf.REPORTSMANAGER.db.host=yourHostname:7432
com.cloudera.cmf.NAVIGATOR.db.host=yourHostname:7432
com.cloudera.cmf.NAVIGATORMETASERVER.db.host=yourHostname:7432

and restart the scm server as below:

# service clouders-scm-server restart