Report fetching error

[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

[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

[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

[tgriep]

Responded in the PM

[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

[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.

[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

[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

[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.

[progressive.nagiosXI]

Hi ,

details shared in PM please check

Thanks