Page 1 of 2
Scheduled Reporting stopped
Posted: Wed Apr 05, 2017 2:29 pm
by 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
Re: Scheduled Reporting stopped
Posted: Wed Apr 05, 2017 4:53 pm
by 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?
Re: Scheduled Reporting stopped
Posted: Wed Apr 12, 2017 1:43 pm
by 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
Re: Scheduled Reporting stopped
Posted: Wed Apr 12, 2017 3:15 pm
by 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?
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.
Re: Scheduled Reporting stopped
Posted: Thu Apr 13, 2017 12:50 pm
by sgiworks
Attached apache file, however I could not find scheduledreporting.log at /usr/local/nagiosxi/var/
Yes, we have enterprise license enabled.
Re: Scheduled Reporting stopped
Posted: Thu Apr 13, 2017 1:43 pm
by 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
Re: Scheduled Reporting stopped
Posted: Fri Apr 14, 2017 8:31 am
by 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.
Re: Scheduled Reporting stopped
Posted: Fri Apr 14, 2017 9:13 am
by 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
Re: Scheduled Reporting stopped
Posted: Fri Apr 14, 2017 12:39 pm
by 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 /]#
Re: Scheduled Reporting stopped
Posted: Fri Apr 14, 2017 1:08 pm
by 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