Andreas Beckmann
2007-Mar-06 02:03 UTC
[Logcheck-devel] Bug#404852: postfix-mysql corrections
Hi,
here are some corrections/additions for the newly added postfix-mysql
rules (from my own ruleset, hopefully to be retired someday):
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ postfix/smtpd\[[0-9]+\]: sql plugin
doing query select password from [_[:alnum:]]+ where
[_[:alnum:]]+='[._@[:alnum:]-]+';?$
* do not hardcode table and column names ('password' does not seem a
variable column name but a fixed string)
* the trailing semicolon is optional (I've seen this message with and
without ...)
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ postfix/smtpd\[[0-9]+\]: sql plugin
create statement from
(userPassword|cmusaslsecret(PLAIN|CRAM-MD5|DIGEST-MD5)) [._[:alnum:]-]+
[.[:alnum:]-]+$
* the plugin creates more statements ...
* the trailing $ was missing
Andreas