[Bug 405845] [NEW] postfix-policyd installation omits a table when creating the database

[rjwellsted]

Public bug reported:

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://gb.archive.ubuntu.com hardy/universe Packages
        100 /var/lib/dpkg/status

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_dnsname=bypass" flagged against them.

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
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

** Affects: postfix-policyd (Ubuntu)
     Importance: Undecided
         Status: New

** Package changed: ubuntu => postfix-policyd (Ubuntu)

-- 
postfix-policyd installation omits a table when creating the database
https://bugs.launchpad.net/bugs/405845
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs