Hi, On Thu, 03 Dec 2015, Ondřej Surý wrote: > postfix-policyd is a long dead upstream and there are better > alternatives available. (e.g. I do not intend to work on that.)
The fix is rather trivial (see attached debdiff) so we will upload a fixed package rather than adding a Breaks. Thanks for your quick answer anyway! -- Raphaël Hertzog ◈ Debian Developer Support Debian LTS: http://www.freexian.com/services/debian-lts.html Learn to master Debian: http://debian-handbook.info/get/
diff -u postfix-policyd-1.82/debian/policyd.conf postfix-policyd-1.82/debian/policyd.conf --- postfix-policyd-1.82/debian/policyd.conf +++ postfix-policyd-1.82/debian/policyd.conf @@ -118,7 +118,7 @@ # # what syslog facility to log to # -SYSLOG_FACILITY="LOG_MAIL | LOG_INFO" +SYSLOG_FACILITY="LOG_MAIL|LOG_INFO" 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-2+deb6u1) squeeze-lts; urgency=medium + + * Non-maintainer upload by the Debian LTS team. + * debian/install-files/*.sql: Update SQL files to be compatible with MySQL + 5.5 by replacing TYPE= with ENGINE=. + * Update /etc/postfix-policyd.conf so that the service actually works out + of the box. + + -- Raphaël Hertzog <[email protected]> Thu, 03 Dec 2015 10:59:00 +0100 + 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-upgrade-1.73.sql postfix-policyd-1.82/debian/install-files/mysql-upgrade-1.73.sql --- postfix-policyd-1.82/debian/install-files/mysql-upgrade-1.73.sql +++ postfix-policyd-1.82/debian/install-files/mysql-upgrade-1.73.sql @@ -7 +7 @@ -) TYPE=MyISAM; +) ENGINE=MyISAM; 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 @@ -3,14 +3,14 @@ _optin tinyint(1) unsigned NOT NULL default '1', _priority tinyint(1) unsigned NOT NULL default '0', UNIQUE KEY _rcpt (_rcpt,_optin) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS policy_training ( _rcpt char(60) NOT NULL default '', _expire int(10) unsigned NOT NULL default '0', UNIQUE KEY _rcpt (_rcpt), KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS throttle ( _from char(60) NOT NULL default '', @@ -31,7 +31,7 @@ _log_panic int(10) unsigned NOT NULL default '0', _priority tinyint(1) unsigned NOT NULL default '0', UNIQUE KEY _from (_from) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS throttle_from_instance ( _instance char(60) NOT NULL default '', @@ -39,7 +39,7 @@ _expire int(10) unsigned NOT NULL default '0', UNIQUE KEY _instance (_instance), KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS throttle_rcpt ( _rcpt char(60) NOT NULL default '', @@ -53,7 +53,7 @@ _log_warn int(10) unsigned NOT NULL default '0', _log_panic int(10) unsigned NOT NULL default '0', UNIQUE KEY _rcpt (_rcpt) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS triplet ( _from char(60) NOT NULL default '', @@ -65,7 +65,7 @@ UNIQUE KEY _host (_host,_from,_rcpt), KEY _datelast (_datelast), KEY _datenew (_datenew) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS whitelist ( _whitelist char(15) NOT NULL default '', @@ -73,7 +73,7 @@ _expire int(10) unsigned NOT NULL default '0', UNIQUE KEY _whitelist (_whitelist), KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS whitelist_sender ( _whitelist char(60) NOT NULL default '', @@ -81,7 +81,7 @@ _expire int(10) unsigned NOT NULL default '0', UNIQUE KEY _whitelist (_whitelist), KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS whitelist_dnsname ( _whitelist char(60) NOT NULL default '', @@ -89,7 +89,7 @@ _expire int(10) unsigned NOT NULL default '0', UNIQUE KEY _whitelist (_whitelist), KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS blacklist ( _blacklist char(15) NOT NULL default '', @@ -97,12 +97,12 @@ _expire int(10) unsigned NOT NULL default '0', UNIQUE KEY _blacklist (_blacklist), KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS blacklist_helo ( _helo char(60) NOT NULL default '', UNIQUE KEY _helo (_helo) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS blacklist_sender ( _blacklist char(60) NOT NULL default '', @@ -110,13 +110,13 @@ _expire int(10) unsigned NOT NULL default '0', UNIQUE KEY _blacklist (_blacklist), KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS spamtrap ( _rcpt char(60) NOT NULL default '', _active tinyint(1) unsigned NOT NULL default '1', UNIQUE KEY _rcpt (_rcpt,_active) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS helo ( _host char(15) NOT NULL default '', @@ -126,3 +126,3 @@ KEY _expire (_expire) -) TYPE=MyISAM; +) ENGINE=MyISAM;
