FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

I am looking for an LTO tape library. Do you have one to spare?
Port details
sqlgrey 1.8.0_1 mail on this many watch lists=10 search for ports that depend on this port
Greylisting policy server for Postfix using an SQL backend

There is no maintainer for this port.
Any concerns regarding this port should be directed to the FreeBSD Ports mailing list via ports@FreeBSD.org search for ports maintained by this maintainer
Port Added: 18 Feb 2005 11:40:09
License: GPLv2


SQLgrey is a postfix policy service implementing a grey-listing policy.

SQLgrey is written in Perl and uses DBI to access an SQL database.

Its goal is reducing the SPAM reaching user mailboxes

WWW: http://sqlgrey.sourceforge.net/
SVNWeb : Main Web Site : Distfiles Availability : PortsMon

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Required To Run:
  1. net/p5-Net-Server
  2. devel/p5-IO-Multiplex
  3. textproc/p5-Pod-Parser
  4. databases/p5-DBD-Pg
  5. lang/perl5.16
There are no ports dependent upon this port

To install the port: cd /usr/ports/mail/sqlgrey/ && make install clean
To add the package: pkg install mail/sqlgrey


Configuration Options
===> The following configuration options are available for sqlgrey-1.8.0_1:
     DOCS=on: Build and/or install documentation
     MYSQL=off: MySQL database support
     PGSQL=on: PostgreSQL database support
     SQLITE=off: SQLite database support
     STATS=off: Depend on Date::Calc for logstats.pl script
===> Use 'make config' to modify these settings

Master Sites:
  1. http://aarnet.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  2. http://distcache.FreeBSD.org/ports-distfiles/
  3. http://downloads.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  4. http://freefr.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  5. http://garr.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  6. http://heanet.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  7. http://hivelocity.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  8. http://ignum.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  9. http://internode.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  10. http://iweb.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  11. http://jaist.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  12. http://kaz.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  13. http://kent.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  14. http://master.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  15. http://nchc.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  16. http://ncu.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  17. http://netcologne.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  18. http://sunet.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  19. http://superb-dca3.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  20. http://switch.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  21. http://tenet.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  22. http://ufpr.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/
  23. http://waix.dl.sourceforge.net/project/sqlgrey/sqlgrey-1.8%20%28stable%29/

Number of commits found: 34

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
04 Sep 2014 11:56:46
Original commit files touched by this commit  1.8.0_1
Revision:367260
feld search for other commits by this committer
License is supposed to have a lower case "v" or some build
environments will error with:

 License GPLV2 needs confirmation, but BATCH is defined

as it will be an unrecognized license.
03 Sep 2014 20:49:19
Original commit files touched by this commit  1.8.0_1
Revision:367233
feld search for other commits by this committer
Revive from the dead. This port is too important to let slip through the
cracks.

- Support STAGE
- Appease rclint and portlint
- Remove pkg-install. We can do this in @unexec and rc script.
- Set a default database option -- PGSQL will be default as recommended
upstream.
- Use new @sample capability
- SHEBANGFIX

Sponsored by:	SupraNet Communications, Inc
01 Sep 2014 21:26:00
Original commit files touched by this commit  1.8.0_1
Revision:366959
bapt search for other commits by this committer
Remove non staged ports without pending PR from ma*
04 Jul 2014 09:12:57
Original commit files touched by this commit  1.8.0_1
Revision:360579
bapt search for other commits by this committer
Resetting maintainership on ports that have not been staged and without any
pending PR (related to stage)

With hat:	portmgr
06 Dec 2013 16:59:37
Original commit files touched by this commit  1.8.0_1
Revision:335776
feld search for other commits by this committer
Import patch to fix IPv6 greylisting

This patch is floating in the bug system on SourceForge. Upstream
develoment is slow/nonexistent.

If you have IPv6 mail servers and run sqlgrey you may notice emails from
places like GMail sometimes get lost or take forever to get be received.
This is because GMail does not retry from the same server, and they have
a large pool of IPv6 capable MTAs. For IPv4 sqlgrey handles this by
whitelisting the entire /24, but similar logic for whitelisting a /64 in
sqlgrey doesn't work consistently. This fixes it.

