[rrd-users] mysql question

[rrdtool at martin.sperl.org]

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> 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: rrdtool at martin.sperl.org <mailto: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 <mailinglist at tikklik.nl <mailto:mailinglist at tikklik.nl>>
> CC: rrd-users at lists.oetiker.ch <mailto: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=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>
>  
> _______________________________________________
> 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/cc330794/attachment-0001.html>