05-10-2016 11:42 AM
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.