Hi Steffan! If you are using the default rpms of rrdtool then libdbi support may not be compiled in…
check the rrd shared library with ldd if it lists libdbi as a shared library it needs… something like this: ldd /usr/lib64/librrd.so.4 | grep dbi At least standard Centos7 does not come with it enabled. Martin > On 13.11.2017, at 16:17, Steffan <mailingl...@tikklik.nl> wrote: > > Hello, > > Im using the tutorial from > https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html > <https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html> > > including the test database tables etc > > but im getting > > root@61 web]# > DS_BASE="sql//mysql/host=sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274 > > <http://sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274>" > [root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day > --end=+3hours --width=1000 --height=600 "DEF:min=$DS_BASE:min:AVERAGE" > "LINE1:min#FF0000:value" "DEF:avg=$DS_BASE:avg:AVERAGE" > "LINE1:avg#00FF00:average" "DEF:max=$DS_BASE:max:AVERAGE" > "LINE1:max#FF0000:max" "DEF:sigma=$DS_BASE:sigma:AVERAGE" > "CDEF:upper=avg,4,sigma,*,+" "LINE1:upper#0000FF:+4 sigma" > "CDEF:lower=avg,4,sigma,*,-" "LINE1:lower#0000FF:-4 sigma" > ERROR: opening > 'sql//mysql/host=sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=11419429007577892741141942900757789274': > > <http://sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=11419429007577892741141942900757789274':> > No such file or directory > > > -- > -- Tabelstructuur voor tabel `RRDValue` > -- > (`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES > (1141942900757789274, 1510552800, 2345), > (1141942900757789274, 1510563600, 4563461); > > > Installed Packages > libdbi.x86_64 > 0.8.3-4.el6 > @base > libdbi-dbd-mysql.x86_64 > 0.8.3-5.1.el6 > @base > libdbi-devel.x86_64 > 0.8.3-4.el6 > @base > libdbi-drivers.x86_64 > 0.8.3-5.1.el6 > @base > > > any idees where the problem is? > > Thanxs > Steffan > _______________________________________________ > rrd-users mailing list > rrd-users@lists.oetiker.ch <mailto:rrd-users@lists.oetiker.ch> > https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users > <https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users>
_______________________________________________ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
