RRDClean v0.38 - Released

Post by **TheWitness** » Sat Feb 21, 2009 12:28 pm

All,

Helping Gandolf out a bit. Here is a new version. For existing users, it's a pretty simple upgrade. I will be posting in a minute. Here is the ChangeLog.

--- 0.38 ---
feature: Make compatible with rrd structured paths
feature: add a rows selector to the utility
feature: auto-upgrade plugin
feature: change buttons to real ones
feautre: add 'Rescan' option to rebuild tables
info: several miscellaneous fixups

TheWitness

bigrat · Post by **bigrat** » Tue Mar 17, 2009 7:43 pm

I've just installed rrdclean-0.38, unfortunately I receive many errors below :

03/18/2009 07:30:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT plugin_rrdclean_action.id, plugin_rrdclean_action.name, plugin_rrdclean_action.local_data_id, plugin_rrdclean_action.action FROM plugin_rrdclean_action"

There has no plugin_rrdclean_action table in mysql database.

Fedora Core 10 - 2.6.27.12-170.2.5.fc10.i686.PAE
Cacti-0.8.7d
PIA 2.4
Spine-0.8.7c
MySQL 5.0.67

Please kindly help me to fix that

Thanks

Post by **TheWitness** » Tue Mar 17, 2009 7:49 pm

The table does not exist. You should re-install the plugin.

TheWitness

Post by **TheWitness** » Tue Mar 17, 2009 7:49 pm

It may be easier to simply import the table structure.

mysql cacti < rrdclean.sql

TheWitness

bigrat · Post by **bigrat** » Tue Mar 17, 2009 8:26 pm

Hi TheWitness

Thanks for your quick help.

I reinstalled rrdclean many times, I also received those errors.

I couldn't find rrdclean.sql in rrdclean-0.38-1.tar.gz.

Regards.

Bigrat.

Post by **TheWitness** » Tue Mar 17, 2009 10:48 pm

If you installed via plugin mgmt good. Global.php bad.

TheWitness

bigrat · Post by **bigrat** » Tue Mar 17, 2009 11:24 pm

Could you send me the file rrdclean.sql ?

Thanks

Post by **TheWitness** » Wed Mar 18, 2009 6:52 am

How are you installing RRDclean?

TheWitness

Post by **TheWitness** » Wed Mar 18, 2009 6:58 am

I reviewed the code. You have to access the UI at least once and press the rescan button. I will make it a bit more convenient for Gandolf, if he does not feel up to it. In the mean time, just access the UI and you should be all set.

TheWitness

bigrat · Post by **bigrat** » Thu Mar 19, 2009 10:10 pm

I just copied rrdclean to plugins directory, modify global.php.
Then, I click "Install" and "Enable" rrdclean in Plugin Management Tab.
Is there anything wrong when I install rrdclean plugin?

Regards,
Bigrat

Post by **TheWitness** » Fri Mar 20, 2009 4:49 am

1) Do not add rrdclean to global.php
2) Install and Enable
3) Give yourself rights to the plugin
4) Immediately goto the RRDClean Console Pick to create the table.

TheWitness

patas75 · Post by **patas75** » Fri Mar 20, 2009 5:10 pm

It looks like structured rra paths aren't working properly. Here is the output I get in the cacti log when I try to archive an rrd.

03/20/2009 03:05:18 PM - RRDCLEAN: Poller[0] RRDClean has finished 1 items
03/20/2009 03:05:18 PM - RRDCLEAN: Poller[0] 23/219.rrd Error: unable to move to /usr/local/cacti/rra/archive/!
03/20/2009 03:05:18 PM - RRDCLEAN: Poller[0] RRDClean is now running on 1 items

I ran the following query found in rrdmove.php:

SELECT plugin_rrdclean_action.id, plugin_rrdclean_action.name, plugin_rrdclean_action.local_data_id, plugin_rrdclean_action.action FROM plugin_rrdclean_action;
+----+------------+---------------+--------+
| id | name | local_data_id | action |
+----+------------+---------------+--------+
| 1 | 23/219.rrd | 0 | 3 |
+----+------------+---------------+--------+

