Remstats Home


  About remstats
  architecture
  Release Notes
  FAQ
  Conventions
  Prerequisites
  Installation
  Configuration
  Configuration Tools
  Servers
  Collectors
      cisco-access-server-collector
      dbi-collector
      dns-collector
      error-collector
      log-collector
      nt-status-collector
      ntop-collector
      ping-collector
      port-collector
      program-collector
      remoteping-collector
      snmp-collector
      snmp-route-collector
      unix-status-collector
  Updater
  Monitors
  pagemakers
  run-remstats2
  CGIs
  troubleshooting
  do-traceroutes
  Miscellany
  Thank-you
  Index


  Live Data

  Remstats was written by
  Thomas Erskine at the
  CRC in Canada and now
  at SourceWorks.

[Top] [Prev] [Next]

dbi-collector - data from remote databases

Usage:

Can't locate DBI.pm in @INC (@INC contains: . /usr/lib/remstats/lib /usr/lib/perl5/ /etc/perl /usr/local/lib/perl/5.8.7 /usr/local/share/perl/5.8.7 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl) at ../dbi-collector line 51.
BEGIN failed--compilation aborted at ../dbi-collector line 51.

Description:

The dbi-collector uses perl's DBI interface to access remote databases to collect data. If you have a DBD driver for your database, and can write an SQL select statement to select the data you're interested in, the dbi-collector can import the data into rrdtool and remstats.

The dbi-collector adds three new directives to RRD definitions which use it:

The connect directive tells how to connect to the appropriate server and database; the select tells how to select the data.

For an RRD collected by the dbi-collector, the data directive will require the column number in the select that will provide its data. This will be appended to the data directive like:

	data xxx=yyy GAUGE:600:0:U COL=12

There are also pseudo-columns called STATUS and RESPONSE to enable the rrd definition to reference the connection-status and response-time.

There are also some possible additions to the rrd directive in the host file. The rrd directive can look like:

	rrd	rrdname CONNECT="cc" SELECT="ss" USER="uu" PASSWORD="pp" DATABASE="dd"

All of the extras on the end are optional, and are provided in order to be able to use a single connect file with multiple databases, users, ...

If the multirowid is specified, then the variable returned is named RRDNAME:DATANAME:ROWNAME. Otherwise, it is named RRDNAME:DATANAME.

Notes

The dbi-collector, when querying an Oracle database, needs to know where Oracle was installed, specifically, it needs the environment to contain ORACLE_HOME pointing at where Oracle was installed. This can be simply done using the new environment config-file.


[Top] [Remstats] [SourceWorks] [RRDtool] [SourceForge]
Last updated Tue Oct 25 15:14:19 UTC 2005 by <terskine@users.sourceforge.net>.