> -----Original Message----- > From: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Schmidauer Martin > Sent: Friday, November 30, 2012 1:02 PM > To: [email protected] > Subject: [rsyslog] Replace ' with '' in msg > > We use rsyslog to fill our MSSQL database with exim mail logs. > Sometimes in > msg there is a ' character (39 dez) wich the MSSQL interprets. The > solution > on the MSSQL side is to escape the ' with a secon one.
Have you configured mysql to use ANSI standard escaping? Usually, \' is required in mysql (unfortunately). If you reconfigured, the default template does not work, you need to provide your own with the STDSQL template option. Rainer >Is there a > possibility to change the content oft he msg in this way? > > Thanks, Martin > > _______________________________________________ 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 NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE THAT.
