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

General discussion about Plugins for Cacti

Moderators: Moderators, Developers

Post Reply
Author
Message
cruxx
Posts: 16
Joined: Thu Sep 09, 2010 7:36 am
Location: Schwerin, Germany

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

#706 Post by cruxx » Mon Aug 12, 2013 7:46 am

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
Posts: 18
Joined: Fri Sep 23, 2011 6:04 am

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

#707 Post by axcx » Mon Aug 12, 2013 8:18 am

Tried it, and still no luck :(

Everything seems to work fine except this last piece.

Here is a picture of the set up.

Image

heyme
Posts: 2
Joined: Sun Jun 24, 2012 7:46 pm

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

#708 Post by heyme » Sat Sep 07, 2013 6:21 pm

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
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

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

#709 Post by mcutting » Thu Sep 26, 2013 4:10 am

mcutting wrote:
jumafrhe wrote: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)
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

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

#710 Post by smlick » Tue Oct 01, 2013 3:56 am

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
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map

Kreezer
Posts: 43
Joined: Fri Jan 31, 2014 8:26 am

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

#711 Post by Kreezer » Fri Jan 31, 2014 8:36 am

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.
Cacti Version - 0.8.8h - Poller Type - SPINE 0.8.8h
MySQL - 5.0.54 - PHP - 5.1.6 -RRDTool - 1.2.23 - SNMP - 5.1.2
Plugins - Banner 0.32, Camm 1.6.7, Dashboard 1.2, Fix64bit 0.4, Monitor 1.3, Passwd 0.1, Settings 0.71, Tools 0.3, Realtime 0.5, Rrdclean 1.1, Spikekill 1.3, Syslog 1.22, Thold 0.6

User avatar
gthe
Cacti User
Posts: 410
Joined: Sat Jul 29, 2006 1:23 pm
Location: RU

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

#712 Post by gthe » Fri Jan 31, 2014 8:52 am

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';
My cacti plugin -[url=http://forums.cacti.net/viewtopic.php?p=156769#156769]CaMM[/url]
[size=75]Sorry for my English. [/size]

Kreezer
Posts: 43
Joined: Fri Jan 31, 2014 8:26 am

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

#713 Post by Kreezer » Fri Jan 31, 2014 9:00 am

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.
Cacti Version - 0.8.8h - Poller Type - SPINE 0.8.8h
MySQL - 5.0.54 - PHP - 5.1.6 -RRDTool - 1.2.23 - SNMP - 5.1.2
Plugins - Banner 0.32, Camm 1.6.7, Dashboard 1.2, Fix64bit 0.4, Monitor 1.3, Passwd 0.1, Settings 0.71, Tools 0.3, Realtime 0.5, Rrdclean 1.1, Spikekill 1.3, Syslog 1.22, Thold 0.6

User avatar
gthe
Cacti User
Posts: 410
Joined: Sat Jul 29, 2006 1:23 pm
Location: RU

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

#714 Post by gthe » Fri Jan 31, 2014 9:04 am

If soo, U need use innodb or myisam, not memory.
My cacti plugin -[url=http://forums.cacti.net/viewtopic.php?p=156769#156769]CaMM[/url]
[size=75]Sorry for my English. [/size]

Kreezer
Posts: 43
Joined: Fri Jan 31, 2014 8:26 am

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

#715 Post by Kreezer » Fri Jan 31, 2014 9:12 am

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 :roll:
Cacti Version - 0.8.8h - Poller Type - SPINE 0.8.8h
MySQL - 5.0.54 - PHP - 5.1.6 -RRDTool - 1.2.23 - SNMP - 5.1.2
Plugins - Banner 0.32, Camm 1.6.7, Dashboard 1.2, Fix64bit 0.4, Monitor 1.3, Passwd 0.1, Settings 0.71, Tools 0.3, Realtime 0.5, Rrdclean 1.1, Spikekill 1.3, Syslog 1.22, Thold 0.6

User avatar
gthe
Cacti User
Posts: 410
Joined: Sat Jul 29, 2006 1:23 pm
Location: RU

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

#716 Post by gthe » Fri Jan 31, 2014 9:19 am

no one else uses it ? :D :D :D
My cacti plugin -[url=http://forums.cacti.net/viewtopic.php?p=156769#156769]CaMM[/url]
[size=75]Sorry for my English. [/size]

User avatar
gthe
Cacti User
Posts: 410
Joined: Sat Jul 29, 2006 1:23 pm
Location: RU

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

#717 Post by gthe » Fri Jan 31, 2014 9:37 am

I update first post with correct sql.
My cacti plugin -[url=http://forums.cacti.net/viewtopic.php?p=156769#156769]CaMM[/url]
[size=75]Sorry for my English. [/size]

Kreezer
Posts: 43
Joined: Fri Jan 31, 2014 8:26 am

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

#718 Post by Kreezer » Fri Jan 31, 2014 9:56 am

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`;"
gthe wrote:no one else uses it ? :D :D :D
Great :-D
Cacti Version - 0.8.8h - Poller Type - SPINE 0.8.8h
MySQL - 5.0.54 - PHP - 5.1.6 -RRDTool - 1.2.23 - SNMP - 5.1.2
Plugins - Banner 0.32, Camm 1.6.7, Dashboard 1.2, Fix64bit 0.4, Monitor 1.3, Passwd 0.1, Settings 0.71, Tools 0.3, Realtime 0.5, Rrdclean 1.1, Spikekill 1.3, Syslog 1.22, Thold 0.6

User avatar
gthe
Cacti User
Posts: 410
Joined: Sat Jul 29, 2006 1:23 pm
Location: RU

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

#719 Post by gthe » Sat Feb 01, 2014 4:30 am

Kreezer wrote: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.
My cacti plugin -[url=http://forums.cacti.net/viewtopic.php?p=156769#156769]CaMM[/url]
[size=75]Sorry for my English. [/size]

User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

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

#720 Post by smlick » Fri May 02, 2014 3:21 am

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
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map

Post Reply