Hi Manuel, Does the user running rsyslog have rights to write in the working directory?
Best regards, Radu 2012/6/29 Manuel Spies <[email protected]>: > 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 _______________________________________________ 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
