Nagios XI Report Using Command Line

[sandeepatil]

We are currently monitor more than 1000 Host with Nagios XI single instance, but facing during fetching report server utilization going high or hang state.

Want to know, can we able fetch report using command line.

[tacolover101]

running over the CLI won't help at all as SQL is still single thraded.

what kind of report are you trying to run? how large is it?

with only 1000 hosts, SQL should be performing fine so i tend to think there is some issue with your infrastructure, or you're running a ridiculously large report.
- what type of disks are you running?
- is this physical or virtual? public or private cloud?
- how much resources do you have allocated to the machine?

[sandeepatil]

Every time sever going in hang, during report fetching of last 2 month. (Availability etc.)

Please find requested details :

- what type of disks are you running?
HDD
- is this physical or virtual? public or private cloud?
This virtual server. vmware
- how much resources do you have allocated to the machine?
Memory : 64 GB
CPU : Intel(R) Xeon(R) CPU E5-2660 v2 @ 2.20GHz, 4 core.
HDD : 500GB

[dwasswa]

Hi @sandeepatil,


What version of Nagios XI are you currently running?

If it's not the latest, I advise that you upgrade to the latest.

Secondly, please run the Availability Report in Nagios XI and then run a Legacy Availability Report which basically runs off Nagios core and let me know if you get the same result.


Follow the steps below on how to run a Legacy Report:


On the Reports Menu, scroll down and click the Legacy Reports link:

Reports_Tab.PNG

Then:

Report_Step1.PNG

Lastly:

Report_Step2.PNG

[sandeepatil]

Tried shared steps, but after clicking on Availability Report or any other option in Report section nagios GUI stuck no other click are working.

[kyang]

If the GUI is hanging when you are trying to load the "availability report" could you try increasing PHP variables?

https://support.nagios.com/kb/article/n ... s-611.html

Once they are increased, restart apache.

Code: Select all

service httpd restart

If that didn't work, could you run a report and when it hangs give us the apache error_logs and put the output in code wraps or a text file.

Code: Select all

tail -50 /var/log/httpd/error_log