head 1.2; access; symbols pkgsrc-2026Q1:1.2.0.80 pkgsrc-2026Q1-base:1.2 pkgsrc-2025Q4:1.2.0.78 pkgsrc-2025Q4-base:1.2 pkgsrc-2025Q3:1.2.0.76 pkgsrc-2025Q3-base:1.2 pkgsrc-2025Q2:1.2.0.74 pkgsrc-2025Q2-base:1.2 pkgsrc-2025Q1:1.2.0.72 pkgsrc-2025Q1-base:1.2 pkgsrc-2024Q4:1.2.0.70 pkgsrc-2024Q4-base:1.2 pkgsrc-2024Q3:1.2.0.68 pkgsrc-2024Q3-base:1.2 pkgsrc-2024Q2:1.2.0.66 pkgsrc-2024Q2-base:1.2 pkgsrc-2024Q1:1.2.0.64 pkgsrc-2024Q1-base:1.2 pkgsrc-2023Q4:1.2.0.62 pkgsrc-2023Q4-base:1.2 pkgsrc-2023Q3:1.2.0.60 pkgsrc-2023Q3-base:1.2 pkgsrc-2023Q2:1.2.0.58 pkgsrc-2023Q2-base:1.2 pkgsrc-2023Q1:1.2.0.56 pkgsrc-2023Q1-base:1.2 pkgsrc-2022Q4:1.2.0.54 pkgsrc-2022Q4-base:1.2 pkgsrc-2022Q3:1.2.0.52 pkgsrc-2022Q3-base:1.2 pkgsrc-2022Q2:1.2.0.50 pkgsrc-2022Q2-base:1.2 pkgsrc-2022Q1:1.2.0.48 pkgsrc-2022Q1-base:1.2 pkgsrc-2021Q4:1.2.0.46 pkgsrc-2021Q4-base:1.2 pkgsrc-2021Q3:1.2.0.44 pkgsrc-2021Q3-base:1.2 pkgsrc-2021Q2:1.2.0.42 pkgsrc-2021Q2-base:1.2 pkgsrc-2021Q1:1.2.0.40 pkgsrc-2021Q1-base:1.2 pkgsrc-2020Q4:1.2.0.38 pkgsrc-2020Q4-base:1.2 pkgsrc-2020Q3:1.2.0.36 pkgsrc-2020Q3-base:1.2 pkgsrc-2020Q2:1.2.0.32 pkgsrc-2020Q2-base:1.2 pkgsrc-2020Q1:1.2.0.12 pkgsrc-2020Q1-base:1.2 pkgsrc-2019Q4:1.2.0.34 pkgsrc-2019Q4-base:1.2 pkgsrc-2019Q3:1.2.0.30 pkgsrc-2019Q3-base:1.2 pkgsrc-2019Q2:1.2.0.28 pkgsrc-2019Q2-base:1.2 pkgsrc-2019Q1:1.2.0.26 pkgsrc-2019Q1-base:1.2 pkgsrc-2018Q4:1.2.0.24 pkgsrc-2018Q4-base:1.2 pkgsrc-2018Q3:1.2.0.22 pkgsrc-2018Q3-base:1.2 pkgsrc-2018Q2:1.2.0.20 pkgsrc-2018Q2-base:1.2 pkgsrc-2018Q1:1.2.0.18 pkgsrc-2018Q1-base:1.2 pkgsrc-2017Q4:1.2.0.16 pkgsrc-2017Q4-base:1.2 pkgsrc-2017Q3:1.2.0.14 pkgsrc-2017Q3-base:1.2 pkgsrc-2017Q2:1.2.0.10 pkgsrc-2017Q2-base:1.2 pkgsrc-2017Q1:1.2.0.8 pkgsrc-2017Q1-base:1.2 pkgsrc-2016Q4:1.2.0.6 pkgsrc-2016Q4-base:1.2 pkgsrc-2016Q3:1.2.0.4 pkgsrc-2016Q3-base:1.2 pkgsrc-2016Q2:1.2.0.2 pkgsrc-2016Q2-base:1.2 pkgsrc-2016Q1:1.1.1.1.0.72 pkgsrc-2016Q1-base:1.1.1.1 pkgsrc-2015Q4:1.1.1.1.0.70 pkgsrc-2015Q4-base:1.1.1.1 pkgsrc-2015Q3:1.1.1.1.0.68 pkgsrc-2015Q3-base:1.1.1.1 pkgsrc-2015Q2:1.1.1.1.0.66 pkgsrc-2015Q2-base:1.1.1.1 pkgsrc-2015Q1:1.1.1.1.0.64 pkgsrc-2015Q1-base:1.1.1.1 pkgsrc-2014Q4:1.1.1.1.0.62 pkgsrc-2014Q4-base:1.1.1.1 pkgsrc-2014Q3:1.1.1.1.0.60 pkgsrc-2014Q3-base:1.1.1.1 pkgsrc-2014Q2:1.1.1.1.0.58 pkgsrc-2014Q2-base:1.1.1.1 pkgsrc-2014Q1:1.1.1.1.0.56 pkgsrc-2014Q1-base:1.1.1.1 pkgsrc-2013Q4:1.1.1.1.0.54 pkgsrc-2013Q4-base:1.1.1.1 pkgsrc-2013Q3:1.1.1.1.0.52 pkgsrc-2013Q3-base:1.1.1.1 pkgsrc-2013Q2:1.1.1.1.0.50 pkgsrc-2013Q2-base:1.1.1.1 pkgsrc-2013Q1:1.1.1.1.0.48 pkgsrc-2013Q1-base:1.1.1.1 pkgsrc-2012Q4:1.1.1.1.0.46 pkgsrc-2012Q4-base:1.1.1.1 pkgsrc-2012Q3:1.1.1.1.0.44 pkgsrc-2012Q3-base:1.1.1.1 pkgsrc-2012Q2:1.1.1.1.0.42 pkgsrc-2012Q2-base:1.1.1.1 pkgsrc-2012Q1:1.1.1.1.0.40 pkgsrc-2012Q1-base:1.1.1.1 pkgsrc-2011Q4:1.1.1.1.0.38 pkgsrc-2011Q4-base:1.1.1.1 pkgsrc-2011Q3:1.1.1.1.0.36 pkgsrc-2011Q3-base:1.1.1.1 pkgsrc-2011Q2:1.1.1.1.0.34 pkgsrc-2011Q2-base:1.1.1.1 pkgsrc-2011Q1:1.1.1.1.0.32 pkgsrc-2011Q1-base:1.1.1.1 pkgsrc-2010Q4:1.1.1.1.0.30 pkgsrc-2010Q4-base:1.1.1.1 pkgsrc-2010Q3:1.1.1.1.0.28 pkgsrc-2010Q3-base:1.1.1.1 pkgsrc-2010Q2:1.1.1.1.0.26 pkgsrc-2010Q2-base:1.1.1.1 pkgsrc-2010Q1:1.1.1.1.0.24 pkgsrc-2010Q1-base:1.1.1.1 pkgsrc-2009Q4:1.1.1.1.0.22 pkgsrc-2009Q4-base:1.1.1.1 pkgsrc-2009Q3:1.1.1.1.0.20 pkgsrc-2009Q3-base:1.1.1.1 pkgsrc-2009Q2:1.1.1.1.0.18 pkgsrc-2009Q2-base:1.1.1.1 pkgsrc-2009Q1:1.1.1.1.0.16 pkgsrc-2009Q1-base:1.1.1.1 pkgsrc-2008Q4:1.1.1.1.0.14 pkgsrc-2008Q4-base:1.1.1.1 pkgsrc-2008Q3:1.1.1.1.0.12 pkgsrc-2008Q3-base:1.1.1.1 cube-native-xorg:1.1.1.1.0.10 cube-native-xorg-base:1.1.1.1 pkgsrc-2008Q2:1.1.1.1.0.8 pkgsrc-2008Q2-base:1.1.1.1 cwrapper:1.1.1.1.0.6 pkgsrc-2008Q1:1.1.1.1.0.4 pkgsrc-2008Q1-base:1.1.1.1 pkgsrc-2007Q4:1.1.1.1.0.2 pkgsrc-2007Q4-base:1.1.1.1 pkgsrc-base:1.1.1.1 TNF:1.1.1; locks; strict; comment @# @; 1.2 date 2016.05.25.21.39.44; author fhajny; state Exp; branches; next 1.1; commitid ph41ZsOMQfPVtU7z; 1.1 date 2007.11.13.16.43.04; author ghen; state Exp; branches 1.1.1.1; next ; 1.1.1.1 date 2007.11.13.16.43.04; author ghen; state Exp; branches; next ; desc @@ 1.2 log @Update sqlgrey to 1.8.0. Add SMF support, clean up etc. * Mon Feb 13 2012 Martin Matuska - 1.8.0 release - Allow to specify complete DSN in configuration file - Support listening on UNIX sockets - Support pidfile command line argument * Mon Feb 01 2010 Michal Ludvig - Upgraded VERSION to 1.8.0-rc2 - Reverted GNU sed syntax in Makefile * Sat Jan 23 2010 Michal Ludvig - Upgraded VERSION to 1.8.0-rc1 - 'make dist' now creates sqlgrey-$VERSION.tar.gz with the help of 'git archive' * Mon Aug 17 2009 Michal Ludvig - 1.7.7 release getting ready - Reworked "smart"/"class-c" IPv6 address handling. - Added IPv6 address support for clients_ip_whitelist(.local) file - client_ip_whitelist(.local) now supports address/prefix notation both for IPv4 and IPv6 addresses. * Sun Aug 05 2007 Lionel Bouton - 1.7.6 release - Database handling fix (deactivated InactiveDestroy unless needed) - Reopen database connection on SIGUSR1 * Thu Feb 15 2007 Dan Faerch - 1.7.5 release - Changed db_cleanup. clean time stored in db for better handling, especially in clustered environments - Fix for harmless warnings about "possible typo" - Fix for sqlgrey dying if syslog is offline - Filled feature req from Riaan Kok. Support "postfix attributes on both sides".. Ie: "client_name !~ helo_name" * Sun Aug 03 2006 Dan Faerch - 1.7.4 release - Added feature Discrimination - Added feature DBCluster - Added config option reject_code (eg. answer 451 instead of 450) * Wed Nov 16 2005 Lionel Bouton - 1.7.3 release - fixes for a crash with '*' in email adresses * Tue Oct 25 2005 Lionel Bouton - 1.7.2 release - fixes for several errors in logging - clean_method ported from 1.6.x * Thu Sep 15 2005 Lionel Bouton - 1.7.1 release - fix for a race condition in multiple instances configurations - fix for weekly stats * Tue Jun 21 2005 Lionel Bouton - 1.7.0 release - now continue if the DB isn't available at startup time - based on 1.6.0 with Michel Bouissou's work: . better connect cleanup when creating AWL entries . source IP throttling @ text @$NetBSD: patch-ad,v 1.1.1.1 2007/11/13 16:43:04 ghen Exp $ Default dirs. --- etc/sqlgrey.conf.orig 2012-02-13 16:54:08.000000000 +0000 +++ etc/sqlgrey.conf @@@@ -7,7 +7,7 @@@@ # - SQLgrey uses a specific config file when called with -f ## Configuration files -# conf_dir = /etc/sqlgrey +# conf_dir = @@PKG_SYSCONFDIR@@ ## Log level # Uncomment to change the log level (default is normal: 2) @@@@ -59,8 +59,8 @@@@ # log_ident = ## username and groupname the daemon runs as -# user = sqlgrey -# group = sqlgrey +# user = @@SQLGREY_USER@@ +# group = @@SQLGREY_GROUP@@ ## Socket # On which socket do SQLgrey wait for queries @@@@ -73,7 +73,7 @@@@ ## PID # where to store the process PID -# pidfile = /var/run/sqlgrey.pid +# pidfile = @@SQLGREY_PIDDIR@@/sqlgrey.pid ## Greylisting delays # If you want to be really strict (RFC-wise) use these @ 1.1 log @Initial revision @ text @d1 1 a1 1 $NetBSD$ d3 3 a5 1 --- etc/sqlgrey.conf.orig 2005-12-20 11:41:30.000000000 +0100 d12 1 a12 1 +# conf_dir = %%PKG_SYSCONFDIR%% d22 2 a23 2 +# user = %%SQLGREY_USER%% +# group = %%SQLGREY_GROUP%% d27 1 a27 1 @@@@ -75,7 +75,7 @@@@ d29 4 a32 4 ## Config directory # where to look for other configuration files (whitelists) -# confdir = /etc/sqlgrey +# confdir = %%PKG_SYSCONFDIR%% @ 1.1.1.1 log @Import sqlgrey-1.6.8 package as requested by Petr Janda on pkgsrc-users list. SQLgrey is a postfix policy service implementing a greylisting policy. It is written in Perl and uses DBI to access an SQL database. Its goal is reducing the SPAM reaching user mailboxes. @ text @@