Member since
12-05-2019
5
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
6588 | 12-06-2019 02:52 AM |
12-13-2019
09:50 AM
While trying to used the hue Web Ui I've had the same problem. I my case the problem was that the impala service was not running. I was trying to do a hive query but impala was set as the default application. So as soon as I connect to Hue Web Ui it tries to connect to the Impala server and throws the error message. Therefore any query you run gets executed by impala and throws the error. To solve this, you must check that impala service is running properly.
... View more
12-06-2019
02:52 AM
I was using the wrong reset admin password and salt. The version that I found searching the internet only worked for version 4. For version 5(.8?) and 6 we must use the following: UPDATE users SET password_hash = '9f7e3270b1aaa4931d38845a0334e66b2dd93f916439006fac4e5e2535a444b3', password_salt = -5357030608435271136 WHERE user_name = 'admin'; I used the following: UPDATE users SET password_hash = 'ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8', password_salt = -4382599614486590865 WHERE user_name = 'admin'; and that did not work. It seems this one is only valid for version 4. Found the solution on: Re: reset cdm (5.8) password unfortunately I had tested the old version first and it didn't work so I went searching for another solution besides reseting the admin password. I can now login. What I can't understand is what happened that invalidated my previous password but I will not dwell into that as I already lost way to much time on this problem. Thank you for the help. Gonçalo
... View more
12-06-2019
01:57 AM
Worked for 6.3.1 (The "9f7e3270b1aaa4931d38845a0334e66b2dd93f916439006fac4e5e2535a444b3", -5357030608435271136) The other combination "ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8", -4382599614486590865 DID NOT work in 6.3.1.
... View more
12-05-2019
03:49 PM
Hi @lwang, The CM version is 6.3.1. This Cloudera Manager server is new (it's being configured and tested). I was able to login through the UI until very recently (since the installation a couple of weeks ago). I always logged with the admin account. Originally the server had neither Kerberos nor Sentry so I believe it was using the "scm" database. Last week I tried to activate kerberos and was able to continue using the Cloudera Manager Web UI. Today I tried to activate the "Sentry" service, for usage with Hive, and was around that time that the login stopped working. I am not sure that's the cause but it's a possibility. Thank you very much for the docs you sent me but I cannot follow them as I don't have access to the Cloudera Manager interface. I read the first doc and a few things sounded promising: "You can configure Cloudera Manager to authenticate users against the Cloudera Manager database or against an external authentication service" - I would like very much to authenticate against the CM database. Is it possible to configure it with the command line? "Users accounts in the Cloudera Manager database page show Cloudera Manager in the User Type column. User accounts in an LDAP directory or other external authentication mechanism show External in the User Type column." - I tried to find the column in the scm database but I couldn't find it. It it only visible on the web page? The third link sounded very promising but I cannot access it. It ask me to sign in but if I try to do it I get the error "The page isn’t redirecting properly". Thank you very much for the help, Gonçalo Redondo
... View more
12-05-2019
12:30 PM
When I connect to 'http://xxx.xxx.xxx:7180/cmf/login' I can see the login screen but any user/password combination that I use fails.
I've tried to change the "users" table on the "scm" database to "ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8" and -4382599614486590865 to try to reset the passwd of admin but nothing works.
cloudera-scm-server.log adds a new line for each login try:
"INFO scm-web-114:com.cloudera.server.web.cmf.AuthenticationFailureEventListener: Authentication failure for user: 'admin' from 111.222.333.111"
If I try some random user the error is the same (minus the user).
Could Kerberos or Sentry have anything to do with this?
Thank you
Gonçalo Redondo
... View more
Labels:
- Labels:
-
Cloudera Manager