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

[rukender]

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]

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]

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]

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

[mcutting]

BUMP - anyone ?

[johnrz]

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.

[johnrz]

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

[johnrz]

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

[johnrz]

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]

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]

One more problem

[adyy]

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]

Anyone know how i can define types?

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

[cruxx]

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

[axcx]

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?