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

[ayinger]

any update?

[hammer733]

Hey folks,
1st thing, I am a noob with Cacti and even Linux, so please be kind.
I installed CactiEZ (cacti v0.8.7c) running on CentOS. Things are working great as far as my normal syslogs that was pre-installed in the package. I would like to be able to also get traps though, so I am trying to get the Camm plugin up and running but keep getting the following when I install the latest version of Camm 1.6.62. I noticed a few others also had experienced this but I have tried the suggestions of forcing a new update, changing the syslo-ng.conf file etc, and so far nothing. Does anyone understand why this error is appearing. Any help is much appreciated. Thanks.

[gthe]

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

Also, there were errors with the upgrade:

2. ERROR: Execute SQL, Add Column Table
plugin_camm_syslog_incoming

I use plugin_camm_syslog as the default incoming database under Settings:

Hey folks,
1st thing, I am a noob with Cacti and even Linux, so please be kind.
I installed CactiEZ (cacti v0.8.7c) running on CentOS. Things are working great as far as my normal syslogs that was pre-installed in the package. I would like to be able to also get traps though, so I am trying to get the Camm plugin up and running but keep getting the following when I install the latest version of Camm 1.6.62. I noticed a few others also had experienced this but I have tried the suggestions of forcing a new update, changing the syslo-ng.conf file etc, and so far nothing. Does anyone understand why this error is appearing. Any help is much appreciated. Thanks.

This issue concerns the table plugin_camm_syslog_incoming - and not important if you not use it, but I will try to find the cause and correct

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.

What value is set in Hostname field in cacti for this device ?
And what in host field of syslog messages from this host ?

[hammer733]

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

Also, there were errors with the upgrade:

2. ERROR: Execute SQL, Add Column Table
plugin_camm_syslog_incoming

I use plugin_camm_syslog as the default incoming database under Settings:

Hey folks,
1st thing, I am a noob with Cacti and even Linux, so please be kind.
I installed CactiEZ (cacti v0.8.7c) running on CentOS. Things are working great as far as my normal syslogs that was pre-installed in the package. I would like to be able to also get traps though, so I am trying to get the Camm plugin up and running but keep getting the following when I install the latest version of Camm 1.6.62. I noticed a few others also had experienced this but I have tried the suggestions of forcing a new update, changing the syslo-ng.conf file etc, and so far nothing. Does anyone understand why this error is appearing. Any help is much appreciated. Thanks.

This issue concerns the table plugin_camm_syslog_incoming - and not important if you not use it, but I will try to find the cause and correct

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.

What value is set in Hostname field in cacti for this device ?
And what in host field of syslog messages from this host ?

Must be missing something. To bypass the install problem I did the following, and am still getting errors in my Catai Log ( See attached )

In the Plugin Camm/Settings & Utils I simply changed the DB name to syslog and then changed the table name to syslog_incoming since data seems to be coming in there. There must be something else to edit though. Any help would be much appreciated.

[gthe]

Must be missing something. To bypass the install problem I did the following, and am still getting errors in my Catai Log ( See attached )

In the Plugin Camm/Settings & Utils I simply changed the DB name to syslog and then changed the table name to syslog_incoming since data seems to be coming in there. There must be something else to edit though. Any help would be much appreciated.

This is wrong.
Must be 2 tables:
plugin_camm_syslog and plugin_camm_syslog_incoming.
Data will be received at that table, which is set up in syslog-ng.conf
Usually this table is plugin_camm_syslog.

[ayinger]

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

Also, there were errors with the upgrade:

2. ERROR: Execute SQL, Add Column Table
plugin_camm_syslog_incoming

I use plugin_camm_syslog as the default incoming database under Settings:

Hey folks,
1st thing, I am a noob with Cacti and even Linux, so please be kind.
I installed CactiEZ (cacti v0.8.7c) running on CentOS. Things are working great as far as my normal syslogs that was pre-installed in the package. I would like to be able to also get traps though, so I am trying to get the Camm plugin up and running but keep getting the following when I install the latest version of Camm 1.6.62. I noticed a few others also had experienced this but I have tried the suggestions of forcing a new update, changing the syslo-ng.conf file etc, and so far nothing. Does anyone understand why this error is appearing. Any help is much appreciated. Thanks.

This issue concerns the table plugin_camm_syslog_incoming - and not important if you not use it, but I will try to find the cause and correct

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.

What value is set in Hostname field in cacti for this device ?
And what in host field of syslog messages from this host ?

