Name: sqlgrey
Version: 1.8.0
Release: 4%{?dist}
Summary: Postfix grey-listing policy service
Group: System Environment/Daemons
License: GPLv2+
URL: http://sqlgrey.sourceforge.net/
Source0: http://dl.sourceforge.net/sqlgrey/sqlgrey-%{version}.tar.gz
Source1: sqlgrey.service
Patch0: sqlgrey-1.7.4-sqlite.patch
Patch1: sqlgrey-1.7.4-warnings.patch
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n)
BuildArch: noarch
Requires: postfix
Requires: perl(DBD::SQLite)
#Requires(post): /sbin/chkconfig
#Requires(post): /sbin/service
#Requires(preun): /sbin/chkconfig
#Requires(preun): /sbin/service
#Requires(postun): /sbin/service
Requires(post): systemd-units
Requires(preun): systemd-units
Requires(postun): systemd-units
%description
SQLgrey is a Postfix grey-listing policy service with auto-white-listing
written in Perl with SQL database as storage backend. Greylisting stops 50
to 90% of junk mails (spam and virus) before they reach your Postfix server
(saves BW, user time and CPU time).
%prep
%setup -q
%patch0 -p1
%patch1 -p1
%build
make
%install
rm -rf $RPM_BUILD_ROOT
make rh-install ROOTDIR=$RPM_BUILD_ROOT
install -D -m 644 %{SOURCE1} $RPM_BUILD_ROOT%{_unitdir}/sqlgrey.service
rm -rf $RPM_BUILD_ROOT%{_sysconfdir}/init.d/
mkdir -p -m 755 $RPM_BUILD_ROOT%{_var}/lib
mkdir -m 750 $RPM_BUILD_ROOT%{_var}/lib/sqlgrey
touch $RPM_BUILD_ROOT%{_var}/lib/sqlgrey/sqlgrey.db
%clean
rm -rf $RPM_BUILD_ROOT
%files
%defattr(-,root,root,-)
%doc Changelog CONTRIB COPYING FAQ HOWTO README* TODO
%{_unitdir}/sqlgrey.service
%{_sbindir}/sqlgrey
%{_sbindir}/update_sqlgrey_config
%{_bindir}/sqlgrey-logstats.pl
%{_mandir}/man1/sqlgrey.1*
%attr(-,sqlgrey,sqlgrey) %dir %{_var}/lib/sqlgrey
%attr(-,sqlgrey,sqlgrey) %ghost %{_var}/lib/sqlgrey/sqlgrey.db
%dir %{_sysconfdir}/sqlgrey
%config(noreplace) %{_sysconfdir}/sqlgrey/sqlgrey.conf
# Content of these files are changed by sqlgrey itself
%config(noreplace) %{_sysconfdir}/sqlgrey/clients_ip_whitelist
%config(noreplace) %{_sysconfdir}/sqlgrey/clients_fqdn_whitelist
%config(noreplace) %{_sysconfdir}/sqlgrey/*.regexp
# Warning admins to not touch the above files
%attr(644,root,root) %config %{_sysconfdir}/sqlgrey/README
%pre
if ! id sqlgrey &>/dev/null ; then
/usr/sbin/groupadd -r sqlgrey || :
/usr/sbin/useradd -r -s /sbin/nologin -d /var/lib/sqlgrey -M \
-c 'SQLgrey Server' -g sqlgrey sqlgrey || :
fi
%post
#/sbin/chkconfig --add sqlgrey || :
#/sbin/service sqlgrey condrestart || :
if [ $1 -eq 1 ] ; then
# Initial installation
/bin/systemctl daemon-reload >/dev/null 2>&1 || :
fi
%preun
#if [ "$1" -eq 0 ]; then
# /sbin/service sqlgrey stop || :
# /sbin/chkconfig --del sqlgrey || :
#fi
if [ $1 -eq 0 ] ; then
# Package removal, not upgrade
/bin/systemctl --no-reload disable sqlgrey.service > /dev/null 2>&1 || :
/bin/systemctl stop sqlgrey.service > /dev/null 2>&1 || :
fi
%postun
/bin/systemctl daemon-reload >/dev/null 2>&1 || :
if [ $1 -ge 1 ] ; then
# Package upgrade, not uninstall
/bin/systemctl try-restart sqlgrey.service >/dev/null 2>&1 || :
fi
%triggerun -- sqlgrey < 1.8.0-1
# Save the current service runlevel info
# User must manually run systemd-sysv-convert --apply sqlgrey
# to migrate them to systemd targets
/usr/bin/systemd-sysv-convert --save sqlgrey >/dev/null 2>&1 ||:
# Run these because the SysV package being removed won't do them
/sbin/chkconfig --del sqlgrey >/dev/null 2>&1 || :
/bin/systemctl try-restart sqlgrey.service >/dev/null 2>&1 || :
%changelog
* Mon Feb 25 2013 Tom Callaway <spot@fedoraproject.org> - 1.8.0-4
- Specify SQLite database by absolute path (Bojan Smojver)
* Fri Feb 15 2013 Fedora Release Engineering <rel-eng@lists.fedoraproject.org> - 1.8.0-3
- Rebuilt for https://fedoraproject.org/wiki/Fedora_19_Mass_Rebuild
* Sat Jul 21 2012 Fedora Release Engineering <rel-eng@lists.fedoraproject.org> - 1.8.0-2
- Rebuilt for https://fedoraproject.org/wiki/Fedora_18_Mass_Rebuild
* Tue Apr 17 2012 Jon Ciesla <limburgher@gmail.com> - 1.8.0-1
- Latest upstream.
- Migrate to ssytemd, BZ 722356.
* Sat Jan 14 2012 Fedora Release Engineering <rel-eng@lists.fedoraproject.org> - 1.7.6-5
- Rebuilt for https://fedoraproject.org/wiki/Fedora_17_Mass_Rebuild
* Wed Feb 09 2011 Fedora Release Engineering <rel-eng@lists.fedoraproject.org> - 1.7.6-4
- Rebuilt for https://fedoraproject.org/wiki/Fedora_15_Mass_Rebuild
* Sun Jul 26 2009 Fedora Release Engineering <rel-eng@lists.fedoraproject.org> - 1.7.6-3
- Rebuilt for https://fedoraproject.org/wiki/Fedora_12_Mass_Rebuild
* Wed Feb 25 2009 Fedora Release Engineering <rel-eng@lists.fedoraproject.org> - 1.7.6-2
- Rebuilt for https://fedoraproject.org/wiki/Fedora_11_Mass_Rebuild
* Fri Sep 5 2008 Tom "spot" Callaway <tcallawa@redhat.com> 1.7.6-1
- fix license tag
- update to 1.7.6
* Mon Mar 12 2007 Steven Pritchard <steve@kspei.com> 1.7.5-1
- Update to 1.7.5
- Drop fedora-usermgmt requirement
- Don't remove the sqlgrey user on uninstall
* Thu Dec 14 2006 Steven Pritchard <steve@kspei.com> 1.7.4-5
- Add missing echos to init script
* Wed Dec 13 2006 Steven Pritchard <steve@kspei.com> 1.7.4-4
- Add more docs
* Tue Dec 12 2006 Steven Pritchard <steve@kspei.com> 1.7.4-3
- Change default database to SQLite
- Require DBD::SQLite
- Own (ghost) SQLite db file
- Clean up post/postun scripts a bit
- Quiet bogus variable used once warnings
* Tue Aug 29 2006 Steven Pritchard <steve@kspei.com> 1.7.4-2
- Change home directory to /var/lib/sqlgrey and create it
- Include our own init script
- Explicitly require postfix
- Drop inconsistent name macro usage
* Tue Aug 29 2006 Steven Pritchard <steve@kspei.com> 1.7.4-1
- Update to 1.7.4
- Own _sysconfdir/sqlgrey and all .regexp files in it
- Handle the service in post/preun/postun scripts
- Random spec cleanup
* Mon Apr 17 2006 Warren Togami <wtogami@redhat.com> 1.7.3-2
- Convert to fedora-usermgmt
- Spec cleanup to Fedora guidelines
* Wed Nov 16 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.7.3 release
- fixes for a crash with '*' in email adresses
* Tue Oct 25 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.7.2 release
- fixes for several errors in logging
- clean_method ported from 1.6.x
* Thu Sep 15 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.7.1 release
- fix for race condition in multiple instances configurations
- fix for weekly stats
* Tue Jun 21 2005 Lionel Bouton <lionel-dev@bouton.name>
- 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
* Thu Jun 16 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.6.0 release
- fix for alternate conf_dir
- fix for timestamp handling in log parser
- log parser cleanup
- added README.PERF and documentation cleanup
* Tue Jun 07 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.9 release
- fix for MySQL's mishandling of timestamps
- better log parser
* Thu Jun 02 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.8 release
- fix for Makefile: rpmbuild didn't work
* Wed Jun 01 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.7 release
- fix for a memory leak
- config directory now user-configurable
- preliminary log analyser
* Mon May 02 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.6 release
- fix for MySQL disconnection crash
- IPv6 support
- Optin/optout support
* Tue Apr 25 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.5 release
- small fix for SRS (again!)
- small fix for deverp code
- log types
* Tue Mar 15 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.4 release
- fix for regexp compilation (regexp in fqdn_whitelists didn't work)
* Sat Mar 05 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.3 release
- the cleanup is now done in a separate process to avoid stalling the service
* Thu Mar 03 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.2 release
- optimize SQL queries by avoiding some now() function calls
* Wed Mar 02 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.1 release
- replaced smart algorithm with Michel Bouissou's one
* Wed Feb 23 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.5.0 release
- drop support for obsolete command-line parameters
- migrate databases to a new layout :
. first_seen added to the AWLs
. optimize AWL Primary Keys
. add indexes
* Mon Feb 21 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.8 release
- AWL performance bugfix
- bad handling of database init errors fixed
* Fri Feb 18 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.7 release
- MAIL FROM: <> bugfix
* Fri Feb 18 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.6 release
- update_sqlgrey_whitelists fix
- removed superfluous regexp in deVERP code
* Thu Feb 17 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.5 release
- update_sqlgrey_whitelists temporary directory fixes from Michel Bouissou
- return code configurable patch from Michel Bouissou
- VERP and SRS tuning, with input from Michel Bouissou
- VERP and SRS normalisation is used only in the AWLs
* Mon Feb 14 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.4 release
- Autowhitelists understand SRS
- more VERP support for autowhitelists
- SQLgrey can warn by mail when the database is unavailable
- update_sqlgrey_whitelists doesn't rely on mktemp's '-t' parameter anymore.
* Sun Feb 06 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.3 release
- log to stdout when not in daemon mode
- added update_sqlgrey_whitelists script
whitelists can now be fetched from repositories
* Thu Jan 13 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.2 release
- Better cleanup logging from Rene Joergensen
- Fix for Syslog.pm error messages at init time
- Fix doc packaging in RPM
* Tue Jan 11 2005 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.1 release
- fix for invalid group id messages from Ãystein Viggen
- allow reloading whitelists with SIGUSR1
- db_maintdelay user-configurable
- don't log pid anymore
* Fri Dec 10 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.4.0 release
- windows for SQL injection fix (reported by Ãystein Viggen)
- spec file tuning inspired by Derek Battams
* Tue Nov 30 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.3.6 release
- whitelist for FQDN as well as IP
- 3 different greylisting algorithms
(RFE from Derek Battams)
* Mon Nov 22 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.3.4 release
- ip whitelisting
* Mon Nov 22 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.3.3 release
- preliminary whitelist support
* Wed Nov 17 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.3.2 release
- RPM packaging fixed
- DB connection pbs don't crash SQLgrey anymore
* Thu Nov 11 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.3.0 release
- Database schema slightly changed,
- Automatic database schema upgrade framework
* Sun Nov 07 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.2.0 release
- SQL code injection protection
- better DBI error reporting
- better VERP support
- small log related typo fix
- code cleanups
* Mon Oct 11 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.1.2 release
- pidfile handling code bugfix
* Mon Sep 27 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.1.1 release
- MySQL-related SQL syntax bugfix
* Tue Sep 21 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.1.0 release
- SQLite support (RFE from Klaus Alexander Seistrup)
* Tue Sep 14 2004 Lionel Bouton <lionel-dev@bouton.name>
- 1.0.1 release
- man page cleanup
* Tue Sep 07 2004 Lionel Bouton <lionel-dev@bouton.name>
- pushed default max-age from 12 to 24 hours
* Sat Aug 07 2004 Lionel Bouton <lionel-dev@bouton.name>
- bug fix for space trimming values from database
* Tue Aug 03 2004 Lionel Bouton <lionel-dev@bouton.name>
- trim spaces before logging possible spams
- v1.0 added license reference at the top
at savannah request
* Fri Jul 30 2004 Lionel Bouton <lionel-dev@bouton.name>
- Bugfix: couldn't match on undefined sender
- debug code added
* Fri Jul 30 2004 Lionel Bouton <lionel-dev@bouton.name>
- Removed NetAddr::IP dependency at savannah request
* Sat Jul 17 2004 Lionel Bouton <lionel-dev@bouton.name>
- Default max-age pushed to 12 hours instead of 5
(witnessed more than 6 hours for a mailing-list subscription
system)
* Fri Jul 02 2004 Lionel Bouton <lionel-dev@bouton.name>
- Documentation
* Thu Jul 01 2004 Lionel Bouton <lionel-dev@bouton.name>
- PostgreSQL support added
* Tue Jun 29 2004 Lionel Bouton <lionel-dev@bouton.name>
- various cleanups and bug hunting
* Mon Jun 28 2004 Lionel Bouton <lionel-dev@bouton.name>
- 2-level AWL support
* Sun Jun 27 2004 Lionel Bouton <lionel-dev@bouton.name>
- Initial Version, replaced BDB by mysql in postgrey
