Reports plugin not sending mail

AndyStewart · Posted: Fri Jun 30, 2006 3:42 am Post subject: Reports plugin not sending mail

Currently have the reports plugin installed (v0.1b) and have a report set up as a test.

Report looks ok, and preview looks ok as well.

But the scheduled mail never arrives.

I've checked the function report_mail in functions.php and noticed there were a few differences between it and the report_mail function in the thold plugin, so modified the code to look the same but to no avail - still no mail.

I know its a beta plugin, but is there any way i can test the report_mail function? can't find anything appearing in the cacti.log file and can't seem to find where the report_mail function is called from?

the thold mails work perfectly btw...

blackakashi · Joined: 13 Feb 2006 Posts: 11

Hi Andy,

It may be a poller bug.
Can you try with the cmd.php ?

Greetings.
Boris

AndyStewart · Posted: Fri Jun 30, 2006 5:44 am Post subject:

this is running with cmd.php

never managed to get cactid working as the poller properly yet....

AndyStewart · Posted: Wed Jul 05, 2006 5:02 am Post subject:

bump - anyone got any ideas? could REALLY do with getting this working

NHDave · Cacti User Joined: 20 Mar 2005 Posts: 58

Start by turning on debug logging for one pass near the time you schedule a report to be sent and check for errors.

AndyStewart · Posted: Thu Jul 06, 2006 5:41 am Post subject:

ok had debug logging on for a poll (scheduled task running E:\PHP\php-win.exe e:\inetpub\wwwroot\cacti\poller.php)

Cannot find any reference in the cacti.log to any files in the reports plugin folder.

I'm assuming that there should be a call somewhere in there to the check-reports.php file, but there isn't.

NHDave · Cacti User Joined: 20 Mar 2005 Posts: 58

What I get in mine anyways. Won't be anything related to a filename in reports folder.

07/06/2006 08:30:08 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from reports"
07/06/2006 08:30:08 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from reports_data where reportid=3 order by gorder"
07/06/2006 08:30:09 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "update reports set lastsent = 1152189009 where id = 3"

AndyStewart · Posted: Thu Jul 06, 2006 7:37 am Post subject:

...i get the 1st 2 lines in my logs, but not the 3rd line...

NHDave · Cacti User Joined: 20 Mar 2005 Posts: 58

Since you don't have the "lastsent" I would first go back to and restore the original functions file you edited or reinstall the plugin altogether and ensure you have the db tables in place.

NetAdmin · Cacti User Joined: 30 Aug 2006 Posts: 69

I'm in the exact same boat. I've got the report functionality installed and I'm able to create reports just fine, but nothing is getting emailed. (Kind of defeats the purpose.)

My Thold plugin is sending email just fine.

I would really like to get this report plugin to send emails as well. Has anyone got this working, even though it is still in beta?????

Thanks!

mcutting · Cacti Pro User Joined: 16 Oct 2006 Posts: 974

Did anyone ever get a response to this question ? I have a need to send reports via email, and can generate the reports fine (preview) etc, but can't email them - anyone have any ideas ?

Thanks

cigamit · Posted: Thu Oct 26, 2006 12:15 am Post subject:

Look at your PHP.ini mail settings. The reports plugin doesn't have all the extra sending options of thold, so it only tries sending out via PHP's Mail function. If your PHP isn't set to properly send mail, it won't make it out the door.

mcutting · Cacti Pro User Joined: 16 Oct 2006 Posts: 974

Could you give me an example of what I need to change ? THOLD works fine - I'd like to have the REPORTS plugin working too, as I have at least one immediate requirement for a daily management report.

Thanks

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

What you need to do is to get Sendmail working from your box, as the PHPMail function uses Sendmail to send stuff out.

Then Choose PHPmail in the THold/Alerting part of the settings, then give it a try.

I'd give a quick tutorial on how to get Sendmail working, if I knew what I had done to get it working!!!

However there is fair (if not complete) documentation in the Webmin manual...

Argon0

NetAdmin · Cacti User Joined: 30 Aug 2006 Posts: 69

Just wondering if there were any plans on updating the reports plugin so that it has the same sending functions as Thold. I'm using the SVN version of Reports which is very nice, but I'm unable to send email since my Cacti is configured to use SMTP. I don't have SendMail installed.

Thanks.

NetAdmin