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

General discussion about Plugins for Cacti

Moderators: Moderators, Developers

Post Reply
Author
Message
rukender
Posts: 5
Joined: Thu Mar 21, 2013 8:07 am

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

#691 Post by rukender » Fri Mar 22, 2013 9:02 am

Hi Guys,


I m Manage to install SNMPTT and getting Traps.

Now, the problem is that i m getting only Unknown Traps.
Will anyone help me get SNMP traps.

It will be very helpful if anyone explain me the procedure to get SNMP Traps :)

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

#692 Post by cruxx » Wed Apr 03, 2013 2:47 am

Hey rukender,

you have to use the snmptt.conf file to define the "know" traps. In the snmptt Installation-zip is a sample file called "snmptt.conf.generic".
You can have more then one "snmptt.conf" files to organize the traps (e.g. SAN, Windows Server, Linux Server, network-devices, ...).
These files are defined in the snmptt.ini file section [TrapFiles]:
[TrapFiles]
snmptt_conf_files = <<END
c:\\snmp\\snmpttconfs\\snmptt-SAN.conf
c:\\snmp\\snmpttconfs\\snmptt-linux.conf
c:\\snmp\\snmpttconfs\\snmptt-win.conf
c:\\snmp\\snmpttconfs\\snmptt-cisco.conf
END
A sample for a "know trap" is e.g.:
# Event ID - 4648 - Logon
#
EVENT EventLog .1.3.6.1.4.1.311.1.13.1.35.77.105.99.114.111.115.111.102.116.45.87.105.110.100.111.119.115.45.83.101.99.117.114.105.116.121.45.65.117.100.105.116.105.110.103.0.4648 "Security" success_logon
FORMAT $1
kind regards

rukender
Posts: 5
Joined: Thu Mar 21, 2013 8:07 am

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

#693 Post by rukender » Wed Apr 03, 2013 8:49 am

Hi cruxx,

Thanks for your reply.

Actually i m using ubuntu as a operating system.

I can see snmptt.conf file. So will you please help know how to edit this snmptt.conf file so that i would be able to see at-least one known TRAP :)

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

#694 Post by mcutting » Mon Apr 15, 2013 5:15 am

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

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

#695 Post by mcutting » Tue Apr 30, 2013 6:22 am

BUMP - anyone ?
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

johnrz
Posts: 7
Joined: Wed Jul 21, 2010 4:32 am

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

#696 Post by johnrz » Mon May 13, 2013 12:21 am

Hi Guys

I have two servers, old server is working fine with CaMM and new doesn't want to work without errors, here is one of them

Code: Select all

05/13/2013 11:15:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1364', SQL:"INSERT INTO `plugin_camm_tree2` (`device_id`,`description`, `hostname`,`gr_f`,`gr_v`,`agentip`,`agentip_source` ,`type` ,`period`,`_is_type`,`_is_device`,`_parent` ,`count` ,`dev_count` ,`online` ,`_is_leaf`,`_lvl`) SELECT `t0`.`device_id`,`t0`.`description`,`t0`.`hostname`,`t0`.`gr_f`,`t0`.`gr_v`,`t0`.`agentip`,`t0`.`agentip_source`,'syslog',`t0`.`period` ,'0' ,'0' ,t1.id ,t0.`count` ,`t0`.`dev_count`,'1' ,'1' ,'5' FROM plugin_camm_temp as t0 join plugin_camm_tree2 as t1 on (t0.type=t1.type and t0.hostname=t1.hostname and t0.period=t1.period and t0.gr_f=t1.gr_f) WHERE `t0`.`type`='syslog' and `t1`.`online`='1' and `_is_marker`='0' group by hostname,period,`t0`.gr_f,gr_v ON DUPLICATE KEY UPDATE `plugin_camm_tree2`.`dev_count` = values(`dev_count`), `plugin_camm_tree2`.`_parent` = values(`_parent`), `plugin_camm_tree2`.`count` = values(`count`), `plugin_camm_tree2`.`online` = '1' ;'  

