[rrd-users] mysql question

rrdtool at martin.sperl.org rrdtool at martin.sperl.org
Mon Nov 13 16:51:03 CET 2017


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 <mailinglist at 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 at 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 at 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 at lists.oetiker.ch <mailto:rrd-users at lists.oetiker.ch>
> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users <https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.oetiker.ch/pipermail/rrd-users/attachments/20171113/668ffd67/attachment-0001.html>


More information about the rrd-users mailing list