Report Query

AndyStewart · Post by **AndyStewart** » Wed Jun 27, 2007 4:41 am

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 · Post by **mcutting** » Wed Jun 27, 2007 8:29 am

You can find an updated version of this plugin here http://cactiusers.org/forums/viewtopic. ... ht=reports

Let me know if you get problems downloading it.

AndyStewart · Post by **AndyStewart** » Wed Jun 27, 2007 8:31 am

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 · Post by **mcutting** » Wed Jun 27, 2007 8:35 am

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

AndyStewart · Post by **AndyStewart** » Wed Jun 27, 2007 9:24 am

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 · Post by **mcutting** » Wed Jun 27, 2007 9:26 am

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 · Post by **AndyStewart** » Wed Jun 27, 2007 9:38 am

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

Cheers for your help

mcutting · Post by **mcutting** » Wed Jun 27, 2007 9:53 am

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

AndyStewart · Post by **AndyStewart** » Wed Jun 27, 2007 9:57 am

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

mcutting · Post by **mcutting** » Wed Jun 27, 2007 9:59 am

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

AndyStewart · Post by **AndyStewart** » Wed Jun 27, 2007 10:00 am

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 · Post by **mcutting** » Wed Jun 27, 2007 10:03 am

Could not instantiate mail function.

Check your php.ini file, and ensure that the following settings are filled in:

[mail function]
; For Win32 only.
SMTP = your.ip.address.here

; For Win32 only.
sendmail_from = you@yourdomain

Save php.ini, restart IIS / Apache, and then try again...

AndyStewart · Post by **AndyStewart** » Wed Jun 27, 2007 10:13 am

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 · Post by **mcutting** » Wed Jun 27, 2007 10:36 am

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

AndyStewart · Post by **AndyStewart** » Thu Jun 28, 2007 4:00 am

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.

Report Query

Report Query

Who is online