File: README.sql

package info (click to toggle)
net-snmp 5.9+dfsg-3
  • links: PTS, VCS
  • area: main
  • in suites: bullseye, sid
  • size: 36,760 kB
  • sloc: ansic: 283,039; perl: 17,712; sh: 11,887; makefile: 2,705; xml: 663; python: 623; pascal: 62; sql: 47
file content (29 lines) | stat: -rw-r--r-- 740 bytes parent folder | download | duplicates (5)
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