Breaking the Order Key into 2 Entries

Anything that you think should be in Cacti.

Moderators: Developers, Moderators

Post Reply
marnues
Posts: 40
Joined: Fri Mar 02, 2007 4:33 pm

Breaking the Order Key into 2 Entries

Post by marnues »

Hi

The order key has been bugging me for quite some time.
I'm not sure why this method was chosen, but I would like to request that the key be broken into 2 separate DB entries, one for the Parent' ID and the other for ordering under the parent's header.
Maybe there's some reason to have the order key that I'm not seeing, but it seems that splitting it is a much more logical and user-friendly method.

Quick background, I have a script that's suppose to be inserting a lot of devices into cacti.
I am doing most of the work through http so as not to mess with Cacti's internals, but attaching graphs to the tree has proven to be quite the bottleneck, so I've taken on interfacing directly with the DB on this one.
However, the order key is making things quite difficult for me as I have to organize every node below a parent, and not just its children.

So, this would be a huge time saver, and I think it would make your DB smaller and more organized.
marnues
Posts: 40
Joined: Fri Mar 02, 2007 4:33 pm

Post by marnues »

Is this a touchy subject?
I'm seriously confused why the graph_tree_items table doesn't use pointers
it would save both you and me a lot of work
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

marnues,

Us, the people who "develop" Cacti, enherited some things and that was one of them. It's a PITA, and will remain that way for a while. We are looking at getting more developers online in the months to come. This, as many other things will be a topic of discussion.

Also, there are some very excellent automation tools that will be in the next point release of Cacti and are available for download today, just not officially supported. I have personall used them to install several hundred hosts and several thousand graphs in less than an hour already.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
marnues
Posts: 40
Joined: Fri Mar 02, 2007 4:33 pm

Post by marnues »

are they all plugins?
seems like we should probably get on the plugin bandwagon
it's a shame we're working with "production boxes" otherwise I'd work on that right now

also, I might be interested in contributing to Cacti
when I have some time I'll have to look into signing up
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

They are scripts that do not modify even a line of Cacti code. Search for them in the Add-On's section.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests