Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri May 24, 2019 8:07 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 740 posts ]  Go to page Previous  1 ... 44, 45, 46, 47, 48, 49, 50  Next
Author Message
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri Mar 22, 2013 9:02 am 
Offline

Joined: Thu Mar 21, 2013 8:07 am
Posts: 5
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 :)


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Wed Apr 03, 2013 2:47 am 
Offline

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

Quote:
# 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


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Wed Apr 03, 2013 8:49 am 
Offline

Joined: Thu Mar 21, 2013 8:07 am
Posts: 5
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 :)


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Mon Apr 15, 2013 5:15 am 
Offline
Cacti Guru User

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

_________________
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 Apr 30, 2013 6:22 am 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
BUMP - anyone ?

_________________
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: Mon May 13, 2013 12:21 am 
Offline

Joined: Wed Jul 21, 2010 4:32 am
Posts: 7
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:
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:
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.

Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Mon May 13, 2013 6:34 am 
Offline

Joined: Wed Jul 21, 2010 4:32 am
Posts: 7
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.

Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Tue May 14, 2013 9:24 pm 
Offline

Joined: Wed Jul 21, 2010 4:32 am
Posts: 7
Another problem with rules, when I click "save", created rule disappear, there are no errors anywhere (((


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Fri May 24, 2013 2:33 am 
Offline

Joined: Wed Jul 21, 2010 4:32 am
Posts: 7
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:
mysql> SET GLOBAL sql_mode="";
Query OK, 0 rows affected (0.00 sec)
but after restart I have to do it again.


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Mon May 27, 2013 11:58 pm 
Offline

Joined: Wed Jul 21, 2010 4:32 am
Posts: 7
finally I solve this problem, first we should change startup script for MySQL server

Code:
: ${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:
[mysqld]
sql-mode=""


Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Tue May 28, 2013 12:33 am 
Offline

Joined: Wed Jul 21, 2010 4:32 am
Posts: 7
One more problem


Attachments:
json.jpg
json.jpg [ 61.43 KiB | Viewed 3622 times ]
Top
 Profile  
 
 Post subject: Re: CaMM (Cacti Message Management) plugin v1.6.7 2010-08-26
PostPosted: Wed Jun 19, 2013 1:30 pm 
Offline

Joined: Wed Jun 19, 2013 1:27 pm
Posts: 1
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


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

Joined: Fri Sep 23, 2011 6:04 am
Posts: 18
Anyone know how i can define types?

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


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

Joined: Thu Sep 09, 2010 7:36 am
Posts: 16
Location: Schwerin, Germany
Yeah - Create some "Host Templates" and define "Devices" to the templates...


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

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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 740 posts ]  Go to page Previous  1 ... 44, 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