Package: sqlgrey
Version: 1:1.8.0-1
Severity: normal
Tags: patch
Dear Maintainer,
Sqlgrey currently logs several informational messages to the syslog for
each connection and message during normal operation. If logcheck is
installed, this results in a lot of unimportant messages being reported.
The logcheck maintainers recommend that packages maintain their own
logcheck rules.[1] To that end I'm filing this bug along with the rules
which I am currently using. I've attempted to match the prevailing
conventions in existing rules for hosts/IPs/emails, which could be made
more or less restrictive if desired. The file should be installed as
/etc/logcheck/ignore.d.server/sqlgrey.
Thanks,
Kevin
1. https://logcheck.alioth.debian.org/docs/README.Maintainer
-- System Information:
Debian Release: stretch/sid
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable'), (101, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.3.0+kevinoid1 (SMP w/4 CPU cores)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: conf: reloading static whitelists
and smart regexps$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: domain awl match: updating
[.:[:xdigit:]]+\([.:[:xdigit:]]+\), [._[:alnum:]-]+$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: domain awl: [.:[:xdigit:]]+,
$sender_domain added$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: early reconnect:
[.:[:xdigit:]]+\([.:[:xdigit:]]+\), [[:graph:]]+@[._[:alnum:]-]+ ->
[[:graph:]]+@[._[:alnum:]-]+$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: from awl match: updating
[.:[:xdigit:]]+\([.:[:xdigit:]]+\),
[[:graph:]]+@[._[:alnum:]-]+\([[:graph:]]+@[._[:alnum:]-]+\)$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: from awl: [.:[:xdigit:]]+,
[[:graph:]]+@[._[:alnum:]-]+ added$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: new:
[.:[:xdigit:]]+\([.:[:xdigit:]]+\), [[:graph:]]+@[._[:alnum:]-]+ ->
[[:graph:]]+@[._[:alnum:]-]+$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: reconnect ok:
[.:[:xdigit:]]+\([.:[:xdigit:]]+\), [[:graph:]]+@[._[:alnum:]-]+ ->
[[:graph:]]+@[._[:alnum:]-]+ \([0-9:.]+\)$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: grey: throttling:
[.:[:xdigit:]]+\($addr\), [[:graph:]]+@[._[:alnum:]-]+ ->
[[:graph:]]+@[._[:alnum:]-]+$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: perf: spent [0-9]+s cleaning:
from_awl \([0-9]+\) domain_awl \([0-9]+\) connect \([0-9]+\)$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: spam: [.:[:xdigit:]]+:
[[:graph:]]+@[._[:alnum:]-]+ -> [[:graph:]]+@[._[:alnum:]-]+ at [0-9-]{10}
[0-9:]{8}\.[0-9]+$
^\w{3} [ :0-9]{11} [._[:alnum:]-]+ sqlgrey: whitelist:
[[:graph:]]+@[._[:alnum:]-]+, [.:[:xdigit:]]+\([._[:alnum:]-]+\) ->
[[:graph:]]+@[._[:alnum:]-]+$
