Re: mysql question
"Steffan" <[email protected]> Mon, 13 Nov 2017 16:55:24 +0100
| Newsgroups | gmane.comp.db.rrdtool.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multipart message in MIME format. --===============4286852665630647908== Content-Type: multipart/alternative; boundary="----=_NextPart_000_026C_01D35CA0.333C9F10" Content-Language: nl This is a multipart message in MIME format. ------=_NextPart_000_026C_01D35CA0.333C9F10 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Its centos 6 And your right ldd /usr/lib64/librrd.so.4 | grep dbi =20 I installed it with yum=20 So I need do a manual install? =20 =20 Van: [email protected] [mailto:[email protected]]=20 Verzonden: maandag 13 november 2017 16:51 Aan: Steffan <[email protected]> CC: [email protected] Onderwerp: Re: [rrd-users] mysql question =20 Hi Steffan! =20 If you are using the default rpms of rrdtool then libdbi support may not = be compiled in=E2=80=A6 =20 check the rrd shared library with ldd if it lists libdbi as a shared = library it needs=E2=80=A6 =20 something like this: ldd /usr/lib64/librrd.so.4 | grep dbi =20 At least standard Centos7 does not come with it enabled. =20 Martin =20 On 13.11.2017, at 16:17, Steffan <[email protected] = <mailto:[email protected]> > wrote: =20 Hello, =20 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 =20 including the test database tables etc =20 but im getting =20 root@61 web]# DS_BASE=3D"sql//mysql/host=3D = <http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***/RRD= Value/UnixTimeStamp/value/RRDKeyID=3D1141942900757789274> = sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//RRDValue/U= nixTimeStamp/value/RRDKeyID=3D1141942900757789274" [root@61 web]# rrdtool graph test.png --imgformat=3DPNG --start=3D-1day = --end=3D+3hours --width=3D1000 --height=3D600 = "DEF:min=3D$DS_BASE:min:AVERAGE" "LINE1:min#FF0000:value" = "DEF:avg=3D$DS_BASE:avg:AVERAGE" "LINE1:avg#00FF00:average" = "DEF:max=3D$DS_BASE:max:AVERAGE" "LINE1:max#FF0000:max" = "DEF:sigma=3D$DS_BASE:sigma:AVERAGE" "CDEF:upper=3Davg,4,sigma,*,+" = "LINE1:upper#0000FF:+4 sigma" "CDEF:lower=3Davg,4,sigma,*,-" = "LINE1:lower#0000FF:-4 sigma" ERROR: opening 'sql//mysql/host=3D = <http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***/RRD= Value/UnixTimeStamp/value/RRDKeyID=3D114194290075778927411419429007577892= 74':> = sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//RRDValue/U= nixTimeStamp/value/RRDKeyID=3D11419429007577892741141942900757789274': = No such file or directory =20 =20 -- -- Tabelstructuur voor tabel `RRDValue` -- (`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES (1141942900757789274, 1510552800, 2345), (1141942900757789274, 1510563600, 4563461); =20 =20 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 =20 =20 any idees where the problem is? =20 Thanxs Steffan _______________________________________________ rrd-users mailing list <mailto:[email protected]> [email protected] <https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users> = https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users =20 ------=_NextPart_000_026C_01D35CA0.333C9F10 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" = xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta = http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta = name=3DGenerator content=3D"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=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DNL link=3Dblue = vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span = lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;= mso-fareast-language:EN-US'>Its centos 6<o:p></o:p></span></p><p = class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;= mso-fareast-language:EN-US'>And your right<o:p></o:p></span></p><p = class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;= mso-fareast-language:EN-US'>ldd /usr/lib64/librrd.so.4 | grep = dbi<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;= mso-fareast-language:EN-US'><o:p> </o:p></span></p><p = class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;= mso-fareast-language:EN-US'>I installed it with yum = <o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;= mso-fareast-language:EN-US'>So I need do a manual = install?<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;= mso-fareast-language:EN-US'><o:p> </o:p></span></p><p = class=3DMsoNormal><span lang=3DEN-US = style=3D'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=3D'border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm'><p class=3DMsoNormal><b><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>Van:</span></= b><span style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> = [email protected] [mailto:[email protected]] = <br><b>Verzonden:</b> maandag 13 november 2017 16:51<br><b>Aan:</b> = Steffan <[email protected]><br><b>CC:</b> = [email protected]<br><b>Onderwerp:</b> Re: [rrd-users] mysql = question<o:p></o:p></span></p></div></div><p = class=3DMsoNormal><o:p> </o:p></p><div><p class=3DMsoNormal>Hi = Steffan!<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><p class=3DMsoNormal>If you = are using the default rpms of rrdtool then libdbi support may not be = compiled in=E2=80=A6<o:p></o:p></p><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>check the rrd shared library with ldd if it lists = libdbi as a shared library it needs=E2=80=A6<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>something like this:<o:p></o:p></p></div><div><p = class=3DMsoNormal>ldd /usr/lib64/librrd.so.4 | grep = dbi<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>At least standard Centos7 does not come with it = enabled.<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><p = class=3DMsoNormal>Martin<o:p></o:p></p></div><div><p = class=3DMsoNormal><o:p> </o:p></p></div><div><div><blockquote = style=3D'margin-top:5.0pt;margin-bottom:5.0pt'><div><p = class=3DMsoNormal>On 13.11.2017, at 16:17, Steffan <<a = href=3D"mailto:[email protected]">[email protected]</a>> = wrote:<o:p></o:p></p></div><p = class=3DMsoNormal><o:p> </o:p></p><div><div><p = class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>Hello,</span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>Im using the = tutorial from</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><a = href=3D"https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html"><span= lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#954F72'= >https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html</span></a><sp= an = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>including = the test database tables etc</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>but im = getting</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>root@61 = web]# DS_BASE=3D"sql//mysql/host=3D</span><a = href=3D"http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D= ***/RRDValue/UnixTimeStamp/value/RRDKeyID=3D1141942900757789274"><span = lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#954F72'= >sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//RRDValue/= UnixTimeStamp/value/RRDKeyID=3D1141942900757789274</span></a><span = lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>"</span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>[root@61 = web]# rrdtool graph test.png --imgformat=3DPNG --start=3D-1day = --end=3D+3hours --width=3D1000 --height=3D600 = "DEF:min=3D$DS_BASE:min:AVERAGE" = "LINE1:min#FF0000:value" = "DEF:avg=3D$DS_BASE:avg:AVERAGE" = "LINE1:avg#00FF00:average" = "DEF:max=3D$DS_BASE:max:AVERAGE" = "LINE1:max#FF0000:max" = "DEF:sigma=3D$DS_BASE:sigma:AVERAGE" = "CDEF:upper=3Davg,4,sigma,*,+" = "LINE1:upper#0000FF:+4 sigma" = "CDEF:lower=3Davg,4,sigma,*,-" = "LINE1:lower#0000FF:-4 sigma"</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>ERROR: = opening 'sql//mysql/host=3D</span><a = href=3D"http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D= ***/RRDValue/UnixTimeStamp/value/RRDKeyID=3D11419429007577892741141942900= 757789274':"><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif;color:#954F72'= >sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//RRDValue/= UnixTimeStamp/value/RRDKeyID=3D11419429007577892741141942900757789274':</= span></a><span class=3Dapple-converted-space><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= </span><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>No such file = or directory</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Courier New"'>--</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Courier New"'>-- Tabelstructuur = voor tabel `RRDValue`</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Courier New"'>--</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Courier New"'>(`RRDKeyID`, = `UnixTimeStamp`, `value`) VALUES</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Courier = New"'>(1141942900757789274, 1510552800, 2345),</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Courier = New"'>(1141942900757789274, 1510563600, 4563461);</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Courier New"'> </span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Courier New"'> </span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>Installed = Packages</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi.x86_64= &= nbsp; &n= bsp; &nb= sp; &nbs= p;  = ; = = 0.8.3-4.el6 &n= bsp; &nb= sp; &nbs= p;  = ; = = @base</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi-dbd-my= sql.x86_64 &nb= sp; &nbs= p;  = ; = &= nbsp; = 0.8.3-5.1.el6 = &= nbsp; &n= bsp; &nb= sp; &nbs= p; @base</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi-devel.= x86_64 &= nbsp; &n= bsp; &nb= sp; &nbs= p; = &= nbsp; 0.8.3-4.el6 &nb= sp; &nbs= p;  = ; = &= nbsp; &n= bsp; @base</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>libdbi-driver= s.x86_64  = ; = &= nbsp; &n= bsp; &nb= sp; = 0.8.3-5.1.el6 = &= nbsp; &n= bsp; &nb= sp; &nbs= p; @base</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>any idees = where the problem is?</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'> </span>= <span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><div><p class=3DMsoNormal><span lang=3DEN-US = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'>Thanxs<br>Ste= ffan</span><span = style=3D'font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></= span></p></div><p class=3DMsoNormal><span = style=3D'font-size:9.0pt;font-family:"Helvetica",sans-serif'>____________= ___________________________________<br>rrd-users mailing = list<br></span><a href=3D"mailto:[email protected]"><span = style=3D'font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#954F72= '>[email protected]</span></a><span = style=3D'font-size:9.0pt;font-family:"Helvetica",sans-serif'><br></span><= a href=3D"https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users"><span = style=3D'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></blockquote></div><p = class=3DMsoNormal><o:p> </o:p></p></div></div></body></html> ------=_NextPart_000_026C_01D35CA0.333C9F10-- --===============4286852665630647908== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ rrd-users mailing list [email protected] https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users --===============4286852665630647908==--