<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.E-mailStijl18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=NL link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>No alternative to get the sql data in a image?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I cant use rrd files the data is changed sometimes from the source so <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>The sql data is altered <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Van:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> rrdtool@martin.sperl.org [mailto:rrdtool@martin.sperl.org] <br><b>Verzonden:</b> maandag 13 november 2017 17:09<br><b>Aan:</b> Steffan <mailinglist@tikklik.nl><br><b>CC:</b> rrd-users@lists.oetiker.ch<br><b>Onderwerp:</b> Re: [rrd-users] mysql question<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Yes, that means that you have to compile it yourself from sources…<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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…<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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...<o:p></o:p></p></div><div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Martin<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>On 13.11.2017, at 17:00, Steffan <<a href="mailto:mailinglist@tikklik.nl">mailinglist@tikklik.nl</a>> wrote:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>What i meen is that<span class=apple-converted-space> </span></span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>ldd /usr/lib64/librrd.so.4 | grep dbi</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>outputs nothing</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Its centos 6</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>And your right</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>ldd /usr/lib64/librrd.so.4 | grep dbi</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I installed it with yum<span class=apple-converted-space> </span></span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So I need do a manual install?</span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Van:</span></b><span class=apple-converted-space><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'><a href="mailto:rrdtool@martin.sperl.org"><span style='color:purple'>rrdtool@martin.sperl.org</span></a><span class=apple-converted-space> </span>[<a href="mailto:rrdtool@martin.sperl.org"><span style='color:purple'>mailto:rrdtool@martin.sperl.org</span></a>]<span class=apple-converted-space> </span><br><b>Verzonden:</b><span class=apple-converted-space> </span>maandag 13 november 2017 16:51<br><b>Aan:</b><span class=apple-converted-space> </span>Steffan <<a href="mailto:mailinglist@tikklik.nl"><span style='color:purple'>mailinglist@tikklik.nl</span></a>><br><b>CC:</b><span class=apple-converted-space> </span><a href="mailto:rrd-users@lists.oetiker.ch"><span style='color:purple'>rrd-users@lists.oetiker.ch</span></a><br><b>Onderwerp:</b><span class=apple-converted-space> </span>Re: [rrd-users] mysql question</span><o:p></o:p></p></div></div></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><div><p class=MsoNormal>Hi Steffan!<o:p></o:p></p></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><p class=MsoNormal>If you are using the default rpms of rrdtool then libdbi support may not be compiled in…<o:p></o:p></p></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal>check the rrd shared library with ldd if it lists libdbi as a shared library it needs…<o:p></o:p></p></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal>something like this:<o:p></o:p></p></div></div><div><div><p class=MsoNormal>ldd /usr/lib64/librrd.so.4 | grep dbi<o:p></o:p></p></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal>At least standard Centos7 does not come with it enabled.<o:p></o:p></p></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal>Martin<o:p></o:p></p></div></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal>On 13.11.2017, at 16:17, Steffan <<a href="mailto:mailinglist@tikklik.nl"><span style='color:purple'>mailinglist@tikklik.nl</span></a>> wrote:<o:p></o:p></p></div></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Hello,</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Im using the tutorial from</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><a href="https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#954F72'>https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html</span></a><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>including the test database tables etc</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>but im getting</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>root@61 web]# DS_BASE="sql//mysql/host=</span><a href="http://sql1.tkservers.com/dbname=***/username=***/password=***/RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#954F72'>sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>"</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>[root@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"</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>ERROR: opening 'sql//mysql/host=</span><a href="http://sql1.tkservers.com/dbname=***/username=***/password=***/RRDValue/UnixTimeStamp/value/RRDKeyID=11419429007577892741141942900757789274':"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#954F72'>sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=11419429007577892741141942900757789274':</span></a><span class=apple-converted-space><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>No such file or directory</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>--</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>-- Tabelstructuur voor tabel `RRDValue`</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>--</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>(1141942900757789274, 1510552800, 2345),</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>(1141942900757789274, 1510563600, 4563461);</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Installed Packages</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi.x86_64 0.8.3-4.el6 @base</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi-dbd-mysql.x86_64 0.8.3-5.1.el6 @base</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi-devel.x86_64 0.8.3-4.el6 @base</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi-drivers.x86_64 0.8.3-5.1.el6 @base</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>any idees where the problem is?</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Thanxs<br>Steffan</span><o:p></o:p></p></div></div><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif'>_______________________________________________<br>rrd-users mailing list<br></span><a href="mailto:rrd-users@lists.oetiker.ch"><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#954F72'>rrd-users@lists.oetiker.ch</span></a><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif'><br></span><a href="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users"><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#954F72'>https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</span></a><o:p></o:p></p></div></div></blockquote></div><div><p class=MsoNormal> <o:p></o:p></p></div></div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif'>_______________________________________________<br>rrd-users mailing list<br></span><a href="mailto:rrd-users@lists.oetiker.ch"><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:purple'>rrd-users@lists.oetiker.ch</span></a><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif'><br></span><a href="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users"><span style='font-size:9.0pt;font-family:"Helvetica",sans-serif;color:purple'>https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</span></a><o:p></o:p></p></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></body></html>