Re: squeeze update of postfix-policyd (for compatibility against mysql-5.5)?
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 <hertzog@debian.org> 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;
Reply to: