Patch: "Structured RRD Path"

[browniebraun]

Reminder:

This patch is only for cacti 0.8.6h !!!

I'm just working on my degree dissertation, so please be patient with me.

If somebody of you needs an upgrade, I'll have to check it with Cacti 0.8.6i at the end of november.

Until then i'll have no time. Sorry


Best regards
-Andreas-

[fconza]

no update ?

thinks for the work.

[oxo-oxo]

Continue, at your displeasure, to SVN thread @ http://forums.cacti.net/viewtopic.php?t=23146

[TheWitness]

This has been committed to SVN today. Beta was so late, and it was heavily requested at the European conference. I have a little extra juice in the engine and gave it a try.

The approach was different, it works for Windoz, UNIX, and Linux. In addition, you can do everything from the command line:

Code: Select all

cd /var/www/html/cacti/cli
php -q structure_rra_path.php --proceed

The help is pretty self explanitory:

Code: Select all

Structured RRA Paths Utility, Copyright 2008 - The Cacti Group

A simple command line utility that converts a Cacti system from using
legacy RRA paths to using structured RRA paths with the following
naming convention: <path_rra>/host_id/local_data_id.rrd

This utility is designed for very large Cacti systems.

The utility follows the process below:
  1) Disables the Cacti Poller
  2) Checks for a Running Poller.

If it Finds a Running Poller, it will:
  1) Re-enable the Poller
  2) Exit

Else, it will:
  1) Enable Structured Paths in the Console (Settings->Paths)

Then, for Each File, it will:
  1) Create the Structured Path, if Necessary
  2) Copy the File to the Strucured Path Using the New Name
  3) Alter the two Database Tables Required
  4) Remove the Old File

Once all Files are Complete, it will
  1) Re-enable the Cacti Poller

If the utility encounters a problem along the way, it will:
  1) Re-enable the poller
  2) Exit

usage: structure_rra_paths.php --proceed [--help | -H | --version | -V]

The "--proceed" option is required.

Regards,

TheWitness

[browniebraun]

Hi Larry!

I read your posting and I'm happy to see that this topic makes progress. So I've just taken a look into your code . From my point of view ( ... and without testing it) I would say that Windows servers could have issues with it at the point where the script checks if the poller is running.
I would expect something like

Code: Select all

shell_exec("wmic process where \"commandline like '%poller.php'\" get threadcount").

Best regards
-Andreas-

[TheWitness]

Andreas,

Please check my commit from just a few minutes ago. I have tested this on Windows and it works flawlessly now (after a few more mods )

Larry

[TheWitness]

Oh, sorry, was in too much of a hurry to get out on the road to work. You are correct. I will take a look at that later tonight.

Larry

[browniebraun]

Mmmh ... I would have expected that "shell_exec("ps -ef | grep poller.php | wc -l");" would not work on Windows.
Maybe I'm too tired as a result of the last conference.

Best regards
-Andreas-

[browniebraun]

Mmmh ... I would have expected that "shell_exec("ps -ef | grep poller.php | wc -l");" would not work on Windows.
Maybe I'm too tired as a result of the last conference.

Best regards
-Andreas-

I think we both have to work on our timing.

[Jesper]

Hi all,

Does the included structure_rra_paths.php script from Cacti 0.8.7c work on Windows? Thank you,

/Jesper

[TheWitness]

Yes, but disable your poller while doing it.

[gundalba]

Just ran the
"php -q structure_rra_paths.php --proceed"
which renamed all my rrd files and moved them to new structured folder.

Though the poller is trying to create new rrd files in the old location and graph display is still pointing there as well.
Thus giving me back the blank graphs...

Help?

Thanks

-- this is what I got on CentOS5 --
Installed Packages
Name : cacti
Arch : noarch
Version: 0.8.7c
Release: 1.el5.rf

[gundalba]

Ummm.... Anybody???

[TheWitness]

Did you enable first from the Cacti UI? Also, did the script return any errors about the poller cache or other issues? When you ran the script, was the poller cache correct?

TheWitness

[gundalba]

Did you enable first from the Cacti UI?

No. I did that after I ran the script.

Also, did the script return any errors about the poller cache or other issues?

Script message went by fast and I did not save the output so I am not too sure. Though I did not notice any messages that looked serious while I was running the script.

When you ran the script, was the poller cache correct?
...

Sorry, no idea. Anyway I can check this now?

Thanks,