summaryrefslogtreecommitdiff
path: root/README.sql
diff options
context:
space:
mode:
Diffstat (limited to 'README.sql')
-rw-r--r--README.sql29
1 files changed, 29 insertions, 0 deletions
diff --git a/README.sql b/README.sql
new file mode 100644
index 0000000..e2f7038
--- /dev/null
+++ b/README.sql
@@ -0,0 +1,29 @@
+snmptrapd MySQL Logging
+-----------------------
+
+A trap handler for logging traps to a MySQL database was added
+in release 5.5.0.
+
+The MySQL database location and password must be configured in
+/root/.my.cnf:
+
+ [snmptrapd]
+ host=localhost
+ password=sql
+
+User may also be configured, if using a MySQL user besides root.
+
+snmptrapd.conf must be configured to for the queue size and
+periodic flush interval:
+
+ # maximum number of traps to queue before forced flush
+ sqlMaxQueue 140
+
+ # seconds between periodic queue flushes
+ sqlSaveInterval 9
+
+A value of 0 for sqlSaveInterval will completely disable MySQL
+logging of traps.
+
+The schema must be loaded into MySQL before running snmptrapd.
+The schema can be found in dist/schema-snmptrapd.sql