[rrd-users] mysql question

Steffan mailinglist at tikklik.nl
Mon Nov 13 16:17:17 CET 2017


Hello,

 

Im using the tutorial from

https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html

 

including the test database tables etc

 

but im getting

 

root at 61 web]# DS_BASE="sql//mysql/host=sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274"

[root at 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=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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.oetiker.ch/pipermail/rrd-users/attachments/20171113/ffc63cae/attachment.html>


More information about the rrd-users mailing list