Bug#404711: Possible solution...

[Norman Messtorff]

package postfix-policyd
tags 404711 confirmed patch
thanks

Hi,

the attached diff provides my prepared solution.


Thanks,

    Norman

-- 
Norman Messtorff | http://normes.org
Do _not_ use this Spamtrap: [EMAIL PROTECTED]

diff -u postfix-policyd-1.80/debian/install-files/mysql.sql postfix-policyd-1.80/debian/install-files/mysql.sql
--- postfix-policyd-1.80/debian/install-files/mysql.sql
+++ postfix-policyd-1.80/debian/install-files/mysql.sql
@@ -112,6 +112,14 @@
   KEY _expire (_expire)
 ) TYPE=MyISAM;
 
+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;
+
 CREATE TABLE IF NOT EXISTS spamtrap (
   _rcpt        char(60) NOT NULL default '',
   _active      tinyint(1) unsigned NOT NULL default '1',
diff -u postfix-policyd-1.80/debian/changelog postfix-policyd-1.80/debian/changelog
--- postfix-policyd-1.80/debian/changelog
+++ postfix-policyd-1.80/debian/changelog
@@ -1,3 +1,9 @@
+postfix-policyd (1.80-2.2) unstable; urgency=low
+
+  * 'blacklist_dnsname' table missing on new installs. (Closes: #404711)
+
+ -- Norman Messtorff <[EMAIL PROTECTED]>  Fri, 10 Aug 2007 12:35:13 +0200
+
 postfix-policyd (1.80-2.1) unstable; urgency=medium
 
   * Non-maintainer upload.

signature.asc
Description: Digital signature