Blame README.sql

Packit fcad23
snmptrapd MySQL Logging
Packit fcad23
-----------------------
Packit fcad23
Packit fcad23
A trap handler for logging traps to a MySQL database was added
Packit fcad23
in release 5.5.0.
Packit fcad23
Packit fcad23
The MySQL database location and password must be configured in
Packit fcad23
/root/.my.cnf:
Packit fcad23
Packit fcad23
	[snmptrapd]
Packit fcad23
	host=localhost
Packit fcad23
	password=sql
Packit fcad23
Packit fcad23
User may also be configured, if using a MySQL user besides root.
Packit fcad23
Packit fcad23
snmptrapd.conf must be configured to for the queue size and
Packit fcad23
periodic flush interval:
Packit fcad23
Packit fcad23
	# maximum number of traps to queue before forced flush
Packit fcad23
	sqlMaxQueue 140
Packit fcad23
Packit fcad23
	# seconds between periodic queue flushes
Packit fcad23
	sqlSaveInterval 9
Packit fcad23
Packit fcad23
A value of 0 for sqlSaveInterval will completely disable MySQL
Packit fcad23
logging of traps.
Packit fcad23
Packit fcad23
The schema must be loaded into MySQL before running snmptrapd.
Packit fcad23
The schema can be found in dist/schema-snmptrapd.sql