Created 06-13-2017 05:36 PM
I've updated admin user's passwd via postgres. restarted admin-server and saw that it's running, however i can not login to admin page via admin / admin user and passwd.
URL and error message is below:
http://192.168.1.27:8080/#/login
Unable to sign in. Invalid username/password combination.
Created 06-13-2017 05:43 PM
Can you please confirm the following:
1. Have you run the following Exact SQL query to reset the ambari credentials for admin user to "admin" (following is the encrypted value of 'admin' password, We can not use plain text). Followed by ambari server restart.
UPDATE ambari.users SET user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' WHERE user_name='admin';
.
2. Do you see any Error or Warning in the ambari server logs?
3. From the client machine where you are using the browser are you able to telnet ambari server host & port? This is because sometimes the browser shows us the cached login page.
# from client machin (browser machine) # telnet $AMBARI_HOSTNAME 8080 # telnet $AMBARI_IPAddress 8080
4. Have you already tried opening the browser in "Private Window" (Firefox) in Google Chrome in "Incognito Mode"
.
Created 06-14-2017 11:11 AM
any update?
Created 06-14-2017 11:50 AM
can you see my updates?
Created 06-14-2017 12:15 PM
1. Have you run the following Exact SQL query to reset the ambari credentials for admin user to "admin" (following is the encrypted value of 'admin' password, We can not use plain text). Followed by ambari server restart. UPDATE ambari.users SET user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' WHERE user_name='admin'; --MA yes, executed the query. 2. Do you see any Error or Warning in the ambari server logs? --MA no logs.. 3. From the client machine where you are using the browser are you able to telnet ambari server host & port? This is because sometimes the browser shows us the cached login page. --MA the error message is "invalid username / password", so there is not an access problem i guess. --MA I've already tried to access the page via internet explorer browser and the result was the same. # from client machin (browser machine) # telnet $AMBARI_HOSTNAME 8080 # telnet $AMBARI_IPAddress 8080 4. Have you already tried opening the browser in "Private Window" (Firefox) in Google Chrome in "Incogn
Created 06-14-2017 12:15 PM
1. Have you run the following Exact SQL query to reset the ambari credentials for admin user to "admin" (following is the encrypted value of 'admin' password, We can not use plain text). Followed by ambari server restart. UPDATE ambari.users SET user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' WHERE user_name='admin'; --MA yes, executed the query.
2. Do you see any Error or Warning in the ambari server logs? --MA no logs..
3. From the client machine where you are using the browser are you able to telnet ambari server host & port? This is because sometimes the browser shows us the cached login page.
--MA the error message is "invalid username / password", so there is not an access problem i guess.
--MA I've already tried to access the page via internet explorer browser and the result was the same. # from client machin (browser machine) # telnet $AMBARI_HOSTNAME 8080 # telnet $AMBARI_IPAddress 8080
4. Have you already tried opening the browser in "Private Window" (Firefox) in Google Chrome in "Incognito Mode"
--MA the error message is "invalid username / password", so there is not an access problem i guess.
Created 06-14-2017 03:34 PM
are you there? will you answer me?
Created 06-14-2017 04:11 PM
additionally,
C:\Users\merta>telnet $AMBARI_IPAddress 8080 Connecting To $AMBARI_IPAddress...Could not open connection to the host, on port 8080: Connect failed
C:\Users\merta>telnet $AMBARI_HOSTNAME 8080 Connecting To $AMBARI_HOSTNAME...Could not open connection to the host, on port 8080: Connect failed
but C:\Users\merta>telnet 192.168.1.27 8080 is working..
and with incognito mode, still receiving the same error..
Created 06-15-2017 09:55 AM
is there anyone there? is this community working?
Created 06-15-2017 10:07 AM
I can think of 2 things at this point:
1. Either your password reset command is not committed to the Database. (usually "auto-commit' happens on postgres) but better to check if the SQL queries are actually committed or not? OR ambari server is not restarted after making DB changes.
2. Your Ambari Database may be different and you might be making changes to other DB. We can check the ambari.properties file to see if the DB is default or remote.
# grep 'jdbc' /etc/ambari-server/conf/ambari.properties server.jdbc.connection-pool=internal server.jdbc.database=postgres server.jdbc.database_name=ambari server.jdbc.postgres.schema=ambari server.jdbc.user.name=ambari server.jdbc.user.passwd=${alias=ambari.db.password}
.