emailed SLA reports do not display dashlets in pdf

[mvikhman]

Hello,
I have a strange problem. I trying to generate SLA reports that get emailed out on a schedule. The SLA report is generated from various Service groups that we have created. However, when the email arrives the attached PDF document in the email only displays the title of the dashelets but not actual dashlet it self. However, if I click on view my dashboard in NagiosXI, it all works fine. I have attached a screen shot of the dashboard and the pdf document that get sent with the email. Please let me know what additional information you need to help trouble shoot this issue.
I also have attached a profile.zip of our Nagios XI configuration / installation

Thank you
Michael
[email protected]

[vtrac]

Hi,
How are you doing?

Please edit your /etc/php.iniand change these:
max_execution_time = 60
max_input_time = 120
max_input_vars = 5000
memory_limit = 256M

To these:
max_execution_time = 300
max_input_time = 300
max_input_vars = 25000
memory_limit = 1280M

Then restart apache:

Code: Select all

systsemctl restart httpd

Best Regards,
Vinh

[mvikhman]

Thank you Vinh,
I made all the changes per your recommendations, however, still not working. We are still getting same pdf output as before. The pdf attachment only shows titles of the dashlets, but not the actual dashlets. I have attached a copy of my php.ini to confirm that the settings are correct.

Also want to confirm we only need to restart the httpd server. There is no additional php process to restart...correct?

Please advise further information on trouble shooting.

Regards,
Michael

[vtrac]

Hi,
How are you doing?
I do not see the database's log "mysql.log" or "mariadb.log" in the "profile.zip".
I also did not see the "nagios.log" as well.

I know your database is remote (not local) on the XI machine.

Could you please share those two files? ... "mariadb.log" and "/usr/local/nagios/var/nagios.log"

I compared your "php.ini" with my and it looks fine.

Can you please test other reports and see if you are getting the same error (empty PDF files)?


Best Regards,
Vinh

[vtrac]

Hi Michael,
I asked one of my senior team member (Sean) and here's what he suggested:

Please edit this file:
/usr/local/nagiosxi/html/config.inc.php

Under each of these lines:
"db" => 'nagiosxi',
"db" => 'nagios',
"db" => 'nagiosql',

Add this line under each of those lines above:
"charset" => 'utf8',

So it looks like this:
"db" => 'nagiosxi',
"charset" => 'utf8',

"db" => 'nagios',
"charset" => 'utf8',

"db" => 'nagiosql',
"charset" => 'utf8',

Additionally, have them go to Admin > Performance Settings > PDF/JPG Exporting, and check or uncheck the box and set both inputs to 6000. Then test again. It is likely one of those issues.

Please try adding those changes as suggested by Sean and see if it helps ...


Best Regards,
Vinh

[mvikhman]

Thank you.
Once I make changes in /usr/local/nagiosxi/html/config.inc.php, is there anything I need to restart.

Mike

[ssax]

No, nothing needs to be restarted.

[mvikhman]

Hi,
When you say to "check or un-check the box" :-
Are you referring to "Use patched jQuery 1.x to render PDF/JPG reports "
It currently checked, do you want me to try removing this check from this setting?

Thank you,
Mike

[ssax]

Yes, that's what I'm referring to, please uncheck it and click Update Settings then try the SLA report again.

[mvikhman]

Hi
Unfortunately none of these settings helped. I am still getting blank dashlets.
I am curious, In the "Edit Scheduled Page" for this email report, there is a "Page URL:" link that generates the report in the web browser instead of email to me. When I click on it, I counted and it take about 25 seconds for all the dashlets to be displayed.
Per your earlier suggestion, I have have changed the settings to 6000 milliseconds for Performance Settings => PDF/JPG Eporting. I am wondering if I should change the milliseconds to 30000, (30 Seconds) to let the report complete before creating a PDF and emailing out.

Please let me know what other things I can try to resolve this issue,

Regards,
Michael.