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

[gthe]

replace folders from archive

[mcutting]

Works perfect - thanks !

[mcutting]

Hmm - I now have a few errors

When attempting to delete a rule, I get the enclosed error messages ?

Also, I can't seem to delete any messages based on rules I create ? I create the rule, test it (see data), but the messages are never deleted ?

Thanks

[gthe]

Hmm - I now have a few errors

When attempting to delete a rule, I get the enclosed error messages ?

Here is the fix.

Also, I can't seem to delete any messages based on rules I create ? I create the rule, test it (see data), but the messages are never deleted ?

Thanks

Rule process only new message.
To process old messages - force it from rule tab.

[mcutting]

Thanks. No more error messages, but I still see the syslogs in the list. Forcing the rule to run doesn't seem to make any difference ?

[mcutting]

Thanks. No more error messages, but I still see the syslogs in the list. Forcing the rule to run doesn't seem to make any difference ?

Ok - ignore that - it's working.

Thanks

[erickbe]

This is a great plugin, I got syslog working using Rsyslog on Fedora. Took a bit of messing around but got it figured out and working (I think). Does the alert column on the camm syslog view suppose to have anything in it from the syslog message?

Also, is CAMM using the database username/password defined in the cacti global.php but just with a different database name set in the camm config? Just curious as I didn't see a username/password field anywhere, etc.

Thanks.

[gthe]

from http://forums.cacti.net/viewtopic.php?t=26040 :

HOW-TO Install Syslog 0.5.2 plugin on Linux/Unix Cacti versions 0.8.7, 0.8.7a and 0.8.7b
-------------------------------------------------------------------------------------------
[submitted by noflies, 26 Feb 2008]

4a. Grant privileges to cactidb_user for the syslogdb_default.

Code: Select all

shell# mysql --user=root --password
Enter password: ********
mysql> GRANT ALL ON <syslogdb_default>.* TO <cacti_dbuser>@<syslogdb_hostname> IDENTIFIED BY '<cacti_dbpass>';
mysql> flush privileges;
mysql> exit

NOTE: Change the above user credentials to your specific installation.

Soo you just need grant privileges for cacti mysql user to database.

[erickbe]

Ok, thanks.

Is there a way to edit items in the Tree yet without going into the SQL database?

I have added a few Cisco routers for syslog with this and some show up under "Cisco Router" part of tree and some don't. For now I went into the SQL table and edited the field so those devices fell under the "Cisco Router" tree.

[mcutting]

Erickbe - CaMM uses the host template to identify the syslog messages. I have all mine grouped under host templates called "Windows Servers", "Cisco Routers" etc.

Fastest way is to go into the devives, and change the host template they use. This won't affect the existing graphs either.

If you want to keep the graphs the same but with a different host template, then copy an existing one and rename it.

[erickbe]

Oh, ok. Well, I had existing servers in Cacti with a host template of "HP Servers" and the hostname in Cacti Devices is VOIPSERVER which matches the server name. I set up syslog on the server to send to the Cacti IP server and see the syslogs from the server fine but in the CAMM tree it shows up as just IP:VOIPSERVER and not under "HP Servers". There is no tree item called "HP Servers" even.

[erickbe]

Here is what I added to rsyslog configuration for use with CAMM...

Code: Select all

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


########################################################
##
## Template to write to MySQL table for Cacti/CAMM use
##

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

# Near bottom of config
*.* :ommysql:127.0.0.1,syslog,cactiDBusername,cactiDBpassword;camm

[erickbe]

Hello,

I have a basic helpdesk type user with view only type rights in Cacti. The user does not have console tab access so that tab does not show up normally. The tabs they see are graphs, npc, camm, weathermaps.

However, when they use camm, the console tab is shown and the camm tab is shown before the others so when the user switches between tabs the tab graphics jump around since when they go back to graphs, etc the console tab goes away.

Any ideas on how to fix this?

[mcutting]

Gthe,

Every other poll, I get the below error in the log

CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"INSERT INTO `syslog`.`plugin_camm_syslog` SELECT * FROM `syslog`.`plugin_camm_syslog_incoming` WHERE status=2'

Any ideas ?

Thanks

[gthe]

erickbe - I will try clean install and check.
mcutting - what scheme do you use ?

There are may be 2 schems of work

a)One table - all incoming messages stored in one table (default "plugin_camm_syslog")
b)Two tables - all incoming messages stored in temp table (default "plugin_camm_syslog_incoming"). On each run poller process all rules and after that copy messages to main table