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

[torstentfk]

-uha...very fast - thanks - will see
I think it is time for a whole download package for other user after this fixes

[lasylve]

Hi, I'm using this plugin for few months and I'd like to know if it's possible to hide the "tree menu" on the left.

I could do it with 1.6.5 version but it looks like it doesn't work on last camm version. Why ? How can I fix that ?

I also have a question about SNMP V3 traps with net-snmp, I'd like to know how can I add new user (with "createUser line" conf) to receive traps without defining a specific engineID.

Can someone help me please ?

[JOEGOR]

Hi gthe

already replaced camm_db.php but still can't see any unknown trap.
also, the alert(email) still not work even force to run.

Is it my SQL table have problem?
THanks~

[JOEGOR]

And the Cacti.log PM to you.
Thanks

[gthe]

Hi, I'm using this plugin for few months and I'd like to know if it's possible to hide the "tree menu" on the left.

I could do it with 1.6.5 version but it looks like it doesn't work on last camm version. Why ? How can I fix that ?

I will fix it in next release

Hi gthe

already replaced camm_db.php but still can't see any unknown trap.
also, the alert(email) still not work even force to run.

Is it my SQL table have problem?
THanks~

Any error in cacti log ?

And the Cacti.log PM to you.
Thanks

where ?

[JOEGOR]

yES, upload the log here~
Thanks

[gthe]

yES, upload the log here~
Thanks

Run this sql in mysql command line and show me full error description:

Code: Select all

select count(*) FROM `plugin_camm_snmptt` where status=1;

Code: Select all

SELECT count(plugin_camm_snmptt_unk.id) FROM plugin_camm_snmptt_unk WHERE 1=1;

Code: Select all

INSERT INTO `plugin_camm_temp` (`device_type_name`,`device_type_id`,`hostname`,`gr_f`,`gr_v`,`type`,`period`,`agentip_source`,`dev_count`,`count`)  select 'Markers','-1',CONCAT('[',`marker`,'] ' , IFNULL(`marker_name`,'no_marker_name')),'marker',  `marker`,'snmptt','all','0',count(*),count(*) FROM `plugin_camm_snmptt`  left join plugin_camm_keys on (`krid`=`plugin_camm_snmptt`.`id`)  left join plugin_camm_rule on (`rule_id`=`plugin_camm_rule`.`id`)  WHERE  1=1  and plugin_camm_rule.is_mark=1 and `status` = '2' and `ktype`=2  Group by  plugin_camm_rule.marker;

[JOEGOR]

Thanks for your reply,
I'm not familar with MYSQL,
But it seems there are no status in the table,
due to there are error msg
ERROR 1054 (42S22): Unknown column 'status' in 'where clause'

also the count(plugin_camm_snmptt_unk.id)

Attached the detail log in the file.
I think maybe I create a wrong database table.
so, I also attached the script which I used to create the mysql table.
Thanks a lot!

[JOEGOR]

I uninstall and re-install the camm again.
I found the log are something different,
but the unknown log and alert still not work even force to run the rule.
attached the new log.
thanks

[JOEGOR]

HI GTHE

IT seems work now.

But could I know what is the problem of mine?
is it the database problem?

And what is the usage of the last command?
Thanks a lot!

[ayinger]

It seems any device within the syslog portion of CaMM is placed into the "not_defined" category, even though the device & IP address are properly set within cacti.

The devices within Snmptt tab are being joined properly to their respective fields.

My "Join Field Name" setting is set to IP Address, and the version I am running is 1.6.4 with Cacti 0.8.7g

[gthe]

ayinger - try update to new version.

[ayinger]

Didn't work, I still have all devices listed under "not_defined" after hitting F5

Also, there were errors with the upgrade:

1. ERROR: Execute SQL, Insert Into [settings] new parameter

camm_snmptt_min_row_all
camm_sys_min_row_all

2. ERROR: Execute SQL, Add Column Table
plugin_camm_syslog_incoming

I use plugin_camm_syslog as the default incoming database under Settings:

[ayinger]

I noticed in the new version there's a "device id" field listed under snmptt. There is no such field listed under syslog.

[ayinger]

Sorry for all the posts, but I found out how to add the "device id" to the syslog. Every host within "not_defined" is set to 0. One example is I have a device ID of 143 within cacti, but within the camm syslog it is 0.