Today i was install new syslog (1.2.1) and found problem. When i create rule for report in cacti log i see next message
in sqlERROR: SQL Save Command Failed for Table '`cacti`.`syslog_alert`'. Error was 'Unknown column 'repeat_alert' in 'field list''
and rule not create-- phpMyAdmin SQL Dump
-- version 2.11.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 13, 2011 at 12:26 PM
-- Server version: 5.0.77
-- PHP Version: 5.1.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `cacti`
--
-- --------------------------------------------------------
--
-- Table structure for table `syslog_alert`
--
CREATE TABLE IF NOT EXISTS `syslog_alert` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`severity` int(10) unsigned NOT NULL default '0',
`method` int(10) unsigned NOT NULL default '0',
`num` int(10) unsigned NOT NULL default '1',
`type` varchar(16) NOT NULL default '',
`enabled` char(2) default 'on',
`message` varchar(128) NOT NULL default '',
`user` varchar(32) NOT NULL default '',
`date` int(16) NOT NULL default '0',
`email` varchar(255) default NULL,
`command` varchar(255) default NULL,
`notes` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `syslog_alert`
--
INSERT INTO `syslog_alert` (`id`, `name`, `severity`, `method`, `num`, `type`, `enabled`, `message`, `user`, `date`, `email`, `command`, `notes`) VALUES
(3, 'ARP request collision', 1, 0, 5, 'messagec', 'on', '%FWSM-4-405001: Received ARP request collision from', 'admin', 1298555668, 'klol@lol.com', '', 'ARP request collision'),
(4, 'vpn3000 disconnect session', 0, 0, 1, 'messagec', 'on', 'disconnected: Session Type: IPSec Duration', 'admin', 1298318405, 'lol@lol.com', '', ''),
(5, 'vpn 3000 connect', 1, 0, 1, 'messagec', 'on', 'PHASE 1 COMPLETED', 'admin', 1298318945, 'lol@lol.com', '', '');
how fix this problem?Error: Save Failed.
Cacti Version: 0.8.7g, Plugin Architecture Version: 2.9