README.sql

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