It appears the it is putting the directory as part of the name. When the script tries to move the file is trying to "rename" 23/219.rrd instead of creating the folder and then moving the rrd file.

Cacti Version - 0.8.7d
Plugin Architecture - 2.4
Poller Type - Cactid v
Server Info - Linux 2.6.27-11-server
Web Server - Apache/2.2.9 (Ubuntu) PHP/5.2.6-2ubuntu4.1 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g
PHP - 5.2.6-2ubuntu4.1
PHP Extensions - zip, xmlwriter, libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, SimpleXML, sockets, soap, SPL, shmop, standard, Reflection, posix, mime_magic, mbstring, json, iconv, hash, gettext, ftp, filter, exif, dom, dba, date, ctype, calendar, bz2, bcmath, zlib, pcre, openssl, xmlreader, apache2handler, gd, ldap, mysql, mysqli, pam_auth, PDO, pdo_mysql, sasl, snmp, xmlrpc, xsl
MySQL - 5.0.67-0ubuntu6
RRDTool - 1.3.6
SNMP - 5.4.1
Plugins
Global Plugin Settings (settings - v0.5)
Host Info (hostinfo - v0.2)
Network Discovery (discovery - v0.8.5)
Network Tools (tools - v0.3)

bigrat · Post by **bigrat** » Fri Mar 20, 2009 8:16 pm

I tried as you talked, but the result is same like that

Post by **TheWitness** » Sun Mar 22, 2009 4:53 pm

bigrat wrote:I tried as you talked, but the result is same like that

You are missing a table, or the table does not exist.

Post by **TheWitness** » Sun Mar 22, 2009 4:55 pm

patas75 wrote:It looks like structured rra paths aren't working properly. Here is the output I get in the cacti log when I try to archive an rrd.

03/20/2009 03:05:18 PM - RRDCLEAN: Poller[0] RRDClean has finished 1 items
03/20/2009 03:05:18 PM - RRDCLEAN: Poller[0] 23/219.rrd Error: unable to move to /usr/local/cacti/rra/archive/!
03/20/2009 03:05:18 PM - RRDCLEAN: Poller[0] RRDClean is now running on 1 items

I ran the following query found in rrdmove.php:

SELECT plugin_rrdclean_action.id, plugin_rrdclean_action.name, plugin_rrdclean_action.local_data_id, plugin_rrdclean_action.action FROM plugin_rrdclean_action;
+----+------------+---------------+--------+
| id | name | local_data_id | action |
+----+------------+---------------+--------+
| 1 | 23/219.rrd | 0 | 3 |
+----+------------+---------------+--------+

It appears the it is putting the directory as part of the name. When the script tries to move the file is trying to "rename" 23/219.rrd instead of creating the folder and then moving the rrd file.

Cacti Version - 0.8.7d
Plugin Architecture - 2.4
Poller Type - Cactid v
Server Info - Linux 2.6.27-11-server
Web Server - Apache/2.2.9 (Ubuntu) PHP/5.2.6-2ubuntu4.1 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g
PHP - 5.2.6-2ubuntu4.1
PHP Extensions - zip, xmlwriter, libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, SimpleXML, sockets, soap, SPL, shmop, standard, Reflection, posix, mime_magic, mbstring, json, iconv, hash, gettext, ftp, filter, exif, dom, dba, date, ctype, calendar, bz2, bcmath, zlib, pcre, openssl, xmlreader, apache2handler, gd, ldap, mysql, mysqli, pam_auth, PDO, pdo_mysql, sasl, snmp, xmlrpc, xsl
MySQL - 5.0.67-0ubuntu6
RRDTool - 1.3.6
SNMP - 5.4.1
Plugins
Global Plugin Settings (settings - v0.5)
Host Info (hostinfo - v0.2)
Network Discovery (discovery - v0.8.5)
Network Tools (tools - v0.3)

Definately a structured paths bug. Can you please open a bug report at http://bugs.cacti.net and provide sufficient detail in the bug report so that we don't have to look here. You can add a reference to this post if you like though.

TheWitness

RRDClean v0.38 - Released

RRDClean v0.38 - Released

Who is online