Cactiusers.org

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

no takers?

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...

Any suggestions on how to get the plugins working?