Graph Export works only for hosts?

srhuston · Post by **srhuston** » Fri Mar 02, 2007 8:50 pm

Instead of having my graphs all lumped under a host, I wanted to separate them out and make them a little nicer (I don't need to see disk stats every time I look at the host's page). However, all the graphs that I setup do not show up at all when exported - only within the cacti view interface.

03/02/2007 08:45:16 PM - EXPORT STATS: ExportDate:2007-03-02_20:45:16 ExportDuration:12.9294 TotalGraphsExported:0

If I put a host entry in there, then the number of exported graphs goes up to 80, and the graphs show up under the host but still not in the tree.

See http://www.srhuston.net/cacti to see what it ends up looking like - though right now it's saying there's 80 graphs exported, and nothing viewable anyway.

I only saw one other person mention this on the forums here, but no solution mentioned. I'm running 0.8.6i from Fedora, though in a desperate attempt at fixing this I even copied the 'lib' directory from 6j over top of the one from 6i. No, it didn't work

Post by **TheWitness** » Fri Mar 02, 2007 9:39 pm

What is the effective user for the export and does that user have access to graphs/hosts? Give me a screen shot of the export settings and the effective user graph settings as well as the tree in question.

TheWitness

srhuston · Post by **srhuston** » Fri Mar 02, 2007 11:16 pm

I've tried it with the effective user of admin, and as guest, with no difference.

Export settings: http://www.srhuston.net/junkpile/export-options.png
Tree: http://www.srhuston.net/junkpile/tree-view.png

I wouldn't think the user graph settings for admin would be restrictive, but here they are anyway: http://www.srhuston.net/junkpile/admin- ... ttings.png

Thanks for your help!

Post by **TheWitness** » Sat Mar 03, 2007 10:34 am

Try it once without FTP and let's see what happens. I am thinking that this was never tested.

There, that was four steps of the seven in dealing with loss. Thank goodness it was quick

I might have ended up depressed or something.

But in all seriousness, if that makes a difference, then I can make a patch.

TheWitness

srhuston · Post by **srhuston** » Sat Mar 03, 2007 11:22 am

Well, I hope you're ready to go through all four again.. 'cause I did try it writing to /tmp as a local export before, and no dice. Still didn't create all the graphs as it should have. Just tried it again to make sure

A friend of mine (who got me hooked on cacti, and groks SQL more than I probably ever will) sees the same problem, and thought it was in the $sql_where clause; he did some tests and got that statement to return things (as it was it returned zero lines), and thought he had the problem figured out. But the closest he got was to have it export graphs, and still not actually change the HTML pages to link to them. He thinks it might be related to the security patches that were applied in 'i' I think? But neither of us has tried downloading an older version and either running it or diffing to try to see the problem.

Post by **TheWitness** » Sat Mar 03, 2007 11:23 am

Dump you DB and e-mail to me. I am working on Cacti at this moment.

TheWitness

Post by **TheWitness** » Sat Mar 03, 2007 11:56 am

Ok, I confirmed the behavior. It's likely something stupid. This section of code is difficult

TheWitness

srhuston · Post by **srhuston** » Sat Mar 03, 2007 11:59 am

The comment from my friend this morning:

<torn_> < $sql_where = "AND !(user_auth_perms.user_id IS NOT NULL AND graph_tree_items.host_id > 0)";
<torn_> ---
<torn_> > $sql_where = "AND !(user_auth_perms.user_id IS NOT NULL)";
<torn_> A bunch of those fixed the graph exporting problem (but who knows if it created and security problems)

But as I mentioned, that only exported the graphs, didn't create the HTML that links the index to them (all the pages you could get to from the index still didn't mention the graphs anywhere, they were just there now - he confirmed this by removing his host graphs from the tree, and they were still being exported when these changes were made).

Hope that helps

Post by **TheWitness** » Sat Mar 03, 2007 12:18 pm

Yea, that code fragment was intended to be used when creating the graph tree and host graphs. If the host_id is not > 0, then it's not a host. What I don't understand was how was this working before

Oh well...

Post by **TheWitness** » Sat Mar 03, 2007 1:02 pm

Tracked it down. Regression testing in progress.

TheWitness

Post by **TheWitness** » Sat Mar 03, 2007 1:13 pm

Use this graph_export.php. Please verify all your graphs are created.

Larry

srhuston · Post by **srhuston** » Sat Mar 03, 2007 1:27 pm

Well, the HTML pages were changed, because they now show the graphs. But it's not updating them any more. I removed the "host" graph from the tree so I'd know looking at the page that it was updated, but the graph pages still show it - the tree pages show it gone as it should be. Export log message also says zero graphs exported (and with a runtime of 12s, I believe it).

Getting there though :>

Post by **TheWitness** » Sat Mar 03, 2007 1:47 pm

Right, I kindof expected that. One more pass in about 10 minutes.

TheWitness

Post by **TheWitness** » Sat Mar 03, 2007 1:55 pm

Here you go..

TheWitness

srhuston · Post by **srhuston** » Sat Mar 03, 2007 2:09 pm

Okay, that's got the graphs updating it seems. But the other issue - showing all the graphs on all the pages - still exists too. You can see it at http://www.srhuston.net/cacti ; the "Disk space" graphs should only be on the "Disk Statistics" leaf.

Graph Export works only for hosts?

Graph Export works only for hosts?

Who is online