Hello everybody !<br><br>I'm trying to use SQL backend for rrdtool graph, as seen here :<br><a href="http://lists.ee.ethz.ch/p/rrdtool+libdbi.patch">http://lists.ee.ethz.ch/p/rrdtool+libdbi.patch</a><br><br>I recompiled latest rrdtool (from trunk: RRDtool 1.3.99909012700) with libDBI support, which is confirmed when configure is done : <br>
With libDBI: yes<br> 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<br>
<br>Then I tried to do a basic graph with following command line : <br>/usr/bin/rrdtool graph - --units=si -l 0 -i -R light --width 600 --height 600 --full-size-mode DEF:value="sql//mysql/host=<a href="http://127.0.0.1/dbname=mydb/username=test/password=test//mytable/mydate/bw/customer='me">127.0.0.1/dbname=mydb/username=test/password=test//mytable/mydate/bw/customer='me</a>'":bp:AVERAGE LINE1:value#FF0000:value<br>
<br>But I get error : <br>ERROR: opening 'sql//mysql/********: No such file or directory <br>(without the ***)<br><br>With a strace : <br>[...]<br>open("sql//mysql/********", O_RDONLY) = -1 ENOENT (No such file or directory)<br>
<br>So it seems my syntax is incorrect and is interpreted as a file. <br><br>What is wrong ?<br><br>Thank you <br><br>Olivier<br><br><br>