Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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. 

 

CM_error-1.PNG

 

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 REPLIES 2

avatar
Master Collaborator

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

avatar
Master Collaborator

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