Problems with plugin, syslog specifically

[inetquestion]

Looking for some help on two items:

1. mysql is full of gigabytes of syslog data
2. why I cannot get the syslog plugin to work correctly.



On my original installation of CactiEZCD v0.4, there were several plugins installed. After upgrading to version 0.8.7.g, all my plugins are now missing from the gui. Thus far all the notes I see about modifying global.php OR config.php do not seem to help.

I added this below to config.php:
$plugins = array();
$plugins[] = 'syslog';


I have also imported the sql for the syslog plugin:
mysql -u ********** --password=********** cacti < syslog.sql


If I try to access the syslog plugin directly by going here: /plugins/syslog/syslog.php
I get the following error: "you are not permitted to access this section of Cacti"


There is something about syslog which is filling up my DB, so I really need to purge it out. The following command generate a HUGE sql file.

# Dump the MySQL Database
mysqldump -uroot --opt cacti> /var/www/html/cacti-backup.sql

# Resulting files
/var/www/html/syslog.sql ==> 2.8GB


/var/lib/mysql/syslog/syslog_incoming.MYD ==> 2.5GB



Regards,


-Inet

[inetquestion]

no takers?

[luckenbach]

Have you granted your self access to the plugin under settings? and how much data are you generating from syslog?

[inetquestion]

in the config files, or through the gui?

in the gui under realm settings, my user has permission to everything...
Is there anything else I need to do?


-Inet

[inetquestion]

After the syslog DB filled up my filesystem, I was unable to remove these entries through mysql.
The following procedure worked for me:

cd /var/lib/mysql/syslog
rm syslog_incoming.MYD
rm syslog.MYD

touch syslog_incoming.MYD
touch syslog.MYD

chown apache:apache *.MYD

################################################################################
### Run the following commands once in the mysql application: mysql -u root
################################################################################
use syslog;
repair table syslog;
describe syslog;
optimize table syslog;

repair table syslog_incoming;
describe syslog_incoming;
optimize table syslog_incoming;
################################################################################

init 6

# Suggest you run fsck to clean up any lingering filesystem anomolies...

[gandalf]

Moved to plugin forum
R.

[inetquestion]

Any suggestions on how to get the plugins working?

[TheWitness]

The right way to handle Syslog is the following:

1) Upgrade your MySQL to 5.1.47++
2) Upgrade Syslog to 1.05
3) When Prompted during upgrade Choose Partitioned Table

The upgrade may take an hour or two, but the system will still work w/o issue. Good luck.

TheWitness

[GlueGuy]

The right way to handle Syslog is the following:

1) Upgrade your MySQL to 5.1.47++
2) Upgrade Syslog to 1.05
3) When Prompted during upgrade Choose Partitioned Table

The upgrade may take an hour or two, but the system will still work w/o issue. Good luck.

TheWitness

Ahhh. I've been having trouble with the syslog plugin. We're currently using MySQL - 5.0.82sp1. Am I correct that this will not work with the 1.05 syslog plugin?

Also, the documentation suggests that we need rsyslog in order to run a central server. If we only have a single server, then is rsyslog not needed? Reason I ask, is because when I attempt to install rsyslog, I get the following:

yum install rsyslog rsyslog-mysql
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Parsing package install arguments
No Match for argument: rsyslog
No Match for argument: rsyslog-mysql

This is on a CentOS (aka CactiEZ v 0.6)

[TheWitness]

Rsyslog must be on the syslog server. That does not need to be the cacti server.

TheWitness