search

Cacti / plugin_monitor

Monitor Plugin for Cacti
GNU General Public License v2.0
36 stars 39 forks source link

Monitor Plugin Last fail date always update to 1970 #148

Closed nghost-nghost closed 1 year ago

nghost-nghost commented 2 years ago

Hi I'm using cacti 1.2.19 and monitor plugin 2.5 on ubuntu 20.04 i have problem when device down, the time of last fail is correct. but after a second its updated to 1970-01-01 how to fix this?

image

TheWitness commented 2 years ago

Oh, interesting. We might have to re-pull that function from Cacti, or just use the Cacti function.

netniV commented 2 years ago

It may also be happening if your mySQL is not set to allow zero dates.

Kodlitko commented 1 year ago

Hello, I am facing same issue on my instance - all hosts have last fail date 1970-01-01 01:32:50.

Can you please tell me, what exact MySQL options should I search for? Thanks.

My system: Debian Linux 10 MariaDB v10.3.34 PHP v7.3.31 Cacti v1.2.22 Monitor plugin v2.5

CatGuai commented 1 year ago

ran into the same problem AlmaLinux 8.6

TheWitness commented 1 year ago

That 1970 date is old school never seen. @netniV may be right.

netniV commented 1 year ago

I think we may have to start revisiting the idea of using null dates rather than zero dates @TheWitness as much as it pains us

TheWitness commented 1 year ago

Resolved.