Skip to main content
Dalier
Gold ⭐️
August 26, 2025
Solved

No database server found while adding Cloudera Management Service.

I have deployed a single node cluster in my lab.  It consists of two virtual machines implemented in VMware: one manager and one host.

Trying to Add Cloudera Management Service to address warning “Unable to issue query: could not connect to host monitor”.

This is a test of my database:

    [root@cloudera-manager ~]# hostname -A
    cloudera-manager.interop.local cloudera-manager

    [root@cloudera-manager ~]# psql -d scmdb -U scm -W
    Password for user scm:
    psql (10.23)
    Type "help" for help.

I entered the following in the Setup Database  GUI:

    Type: PostgreSQL
    Database Hostname: cloudera-manager.interop.local
    Database Name: scmdb
    Usename: scm
    Password: xxxxxxx

Selecting Test Connection fails.

Any ideas?

Dalier.

ymprakash
ymprakashAnswer
Gold ⭐️
August 27, 2025

@Dalier Only Reports Manager role in Cloudera Management Service needs database connectivity and you cannot use scmdb for Reports Manager.

You need to create separate database for Reports manager.Please follow below link.

https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/installation/topics/cdpdc-create-tls-12-rm-database.html 

2 replies

ymprakash
Gold ⭐️
ymprakashAnswer
Gold ⭐️
August 27, 2025

@Dalier Only Reports Manager role in Cloudera Management Service needs database connectivity and you cannot use scmdb for Reports Manager.

You need to create separate database for Reports manager.Please follow below link.

https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/installation/topics/cdpdc-create-tls-12-rm-database.html 

Translate
ymprakash
Gold ⭐️
Gold ⭐️
August 29, 2025

@Dalier Did the response assist in resolving your query? If it did, please mark the relevant reply as the solution, as it will help others locate the answer more easily in the future. 

Translate