I am getting below errors while trying to start Ranger Admin after the latest Ambari upgrade from 2.5.1 to 2.5.2: 2017-10-08 17:30:03,646 - Check db_connection_check was unsuccessful. Exit code: 1. Message: ERROR: Unable to connect to the DB. Please check DB connection properties.
java.sql.SQLException: Access denied for user 'rangerdba'@'scregionm1.field.hortonworks.com' (using password: YES)
Traceback (most recent call last):
File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 531, in <module>
CheckHost().execute()
File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 329, in execute
method(env)
File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 206, in actionexecute
raise Fail(error_message)
resource_management.core.exceptions.Fail: Check db_connection_check was unsuccessful. Exit code: 1. Message: ERROR: Unable to connect to the DB. Please check DB connection properties.
java.sql.SQLException: Access denied for user 'rangerdba'@'scregionm1.field.hortonworks.com' (using password: YES) I confirmed 'rangerdba' user has proper privileges on the MySQL node: mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
+----------------------------------+-------------+-------------------------------------------+------------+------------+
| host | user | password | Grant_priv | Super_priv |
+----------------------------------+-------------+-------------------------------------------+------------+------------+
| localhost | root | | Y | Y |
| scregionm2.field.hortonworks.com | root | | Y | Y |
| 127.0.0.1 | root | | Y | Y |
| ::1 | root | | Y | Y |
| % | rangerdba | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | Y | Y |
| % | hive | *1C2AF9445ECD574DB1D3E4584424EDFB768C1E70 | N | Y |
| localhost | rangerdba | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | Y | Y |
| scregionm2.field.hortonworks.com | rangerdba | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | Y | Y |
| % | rangerkms | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | N | N |
| localhost | rangerkms | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | N | N |
| scregionm2.field.hortonworks.com | rangerkms | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | N | N |
| % | rangeradmin | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | N | N |
| localhost | rangeradmin | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | N | N |
| scregionm2.field.hortonworks.com | rangeradmin | *0DFC06DA054FDC6F974A6709CFCE366817B59894 | N | N |
| % | streamline | *46ADB7217AF6CE7227CD73C4F4AD1C157D664E7F | N | N |
| ambariservernode | rangeruser | | Y | Y |
| scregionm1.field.hortonworks.com | rangerdba | | Y | Y |
| scregionm0.field.hortonworks.com | rangerdba | | Y | Y |
+----------------------------------+-------------+-------------------------------------------+------------+------------+
18 rows in set (0.00 sec) I also checked MySQL connection from the Ranger Admin node to the MySQL instance is fine: sqlline> !connect jdbc:mysql://scregionm2.field.hortonworks.com/mysql rangerdba BadPass#1
Connecting to jdbc:mysql://scregionm2.field.hortonworks.com/mysql
Connected to: MySQL (version 5.6.35)
Driver: MySQL-AB JDBC Driver (version mysql-connector-java-5.1.17-SNAPSHOT ( Revision: ${bzr.revision-id} ))
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:mysql://scregionm2.field.hortonworks.> select version();
+------------+
| version() |
+------------+
| 5.6.35 |
+------------+
1 row selected (0.031 seconds) Any help is appreciated. Thanks.
... View more
