Cacti/plugin_monitor

Monitor Plugin Last fail date always update to 1970

nghost-nghost opened this issue · 7 comments

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

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

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

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

ran into the same problem
AlmaLinux 8.6

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

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

Resolved.