Re: [Sqlgrey-users] Pre Load

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Thanks for the feed back.  We have already for the last week with one of
our domains been running it and have notice some servers (Bell Canada)
retry in 3 hours not 20 mins so that delay is getting a bit up there.
Also about 6 months ago we tried with postgrey and had to pull it
because of the delays so I am a bit gun shy.

With the sql interface we can keep a better eye on what is in the
connect database so I think I will enter the ones I know are good via
SQL INSERT and wing it for the rest. =20

Thanks again for the input everyone.

Paul

PS I am not running 1.7.4 as I got an error and not sure if it was
important however it did load. The error is below

Name "DBIx::DBCluster::DEBUG" used only once: possible typo at
/usr/sbin/sqlgrey line 2413.
Name "DBIx::DBCluster::WRITE_HOSTS_NEVER_READ" used only once: possible
typo at /usr/sbin/sqlgrey line 827.
Name "DBIx::DBCluster::CLUSTERS" used only once: possible typo at
/usr/sbin/sqlgrey line 818.

1.6.7 works so it became the path of least resistance.  I am not using
DBCluster I am using DBI and I have tried just running "make install"
off a clean download as well "make use_dbi && make install" and I still
get the error.=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Dan
Faerch
Sent: Friday, January 19, 2007 12:28 PM
To: SQLgrey users mailing-list
Subject: Re: [Sqlgrey-users] Pre Load

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

If you are worried that delaying all mail for 5 minutes at the same day=20
you enable sqlgrey, consider using the "discrimination" feature from=20
1.7.4+. That will let you, via regular expressions, select what to=20
greylist and what to just let through . Good way of slowly introducing=20
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=20
arent always recommended :)):

You could let sqlgrey learn over a month or two. Havent tried excactly=20
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 =3D dunno
sqlgrey performs as usual, except nothing gets rejected.

Then by changing  "reconnect_delay" to something really low (dont know=20
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=20
treated as a valid sender and added to "from_awl".

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

A word of warning.
This will result in a large "connect" table. Also, you will likely will=20
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 =20
> be there.  The logs only record what is inserted into the database, =20
> so losing the logs will not affect your domain_awl, as long as the =20
> database still exists.  If you're setting up a new MySQL server too, =20
> then just mysql-dump the old database and restore it into the new =20
> server.
>
> On Jan 19, 2007, at 9:43 AM, Paul Barbeau wrote:
>
>  =20
>> 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 =20
>> know
>> I can and server/ip to my whitelist files however I would rather =20
>> 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 =20
>> into the
>> daemon?
>>
>> Paul
>>
>>
>>
----------------------------------------------------------------------
>>    =20
>
>  =20
>> ---
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to =20
>> share your
>> opinions on IT & business topics through brief surveys - and earn
cash
>> http://www.techsay.com/default.php?=20
>> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV
>> _______________________________________________
>> Sqlgrey-users mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>>
>> --=20
>> This message has been scanned for viruses and
>> dangerous content by MailScanner, and is
>> believed to be clean.
>>
>>    =20
>
>
>
------------------------------------------------------------------------
> -
> 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=3Djoin.php&p=3Dsourceforge&CID=3D=
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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
>  =20

------------------------------------------------------------------------
-
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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Sqlgrey-users mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users