Ranger Audit stopped working after server reboot

[#1]

Hello

We use Ranger for auditing Hive. Yesterday at 15:20 after restarting the Server that runs Ambari (Ambari audits to the default mysql which is on the same server) the auditing has stopped working. Ranger is up & running, mysql is also running, plugins are working and synced with Hiveserver2. Yet no data is being audited to he db since the reboot of the server. I've queried the xa_ranger_audit table and it shows entries up until the server reboot.

Clearly something imperative is not running.

Any suggestions are appreciated !

9856-snap-2016-11-29-at-110830.png

9857-snap-2016-11-29-at-110847.png

[#2 · Accepted solution]

Found the problem.

Investigating the hiveserver2.log showed that rangerlogger failed to flush data to the db due to permission problem (Internal Exception: java.sql.SQLException: Access denied for user 'rangerlogger'@'<server>' (using password: YES) Error Code: 1045)

After granting the permissions it flushed the data successfully.

Now i just need to figure out what caused the loss of permissions and how the hell it is related to the server reboot....

Thanks for all your help !