CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26

[cruxx]

typ the following setting in die camm settings section:

Join field name
Choose join field on which record (trap or syslog) will be joined with cacti device's - IP-address (if you device DON'T use DNS name)
Hostname include domain
Do you use host with FQDN in cacti device's ? 0 - Don't use FQDN in cacti hosts hostname (like cacti) - default

[axcx]

Tried it, and still no luck

Everything seems to work fine except this last piece.

Here is a picture of the set up.

[heyme]

I am trying to get this up and running on CactiEZ. I've copied the plugin into /var/www/html/plugins/camm and I was able to see, install and enable the plugin with in the plugin management. I get a tab within the settings under cacti. I get a new tab across the top of the cacti window showing camm. but clicking on that tab just gives me a blank page. Any ideas? I don't see any errors in the cacti log when I click on that tab.

[mcutting]

Hi.

We are running cacti v0.8.7g and we have installed camm v1.6.7 plugin in order to use only syslog part.

Well, all seems to work fine, but we noticed when we try to click on Ip addresses on left tree pannel, sometimes nothing happens. Taking a view to Cacti log, the following message is logged when clicking on ip addresses fails:

10/23/2012 04:55:25 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1176', SQL:" SELECT CONVERT(GROUP_CONCAT(`plugin_camm_keys`.`rule_id`) USING UTF8) as rule_id, temp_sys.*, host.description, host.host_template_id, host.id as device_id from (SELECT id, `facility`, `priority`, `sys_date`, `host`, `message`,`sourceip`,`status` FROM `syslog`.`plugin_camm_syslog` USE INDEX (`hostname`) WHERE 1=1 and (`host` = '10.211.68.42') and 1=1 order by sys_date desc LIMIT 0,50 ) as temp_sys Left join plugin_camm_keys on (temp_sys.id=plugin_camm_keys.krid and plugin_camm_keys.ktype='1') Left join host on (temp_sys.host= `host`.`hostname` ) group by id "

Anybody knows how to solve it?

B.R.

I get the same problem running 0.8.8a and MySQL 5.5.29-0ubuntu0.12.04.1

Anyone managed to resolve this ?

Thanks

Anyone looking for a fix to this, it's relatively simple.

CREATE INDEX hostname
ON plugin_camm_syslog (host)

[smlick]

Hi Gthe, tnx again 4 your precious work, I like to know if you plan some feature improvement with a new release in the next month or is an end of life project?

Regards
Alessio

[Kreezer]

There are errors while installation:

A DB Exec Failed!, Error:'1163', SQL:"CREATE TABLE `plugin_camm_syslog_incoming` (`id` int(11) unsigned NOT NULL auto_increment,`host` varchar(128) default NULL,`sourceip` varchar(45) NOT NULL,`facility` varchar(10) default NULL,`priority` varchar(10) default NULL,`sys_date` datetime default NULL,`message` text,`status` tinyint(4) NOT NULL default 0,`alert` SMALLINT(3) unsigned NOT NULL default 0,`add` varchar(50) default NULL, PRIMARY KEY (`id`), KEY `facility` (`facility`), KEY `priority` (`priority`), KEY `sourceip` (`sourceip`), KEY `sys_date` (`sys_date`), KEY `status` (`status`), KEY `alert` (`alert`)) ENGINE = MEMORY COMMENT = 'camm plugin SYSLOG incoming Data''

MySQL-KB says, there is no support for TEXT in table-engine MEMORY.

[gthe]

Kreezer
Try this:

Code: Select all

CREATE TABLE  `cacti`.`plugin_camm_syslog_incoming` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `host` varchar(128) DEFAULT NULL,
  `sourceip` varchar(45) NOT NULL,
  `facility` varchar(10) DEFAULT NULL,
  `priority` varchar(10) DEFAULT NULL,
  `sys_date` datetime DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `alert` smallint(3) unsigned NOT NULL DEFAULT '0',
  `add` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `facility` (`facility`),
  KEY `priority` (`priority`),
  KEY `sourceip` (`sourceip`),
  KEY `sys_date` (`sys_date`),
  KEY `status` (`status`),
  KEY `alert` (`alert`)
) ENGINE=MEMORY  COMMENT='camm plugin SYSLOG incoming Data';

[Kreezer]

I know this is going to work.
But what, if the trap is longer then 255 characters?
There is no "cut" while piping from snmptrapd to mysql.

[gthe]

If soo, U need use innodb or myisam, not memory.

[Kreezer]

Thanks a lot.
The workaround works fine for me.

I can't imagine why no one else gets this error. Or no one else checks his log

[gthe]

no one else uses it ?

[gthe]

I update first post with correct sql.

[Kreezer]

Before installing and activating CaMM, replace one line in setup.php:

Line 873
-- $data['type'] = 'MEMORY';
++ $data['type'] = 'MyISAM'; // or innoDB

Because of related errors:

ERROR: A DB Exec Failed!, Error:'1146', SQL:"ALTER TABLE `cacti`.`plugin_camm_syslog_incoming` ADD column `add` varchar(50) default '' ;'
ERROR: A DB Exec Failed!, Error:'1061', SQL:"ALTER TABLE `cacti`.`plugin_camm_syslog` ADD INDEX `alert`(`alert`);'
ERROR: A DB Exec Failed!, Error:'1060', SQL:"ALTER TABLE `cacti`.`plugin_camm_syslog` ADD column `alert` SMALLINT(3) unsigned NOT NULL default '0' ;'
ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SHOW columns FROM `cacti`.`plugin_camm_syslog_incoming`;"

no one else uses it ?

Great

[gthe]

Before installing and activating CaMM, replace one line in setup.php:

Line 873
-- $data['type'] = 'MEMORY';
++ $data['type'] = 'MyISAM'; // or innoDB

Because of related errors:

This errors occur if table dos'n exists (you first post). Use file from first post (already fixed) - and all will work.

[smlick]

Hi gthe,
is possible to specify a different data purge delay in CaMM SYSLOG settings?
A custom field would be perfect, but also a 6 month and 1 year option would be nice.

Regards
Alessio