[rrd-developers] Re: MySQL Integration

[Don Kukral]

Rainer,
  Well I took your advice and I added two new DEF's to the graph
routine.  They are as follows:

  DBDEF:var=mysql(host,user,pw,db):CF:t_col:v_col:table

and for more flexibility... 

  DBQDEF:var=mysql(...):CF:sql-query

  With the second DEF you can pass it any valid SQL.  The first column
should be the time and the second column the value.  Works great.  Once
I figure out how autoconf/automake/etc work I'll post a patch.  BTW,
anyone know a good reference for autoconf?

Don

Rainer Bawidamann wrote:
> Did you think about a way to use it like this:
> 
> rrdtool graph DEF:var1=mysql:host;user;pw;db;table;t_col;v_col ...
> 
> (or DEF:var1=%mysql(...):column ... or whatever to distinguish from
> normal DEF)
> 
> This way graphing would work as usual.
> 
> Rainer
> --
> Rainer.Bawidamann at rz.uni-ulm.de
>

--
Unsubscribe mailto:rrd-developers-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-developers-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-developers
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi