Re: [Sqlgrey-users] Pre Load

[Paul B. <pa...@hy...>]

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:

> 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
>
>
> ----------------------------------------------------------------------

> ---
> 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.
>


------------------------------------------------------------------------
-
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