[rrd-users] Using SQL backend

[Olivier Doucet]

Hello everybody !

I'm trying to use SQL backend for rrdtool graph, as seen here :
http://lists.ee.ethz.ch/p/rrdtool+libdbi.patch

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=
127.0.0.1/dbname=mydb/username=test/password=test//mytable/mydate/bw/customer='me'":bp:AVERAGE
LINE1:value#FF0000:value

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
directory)

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

What is wrong ?

Thank you

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