new install, many problems

[iwasinnamuknow]

I've used cacti on and off for years now but this is the biggest problem I've had and I can't work it out.

Just installed a fresh cacti app onto a gentoo server. mysql is sitting on a solaris box.

When I try to create graphs it doesn't create the rra's and I'm having to create them manually (permissions are fine for the webserver).

Even when I create the rra's, I'm unable to select the data sources in the graph management, I just get "none" as my only option in the drop down list.

I'm also getting this error littered through my logs:

07/05/2008 02:52:58 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1271', SQL:"select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=1 order by name"

In short, I'm not getting anything out of cacti, i have tried everything I can think of but no graphs are showing any data.

Thanks in advance.

Matt

[Howie]

When I try to create graphs it doesn't create the rra's and I'm having to create them manually (permissions are fine for the webserver).

It's the poller that needs to be able to write to that directory, not the webserver. Possibly that would explain why rrds are not created, and then not updated either.

For the SQL error, try pasting that SQL into the mysql command-line tool, and see what error *it* gives - should be more than just "failed". Might give you some clue.

[iwasinnamuknow]

Ok I've got things graphing now, it was an issue with the account running the poller. RRAs are now being create automatically and data is appearing in the graphs.

Another problem, when I try to change the colour on any of the graph items, FF gets appended to the 6 character hex string and rrd chokes on this.

For example, I use the drop down box to select a colour, say 4444ff. When I save this it becomes 4444ffff and i get this in the debug info:

ERROR: parameter '#4444FFFF' does not represent a number in line AREA:#4444FFFF:CPU Utilization

No matter which colour I select, It always adds FF on the end and thus breaks my graph. I've been going through the database for an hour trying to find where to restore (or manually change) the colours so the graphs work again but to no avail so far.

[Howie]

Ok I've got things graphing now, it was an issue with the account running the poller. RRAs are now being create automatically and data is appearing in the graphs.

Another problem, when I try to change the colour on any of the graph items, FF gets appended to the 6 character hex string and rrd chokes on this.

For example, I use the drop down box to select a colour, say 4444ff. When I save this it becomes 4444ffff and i get this in the debug info:

ERROR: parameter '#4444FFFF' does not represent a number in line AREA:#4444FFFF:CPU Utilization

No matter which colour I select, It always adds FF on the end and thus breaks my graph. I've been going through the database for an hour trying to find where to restore (or manually change) the colours so the graphs work again but to no avail so far.

Does your rrdtool version match the one in the Cacti settings? Those extra digits are Alpha (transparency) values, which aren't supported in rrdtool 1.0.x if I remember correctly.

[iwasinnamuknow]

I thought it might be to do with the alpha. Well I'm using rrdtool-1.2.27 and cacti is set to 1.2.x

I've used alpha in the past with cacti ages ago, and i didn't run into problems like this.

[iwasinnamuknow]

Just to get my graph working again, can anyone tell me where in the db i can change the colour/alpha back to its original value?

I'll stop playing with things until i can sort out the problem itself, but if i can just fix that graph it'll keep me working for now

[gandalf]

Not sure if this matches, but in CHANGELOG for upcoming 087c, there's a line saying

-bug: drop color setting background on FF does not work

.
The alpha setting is a column in table graph_item_inputs, if you'd like to do a mass change
Reinhard