question Ranger Admin install with access denied error in Support Questions

Ranger Admin install with access denied error

rajkumarraibis — Fri, 16 Sep 2016 21:29:13 GMT

I am getting following error while installing ranger-admin from ambari

2016-09-16 14:15:24,498 [JISQL] /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.71-2.b15.el7_2.x86_64/bin/java -cp /usr/share/java/mysql-connector-java.jar :/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://<host>/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "SELECT version();" SQLException : SQL state: 28000 java.sql.SQLException: Access denied for user 'rangeradmin'@'host' (using password: YES) ErrorCode: 1045 2016-09-16 14:15:24,811 [E] Can't establish connection!! Exiting..

I have already given all required permission to rangeradmin , root , mapped them with host % , localhost what is that i am missing ? Pls help

Re: Ranger Admin install with access denied error

WhiteHa — Fri, 16 Sep 2016 21:34:11 GMT

Can you follow this document https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_Ranger_Install_Guide/content/configuring_mysql_for_ranger.html Also if you can provide a screenshot or log file, it will be helpful.

Re: Ranger Admin install with access denied error

rajkumarraibis — Fri, 16 Sep 2016 21:53:34 GMT

pfa logs rangeradmin-install-logs.txt

I am following below link as per my HDP version https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_Ranger_Install_Guide/content/ch_overview_ranger_ambari_install.html

My ambari server and Rangeradmin are on different nodes

Rangeradmin and its mysql metastore are on same node

I am able to run python dba_script successfully on rangeradmin nodes specifying host as localhost

i am also able to run following command successfully from ambari server node , suggesting there is no firewall issue

nc ambaridbhostname 3306

Re: Ranger Admin install with access denied error

WhiteHa — Fri, 16 Sep 2016 23:57:55 GMT

Did you followed this https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_Ranger_Install_Guide/content/configuring_mysql_for_ranger.html and run those MySQL queries?

Re: Ranger Admin install with access denied error

rajkumarraibis — Sat, 17 Sep 2016 00:00:28 GMT

Yes that is correct

Re: Ranger Admin install with access denied error

dsharma — Sat, 17 Sep 2016 05:42:27 GMT

as logs says permission denied so you need yo go to the db that you configured in ranger and grant the provilleges to root user for ranger admin host with grant options and then try again it will work something like:

grant all on Databases to 'root'@'hostname' identified by 'password' with grant option;

Flush privileges;

Re: Ranger Admin install with access denied error

rajkumarraibis — Mon, 19 Sep 2016 20:38:15 GMT

no this is not working

problem is that i am not able to remote connect my mysql instance

these are azure VMs

Re: Ranger Admin install with access denied error

rajkumarraibis — Mon, 26 Sep 2016 20:07:37 GMT

any update please

Re: Ranger Admin install with access denied error

rajkumarraibis — Fri, 30 Sep 2016 20:12:01 GMT

I have resolved the issue ,

In MySQL metastore 'rangeruser'@'ambariservernode' needs grant permission rights for installation to be successfull this is not documented in hortonworks installation doc

GRANT ALL PRIVILEGES ON *.* TO 'rangeruser'@'ambariservernode' WITH GRANT OPTION;

Re: Ranger Admin install with access denied error

Love_Cat — Fri, 09 Sep 2022 02:16:00 GMT

Think u ,it works!🤗