[rrd-users] mysql question

[Steffan]

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: rrdtool at martin.sperl.org [mailto:rrdtool at martin.sperl.org] 
Verzonden: maandag 13 november 2017 17:09
Aan: Steffan <mailinglist at tikklik.nl>
CC: rrd-users at 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 <mailinglist at tikklik.nl <mailto:mailinglist at 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:rrdtool at martin.sperl.org> rrdtool at martin.sperl.org [ <mailto:rrdtool at martin.sperl.org> mailto:rrdtool at martin.sperl.org] 
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan < <mailto:mailinglist at tikklik.nl> mailinglist at tikklik.nl>
CC:  <mailto:rrd-users at lists.oetiker.ch> 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 < <mailto:mailinglist at tikklik.nl> 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

 

_______________________________________________
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/20171114/8380d6b0/attachment-0001.html>