Scheduled Reporting stopped

[sgiworks]

Hello,

Scheduled reporting has stopped after maintenance license expiration and renewal. I know we cannot use enterprise feature if the maintenance is expired. However now as we have the renewal done and can see new expiration date. Can you guide me when do I need to enable the reporting?

On a separate note, how can I share the reports in my login to other users?

Regards,
Swapnil

[tgriep]

Can you login to the XI GUI and go to the Reports > My Scheduled Reports menu and do you see the reports there?
If so, edit one of them, and save it out to see if this will start the reports schedule.

Are you asking if you can share your scheduled reports with other users?

[sgiworks]

Yes, I do see the reports in 'My Scheduled Reports' and tried edit/save but still no luck.

For reports visibility, I would like other users to see the scheduled reports. Is it possible?

Regards,
Swapnil

[tgriep]

The Scheduled reports are run by the Cron daemon and the following file is the commands that cron runs to generate the reports.
Can you post that file from the Nagios server so we can view it?

Code: Select all

/var/spool/cron/apache

Also, post this log file for when the reports run so we can view it for any errors.

Code: Select all

/usr/local/nagiosxi/var/scheduledreporting.log

Also, can you verify that the Enterprise License is enabled on the server by going to the Admin > License Information menu.
If the Enterprise feature it not enabled, scheduled reports will not run because it needs that license.

The only way other users can see the scheduled reports in the XI GUI, they would have to login as your account.
Those reports cannot be shared or deployed to other users.

[sgiworks]

Attached apache file, however I could not find scheduledreporting.log at /usr/local/nagiosxi/var/

Yes, we have enterprise license enabled.

[tgriep]

Can you look in the cron log at 9:00 am and see if there are any errors on why the reports are not running?
The file is /var/log/cron

Then, lets run the reports manually. Login to the XI server in a shell, run the following and post the output.

Code: Select all

su apache
/usr/bin/php /usr/local/nagiosxi/html/includes/components/scheduledreporting/sendreport.php --report=i2nkim --username=swapnil.kadam
/usr/bin/php /usr/local/nagiosxi/html/includes/components/scheduledreporting/sendreport.php --report=q2d8o3 --username=swapnil.kadam
/usr/bin/php /usr/local/nagiosxi/html/includes/components/scheduledreporting/sendreport.php --report=c04psd --username=swapnil.kadam
/usr/bin/php /usr/local/nagiosxi/html/includes/components/scheduledreporting/sendreport.php --report=bhp9j4 --username=swapnil.kadam
/usr/bin/php /usr/local/nagiosxi/html/includes/components/scheduledreporting/sendreport.php --report=7m6ljh --username=swapnil.kadam

[sgiworks]

the Cron log is huge.


If I try to run manually I get the below error:

[root@ServerName /]# su apache
This account is currently not available.

[dwhitfield]

grep 09:00 /var/log/cron...if you need a specific day, you'll need quotes. Something like grep "Apr 12 09:00" /var/log/cron

[sgiworks]

[root@IWKSEUWPSSNXI01 /]# grep "Apr 12 09:00" /var/log/cron
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27703]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/deadpool.php > /usr/local/nagiosxi/var/deadpool.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27708]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/nom.php > /usr/local/nagiosxi/var/nom.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27709]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php > /usr/local/nagiosxi/var/eventman.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27710]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php > /usr/local/nagiosxi/var/cmdsubsys.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27711]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php > /usr/local/nagiosxi/var/perfdataproc.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27715]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php > /usr/local/nagiosxi/var/reportengine.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27712]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php > /usr/local/nagiosxi/var/sysstat.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27718]: (root) CMD (/var/awslogs/bin/awslogs-nanny.sh > /dev/null 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27714]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg --lock-file /var/lib/mrtg/mrtg.lock --confcache-file /var/lib/mrtg/mrtg.ok)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27719]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php > /usr/local/nagiosxi/var/event_handler.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27716]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php > /usr/local/nagiosxi/var/dbmaint.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27717]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php > /usr/local/nagiosxi/var/feedproc.log 2>&1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27720]: (root) CMD (/usr/lib64/sa/sa1 1 1)
Apr 12 09:00:01 IWKSEUWPSSNXI01 CROND[27722]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php > /usr/local/nagiosxi/var/cleaner.log 2>&1)
[root@IWKSEUWPSSNXI01 /]# grep "Apr 13 09:00" /var/log/cron
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17869]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/deadpool.php > /usr/local/nagiosxi/var/deadpool.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17868]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php > /usr/local/nagiosxi/var/event_handler.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17873]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php > /usr/local/nagiosxi/var/perfdataproc.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17875]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php > /usr/local/nagiosxi/var/cleaner.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17870]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php > /usr/local/nagiosxi/var/reportengine.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17877]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/nom.php > /usr/local/nagiosxi/var/nom.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17878]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php > /usr/local/nagiosxi/var/cmdsubsys.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17871]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php > /usr/local/nagiosxi/var/dbmaint.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17872]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php > /usr/local/nagiosxi/var/feedproc.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17879]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg --lock-file /var/lib/mrtg/mrtg.lock --confcache-file /var/lib/mrtg/mrtg.ok)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17874]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php > /usr/local/nagiosxi/var/sysstat.log 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17876]: (root) CMD (/var/awslogs/bin/awslogs-nanny.sh > /dev/null 2>&1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17883]: (root) CMD (/usr/lib64/sa/sa1 1 1)
Apr 13 09:00:01 IWKSEUWPSSNXI01 CROND[17880]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php > /usr/local/nagiosxi/var/eventman.log 2>&1)
[root@IWKSEUWPSSNXI01 /]#

[tgriep]

It looks like the cron job that runs as the apache user isn't getting scheduled.
Can you run the following commands and post the output?

Code: Select all

chage -l apache
ls -lR /var/spool/cron
grep apache /var/log/cron