About rajkumarraibis

rajkumarraibis · ‎09-30-2016

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;

rajkumarraibis · ‎09-26-2016

any update please

rajkumarraibis · ‎09-19-2016

no this is not working problem is that i am not able to remote connect my mysql instance these are azure VMs

rajkumarraibis · ‎09-16-2016

Yes that is correct

rajkumarraibis · ‎09-16-2016

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

rajkumarraibis · ‎09-16-2016

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

Online	Offline
Last Visited	‎09-30-2016 01:12 PM

Member Since	‎09-14-2016 11:01 AM
Last Visited	‎09-30-2016 01:12 PM
Posts	6
Kudos received	1

Cloudera Community

Cloudera Community

Re: Ranger Admin install with access denied error

Re: Ranger Admin install with access denied error

Re: Ranger Admin install with access denied error

Re: Ranger Admin install with access denied error

Re: Ranger Admin install with access denied error

Re: Ranger Admin install with access denied error

Ranger Admin install with access denied error