PR:		ports/182440
Approved by:	crees (mentor), maintainer timeout
20 Sep 2013 19:59:14
Original commit files touched by this commit  1.8.0
Revision:327742
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
mail)
15 Sep 2013 08:15:42
Original commit files touched by this commit  1.8.0
Revision:327334
az search for other commits by this committer
- convert to the new perl5 framework
- convert USE_GMAKE to Uses

Approved by:	portmgr (bapt@, blanket)
04 Jun 2013 10:32:49
Refresh Original commit files touched by this commit
Revision:319851  Sanity Test Failure
bapt search for other commits by this committer
Convert to new options framework
30 Jun 2012 13:10:10
Original commit files touched by this commit  1.8.0
az search for other commits by this committer
- Remove SITE_PERL from *_DEPENDS

Approved by: portmgr@ (bapt@)
14 Feb 2012 10:47:37
Original commit files touched by this commit  1.8.0
mm search for other commits by this committer
Update SQLgrey to 1.8.0
Use UIDs/GIDs infractructure (new uid/gid 226)

PR:             ports/165103
Approved by:    maintainer
14 Jan 2012 08:57:23
Original commit files touched by this commit  1.8.0.r2
dougb search for other commits by this committer
In the rc.d scripts, change assignments to rcvar to use the
literal name_enable wherever possible, and ${name}_enable
when it's not, to prepare for the demise of set_rcvar().

In cases where I had to hand-edit unusual instances also
modify formatting slightly to be more uniform (and in
some cases, correct). This includes adding some $FreeBSD$
tags, and most importantly moving rcvar= to right after
name= so it's clear that one is derived from the other.
03 Jun 2011 21:35:32
Original commit files touched by this commit  1.7.6
wxs search for other commits by this committer
Add corrections in RC script from Doug.

Submitted by:   dougb@
03 Jun 2011 11:25:11
Original commit files touched by this commit  1.8.0.r2
wxs search for other commits by this committer
- Update to 1.8.0rc2.
- Rename RC script.

PR:             ports/157485
Submitted by:   Ryan Steinmetz (rpsfa@rit.edu)
Approved by:    chifeng <chifeng@gmail.com> (maintainer)
27 Mar 2010 00:15:24
Original commit files touched by this commit  1.7.6
dougb search for other commits by this committer
Begin the process of deprecating sysutils/rc_subr by
s#. %%RC_SUBR%%#. /etc/rc.subr#
09 Nov 2009 08:15:15
Original commit files touched by this commit  1.7.6
arved search for other commits by this committer
Fix dependency

PR:             140102
Submitted by:   Frank Wall <fw@moov.de>
Approved by:    maintainer
22 Aug 2009 00:28:34
Original commit files touched by this commit  1.7.6
  Sanity Test Failure
amdmi3 search for other commits by this committer
- Switch SourceForge ports to the new File Release System: categories starting
with M
17 Feb 2009 02:56:32
Original commit files touched by this commit  1.7.6
tabthorpe search for other commits by this committer
- Pass maintainership to submitter

Submitted by:   chifeng via freebsd-ports@
05 Feb 2008 13:48:12
Original commit files touched by this commit  1.7.6
miwi search for other commits by this committer
- Update to 1.7.6

PR:             120259
Submitted by:   bartlomiej.syryjczyk@expro.pl
09 Apr 2007 12:21:51
Original commit files touched by this commit  1.7.5
clsung search for other commits by this committer
- Update to 1.7.5
07 Apr 2007 15:21:24
Original commit files touched by this commit  1.7.4
pav search for other commits by this committer
- Convert to OPTIONS
- Add optional rundep on Date::Calc for sqlgrey-logstats.pl script

Requested by:   Miroslav Lachman <000.fbsd@quip.cz>
04 Apr 2007 17:39:14
Original commit files touched by this commit  1.7.4
gabor search for other commits by this committer
- Remove old Perl support from unmaintained ports in categories starting
  with letter k-n
06 Nov 2006 19:46:25
Original commit files touched by this commit  1.7.4
alepulver search for other commits by this committer
- Typo in Makefile (RUN_DEPENDS) prevent mail/sqlgrey from install with
  pgsql support.
- Some cosmetic cleanup patch for fresh install.

