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

Post by **TheWitness** » Mon Jun 14, 2010 7:37 am

smlick wrote:
TheWitness wrote:Partitioning will fix this problem. Gthe just needs some help with the light bulb. It's still off.

TheWitness
Can you tell us some tips to succesfully partitioning the plugin_camm_syslog db?

Regards
Alessio

Gthe has to do it. I have provided direction. You should ask him. It's not too much work.

TheWitness

torstentfk · Post by **torstentfk** » Mon Jun 14, 2010 7:42 am

just for info:
I have a partioned DB, but it does not speed up or work as wanted; profit is only for incremental backup (not backuping the whole db, only part of it on a daily mission).
speed : see image

Post by **TheWitness** » Mon Jun 14, 2010 7:46 am

What does the query look like? If you are not "limiting" the number or rows searched by date, CAMM will never scale. As the date range increases, so will the query time. In this case, partitioning does not help.

TheWitness

gthe · Post by **gthe** » Thu Jun 17, 2010 4:22 am

torstentfk wrote:just for info:
I have a partioned DB, but it does not speed up or work as wanted; profit is only for incremental backup (not backuping the whole db, only part of it on a daily mission).
speed : see image

smlick wrote:
TheWitness wrote:Partitioning will fix this problem. Gthe just needs some help with the light bulb. It's still off.

TheWitness
Can you tell us some tips to succesfully partitioning the plugin_camm_syslog db?

Regards
Alessio

That's the file that will create an additional (plugin_camm_syslog_parted) table in the default database. All data will be duplicated in this table. Then we can inspect the difference in the performance of queries.

Ever · Post by **Ever** » Thu Jun 17, 2010 10:29 am

Hi gthe, I am trying to install CAMM plugin but i couldn't, can you help me. I have this message:

FATAL: Database or Table does not exist

mcutting · Post by **mcutting** » Thu Jun 17, 2010 10:33 am

Ever wrote:Hi gthe, I am trying to install CAMM plugin but i couldn't, can you help me. I have this message:

FATAL: Database or Table does not exist

Ever,

You really should search the forums before posting
http://forums.cacti.net/post-158796.htm ... ist#158796

Ever · Post by **Ever** » Thu Jun 17, 2010 10:39 am

I did, but I don't know what to do.

mcutting · Post by **mcutting** » Thu Jun 17, 2010 10:42 am

The thread I included tells you how to get round this. Also, you need to ensure that you have the latest copy, as this was addressed a while back.

Ever · Post by **Ever** » Thu Jun 17, 2010 10:57 am

Ok man thanks for the help I already read the other post, but I dont know how to import tables and how to create db in syslog, can you help me

mcutting · Post by **mcutting** » Thu Jun 17, 2010 11:08 am

Ok.

You'll need access to something like PHPMyAdmin, or a GUI for your MySQL installation - are you running Windows or Linux ?

I also recommend that you create a new database, and DON'T use your Cacti DB for this, as the syslog tables can get very large very quickly, dependant on what you are logging.

1. In the CAMM directory, locate the SQL subdirectory
2. In here, there are two files. Take the "plugin_camm_syslog_incoming_memory.sql" file, as this is more efficient
3. Login to your MySQL (this is a command line example)

Now enter

CREATE DATABASE syslog;

Now from a command line (from the mysql\bin directory)

mysql -u root -p <your password> < /path/to/camm/sql/plugin_camm_syslog_incoming_memory.sql

The database should get imported.

That should be it.

Ever · Post by **Ever** » Thu Jun 17, 2010 11:51 am

Hi I already did that but nothing happened. Can you check it please.

mcutting · Post by **mcutting** » Thu Jun 17, 2010 12:19 pm

Ok. You didn't follow my instructions

As you appear to be using linux, install phpmyadmin, and use this to

1. Create the database "syslog"
2. Import the sql file

Ever · Post by **Ever** » Thu Jun 17, 2010 12:29 pm

Sorry I am new using Cacti. I already installed phpmyadmin and now what should I do????

mcutting · Post by **mcutting** » Thu Jun 17, 2010 12:43 pm

If you've not already installed PhpMyAdmin, then choose all the defaults. I'm using a Blackberry at the moment, and can't easily tell if you've already got this installed and are just reconfiguring the package.
If it's installed already, just:

1. Go to http://localhost/phpmyadmin
2. Login using your mysql root user and password
3. Create a new database called syslog
4. Import the sql file I mentioned earlier

PhpMyAdmin is very intuitive, and is also self-explanatory.

Once you've done this, enable the CAMM plugin. If it complains "FATAL......":

Click the back button on your browser, go to Settings / Camm, and change the database name at the bottom of the screen to reflect yours, and then save

Make sure the plugin is enabled, and you've given yourself rights to use it. To do this

1. In Cacti, go to user management
2. Select your login
3. Place a tick in all Camm plugin related realms (there's two or three)
4. Click save

The Camm tab should appear

If this part works, then you now need to configure a mysql pipe to get syslog entries into your database. Search the forums for "syslog" - there is a raft or info in here on how to create this pipe.

The last thing to do is setup yÃ³ur devices to forward syslogs to your Cacti server. If the pipe is open, Camm will begin to accept logs.

Hope this helps.

Ever · Post by **Ever** » Thu Jun 17, 2010 1:34 pm

Hi I couldn't, I have Cacti in Ubuntu Server using an Ip address, if you have time Could you please give me some advice to finish to install the plugin. Thanks

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

Who is online