Hi all, thx for this mailing list. I just want to know if someone has already write something to record downtimes on a mysql database ? As I'm not a programer and have no idea about what Perl is, I parsed the code and add :
my $db = 'DBI:mysql:incident:myServer'; my $user = 'xxx'; my $passwd = 'xxx'; my $dbconnect = DBI->connect($db, $user, $passwd); my $sql = qq{INSERT INTO mon ( now, group, service, first, duration) VALUES ('$data{"time"}','$data{"group"}','$data{"service"}','$data{"first"}','$data {"duration"}'); }; $dbconnect->do($sql); $dbconnect->disconnect(); Anyway, if somebody has something similar but service dependent (as an alert, fi), I'll be glad to have a look on it. Thx. Raphael _______________________________________________ mon mailing list [EMAIL PROTECTED] http://linux.kernel.org/mailman/listinfo/mon