Must be missing something. To bypass the install problem I did the following, and am still getting errors in my Catai Log ( See attached )

In the Plugin Camm/Settings & Utils I simply changed the DB name to syslog and then changed the table name to syslog_incoming since data seems to be coming in there. There must be something else to edit though. Any help would be much appreciated.

hostname is 192.168.93.2 in cacti, and host field in syslog is also 192.168.93.2.

[gthe]

hostname is 192.168.93.2 in cacti, and host field in syslog is also 192.168.93.2.

Which database you are use for syslog (cacti or syslog-ng) ?

[ayinger]

hostname is 192.168.93.2 in cacti, and host field in syslog is also 192.168.93.2.

Which database you are use for syslog (cacti or syslog-ng) ?

Neither - rsyslog on Red Hat 5.3

/etc/rsyslog.conf
------------------------------------------

#CaMM Settings

#Use MySQL
$ModLoad ommysql.so
# Provides UDP syslog reception
$ModLoad imudp.so
$UDPServerRun 514

$template camm,"insert into plugin_camm_syslog(host, facility, priority, sys_date, message) values ('%hostname:::UPPERCASE%', '%syslogfacility-text%', '%syslogpriority-text%', '%timereported:::date-mysql%', '%msg%')", SQL

*.* :ommysql:127.0.0.1,cacti,mysql-user,mysql-pass;camm

[gthe]

hostname is 192.168.93.2 in cacti, and host field in syslog is also 192.168.93.2.

Which database you are use for syslog (cacti or syslog-ng) ?

Neither - rsyslog on Red Hat 5.3

/etc/rsyslog.conf
------------------------------------------

#CaMM Settings

#Use MySQL
$ModLoad ommysql.so
# Provides UDP syslog reception
$ModLoad imudp.so
$UDPServerRun 514

$template camm,"insert into plugin_camm_syslog(host, facility, priority, sys_date, message) values ('%hostname:::UPPERCASE%', '%syslogfacility-text%', '%syslogpriority-text%', '%timereported:::date-mysql%', '%msg%')", SQL

*.* :ommysql:127.0.0.1,cacti,mysql-user,mysql-pass;camm

Well, that's the source of error.
You need insert IP from message to sourceip field (VARCHAR(45)) of plugin_camm_syslog

[ayinger]

Which database you are use for syslog (cacti or syslog-ng) ?

Neither - rsyslog on Red Hat 5.3

/etc/rsyslog.conf
------------------------------------------

#CaMM Settings

#Use MySQL
$ModLoad ommysql.so
# Provides UDP syslog reception
$ModLoad imudp.so
$UDPServerRun 514

$template camm,"insert into plugin_camm_syslog(host, facility, priority, sys_date, message) values ('%hostname:::UPPERCASE%', '%syslogfacility-text%', '%syslogpriority-text%', '%timereported:::date-mysql%', '%msg%')", SQL

*.* :ommysql:127.0.0.1,cacti,mysql-user,mysql-pass;camm

Well, that's the source of error.
You need insert IP from message to sourceip field (VARCHAR(45)) of plugin_camm_syslog

Beautiful, I made the change, truncated the table, and now it looks good =)

Here's the correct syntax incase anyone else needs it.

sourceip = %fromhost-ip%

#CaMM Settings
$template camm,"insert into plugin_camm_syslog(host, sourceip, facility, priority, sys_date, message) values ('%hostname:::UPPERCASE%', '%fromhost-ip%', '%syslogfacility-text%', '%syslogpriority-text%', '%timereported:::date-mysql%', '%msg%')", SQL

[gthe]

New version in first post!

CAMM --- 1.6.7 ---2010-08-26
- Add Chart on stats tab. You can view the schedule of income during the selected messages from the selected interval and build the graph of the distribution of messages by hosts. Or you can go to view the specific messages.
- Change to use rule_id as marker_id and rule_name as marker_name. Will no longer be confusion with the marker_id anr rule_id;

- Fix old-time bug with autocreate of trees (thanks torstentfk);
- Fix many minor bugs;

Screens from chart:

[antw1]

Where can we download it?

[ayinger]

Where can we download it?

His first post on page 1.

[hammer733]

This looks great. Fix of tree bug? Is this related to the issue I am having during install (noted in a few posts back)???

[gthe]

This looks great. Fix of tree bug? Is this related to the issue I am having during install (noted in a few posts back)???

It's fixed for clean install.
Will be fixed for update soon.