Reply
Highlighted
New Contributor
Posts: 4
Registered: ‎05-10-2016

Problem accessing embedded DB

I'm having problems accessing the Cloudera Manager UI because of problems with the embedded PostgreSQL database.

 

The web UI shows me:

 

HTTP ERROR 500

Problem accessing /cmf/home. Reason:

    org.hibernate.exception.GenericJDBCException: Could not open connection
Caused by:

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection
(...)

This seems to be because of what I find in /var/log/cloudera-scm-server/db.log:

 

FATAL:  password authentication failed for user "scm"

I've tried deleting /etc/cloudera-scm-server-db/db.*, and /var/lib/cloudera-scm-server-db/data/, and restarting the cloudera-scm-server-db service, but to no avail.

 

The weird thing is that I CAN access the database using:

 

psql -U scm -p 7432 -h localhost -d scm

with the generated password from /etc/cloudera-scm-server-db/db.properties.

 

I can also access using user cloudera-scm with the generated password in /var/lib/cloudera-scm-server-db/data/generated_password.txt without problem.

 

Any ideas are appreciated.

Announcements