-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Apr 17, 2007, at 10:02 AM, Paolo Ghidini wrote:
>
> Hi all, i need to export maia wb list for using in
postgrey, i think
> to export this with cron but i don't understand how
maia save the list
> in the database.
> Help me please
I don't think you really want to do that. By putting those
addresses in the greylisting whitelist, you reduce its
effectiveness,
since spam often forges the sender address.
The whitelist in a greylist environment is useful for 1)
Broken
MTA's and 2) sender/recipient/IP triples that are known to
be good.
The key issue there is that it needs an IP address to go
along with
it, so that the greylist program can determine the
difference
between a known good IP delivering mail for a specific user
or
domain, vs a forged sender.
That said, the wblist uses foreign keys to other tables, so
you have
to do a join. The wblist table relates to the maia_users
table,
which may have multiple email addresses linked, so this
query lists
all sender/recipient pairs:
SELECT users.email AS recipient, mailaddr.email AS sender,
wblist.wb
from users, maia_users, mailaddr, wblist WHERE
maia_users.id = wblist.rid
AND users.maia_user_id = maia_users.id
AND wblist.sid = mailaddr.id
AND wblist.wb='W';
If you just need the whitelisted email addresses,
SELECT mailaddr.email AS sender, wblist.wb from mailaddr,
wblist WHERE
wblist.sid = mailaddr.id
AND wblist.wb='W';
David Morton
Maia Mailguard http://www.maiamailguard
.com
mortonda dgrmm.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)
iD8DBQFGJPU4Uy30ODPkzl0RAnO+AKC3k1A0GpdEzj0KJtsIPYVqzQAL8QCf
VqHA
ee6nXmNQNwT6//qWRrrNvGI=
=oLcb
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|
