Actions
Bug #4281
closedRsyslog filters reports when too many reports arrive simultaneously
Status:
Released
Priority:
1 (highest)
Assignee:
Jonathan CLARKE
Category:
Web - Compliance & node report
Target version:
Pull Request:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:
Description
Issue:
Logs from rsyslog are not stored in postgres
Rsyslog version:
# dpkg -l |grep rsyslog ii rsyslog 5.8.6-1ubuntu8.6 reliable system and kernel logging daemon ii rsyslog-pgsql 5.8.6-1ubuntu8.6 PostgreSQL output plugin for rsyslog
Postgres error log:
2013-12-19 11:16:09 CET ERROR: invalid input syntax for integer: "**NO MATCH**" at character 228 2013-12-19 11:16:09 CET STATEMENT: insert into RudderSysEvents (executionDate, nodeId, ruleId, directiveId, serial, Component, KeyValue, executionTimeStamp, eventType, msg, Policy) values ('2013-12-19T11:15:42.010588+01:00','**NO MATCH**', '**NO MATCH**' , '0', '**NO MATCH**', '**NO MATCH**', '**NO MATCH**', '**NO MATCH**', '**NO MATCH**', '**NO MATCH**', '**NO MATCH**' )
Solution:
# sed -i 's#$RepeatedMsgReduction on#$RepeatedMsgReduction off#' /etc/rsyslog.conf # /etc/init.d/rsyslog restart
Actions