05/13/2013 11:15:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1364', SQL:"INSERT INTO `plugin_camm_tree2` (`device_id`,`description`, `hostname`,`gr_f`,`gr_v`,`agentip`,`agentip_source` ,`type` ,`period`,`_is_type`,`_is_device`,`_parent` ,`count` ,`dev_count` ,`online` ,`_is_leaf`,`_lvl`) SELECT `t0`.`device_id`,`t0`.`description`,`t0`.`hostname`,`t0`.`gr_f`,`t0`.`gr_v`,`t0`.`agentip`,`t0`.`agentip_source`,'syslog',`t0`.`period` ,'0' ,'0' ,t1.id ,t0.`count` ,`t0`.`dev_count`,'1' ,'0' ,'4' FROM plugin_camm_temp as t0 join plugin_camm_tree2 as t1 on (t0.type=t1.type and t0.hostname=t1.hostname and t0.period=t1.period) WHERE `t0`.`type`='syslog' and `t1`.`online`='1' and `_is_marker`='0' group by hostname,period,gr_f ON DUPLICATE KEY UPDATE `plugin_camm_tree2`.`dev_count` = values(`dev_count`), `plugin_camm_tree2`.`_parent` = values(`_parent`), `plugin_camm_tree2`.`count` = values(`count`), `plugin_camm_tree2`.`online` = '1' ;' 
All tables was created successfully.
When I try to inser this to sql command line I receive

Code: Select all

ERROR 1364 (HY000): Field 'typ_count' doesn't have a default value
mysql-server-5.6.10
and when I insert this to old servers, everything is OK. Can somebody help me please. Thanks.
Last edited by johnrz on Mon May 13, 2013 9:58 pm, edited 1 time in total.

johnrz
Posts: 7
Joined: Wed Jul 21, 2010 4:32 am

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

#697 Post by johnrz » Mon May 13, 2013 6:34 am

I don't know is it right or no, I changed default values for "typ_count" in table "plugin_camm_tree2", "Null=Yes" and "Default=NULL" or "Null=No" and "Default=0" and now it seems working
Last edited by johnrz on Tue May 14, 2013 9:27 pm, edited 1 time in total.

johnrz
Posts: 7
Joined: Wed Jul 21, 2010 4:32 am

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

#698 Post by johnrz » Tue May 14, 2013 9:24 pm

Another problem with rules, when I click "save", created rule disappear, there are no errors anywhere (((

johnrz
Posts: 7
Joined: Wed Jul 21, 2010 4:32 am

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

#699 Post by johnrz » Fri May 24, 2013 2:33 am

All my problems because of MySQL restrict modes, i try to insert to my.cnf sql-mode="" in [mysqld] section, but it doesn't work, other solution

Code: Select all

mysql> SET GLOBAL sql_mode="";
Query OK, 0 rows affected (0.00 sec)
but after restart I have to do it again.

johnrz
Posts: 7
Joined: Wed Jul 21, 2010 4:32 am

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

#700 Post by johnrz » Mon May 27, 2013 11:58 pm

finally I solve this problem, first we should change startup script for MySQL server

Code: Select all

: ${mysql_optfile="/etc/my.cnf"}
command_args="-c -f /usr/local/bin/mysqld_safe --defaults-extra-file=${mysql_optfile} --user=${mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile} ${mysql_args}" 
and then we should add in my.cnf

Code: Select all

[mysqld]
sql-mode=""

johnrz
Posts: 7
Joined: Wed Jul 21, 2010 4:32 am

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

#701 Post by johnrz » Tue May 28, 2013 12:33 am

One more problem
Attachments
json.jpg
json.jpg (61.43 KiB) Viewed 3797 times

adyy
Posts: 1
Joined: Wed Jun 19, 2013 1:27 pm

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

#702 Post by adyy » Wed Jun 19, 2013 1:30 pm

Hi,

I use CactiEZ 0.8.8a and after the installation of the CAMM plugin I see nothing. Only a blank screen.
In the cacti.log I have no errors.

Any idea about this error?

Adrian

axcx
Posts: 18
Joined: Fri Sep 23, 2011 6:04 am

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

#703 Post by axcx » Wed Aug 07, 2013 8:58 am

Anyone know how i can define types?

In my left navigation panel I see a tree structure with "Type: Not_defined".

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

#704 Post by cruxx » Mon Aug 12, 2013 4:43 am

Yeah - Create some "Host Templates" and define "Devices" to the templates...

axcx
Posts: 18
Joined: Fri Sep 23, 2011 6:04 am

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

#705 Post by axcx » Mon Aug 12, 2013 5:11 am

Hey

Thanks for the quick reply. All my devices already have a host template defined, still no luck. Guess it's time to do a bit more digging :)

Also, is the description field supposed to be empty? Or will that populate once I figure out why my host template names are not pulled in?

Post Reply