Cacti 0.8.7g + Nectar scheduled reports

[kostashov]

Hi, all.

I've a problem with cacti's nectar plugin: when I click to button "send report" and receive e-mail successfully.
But when i configure "Email Frequency" with settings:
-2011/06/09 17:00:00
-Day(s)
-1
-0
and I haven't receive e-mail successfully.

I research and found that:
1. In success result system
a. make changes in /var/log/mail

Jun 9 14:59:03 monitoring-ext postfix/pickup[15932]: 145993F316: uid=30 from=<wwwrun>
Jun 9 14:59:03 monitoring-ext postfix/cleanup[17843]: 145993F316: message-id=<20110609105903.145993F316@monitoring-ext.site>
Jun 9 14:59:03 monitoring-ext postfix/qmgr[1992]: 145993F316: from=<wwwrun@monitoring-ext.site>, size=373599, nrcpt=1 (queue active)
Jun 9 14:59:08 monitoring-ext postfix/smtp[17846]: 145993F316: to=<$user$@gmail.com>, relay=gmail-smtp-in.l.google.com[74.125.77.27]:25, delay=5.6, delays=0.85/0.86/1.5/2.4, dsn=2.0.0, status=sent (250 2.0.0 OK 1307617148 48si4022374eex.98)
Jun 9 14:59:08 monitoring-ext postfix/qmgr[1992]: 145993F316: removed

b. don't make changes in /var/log/messages
2. In unsuccess result system
a. make changes in /var/log/messages

Jun 9 15:15:01 monitoring-ext /USR/SBIN/CRON[18179]: (wwwrun) CMD ( php /usr/share/cacti/poller.php > /dev/null 2>&1)

b. don't make changes in /var/log/mail

in /var/log/cacti/cacti.log

.........
06/09/2011 02:55:24 PM - SYSTEM STATS: Time:21.8397 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:40 RRDsProcessed:34
06/09/2011 03:00:22 PM - SYSTEM STATS: Time:18.2881 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:40 RRDsProcessed:34
06/09/2011 03:05:10 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'xxxxxxxxx', and OID:'.1.3.6.1.2.1.1.3.0'
.........

Please give me a reasons for this bug asap.

[gandalf]

This is which version of cacti and which version of nectar? And, I need the version of the settings plugin.
R.

[kostashov]

Cacti 0.8.7g
Plugin Architecture 2.9
Nectar V 0.30

[TheWitness]

I suspect that the report is not enabled.

TheWitness

[kostashov]

Please tell me when this option enabling?
I have added screen shots of nectar.

[gandalf]

The report is indeed enabled.
Are you able to export the plugin_nectar* tables and pm/email them to me?
R.

[kostashov]

plugin_nectar* tables and pm/email

What is it?

[gandalf]

Thera are two tables in the cacti db that I need: plugin_nectar and plugin_nectar_items.
Please dump those either by using mysqldump or e.g. phpmyadmin and post them to my email account (find it underneath each of my posts)
R.

[kostashov]

I've already sended mysql dumps to your email. Please check.

[gandalf]

Will do
R.

[gandalf]

I obviously had to change the graphs to be mailed, but it simply works for me.
What happens, when you manually send the report in question by selecting "Send Now" action?
Did you verify, that Cacti is correctly configured for sending EMails (see "Settings -> Mail/DNS", try to send a test email here until everything is set up correctly).
And it may happen, that sending of email is supported but the email itself gets rejected due to a spam policy or the like
R.

[gandalf]

BTB: A screenshot of the nectar preview tab would help as well
R.

[TheWitness]

Reinhard,

What about /etc/php.ini setting "date.timezone = Somewhere". Might be the issue...

TheWitness

[gandalf]

Ok, but the OP reported, that on the sending system he found some maillog entries. So I supposed (in the first instance), that the report is generated and trying to be send. I currently suspect an issue in the mail send path.
R.

[kostashov]

What happens, when you manually send the report in question by selecting "Send Now" action?

I successfully received reports:

