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

[gthe]

I have my syslog set to autopurge after 25000 entries older then 3 days and I have almost 350k rows.

Running 1.6.3 CAMM. Any ideas on why the purge isn't happening?

Erick

Same issue for me - works for a couple of days (after changing settings to something else, then back to what they were), then stops working again.

Can I see the your results of the 2 sql ? This may help in identifying problems (if any).

Code: Select all

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

and

Code: Select all

SELECT * FROM settings where name = 'camm_sys_delay_purge_day';

[gthe]

gthe,

I have confirmed that the problem definitely happens when I fill in each of the items in order on the rule creation screen. I did find that if I locate a syslog item in the syslog tab and click the "cog" icon the rule creation works fine. I have attached the error message (and screenshots of how I tried to create the rule when it failed) below.

Hope this helps.

Regards,

Peter

Can you send me your version of the file cacti.plugin.camm-min.js (in rar in PM) ?

[gthe]

pthaynes your file does not match with my file with fix from post 170785

[erickbe]

I tried the email rule feature and it works but I accidentally got a ton of emails waiting to be sent.

Does anyone know where on Fedora the outbound emaila are held before they are sent to sendmail? If I stop sendmail then the email stops coming and I want to delete whatever messages are buffered up but can't find where they are.

Thanks

[erickbe]

I tried the email rule feature and it works but I accidentally got a ton of emails waiting to be sent.

Does anyone know where on Fedora the outbound emaila are held before they are sent to sendmail? If I stop sendmail then the email stops coming and I want to delete whatever messages are buffered up but can't find where they are.

Thanks

Ok, I figured out my email issue and fixed it by deleting the thousands of files in the clientmqueue folder and mqueue folders.

Does anyone know how to configure Cacti and/or sendmail so it can only accept like 100 messages in the clientmqueue folder and then stop accepting new emails? Or any other ideas on how to prevent a email flood occurring from Cacti / camm emails?


Also, I'm still having problems with camm not purging my syslogs. I have it set for 50000 now and it is not purging, I am up to nearly 700,000 records in the syslog table now.

[gthe]

Ok, I figured out my email issue and fixed it by deleting the thousands of files in the clientmqueue folder and mqueue folders.

Does anyone know how to configure Cacti and/or sendmail so it can only accept like 100 messages in the clientmqueue folder and then stop accepting new emails? Or any other ideas on how to prevent a email flood occurring from Cacti / camm emails?


Also, I'm still having problems with camm not purging my syslogs. I have it set for 50000 now and it is not purging, I am up to nearly 700,000 records in the syslog table now.

I have my syslog set to autopurge after 25000 entries older then 3 days and I have almost 350k rows.

Running 1.6.3 CAMM. Any ideas on why the purge isn't happening?

Erick

Same issue for me - works for a couple of days (after changing settings to something else, then back to what they were), then stops working again.

Can I see the your results of the 2 sql ? This may help in identifying problems (if any).

Code: Select all

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

and

Code: Select all

SELECT * FROM settings where name = 'camm_sys_delay_purge_day';

[erickbe]

Ok, I figured out my email issue and fixed it by deleting the thousands of files in the clientmqueue folder and mqueue folders.

Does anyone know how to configure Cacti and/or sendmail so it can only accept like 100 messages in the clientmqueue folder and then stop accepting new emails? Or any other ideas on how to prevent a email flood occurring from Cacti / camm emails?


Also, I'm still having problems with camm not purging my syslogs. I have it set for 50000 now and it is not purging, I am up to nearly 700,000 records in the syslog table now.

I have my syslog set to autopurge after 25000 entries older then 3 days and I have almost 350k rows.

Running 1.6.3 CAMM. Any ideas on why the purge isn't happening?

Erick

Same issue for me - works for a couple of days (after changing settings to something else, then back to what they were), then stops working again.

Can I see the your results of the 2 sql ? This may help in identifying problems (if any).

Code: Select all

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

and

Code: Select all

SELECT * FROM settings where name = 'camm_sys_delay_purge_day';

Code: Select all

mysql> SELECT day(sys_date), count(*)  FROM syslog.plugin_camm_syslog group by day(sys_date);

+---------------+----------+
| day(sys_date) | count(*) |
+---------------+----------+
|            19 |   230857 |
|            20 |  1222177 |
|            21 |   538699 |
|            22 |   753754 |
|            23 |     6534 |
+---------------+----------+
5 rows in set (24.30 sec)


mysql> SELECT * FROM settings where name = 'camm_sys_delay_purge_day';
+--------------------------+-------+
| name                     | value |
+--------------------------+-------+
| camm_sys_delay_purge_day | 5     |
+--------------------------+-------+

[/code]

[gthe]

erickbe, And this is your answer. AutoPurge removes only those records that are older than the period 'camm_sys_delay_purge_day'.

Does anyone know how to configure Cacti and/or sendmail so it can only accept like 100 messages in the clientmqueue folder and then stop accepting new emails? Or any other ideas on how to prevent a email flood occurring from Cacti / camm emails?

In rule CaMM have a parameter in email action - [Email Mode] = [All records in the one email]

[fiberpimp]

Is there a way to execute the rules every 5 mins?

[pthaynes]

pthaynes your file does not match with my file with fix from post 170785

gthe,

Sorry for wasting your time. I had accidentally copied the replacement file into the wrong subdirectory.

I copied the file from the rar into the js directory and it works fine.

Regards,

Peter

[gthe]

Is there a way to execute the rules every 5 mins?

Yes, rules are runs in each cacti poller run.

[gthe]

From first post:

CAMM --- 1.6.4 ---2009-09-03

• - Added the possibility of cloning rules;
  - Added "host type" field in rule's sql;
  - Added ability to the rapid removal of records through the context menu for syslog and snmp traps Menu Tree;
  - minor fixs;

After updating the files, be sure to press CTRL + F5 to refresh your browser cache!

[mcutting]

1.6.4 in and working - thanks

[erickbe]

erickbe, And this is your answer. AutoPurge removes only those records that are older than the period 'camm_sys_delay_purge_day'.

Ok. I had stopped sending syslogs to the database for a bit, while I had time to figure out this issue on my box. A week ago I had a couple thousand records (above) and had stopped adding more to syslog and today I went in and mysql is saying the syslog table is bad and needs repairing. I haven't stopped my MySQL in past week (cacti is running still, etc fine) so not sure how this happened to the syslog database when it just was sitting there past week except for camm doing it's stuff. So just a FYI that maybe it slowly purges and if no records get added and it gets down to nothing it does something to the table maybe. Maybe not.


Thanks.

Does anyone know how to configure Cacti and/or sendmail so it can only accept like 100 messages in the clientmqueue folder and then stop accepting new emails? Or any other ideas on how to prevent a email flood occurring from Cacti / camm emails?

In rule CaMM have a parameter in email action - [Email Mode] = [All records in the one email]

[mcutting]

Is email broken again in version 1.6.4 ? I have existing rules from previous versions that worked fine before, but don't seem to anymore - I don't get any emails when I run them manually ??