new upstream release (3.3.0); modify package compatibility for Stretch
[ossec-hids.git] / debian / ossec-hids / var / ossec / rules / postgresql_rules.xml
diff --git a/debian/ossec-hids/var/ossec/rules/postgresql_rules.xml b/debian/ossec-hids/var/ossec/rules/postgresql_rules.xml
new file mode 100644 (file)
index 0000000..071f265
--- /dev/null
@@ -0,0 +1,102 @@
+<!-- @(#) $Id: ./etc/rules/postgresql_rules.xml, 2011/09/08 dcid Exp $
+
+  -  Official PostgreSQL rules for OSSEC.
+  -
+  -  Copyright (C) 2009 Trend Micro Inc.
+  -  All rights reserved.
+  -
+  -  This program is a free software; you can redistribute it
+  -  and/or modify it under the terms of the GNU General Public
+  -  License (version 2) as published by the FSF - Free Software
+  -  Foundation.
+  -
+  -  License details: http://www.ossec.net/en/licensing.html
+  -->
+  
+
+<!-- PostgreSQL Log messages -->
+<group name="postgresql_log,">
+  <rule id="50500" level="0">
+    <decoded_as>postgresql_log</decoded_as>
+    <description>PostgreSQL messages grouped.</description>
+  </rule>
+
+  <rule id="50501" level="0">
+    <if_sid>50500</if_sid>
+    <status>^LOG</status>
+    <description>PostgreSQL log message.</description>
+  </rule>
+  
+  <rule id="50502" level="0">
+    <if_sid>50500</if_sid>
+    <status>^NOTICE|INFO</status>
+    <description>PostgreSQL informational message.</description>
+  </rule>
+  
+  <rule id="50503" level="4">
+    <if_sid>50500</if_sid>
+    <status>^ERROR</status>
+    <description>PostgreSQL error message.</description>
+  </rule>
+   
+  <rule id="50504" level="5">
+    <if_sid>50500</if_sid>
+    <status>^FATAL</status>
+    <description>PostgreSQL error message.</description>
+  </rule>
+  
+  <rule id="50505" level="0">
+    <if_sid>50500</if_sid>
+    <status>^DEBUG</status>
+    <description>PostgreSQL debug message.</description>
+  </rule>
+  
+  <rule id="50510" level="0">
+    <if_sid>50501</if_sid>
+    <match> duration: | statement: </match>
+    <description>Database query.</description>
+  </rule>
+  
+  <rule id="50511" level="3">
+    <if_sid>50501</if_sid>
+    <match>connection authorized</match>
+    <description>Database authentication success.</description>
+    <group>authentication_success,</group>
+  </rule>
+
+  <rule id="50512" level="9">
+    <if_sid>50504</if_sid>
+    <match>authentication failed</match>
+    <description>Database authentication failure.</description>
+    <group>authentication_failed,</group>
+  </rule>
+  
+  <rule id="50520" level="12">
+    <if_sid>50504</if_sid>
+    <match>terminating connection due</match>
+    <description>Database shutdown message.</description>
+    <group>service_availability,</group>
+  </rule>
+  
+  <rule id="50521" level="12">
+    <if_sid>50501</if_sid>
+    <match>aborting any active transactions|shutting down</match>
+    <description>Database shutdown message.</description>
+    <group>service_availability,</group>
+  </rule>
+
+  <rule id="50580" level="10" frequency="6" timeframe="120" ignore="60">
+    <if_matched_sid>50504</if_matched_sid>
+    <description>Multiple database errors.</description>
+    <group>service_availability,</group>
+  </rule>
+  
+  <rule id="50581" level="10" frequency="6" timeframe="120" ignore="60">
+    <if_matched_sid>50503</if_matched_sid>
+    <description>Multiple database errors.</description>
+    <group>service_availability,</group>
+  </rule>
+
+</group> <!-- POSTGRESQL -->
+
+<!-- EOF -->