Support Questions
Find answers, ask questions, and share your expertise

Re: Ranger Audit Admin Page Not Found(404) Error

New Contributor

Follow below steps to fix the issue. 

 

Temp Solution:

 

login to mysql of ranger using root or ranger credentials. 

mysql -u root -p XXXXX

use ranger;

select * from vx_trx_log limit 1; u will get error message like "ERROR 1055 (42000): Expression #1 of SELECT list "

execute below command to set global variables to refresh the admin page. 

SET GLOBAL SQL_MODE = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

 

wait for few mins and refresh the page.

 

Permanent solution. 

 

Open MySQL config file(my.cnf) file and change/add sql_mode as given below under [mysqld] section of the file

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Restart MySQL server after shaving changes.

 

 

Re: Ranger Audit Admin Page Not Found(404) Error

Mentor

@Erkan ŞİRİN

Does the ranger host FQDN map to the ranger URL?

Can you share your Ranger Admin log file, xa_portal.log

Re: Ranger Audit Admin Page Not Found(404) Error

Expert Contributor

Hi @Geoffrey Shelton Okot It is attached.xa-portallog.txt

I think the problem is caused by this:

java.io.FileNotFoundException: /etc/ranger/admin/.rangeradmin.jceks.crc (Permission denied)