-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm forwarding the patch I've applied to Ubuntu now to fix this.
- -- http://daniel.hahler.de/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFKdGvXfAK/hT/mPgARAqEgAJ4hW92Fw0z9lJ8jq1kaczrcsmi6CwCZAbzu 6KcxrnAc8R6ik70nVfNPspA= =69I/ -----END PGP SIGNATURE-----
diff -u postfix-policyd-1.82/debian/rules postfix-policyd-1.82/debian/rules --- postfix-policyd-1.82/debian/rules +++ postfix-policyd-1.82/debian/rules @@ -59,6 +59,7 @@ /usr/bin/install -m 600 $(CURDIR)/debian/policyd.conf $(CURDIR)/debian/postfix-policyd/usr/share/postfix-policyd/postfix-policyd.conf /usr/bin/install -m 644 $(CURDIR)/debian/install-files/mysql.sql $(CURDIR)/debian/postfix-policyd/usr/share/dbconfig-common/data/postfix-policyd/install/mysql /usr/bin/install -m 644 $(CURDIR)/debian/install-files/mysql-upgrade-1.73.sql $(CURDIR)/debian/postfix-policyd/usr/share/dbconfig-common/data/postfix-policyd/upgrade/mysql/1.73-1 + /usr/bin/install -m 644 $(CURDIR)/debian/install-files/mysql-upgrade-1.82-2ubuntu1.sql $(CURDIR)/debian/postfix-policyd/usr/share/dbconfig-common/data/postfix-policyd/upgrade/mysql/1.82-2ubuntu1 # Build architecture-independent files here. binary-indep: build install diff -u postfix-policyd-1.82/debian/changelog postfix-policyd-1.82/debian/changelog --- postfix-policyd-1.82/debian/changelog +++ postfix-policyd-1.82/debian/changelog @@ -1,3 +1,13 @@ +postfix-policyd (1.82-2ubuntu1) karmic; urgency=low + + * Create MySQL table blacklist_dnsname on new installs. This has + been added in 1.73, but only for upgrades (LP: #405845) + - debian/install-files/mysql.sql + - debian/install-files/mysql-upgrade-1.82-2ubuntu1.sql + - debian/rules + + -- Daniel Hahler <ubu...@thequod.de> Sat, 01 Aug 2009 17:57:48 +0200 + postfix-policyd (1.82-2) unstable; urgency=low * Add LSB dependency header to init.d scripts (Closes: #467141). diff -u postfix-policyd-1.82/debian/install-files/mysql.sql postfix-policyd-1.82/debian/install-files/mysql.sql --- postfix-policyd-1.82/debian/install-files/mysql.sql +++ postfix-policyd-1.82/debian/install-files/mysql.sql @@ -128,0 +129,8 @@ +CREATE TABLE IF NOT EXISTS blacklist_dnsname ( + _blacklist char(60) NOT NULL default '', + _description char(60) NOT NULL default '', + _expire int(10) unsigned NOT NULL default '0', + UNIQUE KEY _blacklist (_blacklist), + KEY _expire (_expire) +) TYPE=MyISAM; + only in patch2: unchanged: --- postfix-policyd-1.82.orig/debian/install-files/mysql-upgrade-1.82-2ubuntu1.sql +++ postfix-policyd-1.82/debian/install-files/mysql-upgrade-1.82-2ubuntu1.sql @@ -0,0 +1,8 @@ +CREATE TABLE IF NOT EXISTS blacklist_dnsname ( + _blacklist char(60) NOT NULL default '', + _description char(60) NOT NULL default '', + _expire int(10) unsigned NOT NULL default '0', + UNIQUE KEY _blacklist (_blacklist), + KEY _expire (_expire) +) TYPE=MyISAM; +
