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

gthe · Post by **gthe** » Wed Jun 03, 2009 9:32 am

Palermo wrote:If i unstall the plugin the hole plunin is gone.

Excuse, I can not understand it

Palermo wrote: If i press install in the PA than i got this error:
Code: Select all
FATAL: Database or Table does not exist

It because you use mysql root account in cacti config.php.
To solve this I need know all tables names in cacti and syslog (or syslog-ng) DBs (May be in PM)

Code: Select all

show tables from cacti;
show tables from syslog;

Soo I need find incorrect tables.

Palermo · Post by **Palermo** » Wed Jun 03, 2009 10:42 am

gthe wrote:
Palermo wrote:If i unstall the plugin the hole plunin is gone.
Excuse, I can not understand it

Yea if i read it back its a bit unclear

Let me explane in a clear way

If i press on the uninstall button. i get the error

Code: Select all

FATAL: Database or Table does not exist

But in the settings page the CAMM tab is available.
so i change the database options from syslog-ng to syslog and save the options.
In the PA i see the CAMM plugin with the install button highlighted.
if i press the button it installs CAMM successfully.
But the 3 CAMM screens reappears.

I`l send you the databases via PM.

Thx for your help.

gthe · Post by **gthe** » Wed Jun 03, 2009 10:19 pm

Palermo wrote: But in the settings page the CAMM tab is available.
so i change the database options from syslog-ng to syslog and save the options.

And after that uninstalling also fail ?

mcutting · Post by **mcutting** » Thu Jun 04, 2009 1:17 am

I had exactly the same problem when initially setting up the plugin. From what I see, the syslog database name is hard coded into the setup. For me, even dropping out the plugin, creating the table, and then attempting to install showed the same error.

In the end, I went into CAMM settings, changed the syslog database name, created the tables from the sql files included, and then went into mysql and deleted two of the rogue entries from the plugin management table.

After this, everything works fine.Been using this fine plugin for about 2 months.

Palermo · Post by **Palermo** » Thu Jun 04, 2009 5:49 am

gthe wrote:And after that uninstalling also fail ?

When i hit the uninstall button the database error shows up.
i hit the back button of the browser and than is see in PA 1 install for the CAMM plugin. (looks good)
At this moment in the settings option of cacti there is no CAMM tab.
If i press the install of CAMM in the PA again i got the database error.
Again hit the back button of the browser.
Now there is a tab CAMM in the setting of cacti. There i change the database name to syslog.
Now again i hit the install CAMM in PA and now it works.
But i have more CAMM screens in the PA page (Like picture above)

sorry for this.
My English is not great.

mcutting wrote: In the end, I went into CAMM settings, changed the syslog database name, created the tables from the sql files included, and then went into mysql and deleted two of the rogue entries from the plugin management table.

I i understand you right
first you create (import) the 3 SQL files from the folder SQL
And then you drop the tables from SQL?

mcutting · Post by **mcutting** » Thu Jun 04, 2009 5:50 am

Gthe,

Is it possible to define multiple recipients when sending email from a rule ? Also, when the rule is triggered, it sends ALL events that are linked to this. Is there a way to send only those records that have not been marked ?

33boston · Post by **33boston** » Tue Jun 09, 2009 8:50 am

Hi - I recently installed the camm plugin and I'm having trouble getting the syslogs to populate.

I have Cacti on a Windows 2003 Server with Kiwi Syslog popluating a mysql db.

During the install of camm I received the following -

Error: Create Table, Table->'syslog-ng'.'plugin_camm_syslog'
Error: Add Column, Table-> 'syslog-ng'.'plugin_camm_syslog'. Column->Alert
Error: Execute SQL, Add Index, Table -> 'syslog-ng'.'plugin_camm_syslog', Index->Alert

Now through Kiwi I can query the plugin_camm_syslog table located in the cacti db and it returns the correct info but the camm syslog is not populating.

I receive the following errors every poll -

--CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"INSERT INTO `plugin_camm_tree` (`hostname`,`eventname`,`type`,`agentip_source`,`count`) SELECT `sysl`.`host`, `sysl`.`facility`, 't_syslog',`sysl`.`sourceip`,count(*) FROM `cacti`.`plugin_camm_syslog` as sysl GROUP BY `host`, `facility`'

--CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"select count(*) FROM `cacti`.`plugin_camm_syslog` where `status`=1"

--CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE `cacti`.`plugin_camm_syslog` set status=2 where status=1'

As well as a couple of other errors.

I'm hoping this is an easy fix due to the fact that I am extremely new to MySQL and am trying to feel my way through this.

Any help would be greatly appreciated. Thanks!

gthe · Post by **gthe** » Wed Jun 10, 2009 3:17 am

33boston,
try this mysql command

Code: Select all

UPDATE settings SET `value`='0' where name = 'camm_version';

And open camm tab. This will force autoupdate process.

gthe · Post by **gthe** » Wed Jun 10, 2009 6:18 am

mcutting wrote:Gthe,

Is it possible to define multiple recipients when sending email from a rule ?

may be just add ";" in email field and type multiple emails ?

mcutting wrote: Also, when the rule is triggered, it sends ALL events that are linked to this. Is there a way to send only those records that have not been marked ?

Sorry I can not understand it.

mcutting · Post by **mcutting** » Wed Jun 10, 2009 6:48 am

may be just add ";" in email field and type multiple emails ?

Tried that - doesn't seem as though CAMM allows you to enter anything other than name@domain.com

33boston · Post by **33boston** » Wed Jun 10, 2009 6:53 am

Gthe,

Thank you for the reply. I ran the command you posted and it did force the autoupdate process when I opened the camm tab but I am still not seeing anything. I let the poller run again and checked the cacti log and i am getting the same error messages I posted earlier.

Any ideas?

smlick · Post by **smlick** » Fri Jun 12, 2009 6:03 am

mcutting wrote:
may be just add ";" in email field and type multiple emails ?
Tried that - doesn't seem as though CAMM allows you to enter anything other than name@domain.com

Yes I also tried adding multiple recipient but the system didn't accept any separator like ; , . * : ecc.
Have you any news about that?

Regards
Alessio

mcutting · Post by **mcutting** » Fri Jun 12, 2009 10:10 am

No news from my side...

smlick · Post by **smlick** » Fri Jun 12, 2009 11:54 am

It's possible that there's a charset limitations inside the code?
Tonight I'll try to fix.

Regards
Alessio

gthe · Post by **gthe** » Sat Jun 13, 2009 4:13 am

smlick wrote:It's possible that there's a charset limitations inside the code?
Tonight I'll try to fix.

Regards
Alessio

Yes, they there are. But I cannot simply lay out the new version with corrections, because the new version contains many additions and is still not ready.

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

syslogs

Who is online