[Logcheck-devel] Bug#444353: dovecot: filter for 'Connected to sql database' - "patch"

[Stefan Schlesinger]

Package: logcheck-database
Version: 1.2.54
Severity: normal


Please update ignore.d.server/dovecot since it contains a 
bug in the "Connected to (pg|my)sql database" regex. The 
following is the log line which should be matched:

Sep 28 00:00:00 localhost dovecot: auth-worker(default): mysql: Connected to localhost (DATABASENAME)

I think the line has changed some time ago. I found the 
following changeset:
http://hg.dovecot.org/dovecot/rev/74df0c0743c4

The following line should fix it:
^\w{3} [ :[:digit:]]{11} [._[:alnum:]-]+ dovecot: auth-worker\([-_.[:alnum:]]+\): (pg|my)sql: Connected to [-_.[:alnum:]]+ \([_[:alnum:]]+\)$

As SVN isn't working ATM, I cannot send you a diff of 
the version in the debian SVN trunk (as stated at the
wiki site).

HTH

Regards, Stefan.

-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.8-3-k7
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages logcheck-database depends on:
ii  debconf [debconf-2.0]         1.5.11     Debian configuration management sy

logcheck-database recommends no packages.

-- debconf information:
  logcheck-database/conffile-cleanup: false
  logcheck-database/standard-rename-note: