about report plugins

[liuzhe2000]

hi everybody
i have setup the report plugins,but it can't send me email
in my threshld, i tried send a test email with SMTP, and it is successful.
in my report v0.3, the graph is a ".png" document, the preview is normal, and after i click the "send now", there isn't an error prompt,it seem as if it is normal.
the cacti log prompt "Reports: Poller[0] Email could not be sent - 'Language string failed to load: instantiate' "
why is it?
Do i need configure some ?
thanks !!!

[mcutting]

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...

[liuzhe2000]

thank you very much!

this is my php.ini :

[mail function]
; For Win32 only.
SMTP = xxx.xxx.xxx.xxx

; For Win32 only.
sendmail_from = xxxxxx@hotmail.com

is it right?

but it still can't send me email ,and in my setting i configure "php mail() fuction" , then when i click the "Send a Test Email", it prompt "ERROR: Unable to send email with php mail function, check your system logs "

why is it ?

it seem as if the php mail fuction is invalid

how shoud i configure it ?

help me
thanks.

[mcutting]

The settings look ok, however, whatever you defined in the IP Address should accept relay requests. If you are using Exchange, you'll need to tell the Virtual SMTP Server that your Cacti server can relay mail through it.

As php.ini looks good, this is likely to be the reason why. If you don't use an Exchange server, then I would investigate the mail sending method. Tthis is going to be a relay denied problem generated by whatever the IP Address is that you have specified.

Also, did you restart apache or IIS ?

Lastly, if you are using the reports plugin, then the mail format only works with the PHP Mailer class.

[TFC]

Hi,
I install reports, but where is e-mail settings? I cand find those configurations.
And i get that type errors from log file :

11/19/2009 10:15:50 AM - Reports: Poller[0] Email could not be sent - 'Language string failed to load: instantiate'
11/19/2009 10:15:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select gorder from reports_data where reportid = $id order by gorder DESC LIMIT 1"
11/19/2009 10:15:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports where id = $id"
11/19/2009 10:15:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select gorder from reports_data where reportid = $id order by gorder DESC LIMIT 1"

pls help me

[mcutting]

Hi,
I install reports, but where is e-mail settings? I cand find those configurations.
And i get that type errors from log file :

11/19/2009 10:15:50 AM - Reports: Poller[0] Email could not be sent - 'Language string failed to load: instantiate'
11/19/2009 10:15:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select gorder from reports_data where reportid = $id order by gorder DESC LIMIT 1"
11/19/2009 10:15:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports where id = $id"
11/19/2009 10:15:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select * from reports_data where reportid = $id order by gorder"
11/19/2009 10:15:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select gorder from reports_data where reportid = $id order by gorder DESC LIMIT 1"

pls help me

Import the reports table.

[TFC]

you mean you wanna look at reports table in mysql?
then :

mysql> describe reports;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| id | int(10) | NO | MUL | NULL | auto_increment |
| name | varchar(100) | NO | | | |
| hour | int(2) | NO | | 0 | |
| minute | int(2) | NO | | 0 | |
| email | text | NO | | NULL | |
| rtype | varchar(12) | NO | | attach | |
| lastsent | int(32) | NO | | 0 | |
| daytype | text | NO | | NULL | |
+----------+--------------+------+-----+---------+----------------+
8 rows in set (0.01 sec)

By the way, i ask that where is smtp server config or etc, show above images in previous replies..

[TFC]

Still I have problem. I wonder where is SMTP settings in cacti?

[mcutting]

Still I have problem. I wonder where is SMTP settings in cacti?

You will find this in SETTINGS under "Mail / DNS". You need the "settings" plugin installed.

[TFC]

That is what exactly did.
Now works.
Thanks for your assistances.