Help on a script-addon...

[yid]

I'm writing a script to add datasources, rras, graphs, and graph_items via command line, so that I can automate some of my graph creation.

In working on the graph_item portion, I found that the "TextFormat" field is a binary object. What is that? If I don't specify anything, will the graph_items get created?

Let me know,
yid

[raX]

I wasn't quite sure, but I double checked and it sure is a binary object. Not sure what I was thinking when created that table, but I see no reason why you could not convert it to a CHAR(255) field or whatnot.

Try executing this and see what happens:

Code: Select all

ALTER TABLE `rrd_graph_item` CHANGE `TextFormat` `TextFormat` CHAR( 255 ) DEFAULT NULL;

-Ian

[yid]

Once I figured out what was actually in that field, I tried inserting text into it (today actually), and it worked without even converting it.

Maybe on a later release you could just convert it to a char field, but its not a big deal regardless.

Thanks,
Aaron