> -----Original Message----- > From: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Schmidauer Martin > Sent: Friday, November 30, 2012 1:27 PM > To: rsyslog-users > Subject: Re: [rsyslog] Replace ' with '' in msg > > > > Have you configured mysql to use ANSI standard escaping? Usually, \' > is > > required in mysql (unfortunately). > > We are using MSSQL, not MySQL. Obviously \' is used in our present > rsyslog configuration. The template looks like: > $template MSSQL-exim_out,"exec dbo.insertEmail_Out @host='%HOSTNAME%', > @message='%msg'",SQL
Then you need to use the STDSQL option, details: http://www.rsyslog.com/doc/rsyslog_conf_templates.html Rainer > > > > > > > > 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. > _______________________________________________ > 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. _______________________________________________ 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.
