[rrd-users] mysql question

[Steffan]

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: rrdtool at martin.sperl.org [mailto:rrdtool at martin.sperl.org] 
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan <mailinglist at tikklik.nl>
CC: rrd-users at 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 <mailinglist at tikklik.nl <mailto: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= <http://sql1.tkservers.com/dbname=***/username=***/password=***/RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274> 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= <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 at lists.oetiker.ch> 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/8ec07e4a/attachment.html>