|
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
|