[rrd-users] Using SQL backend

Olivier Doucet webmaster at ajeux.com
Tue Jan 27 15:09:14 CET 2009

Hello everybody !

I'm trying to use SQL backend for rrdtool graph, as seen here :

I recompiled latest rrdtool (from trunk: RRDtool 1.3.99909012700) with
libDBI support, which is confirmed when configure is done :
           With libDBI: yes
            Libraries: -lxml2 -lcairo -lcairo -lcairo -lm  -ldbi -ldl
-lcairo -lfreetype -lfontconfig -lpng12 -lz -lm -lpixman-1   -lglib-2.0
-lpangocairo-1.0 -lpango-1.0 -lcairo -lgobject-2.0 -lgmodule-2.0 -lglib-2.0
-lfreetype -lfontconfig -lpng12 -lz -lm -lpixman-1

Then I tried to do a basic graph with following command line :
/usr/bin/rrdtool graph - --units=si -l 0 -i -R light --width 600 --height
600 --full-size-mode DEF:value="sql//mysql/host='me'":bp:AVERAGE

But I get error :
ERROR: opening 'sql//mysql/********: No such file or directory
(without the ***)

With a strace :
open("sql//mysql/********", O_RDONLY) = -1 ENOENT (No such file or

So it seems my syntax is incorrect and is interpreted as a file.

What is wrong ?

Thank you

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20090127/2f43339e/attachment.html 

More information about the rrd-users mailing list