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

[mcutting]

mcutting, can you show me result of sql query:

Code: Select all

SELECT * FROM settings where name like 'camm_autop%' or name like 'camm_sys%';

Here you are

camm_autopurge_timing 1440
camm_syslog_db_name syslog
camm_syslog_pretable_name plugin_camm_syslog_incoming
camm_sys_delay_purge_day 1
camm_sys_max_row_all 50000
camm_sys_max_row_per_device 1200
camm_sys_tab_update 1

[gthe]

And this two:

Code: Select all

SELECT day(sys_date), count(*) FROM syslog_ng.plugin_camm_syslog group by day(sys_date);

Code: Select all

SELECT host, date(`sys_date`) as day_noumber, count(*) as count_rows FROM  syslog_ng.plugin_camm_syslog group by host, date(`sys_date`) HAVING count_rows > 1200

Also turn debug mode in camm settings in enable, "Data Purge Timing" in 10 min and check/post cacti log after "Auto purge process" complete.

[mcutting]

And this two:

Code: Select all

SELECT day(sys_date), count(*) FROM syslog_ng.plugin_camm_syslog group by day(sys_date);

Code: Select all

SELECT host, date(`sys_date`) as day_noumber, count(*) as count_rows FROM  syslog_ng.plugin_camm_syslog group by host, date(`sys_date`) HAVING count_rows > 1200

Also turn debug mode in camm settings in enable, "Data Purge Timing" in 10 min and check/post cacti log after "Auto purge process" complete.

day(sys_date) count(*)
11 1710
12 8255
13 9512
14 11340
15 15363
16 3820
21 25530
22 10250

host day_noumber count_rows
192.168.120.5 2009-04-21 7581
192.168.121.21 2009-04-21 1787
192.168.121.21 2009-04-22 1541
192.168.240.5 2009-04-21 1358

[gthe]

very strange ...
Will try to collect more records and debug it.

[mcutting]

Ok - no rush. I can delete manually (with my .sql script) for the time being.

[mcutting]

One other thing I have noticed is this is the event logs

04/22/2009 01:35:25 PM - SYSTEM camm STATS: del_traps:0 del_unk_traps:0 del_sys_messages:0

Not that there "anything wrong" with this, but why doesn't it mention about how many syslog messages it processed etc?

[mcutting]

Gthe - Any developments on the above ? Also, I've just noticed that the templates included also seem to be broken (on my system anyway). There are several errors in the log (I don't have these handy at the moment).

In particular, I am looking for the SYSLOG graphs..

[L0gRuS]

GTHE hi!
Today i found error in my cacti log

05/04/2009 12:53:25 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT count(*) FROM plugin_camm_snmptt WHERE 1=1 and (hostname IN ()) ;"

it repeated only 1 time. but i dont know what is it

[pthaynes]

First thanks for making an excellent plugin.

I only have one minor issue - on the stats page in the camm plugin my graph doesn't appear (I get the standard "the rrd file does not exist" image.

I noticed that when I installed the camm plugin it didn't install the templates for the graphs nor did it create the graphs. So manually I did the following:
1. Imported the templates from the /plugins/camm/addons/graphs directory.
2. Copied the ss_cammpoller.php file from that same directory to /scripts.
3. chown apache:apache ss_cammpoller.php
4. chmod +755 ss_cammpoller.php
5. Added each of the graph templates that started with "Local - CAMM" to localhost and then ticked them to graph them.

Once I did that I noticed that my poller was logging errors. After looking around I found that the "Local - CAMM Poller Rows Statistics" data input method refers to a script that does not exist. It refers to "/scripts/ss_cammtpoller.php ss_cammpoller". Is this a typo or should there be a ss_cammtpoller.php file?

After making those changes I noticed that only the "Local - CAMM Poller Time Statistics" graph works. The graph on the Stats page for CAMM still doesn't work.

Could you please let me know if that file name was a typo or where I can find a copy of the ss_cammtpoller.php file?

Thanks in advance for any help.

[pthaynes]

I'm currently using version 1.5.3 of CAMM and looking at the rule processing. When I tick the box next to "Mark Record" it seems to only accept a number.

When I put in a number and run a rule that does match something in syslog I don't notice any difference in what is shown in syslog. What is this function intended for?

I was assuming that the Mark would either create a new folder under that host on the Syslogs with that Mark OR would change something in the description or message tab.

Also is there a list of any variables that can be used in the Mail messages?

Thanks again for a great plugin.

[mcutting]

First thanks for making an excellent plugin.

I only have one minor issue - on the stats page in the camm plugin my graph doesn't appear (I get the standard "the rrd file does not exist" image.

I noticed that when I installed the camm plugin it didn't install the templates for the graphs nor did it create the graphs. So manually I did the following:
1. Imported the templates from the /plugins/camm/addons/graphs directory.
2. Copied the ss_cammpoller.php file from that same directory to /scripts.
3. chown apache:apache ss_cammpoller.php
4. chmod +755 ss_cammpoller.php
5. Added each of the graph templates that started with "Local - CAMM" to localhost and then ticked them to graph them.

Once I did that I noticed that my poller was logging errors. After looking around I found that the "Local - CAMM Poller Rows Statistics" data input method refers to a script that does not exist. It refers to "/scripts/ss_cammtpoller.php ss_cammpoller". Is this a typo or should there be a ss_cammtpoller.php file?

After making those changes I noticed that only the "Local - CAMM Poller Time Statistics" graph works. The graph on the Stats page for CAMM still doesn't work.

Could you please let me know if that file name was a typo or where I can find a copy of the ss_cammtpoller.php file?

Thanks in advance for any help.

I saw these same errors also. It looks like the templates are busted - I reported this in a previous post.

[mcutting]

Gthe - Any developments on the above ? Also, I've just noticed that the templates included also seem to be broken (on my system anyway). There are several errors in the log (I don't have these handy at the moment).

In particular, I am looking for the SYSLOG graphs..

BUMP -Any news ?

Thanks

[gthe]

1. Graphs do not work yet (it is known issue from first post)
2. pthaynes - mark used for marking record - i.e. add marker in `mark` filed of record. It was old feature request and was used for construction of graph on markers. But if you have an idea on another of application - I am ready to listen
3. mcutting - Still at least week I will be occupied by work on other plugin, and only then I can correct errors. Sorry.

[pthaynes]

GTHE - thanks for the reply. I had another look at my syslog data - it seems that the "Mark" value updates the alert field for a syslog entry in the database. When I look at the syslogs in the web browser I can see the column marked "Alert" but it doesn't actually show the value of the marker.

If I double click on a syslog entry I can't see nor edit the "Alert" value.

My thoughts for using the field were that I could flag syslogs or SNMP traps that related to low priority or "non-issues" with a marker so that we could filter them out or sort the syslogs by that field. The benefit of doing that rather than deleting them is that if we do later find out that there really is a problem we can un-filter those syslogs and use them for troubleshooting.

This is not a high priority modification for me GTHE, more of a nice thing to have in the long term.

Thanks for your help.

[smlick]

Very great plugin!!!!

I found a bug with the recreate tree that seems didn't work properly.
If I add new template in Cacti I'm not able to see the log in the correct tree.
The system create the correct folder for the device but inside it doesn't collect any data and I can only see the log of the device with a query from the "global search" or directly in the root directory (syslog).
So I tried to uninstall and reinstall the camm plugin and now all is ok, any device in the right folder with the right log, I lost only the rule with this trick and I have to reimport them from a previous backup.
In the next release do you think to solve that problem?

Tnx again for your job.


Regards
Alessio