Page 3 of 4
Re: Report fetching error
Posted: Tue Mar 03, 2020 1:27 pm
by progressive.nagiosXI
Hi,
Login as the user in question and go to the Reports menu, in the Legacy Reports section, can you run the Legacy version of the Availability report?
==>> yes,we are able to fetch nagios report from Legacy Reports section in users account .
I am guessing that you are accessing the server through some sort of device as the IP address in the Program and External URL is different that the IP address of the server.
Can you see if that is blocking the report?
==>> we also face this issue in production server in nagiosxi where versions > 5.6.8
I do see a use account issue, the welcompack account has a space on the end of the username, edit the username and remove the space from the end.
==>> we renamed this but no solution
Also, get the following file and PM it to me.
Code: Select all
/usr/local/nagiosxi/etc/htpasswd.users
[/quote]
==> attached
we also share snapshot for same user report where we are not getting permission issue after nagiosxi downgrade to 5.6.8 and service graph icon also showing
attachment shared in PM ==> tgriep
Thanks
Re: Report fetching error
Posted: Tue Mar 03, 2020 2:33 pm
by tgriep
I talked with a developer and went over the htpasswd file you sent is and we noticed that there are a lot of duplicated accounts (Some upper case, some lower case characters, same name) in it and that may be causing the permission issues.
Can you edit the /usr/local/nagiosxi/etc/htpasswd.users file and remove the duplicate entries.
There was a bug in an older version of XI that would allow the duplicated users and that would cause issues. That was fixed in the new version of XI but since the old accounts still exist in your files, it is causing the issue you are having.
The system is supposed to rebuild the file but there may be another permission issue that is causing XI from updating the htpasswd file.
Run the following and post the /tmp/info.txt file so I can check them.
Code: Select all
ls -lR /usr/local/nagios >/tmp/info.txt
ls -lR /usr/local/nagiosxi >>/tmp/info.txt
Re: Report fetching error
Posted: Wed Mar 04, 2020 1:33 pm
by progressive.nagiosXI
Hi,
require info.txt shared in PM ==> tgriep
Please help here ,how we identify which duplicate entry need to delete and vkl-report2019 user not contain any duplicate entry then why its showing authentication error
[root@monitoring-nagiosxi gearmand]# cat /usr/local/nagiosxi/etc/htpasswd.users |grep -i direct
shared in PM
[root@monitoring-nagiosxi gearmand]# cat /usr/local/nagiosxi/etc/htpasswd.users |grep -i vkl
shared in PM
Thanks
Re: Report fetching error
Posted: Wed Mar 04, 2020 5:40 pm
by tgriep
Responded in the PM
Re: Report fetching error
Posted: Tue Mar 24, 2020 9:14 am
by progressive.nagiosXI
Hi Team,
we have done the changes today and remove all entries except below(nagiosadmin and nagiosxi ) in /usr/local/nagiosxi/etc/htpasswd.users
but still issue is not resolved and for all users getting below error
ERROR: You are not authorized to view this report.
Code: Select all
[root@monitoring-nagiosxi etc]# cat htpasswd.users
nagiosadmin:{SHA}hCLQ7l4awPeVC73Hzxxxxxxxxx=
nagiosxi:{SHA}Xey9q+XHXUveKDv5606XXXXXXXE=
Note:- after deleting all entries in htpasswd.users , whenever we login to user then new entry created in this file with username and encrypted password for that login user.
Thanks
Re: Report fetching error
Posted: Tue Mar 24, 2020 11:07 am
by tgriep
Make sure after the user account is created in the htpasswd file that they logout of the GUI and get back in.
Lets truncate the objects in the nagios database so they can be recreated.
Run the following as root.
Code: Select all
systemctl stop nagios
systemctl stop ndo2db
systemctl stop httpd
echo 'TRUNCATE TABLE nagios_objects;' | mysql -u root -pnagiosxi nagios
systemctl start httpd
systemctl start ndo2db
systemctl start nagios
Wait for 10 minutes so the table is rebuilt and have the users login and test.
Re: Report fetching error
Posted: Tue Mar 24, 2020 1:06 pm
by progressive.nagiosXI
Thanks tgriep,
Now we getting report,
After execute truncate command look like issue is resolved now ,we check this for 8 users and getting no problem.
we will observe this for 2 week , because first week of every month is reporting time and we cover all users at that time ,if getting problem for any user we will let you know.
Thanks
Re: Report fetching error
Posted: Tue Mar 24, 2020 1:44 pm
by progressive.nagiosXI
Hi as report permission issue resolved we have another issue / case that we closed because looks similar related to report pdf report error
for one client we are still not getting data in pdf file please check the attachment(profile ,issue snap doc file,report pdf) ==> shared in PM
Thanks
Re: Report fetching error
Posted: Tue Mar 24, 2020 4:25 pm
by tgriep
That is good news that the truncation work. I'll wait for the PM for the other issue.
FYI, I have not received it.
Re: Report fetching error
Posted: Wed Mar 25, 2020 12:01 am
by progressive.nagiosXI
Hi ,
details shared in PM please check
Thanks