Report Query

AndyStewart · Posted: Wed Jun 27, 2007 4:41 am Post subject: Report Query

I've looked at ReportIt (great plugin) and also an older report plugin that has since disappeared from cactiusers.org (reports)

I'm looking for a plugin that will allow me to e-mail certain graph items to a e-mail address, either daily or weekly.

Preferably it would just be a ticklist of available graphs, and select which ones i want to show on a report.

Does such a plugin exist? The old "reports" plugin allowed this sort of thing to be set up, but a scheduler for sending the e-mails was never implemented?

mcutting · Cacti Guru User Joined: 16 Oct 2006 Posts: 1007

You can find an updated version of this plugin here http://cactiusers.org/forums/viewtopic.php?t=836&highlight=reports

Let me know if you get problems downloading it.

AndyStewart · Posted: Wed Jun 27, 2007 8:31 am Post subject:

yeh thats the one i've got, but the automated e-mail bit never worked.

dloading now to see if new version is better

mcutting · Cacti Guru User Joined: 16 Oct 2006 Posts: 1007

Hmmm....works for me - give the new version a try, and let me know if it doesn't work.

AndyStewart · Posted: Wed Jun 27, 2007 9:24 am Post subject:

ok installed and looks good (previews anyway)

I've tried clicking "send now" and no e-mail appears, and nothing appears in the log file that i can see.

THOLD is installed and working correctly, and all e-mail alerts for this work fine, and i know the reports is meant to use the same alerting info as this.

I've also created a scheduled task on my cacti server that runs plugins/reports/check-reports.php but this doesn't generate any e-mails or errors in the log file either - any ideas?

mcutting · Cacti Guru User Joined: 16 Oct 2006 Posts: 1007

Are you using SMTP for email ? I know the reports plugin normally only works with PHPMail that I know of. You shouldn't need the scheduled task - the poller takes care of the report sending when it is due.

AndyStewart · Posted: Wed Jun 27, 2007 9:38 am Post subject:

ah ok, i'll hack the code to get the SMTP working then

Cheers for your help

mcutting · Cacti Guru User Joined: 16 Oct 2006 Posts: 1007

No need to hack the code. In the settings tab for THRESHOLD, change the SMTP mail type to PHPMail.

AndyStewart · Posted: Wed Jun 27, 2007 9:57 am Post subject:

yeh but for some reason for me, SMTP works well, phpMail don't work at all

mcutting · Cacti Guru User Joined: 16 Oct 2006 Posts: 1007

If you use the test button with PHPMail enabled, what do you get ?

AndyStewart · Posted: Wed Jun 27, 2007 10:00 am Post subject:

Checking Configuration...
Creating Message Text...

This is a test message generated from Cacti. This message was sent to test the configuration of your Mail Settings.

Your email settings are currently set as follows

Method: PHP's Mailer Class

Sending Message...

Could not instantiate mail function.

mcutting · Cacti Guru User Joined: 16 Oct 2006 Posts: 1007

AndyStewart · Posted: Wed Jun 27, 2007 10:13 am Post subject:

ok PHPEmail now works (cheers for that), testmail works, threshold mails still work, but the reports one still sends nothing.

Tried PDF, Inline PNG and JPG - nothing appearing in cact.log either...

mcutting · Cacti Guru User Joined: 16 Oct 2006 Posts: 1007

Bizarre - how about if you drop any tables that you have created for the reports, and try the plugin again ?

AndyStewart · Posted: Thu Jun 28, 2007 4:00 am Post subject:

ok, used SQLyog (MySQL UI) to drop the reports and reports_data table.

ran plugins/reports/setup.php to rebuild the tables.

Added a report back in with 2 graphs and 2 text entries - checked in SQLyog that the data was in the tables ok.

Preview works fine, but "send now" with PNG,JPG,PDF still does nothing at all - and still nothing at all appearing in log (i switched settings to DEBUG before clicking the send now to check)

I'll cross post this over to the thread above where the author posted the plugin to see if he can help as well...

Almost there

the reports are what I/manager was looking for, so just need to resolve the auto-mail issue and he'll be happy.