Re: [Sqlgrey-users] Pre Load

[Dan F. <da...@ha...>]

I agree with Lionel.
Its best letting sqlgrey do all this since you really cant tell who is 
valid senders if you dont temporally reject first, and then sees who 
comes back. (which is what greylisting does)

If you are worried that delaying all mail for 5 minutes at the same day 
you enable sqlgrey, consider using the "discrimination" feature from 
1.7.4+. That will let you, via regular expressions, select what to 
greylist and what to just let through . Good way of slowly introducing 
greylisting by making the discrimination rules more and more restrictive.


Also i got this wild idea of the top of my head (note: my wild idea's 
arent always recommended :)):

You could let sqlgrey learn over a month or two. Havent tried excactly 
what you need, but i imagine something like this would work:

By using version 1.7.4+ you can set the "reject_code". By setting
reject_code = dunno
sqlgrey performs as usual, except nothing gets rejected.

Then by changing  "reconnect_delay" to something really low (dont know 
if you kan use "0" here) and
"max_connect_age" to something really high, then everyone who sends more 
than 1 mail withing the time specified by "max_connect_age", will be 
treated as a valid sender and added to "from_awl".

after a while, simply set reject_code, max_connect_age and 
reconnect_delay back to default.

A word of warning.
This will result in a large "connect" table. Also, you will likely will 
get a stack of spammers added to your from_awl as well whom will have to 
expire.

As i said, its a wild idea ;)

- Dan Faerch


Paul Barbeau wrote:
> 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.
>
> Paul
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of Kasey
> Speakman
> Sent: Friday, January 19, 2007 11:04 AM
> To: SQLgrey users mailing-list
> Subject: Re: [Sqlgrey-users] Pre Load
>
> If you're using the same MySQL database as before, it should already  
> be there.  The logs only record what is inserted into the database,  
> so losing the logs will not affect your domain_awl, as long as the  
> database still exists.  If you're setting up a new MySQL server too,  
> then just mysql-dump the old database and restore it into the new  
> server.
>
> On Jan 19, 2007, at 9:43 AM, Paul Barbeau wrote:
>
>   
>> I am about to start up SQLGREY and I would like to "pre" load the
>> "domain_awl" and "from_awl" from my old postfix logs and usage.  I  
>> know
>> I can and server/ip to my whitelist files however I would rather  
>> them go
>> into the AWL so they can expire if need be.  Other then just adding to
>> the database is there a better way to do this?  Some how submit  
>> into the
>> daemon?
>>
>> Paul
>>
>>
>> ----------------------------------------------------------------------
>>     
>
>   
>> ---
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Sqlgrey-users mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>>
>> -- 
>> This message has been scanned for viruses and
>> dangerous content by MailScanner, and is
>> believed to be clean.
>>
>>     
>
>
> ------------------------------------------------------------------------
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE
> V
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
>