[EMAIL PROTECTED] wrote:
Hi there,
it's me again.
Now i got a question about mysql and Spamassassin.
I wan't to store all rules inside an mysql table,
but the only think i can find is to store user prefs.
I did'nt use user prefs, because i use
postfix/amavisd-new/SA as an Anti Spam gateway wich
is connected between internet and the internal mailserver.
With due respect... if you're not using per-user preferences then you're
not using per-user rules either, so what is the point of storing them in
MySQL?
How often do they need to be edited, and by whom?
Good reasons not to: there's no support for it that I know of, so you'll
have to write it yourself, and if it is possible it would break
compatibility with existing tools like sa-update and rules_du_jour
(which you need to filter the HTML spam you asked about earlier). Get
those working first, and URIBLs / SURBLs as suggested in a later reply,
and then decide whether you really need to break it all...
IIWY I would not try to reinvent the wheel. SQL support is useful for
userprefs, Bayes and AWL because it stores data for users who don't have
a home directory on the system. That's why it's been developed for those
functions. For global information which happily lives in /etc, I don't
see why you *want* this in MySQL other than 'because SQL is cool' (which
is not a good basis for running your mail system).
Regards,
Keith.
