#630025 rsyslog-mysql: ommysql inserts leading space into 'Message'-column

Package:
rsyslog-mysql
Source:
rsyslog
Description:
MySQL output plugin for rsyslog
Submitter:
Johann Hartwig Hauschild
Date:
2014-08-20 18:45:04 UTC
Severity:
normal
#630025#5
Date:
2011-06-10 12:25:59 UTC
From:
To:
ommysql does not strip leading spaces from the system log.
This is not really practical as it essentially forces users to select using
LIKE '%$SEARCHTERM', making SELECTS somehow more expensive than they could
be.
#630025#10
Date:
2014-08-20 18:25:36 UTC
From:
To:
Hi Johann,

Am 10.06.2011 14:25, schrieb Johann Hartwig Hauschild:

Sorry for the late reply.
Can you still reproduce the problem on an up-to-date wheezy or sid system?
#630025#15
Date:
2014-08-20 18:43:13 UTC
From:
To:
Sent from phone, thus brief.
Am 20.08.2014 20:27 schrieb "Michael Biebl" <biebl@debian.org>:
using
could

I guess so. We do not try to strip leading spaces and most logs have at
least one due to rfc3164 definitions.

So this sounds like a feature request to me.

Rainer