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

  • anxious
  • Member
  • Offline
  • Registered: 2010-08-04
  • Posts: 30

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

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,134

Re: Deleted rules in table postfixpolicyd...

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

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

3 Reply by anxious

  • anxious
  • Member
  • Offline
  • Registered: 2010-08-04
  • Posts: 30

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,134

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