[Logcheck-devel] Bug#765947: logcheck-database: improved rules for postfix SQL plugin

[Peter Wyss]

Package: logcheck-database
Version: 1.3.15
Severity: normal

The logcheck ignore.d.server rules for postfix need some adjustments regarding the SQL plugin:

^\w{3} [ :[:digit:]]{11} [._[:alnum:]-]+ postfix/smtpd\[[[:digit:]]+\]: sql plugin doing query (SELECT|select) [_[:alnum:]]+ (FROM|from) [_[:alnum:]]+ (WHERE|where) [_[:alnum:]]+( )?=( )?'[._@[:alnum:]-]+';?$
^\w{3} [ :[:digit:]]{11} [._[:alnum:]-]+ postfix/smtpd\[[[:digit:]]+\]: sql plugin create statement from (cmusaslsecret(CRAM-MD5|PLAIN)|userPassword) [^[:space:]]+ [^[:space:]]+


-- System Information:
Debian Release: 7.6
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-4-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash