question Re: Ranger test db connection failing in Archives of Support Questions (Read Only)

Ranger test db connection failing

aliyesami — Wed, 12 Jul 2017 00:24:32 GMT

I am getting this error

2017-07-11 13:18:41,662 - 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 'root'@'hadoop1.tolls.dot.state.fl.us' (using password: YES)

ok I fixed this issue by creating the user 'root'@'hadoop1.tolls.dot.state.fl.us' but my question is why ranger is connecting to the database as root1@hadoop1 and not root@hadoop2 ?

Re: Ranger test db connection failing

vperiasamy — Wed, 12 Jul 2017 00:38:11 GMT

what version of HDP are you using? Make sure you have given all privileges to the root user "with grant option". Please see https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_security/content/configuring_mysql_for_ranger.html

Re: Ranger test db connection failing

vperiasamy — Wed, 12 Jul 2017 00:39:43 GMT

where is ranger running? If it is on 'hadoop1', then it is connecting to db from 'hadoop1'. You could also create 'root'@'%' user.