Colors: opacity using optional alpha in rrdtool

Mikf · Joined: 13 Aug 2004 Posts: 36 Location: Paris, France

hi!

I have search in the forum, if there is a project for using the alpha optional component of the color attribut. But i found nothing usable...
And i didn't read anything on this subject in the roadmap

So, here is my work on the subject.

I have appended a field name 'alpha' in the 'graph_templates_item ' table :

mysql command to append the field:
#alter table graph_templates_item add alpha varchar(2) default "FF";

the code is in the patch file attached.

to use with rrdtool 1.2.x

EDIT 24/oct/2007 : added patch for cacti 0.8.7 with plugin arch

fmangeant · Posted: Tue Oct 23, 2007 4:37 am Post subject:

Very nice, thanks !

cigamit · Posted: Tue Oct 23, 2007 5:04 pm Post subject:

Nice patch, testing it on my production box now.

Mikf · Joined: 13 Aug 2004 Posts: 36 Location: Paris, France

added patch for cacti 0.8.7 with plugin arch

jay · Posted: Tue Oct 30, 2007 7:11 am Post subject:

Hi

I have applied the patch but I'm unable to get this working as my graphs disappear.

I downloaded the win32 GNU version of Patch and did the following:-

C:\Apache2\htdocs\cacti>patch -p1 -N < alpha_colors_201.patch
patching file graphs_items.php
patching file graph_templates_items.php
patching file include/config_arrays.php
patching file include/config_form.php
patching file lib/rrd.php
Hunk #1 succeeded at 557 (offset 2 lines).
patch unexpectedly ends in middle of line
Hunk #2 succeeded at 1103 with fuzz 1 (offset 8 lines).

I then downloaded the patch again and turned off word wrap within notepad in case that was causing and problem and re-applied.

C:\Apache2\htdocs\cacti>
C:\Apache2\htdocs\cacti>patch -p1 -N < alpha_colors.patch
The system cannot find the file specified.

C:\Apache2\htdocs\cacti>patch -p1 -N < alpha-colors.patch
patching file graphs_items.php
Reversed (or previously applied) patch detected! Skipping patch.
1 out of 1 hunk ignored -- saving rejects to file graphs_items.php.rej
patching file graph_templates_items.php
Reversed (or previously applied) patch detected! Skipping patch.
1 out of 1 hunk ignored -- saving rejects to file graph_templates_items.php.rej
patching file include/config_arrays.php
Reversed (or previously applied) patch detected! Skipping patch.
1 out of 1 hunk ignored -- saving rejects to file include/config_arrays.php.rej
patching file include/config_form.php
Reversed (or previously applied) patch detected! Skipping patch.
1 out of 1 hunk ignored -- saving rejects to file include/config_form.php.rej
patching file lib/rrd.php
Reversed (or previously applied) patch detected! Skipping patch.
patch unexpectedly ends in middle of line
2 out of 2 hunks ignored -- saving rejects to file lib/rrd.php.rej

When I went to check my graphs they had weren't there

( I had a look through the logs and saw the following:-

10/30/2007 11:38:07 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=371 order by graph_templates_item.sequence"

Also when I looked at a graph template and looked at one of the items I saw the following:-

Notice: Undefined index: alpha in C:\Apache2\htdocs\cacti\graph_templates_items.php on line 335

I don't use the plugin arch. The only modification I have done to Cacti is to the colours.

http://forums.cacti.net/viewtopic.php?t=6308&highlight=colors

Any ideas???

Jay

streaker69 · Posted: Tue Oct 30, 2007 7:35 am Post subject:

Very cool addon. Worked perfectly!

Mikf · Joined: 13 Aug 2004 Posts: 36 Location: Paris, France

Jay : do you have done this :
alter table graph_templates_item add alpha varchar(2) default "FF";
on your cacti database ?

jay · Posted: Tue Oct 30, 2007 7:43 am Post subject:

aaaaah..that might be the problem as I didn't run this command within the database. I will try this now and get back to you.

Thanks for the quick response.

Jay

jay · Posted: Tue Oct 30, 2007 8:55 am Post subject:

Hi

That's works like a charm now

) . Thanks for your assistance.

How do you get your graphs to look like the one you have shown?? I like the way you have drawn a line over the coloured area to define the graphs better. I have tried this and I can get the line drawn over the area but it shows both of the colours under the graphs as shown in my screenshots. I would like it so that it just shows one of the colours within the legend as yours does.

Jay

chrisgapske · Posted: Tue Oct 30, 2007 9:14 am Post subject: This is really nice.

I hope the devolipers add this to the base code it is a great and simple option.

I don't want to loose it when I upgrade to 0.8.8/0.9.0.

Mikf · Joined: 13 Aug 2004 Posts: 36 Location: Paris, France

Jay: the screen of the items i used

gandalf · Posted: Thu Nov 08, 2007 5:36 am Post subject: Re: This is really nice.

chrisgapske · Posted: Thu Nov 08, 2007 8:59 am Post subject:

That is great to hear.

Thanks as always.

fmangeant · Posted: Mon Nov 19, 2007 9:51 am Post subject:

For those who haven't upgraded to Cacti 0.8.7a, this nice patch has been added to the Cacti core

TFC · Posted: Thu Nov 13, 2008 9:57 am Post subject: