question Re: No database server found while adding Cloudera Management Service. in Support Questions

No database server found while adding Cloudera Management Service.

Dalier — Tue, 26 Aug 2025 18:41:48 GMT

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.

Re: No database server found while adding Cloudera Management Service.

ymprakash — Wed, 27 Aug 2025 00:36:36 GMT

@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

Re: No database server found while adding Cloudera Management Service.

ymprakash — Fri, 29 Aug 2025 16:42:53 GMT

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