[rrd-users] mysql question

[rrdtool at martin.sperl.org]

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>