Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Mar 24, 2017 5:14 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 738 posts ]  Go to page Previous  1 ... 45, 46, 47, 48, 49, 50  Next
Author Message
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Mon Aug 12, 2013 7:46 am 
Offline

Joined: Thu Sep 09, 2010 7:36 am
Posts: 16
Location: Schwerin, Germany
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


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Mon Aug 12, 2013 8:18 am 
Offline

Joined: Fri Sep 23, 2011 6:04 am
Posts: 18
Tried it, and still no luck :(

Everything seems to work fine except this last piece.

Here is a picture of the set up.

Image


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Sat Sep 07, 2013 6:21 pm 
Offline

Joined: Sun Jun 24, 2012 7:46 pm
Posts: 2
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.


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Thu Sep 26, 2013 4:10 am 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1876
Location: United Kingdom
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.

Quote:
CREATE INDEX hostname
ON plugin_camm_syslog (host)

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Tue Oct 01, 2013 3:56 am 
Offline
Cacti User
User avatar

Joined: Tue May 20, 2008 4:09 am
Posts: 266
Location: Italy, Rome
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


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 8:36 am 
Offline

Joined: Fri Jan 31, 2014 8:26 am
Posts: 43
There are errors while installation:
Quote:
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


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 8:52 am 
Offline
Cacti User
User avatar

Joined: Sat Jul 29, 2006 1:23 pm
Posts: 401
Location: RU
Kreezer
Try this:
Code:
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 -CaMM
Sorry for my English.


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 9:00 am 
Offline

Joined: Fri Jan 31, 2014 8:26 am
Posts: 43
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


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 9:04 am 
Offline
Cacti User
User avatar

Joined: Sat Jul 29, 2006 1:23 pm
Posts: 401
Location: RU
If soo, U need use innodb or myisam, not memory.

_________________
My cacti plugin -CaMM
Sorry for my English.


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 9:12 am 
Offline

Joined: Fri Jan 31, 2014 8:26 am
Posts: 43
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


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 9:19 am 
Offline
Cacti User
User avatar

Joined: Sat Jul 29, 2006 1:23 pm
Posts: 401
Location: RU
no one else uses it ? :D :D :D

_________________
My cacti plugin -CaMM
Sorry for my English.


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 9:37 am 
Offline
Cacti User
User avatar

Joined: Sat Jul 29, 2006 1:23 pm
Posts: 401
Location: RU
I update first post with correct sql.

_________________
My cacti plugin -CaMM
Sorry for my English.


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Jan 31, 2014 9:56 am 
Offline

Joined: Fri Jan 31, 2014 8:26 am
Posts: 43
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:
Quote:
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


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Sat Feb 01, 2014 4:30 am 
Offline
Cacti User
User avatar

Joined: Sat Jul 29, 2006 1:23 pm
Posts: 401
Location: RU
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 -CaMM
Sorry for my English.


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri May 02, 2014 3:21 am 
Offline
Cacti User
User avatar

Joined: Tue May 20, 2008 4:09 am
Posts: 266
Location: Italy, Rome
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 738 posts ]  Go to page Previous  1 ... 45, 46, 47, 48, 49, 50  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group