[prev in list] [next in list] [prev in thread] [next in thread]
List: rrd-users
Subject: Re: [rrd-users] mysql question
From: "Steffan" <mailinglist () tikklik ! nl>
Date: 2017-11-14 8:16:30
Message-ID: 004301d35d20$e06fb430$a14f1c90$ () tikklik ! nl
[Download RAW message or body]
This is a multipart message in MIME format.
[Attachment #2 (multipart/alternative)]
This is a multipart message in MIME format.
Never mind
yum update rrdtool --enablerepo='rpmforge*'
fixed it for me.
thanxs
Van: rrdtool@martin.sperl.org [mailto:rrdtool@martin.sperl.org]
Verzonden: maandag 13 november 2017 17:09
Aan: Steffan <mailinglist@tikklik.nl>
CC: rrd-users@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@tikklik.nl \
<mailto:mailinglist@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@martin.sperl.org> rrdtool@martin.sperl.org [ \
<mailto:rrdtool@martin.sperl.org> mailto:rrdtool@martin.sperl.org]
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan < <mailto:mailinglist@tikklik.nl> mailinglist@tikklik.nl>
CC: <mailto:rrd-users@lists.oetiker.ch> rrd-users@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@tikklik.nl> \
mailinglist@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@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@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@lists.oetiker.ch> rrd-users@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@lists.oetiker.ch> rrd-users@lists.oetiker.ch
<https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users> \
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
[Attachment #5 (text/html)]
<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'>Never \
mind<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'>yum \
update rrdtool --enablerepo='rpmforge*'<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'>fixed \
it for me.<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'>thanxs<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.oe \
tiker.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'>sql \
1.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'>sql \
1.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&nbs \
p; \
&n \
bsp; &nbs \
p; \
\
0.8.3-4.el6 &nb \
sp;   \
; & \
nbsp; \
@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 &n \
bsp; &nbs \
p; \
\
0.8.3-5.1.el6 & \
nbsp; &nb \
sp;   \
; \
_______________________________________________
rrd-users mailing list
rrd-users@lists.oetiker.ch
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic