Re: [Sqlgrey-users] Pre Load

[Lionel B. <lio...@bo...>]

Paul Barbeau wrote the following on 19.01.2007 17:12 :
> I was not using grey listing before at all so this is first time data.
> What I am pulling out of the logs is from the postfix lines and they are
> sender, recipient, server what normally would have been passed to the
> server if I had been using it.  I know they will go into the "connect"
> first however based on volume I can move them over as I know what should
> have been added.
>
> Hope this clears up what i meant.
>   

You'll have to use your favorite language to script it. By greylisting's
design there's no sure way of determining the good from the bad reading
postfix logs, so you'll have to code your own heuristics adapted to your
own case. Inserting the lines you want in the good table is the easiest
part, it's only a matter of connecting to the database and doing
INSERTs. You can even prepare the INSERTs in a file and feed it to psql
or mysql clients to avoid coding database accesses in your script.

In fact, if I were you I wouldn't even bother doing so. Greylisting only
adds a small delay that is often not noticeable, even without
auto-whitelists. The delay usually is around 20 minutes, so unless you
expect a mail at a very precise moment or the sender just called to
check if the email got through, nobody is even aware that greylisting
took place.

Even people with huge mailservers didn't have any problem letting
SQLgrey handle the task automatically, why should you have any?

Lionel.