Re: mysql question
[email protected] Mon, 13 Nov 2017 16:51:03 +0100
| Newsgroups | gmane.comp.db.rrdtool.user |
|---|---|
| Message-ID | <[email protected]> |
--===============7142531274118429378== Content-Type: multipart/alternative; boundary="Apple-Mail=_4F108A7A-EF1C-43C7-999E-A73486FF2D77" --Apple-Mail=_4F108A7A-EF1C-43C7-999E-A73486FF2D77 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Steffan! If you are using the default rpms of rrdtool then libdbi support may not = be compiled in=E2=80=A6 check the rrd shared library with ldd if it lists libdbi as a shared = library it needs=E2=80=A6 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 <[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=3Dsql1.tkservers.com/dbname=3D***/username=3D**= */password=3D***//RRDValue/UnixTimeStamp/value/RRDKeyID=3D1141942900757789= 274 = <http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//RRD= Value/UnixTimeStamp/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=3Dsql1.tkservers.com/dbname=3D***/username=3D***/password= =3D***//RRDValue/UnixTimeStamp/value/RRDKeyID=3D11419429007577892741141942= 900757789274': = <http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//RRD= Value/UnixTimeStamp/value/RRDKeyID=3D1141942900757789274114194290075778927= 4':> 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 > [email protected] <mailto:[email protected]> > https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users = <https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users> --Apple-Mail=_4F108A7A-EF1C-43C7-999E-A73486FF2D77 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html = charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" = class=3D""><div class=3D"">Hi Steffan!</div><div class=3D""><br = class=3D""></div>If you are using the default rpms of rrdtool then = libdbi support may not be compiled in=E2=80=A6<div class=3D""><br = class=3D""></div><div class=3D"">check the rrd shared library with ldd = if it lists libdbi as a shared library it needs=E2=80=A6</div><div = class=3D""><br class=3D""></div><div class=3D"">something like = this:</div><div class=3D"">ldd /usr/lib64/librrd.so.4 | grep = dbi</div><div class=3D""><br class=3D""></div><div class=3D"">At least = standard Centos7 does not come with it enabled.</div><div class=3D""><br = class=3D""></div><div class=3D"">Martin</div><div class=3D""><br = class=3D""></div><div class=3D""><div><blockquote type=3D"cite" = class=3D""><div class=3D"">On 13.11.2017, at 16:17, Steffan <<a = href=3D"mailto:[email protected]" = class=3D"">[email protected]</a>> wrote:</div><br = class=3D"Apple-interchange-newline"><div class=3D""><div = class=3D"WordSection1" style=3D"page: WordSection1; font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant-caps: = normal; font-weight: normal; letter-spacing: normal; orphans: auto; = text-align: start; text-indent: 0px; text-transform: none; white-space: = normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: = 0px;"><div style=3D"margin: 0cm 0cm 0.0001pt; font-size: 11pt; = font-family: Calibri, sans-serif;" class=3D""><span lang=3D"EN-US" = class=3D"">Hello,<o:p class=3D""></o:p></span></div><div style=3D"margin: = 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D"">Im using the tutorial = from<o:p class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D""><a = href=3D"https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html" = style=3D"color: rgb(149, 79, 114); text-decoration: underline;" = class=3D"">https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html</a><= o:p class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D"">including the test database = tables etc<o:p class=3D""></o:p></span></div><div style=3D"margin: 0cm = 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D"">but im getting<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" class=3D""><o:p class=3D""> </o:p></span></div><div = style=3D"margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: = Calibri, sans-serif;" class=3D""><span lang=3D"EN-US" class=3D"">root@61 = web]# DS_BASE=3D"sql//mysql/host=3D<a = href=3D"http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D*= **//RRDValue/UnixTimeStamp/value/RRDKeyID=3D1141942900757789274" = style=3D"color: rgb(149, 79, 114); text-decoration: underline;" = class=3D"">sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//= RRDValue/UnixTimeStamp/value/RRDKeyID=3D1141942900757789274</a>"<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" class=3D"">[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"<o:p class=3D""></o:p></span></div><div = style=3D"margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: = Calibri, sans-serif;" class=3D""><span lang=3D"EN-US" class=3D"">ERROR: = opening 'sql//mysql/host=3D<a = href=3D"http://sql1.tkservers.com/dbname=3D***/username=3D***/password=3D*= **//RRDValue/UnixTimeStamp/value/RRDKeyID=3D114194290075778927411419429007= 57789274':" style=3D"color: rgb(149, 79, 114); text-decoration: = underline;" = class=3D"">sql1.tkservers.com/dbname=3D***/username=3D***/password=3D***//= RRDValue/UnixTimeStamp/value/RRDKeyID=3D1141942900757789274114194290075778= 9274':</a><span class=3D"Apple-converted-space"> </span>No such = file or directory<o:p class=3D""></o:p></span></div><div style=3D"margin: = 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" style=3D"font-family: 'Courier New';" = class=3D"">--<o:p class=3D""></o:p></span></div><div style=3D"margin: = 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" style=3D"font-family: 'Courier New';" = class=3D"">-- Tabelstructuur voor tabel `RRDValue`<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" style=3D"font-family: 'Courier New';" class=3D"">--<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" style=3D"font-family: 'Courier New';" = class=3D"">(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = style=3D"font-family: 'Courier New';" class=3D"">(1141942900757789274, = 1510552800, 2345),<o:p class=3D""></o:p></span></div><div style=3D"margin:= 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span style=3D"font-family: 'Courier New';" = class=3D"">(1141942900757789274, 1510563600, 4563461);<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = style=3D"font-family: 'Courier New';" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span style=3D"font-family: 'Courier New';" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D"">Installed Packages<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" = class=3D"">libdbi.x86_64 &n= bsp; &nbs= p; = &n= bsp; &nbs= p; = = 0.8.3-4.el6 &nb= sp;  = ; &= nbsp; &nb= sp;  = ; @base<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" = class=3D"">libdbi-dbd-mysql.x86_64 &nbs= p; = &n= bsp; &nbs= p; = = 0.8.3-5.1.el6 &= nbsp; &nb= sp;  = ; &= nbsp; &nb= sp; @base<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" = class=3D"">libdbi-devel.x86_64 &n= bsp; &nbs= p; = &n= bsp; = &n= bsp; 0.8.3-4.el6  = ; &= nbsp; &nb= sp;  = ; &= nbsp; &nb= sp; @base<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" = class=3D"">libdbi-drivers.x86_64 = &n= bsp; &nbs= p; = &n= bsp; &nbs= p; = 0.8.3-5.1.el6 &= nbsp; &nb= sp;  = ; &= nbsp; &nb= sp; @base<o:p = class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm 0.0001pt; = font-size: 11pt; font-family: Calibri, sans-serif;" class=3D""><span = lang=3D"EN-US" class=3D""><o:p class=3D""> </o:p></span></div><div = style=3D"margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: = Calibri, sans-serif;" class=3D""><span lang=3D"EN-US" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D"">any idees where the problem = is?<o:p class=3D""></o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D""><o:p = class=3D""> </o:p></span></div><div style=3D"margin: 0cm 0cm = 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" = class=3D""><span lang=3D"EN-US" class=3D"">Thanxs<br = class=3D"">Steffan<o:p class=3D""></o:p></span></div></div><span = style=3D"font-family: Helvetica; font-size: 12px; font-style: normal; = font-variant-caps: normal; font-weight: normal; letter-spacing: normal; = orphans: auto; text-align: start; text-indent: 0px; text-transform: = none; white-space: normal; widows: auto; word-spacing: 0px; = -webkit-text-stroke-width: 0px; float: none; display: inline = !important;" = class=3D"">_______________________________________________</span><br = style=3D"font-family: Helvetica; font-size: 12px; font-style: normal; = font-variant-caps: normal; font-weight: normal; letter-spacing: normal; = orphans: auto; text-align: start; text-indent: 0px; text-transform: = none; white-space: normal; widows: auto; word-spacing: 0px; = -webkit-text-stroke-width: 0px;" class=3D""><span style=3D"font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant-caps: = normal; font-weight: normal; letter-spacing: normal; orphans: auto; = text-align: start; text-indent: 0px; text-transform: none; white-space: = normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; = float: none; display: inline !important;" class=3D"">rrd-users mailing = list</span><br style=3D"font-family: Helvetica; font-size: 12px; = font-style: normal; font-variant-caps: normal; font-weight: normal; = letter-spacing: normal; orphans: auto; text-align: start; text-indent: = 0px; text-transform: none; white-space: normal; widows: auto; = word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=3D""><a = href=3D"mailto:[email protected]" style=3D"color: rgb(149, 79, = 114); text-decoration: underline; font-family: Helvetica; font-size: = 12px; font-style: normal; font-variant-caps: normal; font-weight: = normal; letter-spacing: normal; orphans: auto; text-align: start; = text-indent: 0px; text-transform: none; white-space: normal; widows: = auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" = class=3D"">[email protected]</a><br style=3D"font-family: = Helvetica; font-size: 12px; font-style: normal; font-variant-caps: = normal; font-weight: normal; letter-spacing: normal; orphans: auto; = text-align: start; text-indent: 0px; text-transform: none; white-space: = normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: = 0px;" class=3D""><a = href=3D"https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users" = style=3D"color: rgb(149, 79, 114); text-decoration: underline; = font-family: Helvetica; font-size: 12px; font-style: normal; = font-variant-caps: normal; font-weight: normal; letter-spacing: normal; = orphans: auto; text-align: start; text-indent: 0px; text-transform: = none; white-space: normal; widows: auto; word-spacing: 0px; = -webkit-text-stroke-width: 0px;" = class=3D"">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</a></div></= blockquote></div><br class=3D""></div></body></html>= --Apple-Mail=_4F108A7A-EF1C-43C7-999E-A73486FF2D77-- --===============7142531274118429378== 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 --===============7142531274118429378==--