No database server found while adding Cloudera Management Service.

[#1]

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.

[#2 · Accepted solution]

@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-da... 

[#3]

@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.