04-19-2018 11:47 AM - edited 04-19-2018 11:49 AM
Yeah, I had the same problem and I found the culprit in this log, thanks.
When trying to start cloudera-scm-server it started correctly (apparently, it says OK in green), but it wasn't started. In the log /var/log/cloudera-scm-server/cloudera-scm-server.log I could see this error:
java.sql.SQLException: Access denied for user 'cm'@'localhost' (using password: YES)
I was working with the VM with no problem days before and I didn't change anything. Why it just stopped working? I don't know. But with this post I tried root user instead of cm (changing /etc/cloudera-scm-server/db.properties file) and it worked! :)
After changing the db.properties file I had to restart the services doing this:
Hope it helps!
04-19-2018 02:44 PM - edited 04-19-2018 03:03 PM
Now Hue doen't work... another password problem:
OperationalError: (1045, "Access denied for user 'hue'@'localhost' (using password: YES)")
I don't get it, I didn't change the password after the first Hue login.
The way to get the password is (if I am right):
creds.localjceks is a binary file, so I don't know what password is set in order to change hue password in linux account (I'm not sure if would fix the problem).
Cloudera Manager can't start Hue server because this error, how can I fix Hue?
PD: There is no need for password as I can test trying logging with hue user with mysql... so I tried to comment password line (previous 2º item) and still it is setting the pass. n-hue-HUE_SERVER is created when startint Hue server... so I need to find the original config.
04-24-2018 05:21 AM - edited 04-24-2018 05:22 AM
The user/pass cloudera doesn't work in mysql, but even if it would worked it won't solve my problem.
The thing is, why suddently the access to cm/hue's mysql stop working? I mean 'cm'@'localhost' failed and I had to use root user. Now with HUE I can't use Hue user with the defined password.
In order to continue using cloudera VM I have created another VM and works well.