-
Notifications
You must be signed in to change notification settings - Fork 2
/
sqlgrey.spec
293 lines (237 loc) · 8.67 KB
/
sqlgrey.spec
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
%define name sqlgrey
%define ver 1.8.0-rc2
%define rel 1
Summary: SQLgrey is a postfix grey-listing policy service.
Name: %{name}
Version: %{ver}
Release: %{rel}
License: GPL
Vendor: Lionel Bouton <[email protected]>
Url: http://sqlgrey.sourceforge.net
Packager: Lionel Bouton <[email protected]>
Group: System Utils
Source: %{name}-%{ver}.tar.bz2
BuildRoot: /var/tmp/%{name}-%{ver}-build
BuildArch: noarch
%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 % junk mails (spam and virus) before they
reach your Postfix server (saves BW, user time and CPU time).
%prep
%setup
%build
make
%install
make rh-install ROOTDIR=$RPM_BUILD_ROOT
%clean
make clean
%files
%defattr(-,root,root)
/etc/init.d/sqlgrey
/usr/sbin/sqlgrey
/usr/sbin/update_sqlgrey_config
/usr/bin/sqlgrey-logstats.pl
/usr/share/man/man1/sqlgrey.1*
%doc README* HOWTO Changelog FAQ TODO
%defattr(644,root,root)
%config(noreplace) /etc/sqlgrey/sqlgrey.conf
/etc/sqlgrey/clients_ip_whitelist
/etc/sqlgrey/clients_fqdn_whitelist
/etc/sqlgrey/discrimination.regexp
/etc/sqlgrey/dyn_fqdn.regexp
/etc/sqlgrey/smtp_server.regexp
/etc/sqlgrey/README
%pre
getent group sqlgrey > /dev/null || /usr/sbin/groupadd sqlgrey
getent passwd sqlgrey > /dev/null || /usr/sbin/useradd -g sqlgrey \
-d /var/sqlgrey -s /bin/true sqlgrey
%postun
if [ $1 = 0 ]; then
if [ `getent passwd sqlgrey | wc -l` = 1 ]; then
/usr/sbin/userdel sqlgrey
fi
if [ `getent group sqlgrey | wc -l` = 1 ]; then
/usr/sbin/groupdel sqlgrey
fi
fi
%changelog
* Mon Aug 17 2009 Michal Ludvig <[email protected]>
- 1.7.7 release getting ready
- Reworked "smart" IPv6 address handling.
- Added IPv6 address support for clients_ip_whitelist(.local) file
* Sun Aug 05 2007 Lionel Bouton <[email protected]>
- 1.7.6 release
- numerous bugfixes, update to last current release version
* Wed Nov 16 2005 Lionel Bouton <[email protected]>
- 1.7.3 release
- fixes for a crash with '*' in email adresses
* Tue Oct 25 2005 Lionel Bouton <[email protected]>
- 1.7.2 release
- fixes for several errors in logging
- clean_method ported from 1.6.x
* Thu Sep 15 2005 Lionel Bouton <[email protected]>
- 1.7.1 release
- fix for race condition in multiple instances configurations
- fix for weekly stats
* Tue Jun 21 2005 Lionel Bouton <[email protected]>
- 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 <[email protected]>
- 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 <[email protected]>
- 1.5.9 release
- fix for MySQL's mishandling of timestamps
- better log parser
* Thu Jun 02 2005 Lionel Bouton <[email protected]>
- 1.5.8 release
- fix for Makefile: rpmbuild didn't work
* Wed Jun 01 2005 Lionel Bouton <[email protected]>
- 1.5.7 release
- fix for a memory leak
- config directory now user-configurable
- preliminary log analyser
* Mon May 02 2005 Lionel Bouton <[email protected]>
- 1.5.6 release
- fix for MySQL disconnection crash
- IPv6 support
- Optin/optout support
* Tue Apr 25 2005 Lionel Bouton <[email protected]>
- 1.5.5 release
- small fix for SRS (again!)
- small fix for deverp code
- log types
* Tue Mar 15 2005 Lionel Bouton <[email protected]>
- 1.5.4 release
- fix for regexp compilation (regexp in fqdn_whitelists didn't work)
* Sat Mar 05 2005 Lionel Bouton <[email protected]>
- 1.5.3 release
- the cleanup is now done in a separate process to avoid stalling the service
* Thu Mar 03 2005 Lionel Bouton <[email protected]>
- 1.5.2 release
- optimize SQL queries by avoiding some now() function calls
* Wed Mar 02 2005 Lionel Bouton <[email protected]>
- 1.5.1 release
- replaced smart algorithm with Michel Bouissou's one
* Wed Feb 23 2005 Lionel Bouton <[email protected]>
- 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 <[email protected]>
- 1.4.8 release
- AWL performance bugfix
- bad handling of database init errors fixed
* Fri Feb 18 2005 Lionel Bouton <[email protected]>
- 1.4.7 release
- MAIL FROM: <> bugfix
* Fri Feb 18 2005 Lionel Bouton <[email protected]>
- 1.4.6 release
- update_sqlgrey_whitelists fix
- removed superfluous regexp in deVERP code
* Thu Feb 17 2005 Lionel Bouton <[email protected]>
- 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 <[email protected]>
- 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 <[email protected]>
- 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 <[email protected]>
- 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 <[email protected]>
- 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 <[email protected]>
- 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 <[email protected]>
- 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 <[email protected]>
- 1.3.4 release
- ip whitelisting
* Mon Nov 22 2004 Lionel Bouton <[email protected]>
- 1.3.3 release
- preliminary whitelist support
* Wed Nov 17 2004 Lionel Bouton <[email protected]>
- 1.3.2 release
- RPM packaging fixed
- DB connection pbs don't crash SQLgrey anymore
* Thu Nov 11 2004 Lionel Bouton <[email protected]>
- 1.3.0 release
- Database schema slightly changed,
- Automatic database schema upgrade framework
* Sun Nov 07 2004 Lionel Bouton <[email protected]>
- 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 <[email protected]>
- 1.1.2 release
- pidfile handling code bugfix
* Mon Sep 27 2004 Lionel Bouton <[email protected]>
- 1.1.1 release
- MySQL-related SQL syntax bugfix
* Tue Sep 21 2004 Lionel Bouton <[email protected]>
- 1.1.0 release
- SQLite support (RFE from Klaus Alexander Seistrup)
* Tue Sep 14 2004 Lionel Bouton <[email protected]>
- 1.0.1 release
- man page cleanup
* Tue Sep 07 2004 Lionel Bouton <[email protected]>
- pushed default max-age from 12 to 24 hours
* Sat Aug 07 2004 Lionel Bouton <[email protected]>
- bug fix for space trimming values from database
* Tue Aug 03 2004 Lionel Bouton <[email protected]>
- trim spaces before logging possible spams
- v1.0 added license reference at the top
at savannah request
* Fri Jul 30 2004 Lionel Bouton <[email protected]>
- Bugfix: couldn't match on undefined sender
- debug code added
* Fri Jul 30 2004 Lionel Bouton <[email protected]>
- Removed NetAddr::IP dependency at savannah request
* Sat Jul 17 2004 Lionel Bouton <[email protected]>
- 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 <[email protected]>
- Documentation
* Thu Jul 01 2004 Lionel Bouton <[email protected]>
- PostgreSQL support added
* Tue Jun 29 2004 Lionel Bouton <[email protected]>
- various cleanups and bug hunting
* Mon Jun 28 2004 Lionel Bouton <[email protected]>
- 2-level AWL support
* Sun Jun 27 2004 Lionel Bouton <[email protected]>
- Initial Version, replaced BDB by mysql in postgrey