(SOLVED) Down System Notification

[Cornel]

Hello,
I have setup all our Remote Sites for ping ONLY, and I want to have an email when one of the Remote Sites is down.
I setup the down system notification, but I do NOT get an email when the system is down. I can receive other emails from other things like ping too high, etc.
But for a system down, I DO NOT get an email. Ive attached a screenshot of the setup. Can someone PLEASE PLEASE help me wit this one. Its very crucial I get this working. Our sites go down quite often, and I need some type of an alert, and this one seems to be the only one that might work.

I see some other posts where it says it works for them, but not sure why it wont work for me.
Im running Ubuntu Server 12.04 with Cacti 0.8.8b

[cigamit]

Just to start off, what do you have for Settings >> Poller.

Host Up/Down Settings
Failure Count
The number of polling intervals a host must be down before logging an error and reporting host as down.
Recovery Count
The number of polling intervals a host must remain up before returning host to an up status and issuing a notice.

[Cornel]

Just to start off, what do you have for Settings >> Poller.

Host Up/Down Settings
Failure Count
The number of polling intervals a host must be down before logging an error and reporting host as down.
Recovery Count
The number of polling intervals a host must remain up before returning host to an up status and issuing a notice.

Here you go. I attached a screenshot.

[cigamit]

Ok, everything looks pretty normal there. Can you do one last thing. Run this SQL query when you have a host that has been down for a bit.

Code: Select all

SELECT * FROM  `plugin_thold_host_failed` 

That will tell us if thold is even checking them and putting them in its table.

[Cornel]

Ok, everything looks pretty normal there. Can you do one last thing. Run this SQL query when you have a host that has been down for a bit.

Code: Select all

SELECT * FROM  `plugin_thold_host_failed` 

That will tell us if thold is even checking them and putting them in its table.

Sorry im a noob when it comes to this. Where can I run this command from? From inside Ubuntu Server? Or from Cacti GUI?
Sorry, really not that good with this Cacti YET.

Thanks.

[cigamit]

You have to run that from within mysql.

Google would probably help you more, but basically
Goto Ubuntu terminal
type "mysql" (assuming the root account wasn't setup with a password, otherwise google the proper switches to supply a username/password)
you should be in the mysql prompt now, so type
use cacti; (replace cacti with the actual name of your cacti database)
then type the above command

[Cornel]

You have to run that from within mysql.

Google would probably help you more, but basically
Goto Ubuntu terminal
type "mysql" (assuming the root account wasn't setup with a password, otherwise google the proper switches to supply a username/password)
you should be in the mysql prompt now, so type
use cacti; (replace cacti with the actual name of your cacti database)
then type the above command

OK I was able to figure out how to run that command. I attached screenshots...

[cigamit]

Sorry, you need a ; on the end of any MySQL commands

[Cornel]

Sorry, you need a ; on the end of any MySQL commands

Its working. For some reason, it seems when I put certain mail settings for the server side on the Settings Tab, it wont send down system emails, specially when I try to do txt emails directly to my phone.
So, its not the system that does not work, its the setup, I gotta figure out the txt email setup, and I think its might be my ASA Firewall.
Thanks for the help, really appreciate it. I hope you could solve my routerconfig issue on the other thread, and I really appreciate that one. Backing up my router configs is very crucial, and I hate doing it manually .
Thanks again Cigamit, really appreciate your time for this.

[Richmond1985]

Cornel how did you get it working? What did you change in settings? Am struggling with the same problem. Thanks in advance