What i meen is that ldd /usr/lib64/librrd.so.4 | grep dbi
outputs nothing Its centos 6 And your right ldd /usr/lib64/librrd.so.4 | grep dbi I installed it with yum So I need do a manual install? Van: rrdt...@martin.sperl.org <mailto:rrdt...@martin.sperl.org> [mailto:rrdt...@martin.sperl.org] Verzonden: maandag 13 november 2017 16:51 Aan: Steffan <mailingl...@tikklik.nl <mailto:mailingl...@tikklik.nl> > CC: rrd-users@lists.oetiker.ch <mailto:rrd-users@lists.oetiker.ch> Onderwerp: Re: [rrd-users] mysql question 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 <mailto: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= <http://sql1.tkservers.com/dbname=***/username=***/password=***/RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274> 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= <http://sql1.tkservers.com/dbname=***/username=***/password=***/RRDValue/UnixTimeStamp/value/RRDKeyID=11419429007577892741141942900757789274':> 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 <mailto:rrd-users@lists.oetiker.ch> 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