PR:             ports/104881
Submitted by:   Olli Hauer <ohauer@gmx.de>
16 Sep 2006 20:54:19
Original commit files touched by this commit  1.7.4
miwi search for other commits by this committer
- Update to 1.7.4
26 Jan 2006 08:30:23
Original commit files touched by this commit  1.7.3
dougb search for other commits by this committer
Unbreak by removing manual attempt to install rc.d script,
and a few other fixes.

Pet portlint.
25 Jan 2006 22:52:24
Original commit files touched by this commit  1.7.3
kris search for other commits by this committer
BROKEN: Uses USE_RC_SUBR incorrectly; incorrect pkg-plist
22 Jan 2006 02:20:05
Original commit files touched by this commit  1.7.3
edwin search for other commits by this committer
Replace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtry

Approved by:    krion@
PR:             ports/88711 (related)
26 Nov 2005 10:22:08
Original commit files touched by this commit  1.7.3
edwin search for other commits by this committer
Upgrade to 1.7.3
23 Nov 2005 17:22:15
Original commit files touched by this commit  1.6.7
mat search for other commits by this committer
Update to 1.6.7
give back to ports@ (ENOTIME)

PR:             89418
Submitted by:   den
14 Nov 2005 14:16:12
Original commit files touched by this commit  1.4.8
mat search for other commits by this committer
Be hipe and add SHA256
06 Jul 2005 17:05:15
Original commit files touched by this commit  1.4.8
pav search for other commits by this committer
- Update to 1.4.8

PR:             ports/82318
Submitted by:   Alex Kapranoff <kappa@rambler-co.ru>
Approved by:    mat (maintainer)
11 Jun 2005 16:13:12
Original commit files touched by this commit  1.4.5_2
skv search for other commits by this committer
* reflect renaming on CPAN File-Spec to PathTools
   + add devel/p5-PathTools, remove devel/p5-File-Spec
   + update dependencies for all affected ports (make them unconditional),
     bump PORTREVISION for these ports
module was renamed
* reflect renaming on CPAN PodParser to Pod-Parser
   + add textproc/p5-Pod-Parser, remove textproc/p5-PodParser
   + update dependencies for all affected ports (make them unconditional),
     bump PORTREVISION for these ports

* for all changed ports make dependencies on File::Temp, Digest::MD5,
  Storable unconditional

* remove 'CONFIGURE_ARGS= INSTALLDIRS=site' from Makefile's
  (this variable is forced by bsd.port.mk now)

* update Class-Autouse to 1.17

* update POE-API-Hooks to 1.05

* make portlint happy (clean IGNORE, convert spaces to tabs and so on)
23 May 2005 14:27:20
Original commit files touched by this commit  1.4.5_1
mat search for other commits by this committer
Fix sqlgrey.conf's path in sqlgrey.sh [1]
fixup a few other things while I'm there
bump PORTREVISION

Poked by: flz [1]
21 Feb 2005 17:16:50
Original commit files touched by this commit  1.4.5
mat search for other commits by this committer
Don't mix SUB_LIST and PLIST_SUB, it's a bad idea [1] :-)
+ minor fix in the Makefile

Pointed out by: [1] kris via pointyhat
18 Feb 2005 11:39:31
Original commit files touched by this commit  1.4.5
mat search for other commits by this committer
Add sqlgrey 1.4.5, greylisting policy server for Postfix using an SQL backend.

Number of commits found: 34

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
phpmyadminOct 22
asterisk11Oct 21
libxml2Oct 18
drupal7Oct 16
firefox*Oct 16
firefox-esr*Oct 16
libxul*Oct 16
linux-firefox*Oct 16
linux-seamonkey*Oct 16
linux-thunderbird*Oct 16
seamonkey*Oct 16
thunderbird*Oct 16
linux-c6-opensslOct 15
mingw32-opensslOct 15
opensslOct 15

8 vulnerabilities affecting 30 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds


Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 24265
Broken 100
Deprecated 30
Ignore 357
Forbidden 2
Restricted 205
No CDROM 93
Vulnerable 18
Expired 0
Set to expire 26
Interactive 0
new 24 hours 1
new 48 hours5
new 7 days24
new fortnight44
new month174

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2014 Dan Langille. All rights reserved.