graphs dont show up

[Guest]

I installed Cacti on a mandrake linux 8.0 rrdtool 1.0.33, php 4.0.4pl1, mysql 3.23.36.I read all the documentation provided with the tarball and I have a very big problem.The graph function is not working properly - no graphics generated.The rra database is updating properly, everything is the way it should be.I worked before with rrdtool (bash scripts to plot snmp variables ) and I know how rrdtool works.Yet my php skills suck and i need your advice.If i try to look at the source (below the graph, there is no graphical function of rrd (area,line,etc).There also is a warning there : Warning: Supplied argument is not a valid MySQL result resource in include/rrd_functions.php on line 224.

[Guest]

have you run the sql script? seems that you've got a problem with mysql

On 2002-02-14 07:14, Anonymous wrote:
I installed Cacti on a mandrake linux 8.0 rrdtool 1.0.33, php 4.0.4pl1, mysql 3.23.36.I read all the documentation provided with the tarball and I have a very big problem.The graph function is not working properly - no graphics generated.The rra database is updating properly, everything is the way it should be.I worked before with rrdtool (bash scripts to plot snmp variables ) and I know how rrdtool works.Yet my php skills suck and i need your advice.If i try to look at the source (below the graph, there is no graphical function of rrd (area,line,etc).There also is a warning there : Warning: Supplied argument is not a valid MySQL result resource in include/rrd_functions.php on line 224.

[Guest]

No.The sql script was installed as described in the docs.No error there.Any other idea?

[raX]

Try and download this patch:

http://www.raxnet.net/downloads/patches ... ns.php.txt

Replace your current 'rrd_functions.php' and cacti should print out the SQL that is failing. Go ahead and paste that here, and we'll see what is wrong.

-Ian

[Guest]

I replaced the file
This is the output:
select i.id as iid, i.cdefid, i.textformat, i.value, i.hardreturn, i.consolidationfunction, c.hex, d.dsname, d.name as dname, d.id, cf.name as cname, t.name as tname from rrd_graph_item i left join rrd_ds d on i.dsid=d.id left join def_colors c on i.colorid=c.id left join def_graph_type t on i.graphtypeid=t.id left join def_cf cf on i.consolidationfunction=cf.id where i.graphid=53 and !(cf.id != 1 and (t.name="LINE1" or t.name="AREA" or t.name="STACK" or t.name="LINE2" or t.name="LINE3")) order by i.sequence

[raX]

This is quite odd since you are running the same version of MySQL than me and this query runs fine. What happens if you execute this query manually?

-Ian

[Guest]

I found out that the exported TMPDIR was set to /root/tmp/ fixed now
ERROR 1: Can't create/write to file '/root/tmp/#sql57c3_565_0.MYI' (Errcode: 13)

I replaced the rrd_functions.php with the original one and now it works.
Thanks a lot for the help.
And btw, great tool.