mysql question
"Steffan" <[email protected]> Mon, 13 Nov 2017 16:17:17 +0100
| Newsgroups | gmane.comp.db.rrdtool.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multipart message in MIME format.
--===============8899908881950189278==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0250_01D35C9A.DFC53A40"
Content-Language: nl
This is a multipart message in MIME format.
------=_NextPart_000_0250_01D35C9A.DFC53A40
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Hello,
=20
Im using the tutorial from
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=3D11419429007577=
89274"
[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***/passwor=
d=3D***//RRDValue/UnixTimeStamp/value/RRDKeyID=3D114194290075778927411419=
42900757789274': 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
------=_NextPart_000_0250_01D35C9A.DFC53A40
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:"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:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-mailStijl17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@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=3D"#0563C1" vlink=3D"#954F72"><div class=3DWordSection1><p =
class=3DMsoNormal><span lang=3DEN-US>Hello,<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US>Im using the tutorial =
from<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US><a =
href=3D"https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html">https=
://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html</a><o:p></o:p></spa=
n></p><p class=3DMsoNormal><span =
lang=3DEN-US><o:p> </o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>including the test database tables =
etc<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US><o:p> </o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>but im getting<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US>root@61 web]# =
DS_BASE=3D"sql//mysql/host=3Dsql1.tkservers.com/dbname=3D***/usernam=
e=3D***/password=3D***//RRDValue/UnixTimeStamp/value/RRDKeyID=3D114194290=
0757789274"<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>[root@61 web]# rrdtool graph test.png --imgformat=3DPNG =
--start=3D-1day --end=3D+3hours --width=3D1000 =
--height=3D600=C2=A0=C2=A0=C2=A0=C2=A0 =
"DEF:min=3D$DS_BASE:min:AVERAGE"=C2=A0=C2=A0=C2=A0=C2=A0 =
"LINE1:min#FF0000:value"=C2=A0=C2=A0=C2=A0=C2=A0 =
"DEF:avg=3D$DS_BASE:avg:AVERAGE"=C2=A0=C2=A0=C2=A0=C2=A0 =
"LINE1:avg#00FF00:average"=C2=A0=C2=A0=C2=A0=C2=A0 =
"DEF:max=3D$DS_BASE:max:AVERAGE"=C2=A0=C2=A0=C2=A0=C2=A0 =
"LINE1:max#FF0000:max"=C2=A0=C2=A0=C2=A0=C2=A0 =
"DEF:sigma=3D$DS_BASE:sigma:AVERAGE"=C2=A0=C2=A0=C2=A0=C2=A0 =
"CDEF:upper=3Davg,4,sigma,*,+"=C2=A0=C2=A0=C2=A0=C2=A0 =
"LINE1:upper#0000FF:+4 sigma"=C2=A0=C2=A0=C2=A0=C2=A0 =
"CDEF:lower=3Davg,4,sigma,*,-"=C2=A0=C2=A0=C2=A0=C2=A0 =
"LINE1:lower#0000FF:-4 sigma"<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US>ERROR: opening =
'sql//mysql/host=3Dsql1.tkservers.com/dbname=3D***/username=3D***/passwor=
d=3D***//RRDValue/UnixTimeStamp/value/RRDKeyID=3D114194290075778927411419=
42900757789274': No such file or directory<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p><p =
class=3DMsoNormal style=3D'text-autospace:none'><span lang=3DEN-US =
style=3D'font-family:"Courier New"'>--<o:p></o:p></span></p><p =
class=3DMsoNormal style=3D'text-autospace:none'><span lang=3DEN-US =
style=3D'font-family:"Courier New"'>-- Tabelstructuur voor tabel =
`RRDValue`<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'text-autospace:none'><span lang=3DEN-US =
style=3D'font-family:"Courier New"'>--<o:p></o:p></span></p><p =
class=3DMsoNormal style=3D'text-autospace:none'><span lang=3DEN-US =
style=3D'font-family:"Courier New"'>(`RRDKeyID`, `UnixTimeStamp`, =
`value`) VALUES<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'text-autospace:none'><span style=3D'font-family:"Courier =
New"'>(1141942900757789274, 1510552800, 2345),<o:p></o:p></span></p><p =
class=3DMsoNormal style=3D'text-autospace:none'><span =
style=3D'font-family:"Courier New"'>(1141942900757789274, 1510563600, =
4563461);<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'text-autospace:none'><span style=3D'font-family:"Courier =
New"'><o:p> </o:p></span></p><p class=3DMsoNormal =
style=3D'text-autospace:none'><span style=3D'font-family:"Courier =
New"'><o:p> </o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>Installed Packages<o:p></o:p></span></p><p =
class=3DMsoNormal><span =
lang=3DEN-US>libdbi.x86_64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
0.8.3-4.el6=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
=C2=A0=C2=A0@base<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>libdbi-dbd-mysql.x86_64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
0.8.3-5.1.el6=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @base<o:p></o:p></span></p><p =
class=3DMsoNormal><span =
lang=3DEN-US>libdbi-devel.x86_64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A00.8.3-4.el6=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 @base<o:p></o:p></span></p><p =
class=3DMsoNormal><span =
lang=3DEN-US>libdbi-drivers.x86_64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=
0.8.3-5.1.el6=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @base<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US><o:p> </o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US>any idees where the problem =
is?<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US><o:p> </o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>Thanxs<br>Steffan<o:p></o:p></span></p></div></body></html>
------=_NextPart_000_0250_01D35C9A.DFC53A40--
--===============8899908881950189278==
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
--===============8899908881950189278==--