• From: Monitoring System <kostashov@gmail.com>
  Subject: Daily report from localhost
  Date: June 20, 2011 8:02:02 AM GMT+04:00
  To: Konstantin Ostashov <kostashov@gmail.com>
  Delivered-To: kostashov@gmail.com
  Received: by 10.231.207.12 with SMTP id fw12cs40947ibb; Sun, 19 Jun 2011 21:02:07 -0700 (PDT)
  Received: by 10.204.14.139 with SMTP id g11mr82601bka.199.1308542524783; Sun, 19 Jun 2011 21:02:04 -0700 (PDT)
  Received: from monitoring-ext.site ([80.245.96.2]) by mx.google.com with ESMTP id b11si14186498bkw.82.2011.06.19.21.02.03; Sun, 19 Jun 2011 21:02:04 -0700 (PDT)
  Received: by monitoring-ext.site (Postfix, from userid 30) id 5EC4040C71; Mon, 20 Jun 2011 08:02:02 +0400 (MSD)
  Return-Path: <wwwrun@monitoring-ext.site>
  Received-Spf: neutral (google.com: 80.245.96.2 is neither permitted nor denied by best guess record for domain of wwwrun@monitoring-ext.site) client-ip=80.245.96.2;
  Authentication-Results: mx.google.com; spf=neutral (google.com: 80.245.96.2 is neither permitted nor denied by best guess record for domain of wwwrun@monitoring-ext.site) smtp.mail=wwwrun@monitoring-ext.site
  X-Php-Originating-Script: 500:mailer.php
  X-Mailer: Cacti-Nectar-v0.30
  User-Agent: Cacti-Nectar-v0.30
  Content-Type: multipart/alternative; type="text/html"; boundary="--_MAILER_21332_1308542522_2251620"
  Mime-Version: 1.0
  Message-Id: <20110620040202.5EC4040C71@monitoring-ext.site>

Did you verify, that Cacti is correctly configured for sending EMails (see "Settings -> Mail/DNS", try to send a test email here until everything is set up correctly).

Yes I'm verify this option, you may look it in screenshot 1.
I successfully received reports:

• From: Konstantin Ostashov <kostashov@gmail.com>
  Subject: Cacti Test Message
  Date: June 20, 2011 8:02:16 AM GMT+04:00
  To: Konstantin Ostashov <kostashov@gmail.com>
  Delivered-To: kostashov@gmail.com
  Received: by 10.231.207.12 with SMTP id fw12cs40949ibb; Sun, 19 Jun 2011 21:02:17 -0700 (PDT)
  Received: by 10.204.233.15 with SMTP id jw15mr3603822bkb.48.1308542536947; Sun, 19 Jun 2011 21:02:16 -0700 (PDT)
  Received: from monitoring-ext.site ([80.245.96.2]) by mx.google.com with ESMTP id w13si14195270bkf.41.2011.06.19.21.02.16; Sun, 19 Jun 2011 21:02:16 -0700 (PDT)
  Received: by monitoring-ext.site (Postfix, from userid 30) id 3296A40C71; Mon, 20 Jun 2011 08:02:16 +0400 (MSD)
  Return-Path: <wwwrun@monitoring-ext.site>
  Received-Spf: neutral (google.com: 80.245.96.2 is neither permitted nor denied by best guess record for domain of wwwrun@monitoring-ext.site) client-ip=80.245.96.2;
  Authentication-Results: mx.google.com; spf=neutral (google.com: 80.245.96.2 is neither permitted nor denied by best guess record for domain of wwwrun@monitoring-ext.site) smtp.mail=wwwrun@monitoring-ext.site
  X-Php-Originating-Script: 0:mailer.php
  X-Mailer: Cacti-Mailer-Class
  User-Agent: Cacti-Mailer-Class
  Content-Type: text/plain
  Mime-Version: 1.0
  Message-Id: <20110620040216.3296A40C71@monitoring-ext.site>

BTB: A screenshot of the nectar preview tab would help as well

Yes I'm verify this option, you may look it in screenshot 2.

What about /etc/php.ini setting "date.timezone = Somewhere". Might be the issue...

Code: Select all

find /| grep php.ini
/etc/php5/apache2/php.ini
/etc/php5/cli/php.ini

Code: Select all

date.timezone = Europe/Moscow

Ok, but the OP reported, that on the sending system he found some maillog entries. So I supposed (in the first instance), that the report is generated and trying to be send. I currently suspect an issue in the mail send path.

Mail logs have attached earlier.