Able to find the database server and database, but the login request was rejected - Postgresql

[#1]

Hi All,

When we try to install the Cloudera Management Service we got the below error "login request was rejected" in PostgresSQL. Please advise.

PostgresSQL  - 10.19

Cloudera manager - 7.6.5, and

OS - RHEL 8.4.

There is no Auto-TLS or Kerberos as it is a POC cluster we trying to install. 

error message in Cloudera-scm-server.log:

2022-11-23 19:07:36,287 ERROR CommandPusher-1:com.cloudera.cmf.model.DbCommand: Command 1546334432(RepMgrTestDatabaseConnection) has completed. finalstate:FINISHED, success:false, msg:Logon denied for user/password. Able to find the database server and database, but the login request was rejected.

2022-11-23 19:07:36,287 INFO CommandPusher-1:com.cloudera.cmf.command.components.CommandStorage: Invoked delete temp files for command:DbCommand{id=1546334432, name=RepMgrTestDatabaseConnection, host=hostname01.company.com} at dir:/var/lib/cloudera-scm-server/temp/commands/1546334432

Kind Regards,

Sri

[#2]

Hi,

Can you create a separate user in the database for each service and retry?

You should NOT use the root user for all databases.

Refer below doc:

https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_ig_extrnl_pstgrs.html#cmig_topic...

Regards,

Chethan YM

[#3]

@Srinivs Kindly check if the username and passwords are correct for DB and there should not be any extra space. 

grant the privileges as shown below.

postgres=# GRANT CONNECT ON DATABASE rman TO rman;
GRANT
postgres=# GRANT ALL ON DATABASE rman TO rman;
GRANT
postgres=# GRANT ALL PRIVILEGES ON DATABASE "rman" to rman;
GRANT

 
If you found that the provided solution(s) assisted you with your query, please take a moment to login and click Accept as Solution below each response that helped.