postfix-policyd installation omits a table when creating the database
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postfix-policyd (Debian) |
Fix Released
|
Unknown
|
|||
postfix-policyd (Ubuntu) |
Fix Released
|
Medium
|
Daniel Hahler |
Bug Description
Description: Ubuntu 8.04.3 LTS
Release: 8.04
apt-cache policy postfix-policyd
postfix-policyd:
Installed: 1.82-0ubuntu1
Candidate: 1.82-0ubuntu1
Version table:
*** 1.82-0ubuntu1 0
500 http://
100 /var/lib/
When reviewing the logs on a mail server, I discovered that messages that had passed the various anti-spam tests all had the message "blacklist_
e.g.
Jul 28 12:55:29 server-name postfix-policyd: rcpt=7493, blacklist_
This indicates that the blacklist_dnsname module experienced an error when trying to interrogate the database. Examining the structure of the database revealed that the blacklist_dnsname table was missing.
The database creation script needs to include the following SQL to create the database correctly:
-- start SQL
CREATE TABLE `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`)
) ENGINE=MyISAM;
-- end SQL
Related branches
affects: | ubuntu → postfix-policyd (Ubuntu) |
description: | updated |
Changed in postfix-policyd (Debian): | |
status: | Unknown → Confirmed |
Changed in postfix-policyd (Debian): | |
status: | Confirmed → Fix Released |
Thank you for your bug report, which I'm confirming.
I'll get it fixed by adding the table to the install.sql script, and add a new upgrade script to add it in this version.