No alternative to get the sql data in a image? I cant use rrd files the data is changed sometimes from the source so
The sql data is altered Van: rrdt...@martin.sperl.org [mailto:rrdt...@martin.sperl.org] Verzonden: maandag 13 november 2017 17:09 Aan: Steffan <mailingl...@tikklik.nl> CC: rrd-users@lists.oetiker.ch Onderwerp: Re: [rrd-users] mysql question Yes, that means that you have to compile it yourself from sources… If you want to avoid building all the dependencies that are required with the latest and greatest release of rrdtool, then try and take that exact same version from source that the rpm is providing - then all dependencies should (hopefully) be fullfilled… If you want the latest and greatest, then I believe that there are also some scripts that do handle all those dependency installations for you - can not remember what it is called... Martin On 13.11.2017, at 17:00, Steffan <mailingl...@tikklik.nl <mailto:mailingl...@tikklik.nl> > wrote: 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: <mailto:rrdt...@martin.sperl.org> rrdt...@martin.sperl.org [ <mailto:rrdt...@martin.sperl.org> mailto:rrdt...@martin.sperl.org] Verzonden: maandag 13 november 2017 16:51 Aan: Steffan < <mailto:mailingl...@tikklik.nl> mailingl...@tikklik.nl> CC: <mailto:rrd-users@lists.oetiker.ch> 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 < <mailto:mailingl...@tikklik.nl> 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 <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
