Hello all,
I have a problem with my reliable rsyslog config.
I use the rsyslog-mysql plugin in combination with RELP. The server receive the
data about the RELP protocol and save them to the mysql database. That works
fine.
Here my hardware strutuce:
[rsyslogClient]---->RELP>----[rsyslogServer]---->----[mySQLdatabase]
The problem is, if the mysqlserver goes down (by reboot, network problems or
something like that), I lost every syslog messages that will be accrue during
this period. Once the mysqlserver are available again, the database catch only
the new rsyslog messages, not the messages how was generated on client site
during the disconnected period.
I have monitored the working directory (/var/rsyslog/...) during this test and
the server doesn't create a file for the rsyslog buffer in this directory
although the connection is offline.
The rsyslog configuration:
#####
### /etc/rsyslog.d/60-mysyslog.conf
$template mySyslog,"insert into mySyslog.mySystemEvents (from_host, priority,
message, device_reported_time, received_at, syslog_tag ) values ('%HOSTNAME%', \
'%syslogpriority%', \
'%msg%', \
'%timereported:::date-mysql%', \
'%timegenerated:::date-mysql%', \
'%syslogtag%')",SQL
$ModLoad ommysql
$WorkDirectory /var/rsyslog/mysqlQ # default location for work files
$ActionQueueType LinkedList # use asynchronous processing
$ActionQueueFileName dbq # set file name, also enables disk mode
$ActionResumeRetryCount -1 # infinite retries on insert failure
$ActionQueueSaveOnShutdown on # save in-memory data if
:hostname, regex, "myAppServer[0-9]"
:ommysql:mysqlserver,mySyslog,root,password;mySyslog
###
#####
Why receive the mySQL database no log messages who was generated during the
offline period?
What is my the problem?
Thank you for any improvement suggestions or help.
Best regards
masp
<html>
<body>
-- Freundliche Gr??e / Best Regards Manuel Spies
----------------------------------------------------------------------------------------------
Manuel Spies, M.Sc. Kommunikationssysteme / Communication Systems Fakult?t f?r
Ingenieurwissenschaften / School of
Engineering Hochschule f?r Technik und Wirtschaft des Saarlandes (HTW) /
University of Applied Sciences Standort / Location: HTW
Hochschul-Technologie-Zentrum (HTZ) Campus IT-Park (CIP) Altenkesseler Strasse
17/D2 66115 Saarbruecken, Germany Phone: +49 681
5867-667 Mobile: n.a. Fax: +49 681 5867-671 E-Mail:
[email protected] URL: http://www.htw-saarland.de
----------------------------------------------------------------------------------------------
</body>
</html>
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
