My guess is that the forwarding action on the sender server is not properly configured. It needs to retry (as in the sample below). Can you post the client config?
Rainer > -----Original Message----- > From: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Manuel Spies > Sent: Friday, June 29, 2012 11:06 AM > To: '[email protected]' > Subject: [rsyslog] Rsyslog mySQL reliability doesn't work... > > 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: manuel.spies@htw- > saarland.de 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 _______________________________________________ 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
