From 86f6ca2b5631e3ba487e420a670a7203260c8371 Mon Sep 17 00:00:00 2001
From: Florian Forster <octo@noris.net>
Date: Tue, 7 Oct 2008 16:41:07 +0200
Subject: [PATCH] src/collectd.conf.in: Add a configuration stump for the dbi
 plugin.

---
 src/collectd.conf.in | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

diff --git a/src/collectd.conf.in b/src/collectd.conf.in
index a09522c9..53abd3fa 100644
--- a/src/collectd.conf.in
+++ b/src/collectd.conf.in
@@ -34,6 +34,7 @@ FQDNLookup   true
 @BUILD_PLUGIN_CPU_TRUE@LoadPlugin cpu
 @BUILD_PLUGIN_CPUFREQ_TRUE@LoadPlugin cpufreq
 @BUILD_PLUGIN_CSV_TRUE@LoadPlugin csv
+@BUILD_PLUGIN_DBI_TRUE@LoadPlugin dbi
 @BUILD_PLUGIN_DF_TRUE@LoadPlugin df
 @BUILD_PLUGIN_DISK_TRUE@LoadPlugin disk
 @BUILD_PLUGIN_DNS_TRUE@LoadPlugin dns
@@ -111,6 +112,25 @@ FQDNLookup   true
 #	StoreRates false
 #</Plugin>
 
+#<Plugin dbi>
+#	<Query "num_of_customers">
+#		Statement "SELECT 'customers' AS c_key, COUNT(*) AS c_value FROM customers_tbl"
+#		Type "gauge"
+#		InstancesFrom "c_key"
+#		ValuesFrom "c_value"
+#	</Query>
+#	<Database "customers_db">
+#		Driver "mysql"
+#		DriverOption "host" "localhost"
+#		DriverOption "username" "collectd"
+#		DriverOption "password" "AeXohy0O"
+#		DriverOption "dbname" "custdb0"
+#		#SelectDB "custdb0"
+#		Query "num_of_customers"
+#		#Query "..."
+#	</Database>
+#</Plugin>
+
 #<Plugin df>
 #	Device "/dev/hda1"
 #	Device "192.168.0.2:/mnt/nfs"
-- 
2.11.0