--- sqlgrey-1.8.0rc2.orig/debian/compat
+++ sqlgrey-1.8.0rc2/debian/compat
@@ -0,0 +1 @@
+5
--- sqlgrey-1.8.0rc2.orig/debian/dirs
+++ sqlgrey-1.8.0rc2/debian/dirs
@@ -0,0 +1,5 @@
+usr/bin
+usr/sbin
+var/lib/sqlgrey
+etc/sqlgrey
+etc/init.d
--- sqlgrey-1.8.0rc2.orig/debian/docs
+++ sqlgrey-1.8.0rc2/debian/docs
@@ -0,0 +1,7 @@
+FAQ
+README
+README.OPTINOUT
+README.PERF
+TODO
+HOWTO
+
--- sqlgrey-1.8.0rc2.orig/debian/postrm
+++ sqlgrey-1.8.0rc2/debian/postrm
@@ -0,0 +1,58 @@
+#!/bin/sh
+# postrm script for sqlgrey
+#
+# see: dh_installdeb(1)
+
+set -e
+
+# summary of how this script can be called:
+# * <postrm> `remove'
+# * <postrm> `purge'
+# * <old-postrm> `upgrade' <new-version>
+# * <new-postrm> `failed-upgrade' <old-version>
+# * <new-postrm> `abort-install'
+# * <new-postrm> `abort-install' <old-version>
+# * <new-postrm> `abort-upgrade' <old-version>
+# * <disappearer's-postrm> `disappear' <overwriter>
+# <overwriter-version>
+# for details, see http://www.debian.org/doc/debian-policy/ or
+# the debian-policy package
+
+
+case "$1" in
+ purge|remove|upgrade|failed-upgrade|abort-install|abort-upgrade|disappear)
+
+ DBDIR='/var/lib/sqlgrey'
+ CONFDIR='/var/lib/sqlgrey'
+
+ if [ -d $DBDIR ]; then
+ rmdir $DBDIR || true
+ dpkg-statoverride --remove $DBDIR || true
+ fi
+
+ if [ -d $CONFDIR ]; then
+ rm -f $CONFDIR/*~ \
+ $CONFDIR/clients_fqdn_whitelist \
+ $CONFDIR/clients_ip_whitelist \
+ $CONFIR/dyn_fqdn.regexp \
+ $CONFDIR/README \
+ $CONFDIR/smtp_server.regexp
+ rmdir $CONFDIR || true
+ fi
+
+ ;;
+
+ *)
+ echo "postrm called with unknown argument \`$1'" >&2
+ exit 1
+ ;;
+esac
+
+# dh_installdeb will replace this with shell code automatically
+# generated by other debhelper scripts.
+
+#DEBHELPER#
+
+exit 0
+
+
--- sqlgrey-1.8.0rc2.orig/debian/watch
+++ sqlgrey-1.8.0rc2/debian/watch
@@ -0,0 +1,4 @@
+version=3
+http://sf.net/sqlgrey/sqlgrey-(.*)\.tar\.gz
+
+
--- sqlgrey-1.8.0rc2.orig/debian/init.d
+++ sqlgrey-1.8.0rc2/debian/init.d
@@ -0,0 +1,76 @@
+#! /bin/sh
+#
+# sqlgrey start/stop the postgrey greylisting deamon for postfix
+# (priority should be smaller than that of postfix)
+#
+# Author: (c)2008 Antonin Kral <A.Kral@sh.cvut.cz>
+# Based on Debian sarge's 'skeleton' example
+# Distribute and/or modify at will.
+#
+### BEGIN INIT INFO
+# Provides: sqlgrey
+# Required-Start: $syslog, $local_fs, $remote_fs
+# Required-Stop: $syslog, $local_fs, $remote_fs
+# Default-Start: 2 3 4 5
+# Default-Stop: 0 1 6
+# Short-Description: Start/stop the sqlgrey daemon
+### END INIT INFO
+
+set -e
+
+PATH=/sbin:/bin:/usr/sbin:/usr/bin
+DAEMON=/usr/sbin/sqlgrey
+SQLGREY_HOME=/var/lib/sqlgrey
+NAME=sqlgrey
+DESC="postfix greylisting daemon (sqlgrey)"
+
+PIDFILE=/var/run/$NAME.pid
+SCRIPTNAME=/etc/init.d/$NAME
+
+# Gracefully exit if the package has been removed.
+test -x $DAEMON || exit 0
+
+# Read config file if it is present.
+if [ -r /etc/default/$NAME ]
+then
+ . /etc/default/$NAME
+fi
+
+SQLGREY_OPTS="--daemonize $SQLGREY_OPTS"
+
+case "$1" in
+ start)
+ echo -n "Starting $DESC: $NAME"
+ start-stop-daemon --start --quiet --pidfile $PIDFILE \
+ --chdir $SQLGREY_HOME \
+ --exec $DAEMON -- $SQLGREY_OPTS
+ echo "."
+ ;;
+ stop)
+ echo -n "Stopping $DESC: $NAME"
+ start-stop-daemon --stop --quiet --pidfile $PIDFILE --oknodo
+ rm -f $PIDFILE
+ echo "."
+ ;;
+ reload|force-reload)
+ echo -n "Reloading $DESC configuration..."
+ start-stop-daemon --stop --signal 1 --quiet --pidfile $PIDFILE
+ echo "done."
+ ;;
+ restart)
+ echo -n "Restarting $DESC: $NAME"
+ start-stop-daemon --stop --quiet --oknodo --pidfile $PIDFILE
+ rm -f $PIDFILE
+ sleep 1
+ start-stop-daemon --start --quiet --pidfile $PIDFILE \
+ --chdir $SQLGREY_HOME \
+ --exec $DAEMON -- $SQLGREY_OPTS
+ echo "."
+ ;;
+ *)
+ echo "Usage: $SCRIPTNAME {start|stop|restart|reload|force-reload}" >&2
+ exit 1
+ ;;
+esac
+
+exit 0
--- sqlgrey-1.8.0rc2.orig/debian/README.Debian
+++ sqlgrey-1.8.0rc2/debian/README.Debian
@@ -0,0 +1,14 @@
+sqlgrey for Debian
+------------------
+
+To use Postgrey, put something along the lines of
+
+ smtpd_recipient_restrictions =
+ permit_mynetworks,
+ reject_unauth_destination,
+ check_policy_service inet:127.0.0.1:2501
+
+in your /etc/postfix/main.cf (Postfix 2.1 or newer is required.)
+
+
+ -- Antonin Kral <A.Kral@sh.cvut.cz> Wed, 19 Mar 2008 21:18:15 +0100
--- sqlgrey-1.8.0rc2.orig/debian/copyright
+++ sqlgrey-1.8.0rc2/debian/copyright
@@ -0,0 +1,31 @@
+This package was debianized by Antonin Kral <A.Kral@sh.cvut.cz> on
+Wed, 19 Mar 2008 21:18:15 +0100.
+
+It was downloaded from http://sqlgrey.sourceforge.net/
+
+Upstream Author:
+
+ Lionel Bouton <lionel-dev@bouton.name>
+
+Copyright: 2004 - 2010 Lionel Bouton
+
+License:
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; either version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License with
+ the Debian GNU/Linux distribution in file
+ /usr/share/common-licenses/GPL-2; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301,
+ USA.
+
+The Debian packaging is (C) 2008, Antonin Kral <A.Kral@sh.cvut.cz> and
+is licensed under the GPL-2, see `/usr/share/common-licenses/GPL-2'.
+
--- sqlgrey-1.8.0rc2.orig/debian/control
+++ sqlgrey-1.8.0rc2/debian/control
@@ -0,0 +1,18 @@
+Source: sqlgrey
+Section: mail
+Priority: optional
+Maintainer: Antonin Kral <A.Kral@sh.cvut.cz>
+Build-Depends: debhelper (>= 5), perl-doc
+Standards-Version: 3.8.4
+
+Package: sqlgrey
+Homepage: http://sqlgrey.sourceforge.net/
+Architecture: all
+Depends: ${perl:Depends}, ${misc:Depends}, adduser, perl, libnet-server-perl, libdate-calc-perl, libdbd-pg-perl | libdbd-mysql-perl | libdbd-sqlite3-perl
+Recommends: postfix, libdbd-pg-perl
+Description: Postfix Greylisting Policy Server
+ A policy server for Postfix implementing greylisting.
+ .
+ Could be configured to use MySQL, PostgreSQL or SQLite. PostgreSQL is
+ recommended by author.
+ .
--- sqlgrey-1.8.0rc2.orig/debian/rules
+++ sqlgrey-1.8.0rc2/debian/rules
@@ -0,0 +1,72 @@
+#!/usr/bin/make -f
+# -*- makefile -*-
+# Sample debian/rules that uses debhelper.
+# This file was originally written by Joey Hess and Craig Small.
+# As a special exception, when this file is copied by dh-make into a
+# dh-make output file, you may use that output file without restriction.
+# This special exception was added by Craig Small in version 0.37 of dh-make.
+
+# Uncomment this to turn on verbose mode.
+#export DH_VERBOSE=1
+
+configure: configure-stamp
+configure-stamp:
+ dh_testdir
+
+ touch configure-stamp
+
+
+build: build-stamp
+
+build-stamp: configure-stamp
+ dh_testdir
+
+ $(MAKE) manpage && mv *.1 $(CURDIR)/debian/
+
+ touch $@
+
+clean:
+ dh_testdir
+ dh_testroot
+ rm -f build-stamp configure-stamp
+ #rm -f $(CURDIR)/debian/*.1
+
+ $(MAKE) clean
+
+ dh_clean
+
+install: build
+ dh_testdir
+ dh_testroot
+ dh_clean -k
+ dh_installdirs
+
+ # Add here commands to install the package into debian/sqlgrey.
+ $(MAKE) ROOTDIR=$(CURDIR)/debian/sqlgrey install
+
+
+binary-arch: build install
+
+binary-indep: build install
+ dh_testdir
+ dh_testroot
+ dh_installchangelogs Changelog
+ dh_installdocs
+ dh_installexamples
+# dh_install
+ dh_installinit -- defaults 19
+ dh_installman
+ dh_installman debian/update_sqlgrey_config.1
+ dh_link
+ dh_strip
+ dh_compress
+ dh_fixperms
+ dh_perl
+ dh_installdeb
+ dh_shlibdeps
+ dh_gencontrol
+ dh_md5sums
+ dh_builddeb
+
+binary: binary-indep binary-arch
+.PHONY: build clean binary-indep binary-arch binary install configure
--- sqlgrey-1.8.0rc2.orig/debian/changelog
+++ sqlgrey-1.8.0rc2/debian/changelog
@@ -0,0 +1,33 @@
+sqlgrey (1.8.0rc2-1) unstable; urgency=low
+
+ * New upstream release
+
+ -- Antonin Kral <A.Kral@sh.cvut.cz> Thu, 11 Feb 2010 09:29:57 +0100
+
+sqlgrey (1.6.8-4) unstable; urgency=low
+
+ * Added /var/lib/sqlgrey to dirs (Closes: #532950, #532948)
+ * Chdir to /var/lib/sqlgrey before starting daemon (Closes: #552261)
+
+ -- Antonin Kral <A.Kral@sh.cvut.cz> Tue, 22 Dec 2009 21:18:33 +0100
+
+sqlgrey (1.6.8-3) unstable; urgency=low
+
+ * fixed /etc/sqlgrey/sqlgrey.conf mode (Closes: #514834)
+
+ -- Antonin Kral <A.Kral@sh.cvut.cz> Wed, 11 Feb 2009 11:41:56 +0100
+
+sqlgrey (1.6.8-2) unstable; urgency=low
+
+ * added dependencies for supported DB models (Closes: #513597)
+ * fixed Lintian warning description-contains-homepage
+ * fixed Lintian warning binary-without-manpage
+
+ -- Antonin Kral <A.Kral@sh.cvut.cz> Sun, 08 Feb 2009 15:03:12 +0100
+
+sqlgrey (1.6.8-1) unstable; urgency=low
+
+ * Initial release (Closes: #389472)
+
+ -- Antonin Kral <A.Kral@sh.cvut.cz> Wed, 19 Mar 2008 21:18:15 +0100
+
--- sqlgrey-1.8.0rc2.orig/debian/sqlgrey.1
+++ sqlgrey-1.8.0rc2/debian/sqlgrey.1
@@ -0,0 +1,291 @@
+.\" Automatically generated by Pod::Man 2.22 (Pod::Simple 3.13)
+.\"
+.\" Standard preamble:
+.\" ========================================================================
+.de Sp \" Vertical space (when we can't use .PP)
+.if t .sp .5v
+.if n .sp
+..
+.de Vb \" Begin verbatim text
+.ft CW
+.nf
+.ne \\$1
+..
+.de Ve \" End verbatim text
+.ft R
+.fi
+..
+.\" Set up some character translations and predefined strings. \*(-- will
+.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
+.\" double quote, and \*(R" will give a right double quote. \*(C+ will
+.\" give a nicer C++. Capital omega is used to do unbreakable dashes and
+.\" therefore won't be available. \*(C` and \*(C' expand to `' in nroff,
+.\" nothing in troff, for use with C<>.
+.tr \(*W-
+.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
+.ie n \{\
+. ds -- \(*W-
+. ds PI pi
+. if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
+. if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch
+. ds L" ""
+. ds R" ""
+. ds C` ""
+. ds C' ""
+'br\}
+.el\{\
+. ds -- \|\(em\|
+. ds PI \(*p
+. ds L" ``
+. ds R" ''
+'br\}
+.\"
+.\" Escape single quotes in literal strings from groff's Unicode transform.
+.ie \n(.g .ds Aq \(aq
+.el .ds Aq '
+.\"
+.\" If the F register is turned on, we'll generate index entries on stderr for
+.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
+.\" entries marked with X<> in POD. Of course, you'll have to process the
+.\" output yourself in some meaningful fashion.
+.ie \nF \{\
+. de IX
+. tm Index:\\$1\t\\n%\t"\\$2"
+..
+. nr % 0
+. rr F
+.\}
+.el \{\
+. de IX
+..
+.\}
+.\"
+.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
+.\" Fear. Run. Save yourself. No user-serviceable parts.
+. \" fudge factors for nroff and troff
+.if n \{\
+. ds #H 0
+. ds #V .8m
+. ds #F .3m
+. ds #[ \f1
+. ds #] \fP
+.\}
+.if t \{\
+. ds #H ((1u-(\\\\n(.fu%2u))*.13m)
+. ds #V .6m
+. ds #F 0
+. ds #[ \&
+. ds #] \&
+.\}
+. \" simple accents for nroff and troff
+.if n \{\
+. ds ' \&
+. ds ` \&
+. ds ^ \&
+. ds , \&
+. ds ~ ~
+. ds /
+.\}
+.if t \{\
+. ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
+. ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
+. ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
+. ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
+. ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
+. ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
+.\}
+. \" troff and (daisy-wheel) nroff accents
+.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
+.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
+.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
+.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
+.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
+.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
+.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
+.ds ae a\h'-(\w'a'u*4/10)'e
+.ds Ae A\h'-(\w'A'u*4/10)'E
+. \" corrections for vroff
+.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
+.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
+. \" for low resolution devices (crt and lpr)
+.if \n(.H>23 .if \n(.V>19 \
+\{\
+. ds : e
+. ds 8 ss
+. ds o a
+. ds d- d\h'-1'\(ga
+. ds D- D\h'-1'\(hy
+. ds th \o'bp'
+. ds Th \o'LP'
+. ds ae ae
+. ds Ae AE
+.\}
+.rm #[ #] #H #V #F C
+.\" ========================================================================
+.\"
+.IX Title "sqlgrey 1"
+.TH sqlgrey 1 "2010-02-11" "perl v5.10.1" "User Contributed Perl Documentation"
+.\" For nroff, turn off justification. Always turn off hyphenation; it makes
+.\" way too many mistakes in technical documents.
+.if n .ad l
+.nh
+.SH "NAME"
+sqlgrey \- Postfix Greylisting Policy Server
+.SH "SYNOPSIS"
+.IX Header "SYNOPSIS"
+\&\fBsqlgrey\fR [\fIoptions\fR...]
+.PP
+.Vb 11
+\& \-h, \-\-help display this help and exit
+\& \-\-man display man page
+\& \-\-version output version information and exit
+\& \-d, \-\-daemonize run in the background
+\& \-k, \-\-kill kill a running sqlgrey
+\& (identified by \*(Aqpidfile\*(Aq content)
+\& \-f, \-\-configfile=FILE read config from FILE
+\& (default /etc/sqlgrey/sqlgrey.conf)
+\& expecting config_param=value lines,
+\& \- spaces are ignored,
+\& \- \*(Aq#\*(Aq is used for comments
+.Ve
+.PP
+See the default config file at /etc/sqlgrey/sqlgrey.conf for runtime parameters.
+If you got sqlgrey from sources, read the \s-1HOWTO\s0 file in the compressed archive.
+If it came prepackaged, look into the documentation tree for this file:
+/usr/share/doc/sqlgrey\-<version>/ on most Linux distributions for example.
+.SH "DESCRIPTION"
+.IX Header "DESCRIPTION"
+Sqlgrey is a Postfix policy server implementing greylisting.
+.PP
+When a request for delivery of a mail is received by Postfix via \s-1SMTP\s0,
+the triplet \f(CW\*(C`CLIENT_IP\*(C'\fR / \f(CW\*(C`SENDER\*(C'\fR / \f(CW\*(C`RECIPIENT\*(C'\fR is built. If it is
+the first time that this triplet is seen, or if the triplet was first
+seen less than \fIreconnect-delay\fR minutes (1 is the default), then
+the mail gets rejected with a temporary error. Hopefully spammers or
+viruses will not try again later, as it is however required per \s-1RFC\s0.
+.PP
+In order to alleviate the reconnect delay, sqlgrey uses a 2\-level
+auto-white-list (\s-1AWL\s0) system:
+.IP "\(bu" 4
+As soon as a \f(CW\*(C`CLIENT IP\*(C'\fR / \f(CW\*(C`SENDER\*(C'\fR is accepted, it is added to an
+\&\s-1AWL\s0. The couple expires when it isn't seen for more than \fIawl-age\fR
+days (60 is the default).
+.IP "\(bu" 4
+If \fIgroup-domain-level\fR \f(CW\*(C`SENDER\*(C'\fRs (2 is the default) from the same
+domain or more use the same \f(CW\*(C`CLIENT IP\*(C'\fR, another \s-1AWL\s0 is used based on a
+\&\f(CW\*(C`CLIENT IP\*(C'\fR / \f(CW\*(C`DOMAIN\*(C'\fR couple.
+This couple expires after awl-age days too. This \s-1AWL\s0 is meant to be used
+on high throughput sites in order to :
+.RS 4
+.IP "\(bu" 4
+minimize the amount of data stored in database,
+.IP "\(bu" 4
+minimize the amount of processing required to find an entry in the \s-1AWL\s0.
+.IP "\(bu" 4
+don't impose any further mail delay when a \f(CW\*(C`CLIENT IP\*(C'\fR / \f(CW\*(C`DOMAIN\*(C'\fR
+couple is known.
+.RE
+.RS 4
+.Sp
+It can be disabled by setting \fIgroup-domain-level\fR to 0.
+.RE
+.PP
+General idea:
+.PP
+When a \s-1SMTP\s0 client has been accepted once, if the \s-1IP\s0 isn't dynamic,
+greylisting the \s-1IP\s0 again is only a waste of time when it sends another
+e\-mail. As we already know that this \s-1IP\s0 runs an RFC-compliant \s-1MTA\s0 (at
+least the 4xx error code handling) and will get the new e\-mail through
+anyway.
+.PP
+In the case of mail relays, these AWLs works very well as the same
+senders and mail domains are constantly coming through the same \s-1IP\s0
+addresses \-> the e\-mails are quickly accepted on the first try.
+In the case of individual \s-1SMTP\s0 servers, this works well if the \s-1IP\s0 is
+fixed too.
+When using a floating \s-1IP\s0 address, the AWLs are defeated, but it should
+be the least common case by far.
+.PP
+Why do we put the domain in the \s-1AWL\s0 and not the \s-1IP\s0 only ? If we did
+only store \s-1IP\s0 addresses, polluting the \s-1AWL\s0 would be far too easy. It
+would only take one correctly configured \s-1MTA\s0 sending one e\-mail from
+one \s-1IP\s0 one single time to put it in a whitelist used whatever future
+mails from this \s-1IP\s0 look like.
+.PP
+With this \s-1AWL\s0 system, one single mail can only allow whitelisting of
+mails from a single sender from the same \s-1IP\s0...
+.SH "INSTALLATION"
+.IX Header "INSTALLATION"
+.IP "\(bu" 4
+Create a \f(CW\*(C`sqlgrey\*(C'\fR user. This will be the user the daemon runs as.
+.IP "\(bu" 4
+When using a full-fledge \s-1SGBD\s0 (MySQL and PostgreSQL, not SQLite),
+create a 'sqlgrey' db user and a 'sqlgrey' database. Grant access
+to the newly created database to sqlgrey.
+.IP "\(bu" 4
+Use the packaged init script to start sqlgrey at boot and start it
+manually.
+.SH "CONFIGURATION"
+.IX Header "CONFIGURATION"
+.SS "General"
+.IX Subsection "General"
+.IP "\(bu" 4
+Start by adding check_policy_service after reject_unauth_destination in
+/etc/postfix/main.cf :
+.Sp
+.Vb 4
+\& smtpd_recipient_restrictions =
+\& ...
+\& reject_unauth_destination
+\& check_policy_service inet:127.0.0.1:2501
+.Ve
+.IP "\(bu" 4
+Be aware that some servers do not behave correctly and do not resend
+mails (as required by the standard) or use unique return addresses.
+This is the reason why you should maintain whitelists for them.
+.Sp
+SQLgrey comes with a comprehensive whitelisting system. It can
+even be configured to fetch up-to-date whitelists from a repository. See
+the \s-1HOWTO\s0 for the details.
+.SS "Disabling greylisting for some users"
+.IX Subsection "Disabling greylisting for some users"
+If you want to disable greylisting for some users you can configure
+Postfix like this:
+.PP
+/etc/postfix/sqlgrey_recipient_access:
+ i_like_spam@ee.ethz.ch \s-1OK\s0
+.PP
+Then you'll add a check_recipient_access in main.cf before the
+check_policy_service :
+ smtpd_recipient_restrictions =
+ ...
+ reject_unauth_destination
+ check_client_access hash:/etc/postfix/sqlgrey_client_access
+ check_recipient_access hash:/etc/postfix/sqlgrey_recipient_access
+ check_policy_service inet:127.0.0.1:10023
+.SH "SEE ALSO"
+.IX Header "SEE ALSO"
+See <http://www.greylisting.org/> for a description of what greylisting
+is and <http://www.postfix.org/SMTPD_POLICY_README.html> for a
+description of how Postfix policy servers work.
+.SH "COPYRIGHT"
+.IX Header "COPYRIGHT"
+Copyright (c) 2004 by Lionel Bouton.
+.SH "LICENSE"
+.IX Header "LICENSE"
+This program is free software; you can redistribute it and/or modify
+it under the terms of the \s-1GNU\s0 General Public License as published by
+the Free Software Foundation; either version 2 of the License, or
+(at your option) any later version.
+.PP
+This program is distributed in the hope that it will be useful,
+but \s-1WITHOUT\s0 \s-1ANY\s0 \s-1WARRANTY\s0; without even the implied warranty of
+\&\s-1MERCHANTABILITY\s0 or \s-1FITNESS\s0 \s-1FOR\s0 A \s-1PARTICULAR\s0 \s-1PURPOSE\s0. See the
+\&\s-1GNU\s0 General Public License for more details.
+.PP
+You should have received a copy of the \s-1GNU\s0 General Public License along
+with this program; if not, write to the Free Software Foundation, Inc.,
+59 Temple Place, Suite 330, Boston, \s-1MA\s0 02111\-1307 \s-1USA\s0
+.SH "AUTHOR"
+.IX Header "AUTHOR"
+Lionel\ Bouton\ <lionel\-dev@bouton.name>
--- sqlgrey-1.8.0rc2.orig/debian/sqlgrey-logstats.pl.1
+++ sqlgrey-1.8.0rc2/debian/sqlgrey-logstats.pl.1
@@ -0,0 +1,186 @@
+.\" Automatically generated by Pod::Man 2.22 (Pod::Simple 3.13)
+.\"
+.\" Standard preamble:
+.\" ========================================================================
+.de Sp \" Vertical space (when we can't use .PP)
+.if t .sp .5v
+.if n .sp
+..
+.de Vb \" Begin verbatim text
+.ft CW
+.nf
+.ne \\$1
+..
+.de Ve \" End verbatim text
+.ft R
+.fi
+..
+.\" Set up some character translations and predefined strings. \*(-- will
+.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
+.\" double quote, and \*(R" will give a right double quote. \*(C+ will
+.\" give a nicer C++. Capital omega is used to do unbreakable dashes and
+.\" therefore won't be available. \*(C` and \*(C' expand to `' in nroff,
+.\" nothing in troff, for use with C<>.
+.tr \(*W-
+.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
+.ie n \{\
+. ds -- \(*W-
+. ds PI pi
+. if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
+. if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch
+. ds L" ""
+. ds R" ""
+. ds C` ""
+. ds C' ""
+'br\}
+.el\{\
+. ds -- \|\(em\|
+. ds PI \(*p
+. ds L" ``
+. ds R" ''
+'br\}
+.\"
+.\" Escape single quotes in literal strings from groff's Unicode transform.
+.ie \n(.g .ds Aq \(aq
+.el .ds Aq '
+.\"
+.\" If the F register is turned on, we'll generate index entries on stderr for
+.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
+.\" entries marked with X<> in POD. Of course, you'll have to process the
+.\" output yourself in some meaningful fashion.
+.ie \nF \{\
+. de IX
+. tm Index:\\$1\t\\n%\t"\\$2"
+..
+. nr % 0
+. rr F
+.\}
+.el \{\
+. de IX
+..
+.\}
+.\"
+.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
+.\" Fear. Run. Save yourself. No user-serviceable parts.
+. \" fudge factors for nroff and troff
+.if n \{\
+. ds #H 0
+. ds #V .8m
+. ds #F .3m
+. ds #[ \f1
+. ds #] \fP
+.\}
+.if t \{\
+. ds #H ((1u-(\\\\n(.fu%2u))*.13m)
+. ds #V .6m
+. ds #F 0
+. ds #[ \&
+. ds #] \&
+.\}
+. \" simple accents for nroff and troff
+.if n \{\
+. ds ' \&
+. ds ` \&
+. ds ^ \&
+. ds , \&
+. ds ~ ~
+. ds /
+.\}
+.if t \{\
+. ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
+. ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
+. ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
+. ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
+. ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
+. ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
+.\}
+. \" troff and (daisy-wheel) nroff accents
+.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
+.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
+.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
+.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
+.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
+.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
+.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
+.ds ae a\h'-(\w'a'u*4/10)'e
+.ds Ae A\h'-(\w'A'u*4/10)'E
+. \" corrections for vroff
+.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
+.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
+. \" for low resolution devices (crt and lpr)
+.if \n(.H>23 .if \n(.V>19 \
+\{\
+. ds : e
+. ds 8 ss
+. ds o a
+. ds d- d\h'-1'\(ga
+. ds D- D\h'-1'\(hy
+. ds th \o'bp'
+. ds Th \o'LP'
+. ds ae ae
+. ds Ae AE
+.\}
+.rm #[ #] #H #V #F C
+.\" ========================================================================
+.\"
+.IX Title "sqlgrey-logstats.pl 1"
+.TH sqlgrey-logstats.pl 1 "2010-02-11" "perl v5.10.1" "User Contributed Perl Documentation"
+.\" For nroff, turn off justification. Always turn off hyphenation; it makes
+.\" way too many mistakes in technical documents.
+.if n .ad l
+.nh
+.SH "NAME"
+sqlgrey\-logstats.pl \- SQLgrey log parser
+.SH "SYNOPSIS"
+.IX Header "SYNOPSIS"
+\&\fBsqlgrey\-logstats.pl\fR [\fIoptions\fR...] < syslogfile
+.PP
+.Vb 4
+\& \-h, \-\-help display this help and exit
+\& \-\-man display man page
+\& \-\-version output version information and exit
+\& \-\-debug output detailed log parsing steps
+\&
+\& \-y, \-\-yesterday compute stats for yesterday
+\& \-t, \-\-today compute stats for today
+\& \-\-lasthour compute stats for last hour
+\& \-d, \-\-lastday compute stats for last 24 hours
+\& \-w, \-\-lastweek compute stats for last 7 days
+\&
+\& \-\-programname program name looked into log file
+\&
+\& \-\-top\-from how many from AWL entries to print (default: all)
+\& \-\-top\-domain how many domain AWL entries to print (default: all)
+\& \-\-top\-spam how many SPAM sources to print (default: all)
+\& \-\-top\-throttled how many throttled sources to print (default: all)
+\& \-\-print\-delayed print delayed sources (default: don\*(Aqt)
+.Ve
+.SH "DESCRIPTION"
+.IX Header "DESCRIPTION"
+sqlgrey\-logstats.pl ...
+.SH "SEE ALSO"
+.IX Header "SEE ALSO"
+See <http://www.greylisting.org/> for a description of what greylisting
+is and <http://www.postfix.org/SMTPD_POLICY_README.html> for a
+description of how Postfix policy servers work.
+.SH "COPYRIGHT"
+.IX Header "COPYRIGHT"
+Copyright (c) 2004 by Lionel Bouton.
+.SH "LICENSE"
+.IX Header "LICENSE"
+This program is free software; you can redistribute it and/or modify
+it under the terms of the \s-1GNU\s0 General Public License as published by
+the Free Software Foundation; either version 2 of the License, or
+(at your option) any later version.
+.PP
+This program is distributed in the hope that it will be useful,
+but \s-1WITHOUT\s0 \s-1ANY\s0 \s-1WARRANTY\s0; without even the implied warranty of
+\&\s-1MERCHANTABILITY\s0 or \s-1FITNESS\s0 \s-1FOR\s0 A \s-1PARTICULAR\s0 \s-1PURPOSE\s0. See the
+\&\s-1GNU\s0 General Public License for more details.
+.PP
+You should have received a copy of the \s-1GNU\s0 General Public License along
+with this program; if not, write to the Free Software Foundation, Inc.,
+59 Temple Place, Suite 330, Boston, \s-1MA\s0 02111\-1307 \s-1USA\s0
+.SH "AUTHOR"
+.IX Header "AUTHOR"
+Lionel\ Bouton\ <lionel\-dev@bouton.name>
--- sqlgrey-1.8.0rc2.orig/debian/sqlgrey-logstats.1
+++ sqlgrey-1.8.0rc2/debian/sqlgrey-logstats.1
@@ -0,0 +1,185 @@
+.\" Automatically generated by Pod::Man 2.1801 (Pod::Simple 3.07)
+.\"
+.\" Standard preamble:
+.\" ========================================================================
+.de Sp \" Vertical space (when we can't use .PP)
+.if t .sp .5v
+.if n .sp
+..
+.de Vb \" Begin verbatim text
+.ft CW
+.nf
+.ne \\$1
+..
+.de Ve \" End verbatim text
+.ft R
+.fi
+..
+.\" Set up some character translations and predefined strings. \*(-- will
+.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
+.\" double quote, and \*(R" will give a right double quote. \*(C+ will
+.\" give a nicer C++. Capital omega is used to do unbreakable dashes and
+.\" therefore won't be available. \*(C` and \*(C' expand to `' in nroff,
+.\" nothing in troff, for use with C<>.
+.tr \(*W-
+.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
+.ie n \{\
+. ds -- \(*W-
+. ds PI pi
+. if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
+. if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch
+. ds L" ""
+. ds R" ""
+. ds C` ""
+. ds C' ""
+'br\}
+.el\{\
+. ds -- \|\(em\|
+. ds PI \(*p
+. ds L" ``
+. ds R" ''
+'br\}
+.\"
+.\" Escape single quotes in literal strings from groff's Unicode transform.
+.ie \n(.g .ds Aq \(aq
+.el .ds Aq '
+.\"
+.\" If the F register is turned on, we'll generate index entries on stderr for
+.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
+.\" entries marked with X<> in POD. Of course, you'll have to process the
+.\" output yourself in some meaningful fashion.
+.ie \nF \{\
+. de IX
+. tm Index:\\$1\t\\n%\t"\\$2"
+..
+. nr % 0
+. rr F
+.\}
+.el \{\
+. de IX
+..
+.\}
+.\"
+.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
+.\" Fear. Run. Save yourself. No user-serviceable parts.
+. \" fudge factors for nroff and troff
+.if n \{\
+. ds #H 0
+. ds #V .8m
+. ds #F .3m
+. ds #[ \f1
+. ds #] \fP
+.\}
+.if t \{\
+. ds #H ((1u-(\\\\n(.fu%2u))*.13m)
+. ds #V .6m
+. ds #F 0
+. ds #[ \&
+. ds #] \&
+.\}
+. \" simple accents for nroff and troff
+.if n \{\
+. ds ' \&
+. ds ` \&
+. ds ^ \&
+. ds , \&
+. ds ~ ~
+. ds /
+.\}
+.if t \{\
+. ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
+. ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
+. ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
+. ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
+. ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
+. ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
+.\}
+. \" troff and (daisy-wheel) nroff accents
+.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
+.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
+.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
+.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
+.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
+.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
+.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
+.ds ae a\h'-(\w'a'u*4/10)'e
+.ds Ae A\h'-(\w'A'u*4/10)'E
+. \" corrections for vroff
+.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
+.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
+. \" for low resolution devices (crt and lpr)
+.if \n(.H>23 .if \n(.V>19 \
+\{\
+. ds : e
+. ds 8 ss
+. ds o a
+. ds d- d\h'-1'\(ga
+. ds D- D\h'-1'\(hy
+. ds th \o'bp'
+. ds Th \o'LP'
+. ds ae ae
+. ds Ae AE
+.\}
+.rm #[ #] #H #V #F C
+.\" ========================================================================
+.\"
+.IX Title "sqlgrey-logstats.pl 1"
+.TH sqlgrey-logstats.pl 1 "2009-02-08" "perl v5.10.0" "User Contributed Perl Documentation"
+.\" For nroff, turn off justification. Always turn off hyphenation; it makes
+.\" way too many mistakes in technical documents.
+.if n .ad l
+.nh
+.SH "NAME"
+sqlgrey\-logstats.pl \- SQLgrey log parser
+.SH "SYNOPSIS"
+.IX Header "SYNOPSIS"
+\&\fBsqlgrey\-logstats.pl\fR [\fIoptions\fR...] < syslogfile
+.PP
+.Vb 4
+\& \-h, \-\-help display this help and exit
+\& \-\-man display man page
+\& \-\-version output version information and exit
+\& \-\-debug output detailed log parsing steps
+\&
+\& \-y, \-\-yesterday compute stats for yesterday
+\& \-t, \-\-today compute stats for today
+\& \-\-lasthour compute stats for last hour
+\& \-d, \-\-lastday compute stats for last 24 hours
+\& \-w, \-\-lastweek compute stats for last 7 days
+\&
+\& \-\-programname program name looked into log file
+\&
+\& \-\-top\-from how many from AWL entries to print (default: all)
+\& \-\-top\-domain how many domain AWL entries to print (default: all)
+\& \-\-top\-spam how many SPAM sources to print (default: all)
+\& \-\-print\-delayed print delayed sources (default: don\*(Aqt)
+.Ve
+.SH "DESCRIPTION"
+.IX Header "DESCRIPTION"
+sqlgrey\-logstats.pl ...
+.SH "SEE ALSO"
+.IX Header "SEE ALSO"
+See <http://www.greylisting.org/> for a description of what greylisting
+is and <http://www.postfix.org/SMTPD_POLICY_README.html> for a
+description of how Postfix policy servers work.
+.SH "COPYRIGHT"
+.IX Header "COPYRIGHT"
+Copyright (c) 2004 by Lionel Bouton.
+.SH "LICENSE"
+.IX Header "LICENSE"
+This program is free software; you can redistribute it and/or modify
+it under the terms of the \s-1GNU\s0 General Public License as published by
+the Free Software Foundation; either version 2 of the License, or
+(at your option) any later version.
+.PP
+This program is distributed in the hope that it will be useful,
+but \s-1WITHOUT\s0 \s-1ANY\s0 \s-1WARRANTY\s0; without even the implied warranty of
+\&\s-1MERCHANTABILITY\s0 or \s-1FITNESS\s0 \s-1FOR\s0 A \s-1PARTICULAR\s0 \s-1PURPOSE\s0. See the
+\&\s-1GNU\s0 General Public License for more details.
+.PP
+You should have received a copy of the \s-1GNU\s0 General Public License along
+with this program; if not, write to the Free Software Foundation, Inc.,
+59 Temple Place, Suite 330, Boston, \s-1MA\s0 02111\-1307 \s-1USA\s0
+.SH "AUTHOR"
+.IX Header "AUTHOR"
+Lionel\ Bouton\ <lionel\-dev@bouton.name>
--- sqlgrey-1.8.0rc2.orig/debian/postinst
+++ sqlgrey-1.8.0rc2/debian/postinst
@@ -0,0 +1,60 @@
+#!/bin/sh
+# postinst script for sqlgrey
+#
+# see: dh_installdeb(1)
+
+set -e
+
+# summary of how this script can be called:
+# * <postinst> `configure' <most-recently-configured-version>
+# * <old-postinst> `abort-upgrade' <new version>
+# * <conflictor's-postinst> `abort-remove' `in-favour' <package>
+# <new-version>
+# * <postinst> `abort-remove'
+# * <deconfigured's-postinst> `abort-deconfigure' `in-favour'
+# <failed-install-package> <version> `removing'
+# <conflicting-package> <version>
+# for details, see http://www.debian.org/doc/debian-policy/ or
+# the debian-policy package
+
+
+case "$1" in
+ configure)
+ DBDIR='/var/lib/sqlgrey'
+
+ getent passwd sqlgrey > /dev/null || \
+ adduser --system --home "$DBDIR" --no-create-home \
+ --disabled-password --group sqlgrey
+
+ getent group sqlgrey > /dev/null || \
+ addgroup --system sqlgrey
+
+ chown sqlgrey /etc/sqlgrey/sqlgrey.conf
+ chgrp sqlgrey /etc/sqlgrey/sqlgrey.conf
+ chmod 0660 /etc/sqlgrey/sqlgrey.conf
+
+ if [ ! -e "$DBDIR" ]; then
+ mkdir -p "$DBDIR"
+ dpkg-statoverride --update --add \
+ sqlgrey sqlgrey 0700 "$DBDIR"
+ fi
+
+ ;;
+
+ abort-upgrade|abort-remove|abort-deconfigure)
+ ;;
+
+ *)
+ echo "postinst called with unknown argument \`$1'" >&2
+ exit 1
+ ;;
+esac
+
+# dh_installdeb will replace this with shell code automatically
+# generated by other debhelper scripts.
+
+#DEBHELPER#
+
+exit 0
+
+
--- sqlgrey-1.8.0rc2.orig/debian/update_sqlgrey_config.1
+++ sqlgrey-1.8.0rc2/debian/update_sqlgrey_config.1
@@ -0,0 +1,16 @@
+.TH UPDATE_SQLGREY_CONFIG "1" "Feb 2010" "Antonin Kral" "sqlgrey"
+.SH "NAME"
+update_sqlgrey_config \- the simple white\-list updater
+.SH "SYNOPSIS"
+\fBupdate_sqlgrey_config
+.SH "DESCRIPTION"
+.PP
+\fBupdate_sqlgrey_config\fR
+is a simple bash script, which downloads white\-list file from defined web server (sqlgrey.bouton.name is used by default). Host could be changed in sqlgrey.conf.
+.PP
+Beware of the fact that script will overwrite any local changes.
+.SH "COPYRIGHT"
+.PP
+Copyright 2010 Antonin Kral
+.SH "AUTHOR"
+Antonin Kral
![[patchlogo]](http://patch-tracker.debian.org/static/img/swirlpatch.png)