1 (edited by anxious 2010-09-17 21:37:17)

Topic: Deleted rules in table postfixpolicyd...

Hello

while migrating iRedMail from a server to another one 2 weeks ago, i deleted the rules contained in postfixpolicyd (blacklist, blacklist_dsnname, whitelist..........)

is it possible to send me the content of this table please via a MySQL dump because now i recieve a lot of spam.

thanks

2

Re: Deleted rules in table postfixpolicyd...

Policyd ships some white-/blacklist, you can import them.

# dpkg -L postfix-policyd | grep -i sql

3

Re: Deleted rules in table postfixpolicyd...

thanks i've just did that but it only filled the table "helo"

and there is still no content in blacklist.

The only table which have content :
helo and triplet.

Is that normal ?

I remember that before deleting the content during the importation, there was PLENTY of data in blacklist ( even if i use iredmail since not a long time (1month approx)

thanks

4

Re: Deleted rules in table postfixpolicyd...

As you can see here (http://packages.ubuntu.com/lucid/i386/p … d/filelist), policyd ships some SQL files:

/usr/share/dbconfig-common/data/postfix-policyd/install/mysql
/usr/share/dbconfig-common/data/postfix-policyd/upgrade/mysql/1.73-1
/usr/share/dbconfig-common/data/postfix-policyd/upgrade/mysql/1.82-2ubuntu1
/usr/share/doc/postfix-policyd/blacklist_helo.sql.gz
/usr/share/doc/postfix-policyd/whitelist.sql.gz

Also, some in iRedMail:

http://iredmail.googlecode.com/hg/iRedM … t_helo.sql