summaryrefslogtreecommitdiff
path: root/README.sql
blob: e2f70384d63d46e50ce49d4aed7554741a93239d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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