Changeset 910 for eddie/trunk/doc/manual.html

Timestamp:

12/10/2007 06:48:51 AM (13 months ago)

Author:

chris

Message:

Updated documentation & comments for the DBI directive.

Files:

• eddie/trunk/doc/manual.html (modified) (2 diffs)

eddie/trunk/doc/manual.html

@@ -1947 +1947 @@
     <i>Directive Examples:</i>
     <pre>
+        # test that our postgresql server is alive and responding to requests properly
+        DBI postgresql_check:
+            dbtype='pg'
+            host='localhost'
+            database='monitoring'
+            user='monitoring'
+            password='sshhh'
+            query='select * from monitoring'
+            rule='not connected or results != 1 or result1 != 42'
+            action=email(ALERT_EMAIL, 'PostgreSQL DB %(database)s failed test', 'Query: %(query)s\nConnected: %(connected)s\nError: %(errmsg)s')
+        
         # alert if too many connections to the Postgres database
         DBI db_connections:
@@ -1955 +1966 @@
             password='sekrit'
             query='select count(1) from pg_stat_activity'
-            rule='not connected or results != 1 or result1 &gt; 40'
+            rule='connected and results > 0 and result1 &gt; 40'
             action=email('alert', 'Database %(database)s on %(h)s: too many connections (currently %(result1)s)')
             console='%(database)s on %(host)s : connections = %(result1)d'