Hi @Jonas Straub , thanks for answering. yep, audit-to-db is marked in HDFS Ranger plugin config, I checked MySQL directly as user 'rangeradmin', but the table xa_access_audit is empty. These are the settings for Ranger MySQL in Ambari => ... View more

Hi @Artem Ervits , if I will find the time to do so, I'll post an article here, for sure 😉 ... View more

ups, many thanks @Artem Ervits ! ... View more

Hi @John Cod , a good starting point for diving into Hive is: https://cwiki.apache.org/confluence/display/Hive/Home. If you install your cluster including Hive, the Hive Metastore will be installed as well...it is more or less "the brain" HTH, Gerd ... View more

Hello @Hajime , yes, at the end the problem got solved and I published the steps here https://community.hortonworks.com/content/kbentry/16373/ranger-ssl-pitfalls.html HTH, Gerd ... View more

Hello @Ancil McBarnett , I checked that ranger-admin-site.xml, it was not updated there. I was wondering, since I am using HDP2.2.4, why is that file under .../HDP/2.3/... ?!?! Anyways, I set the port to 6182, but unfortunately after restarting Ranger the alert was still there. So I searched for other RANGER configs, because of the HDP2.2.4 vs. HDP2.3 and at the end it turned out that I had to update the port in file /var/lib/ambari-server/resources/common-services/RANGER/0.4.0/configuration/ranger-site.xml After restarting Ranger the alert disappeared. Many thanks for this hint... ... View more

Hello @Shishir Saxena , I just checked another cluster with Ambari 2.1.2, there is the same situation. HTTP disabled, port set to 6182, but Ambari Alert is checking port 6080 This is the Ranger config used Ambari version 2.1.2.1 What else to check? ... View more

Many thanks @Shishir Saxena . ... View more