postfix-policyd installation omits a table when creating the database

Bug #405845 reported by rjwellsted
6
This bug affects 1 person
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://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.
e.g.
Jul 28 12:55:29 server-name postfix-policyd: rcpt=7493, blacklist_dnsname=bypass, host=XXX.XXX.XXX.XXX (aluminium-oneisi.ccmdcampaigns.net), <email address hidden>, <email address hidden>, size=0

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

affects: ubuntu → postfix-policyd (Ubuntu)
description: updated
Revision history for this message
Daniel Hahler (blueyed) wrote :

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.

Changed in postfix-policyd (Ubuntu):
assignee: nobody → Daniel Hahler (blueyed)
importance: Undecided → Medium
status: New → In Progress
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postfix-policyd - 1.82-2ubuntu1

---------------
postfix-policyd (1.82-2ubuntu1) karmic; urgency=low

  * Create MySQL table blacklist_dnsname on new installs. This has
    been added in 1.73, but only for upgrades (LP: #405845)
    - debian/install-files/mysql.sql
    - debian/install-files/mysql-upgrade-1.82-2ubuntu1.sql
    - debian/rules

 -- Daniel Hahler <email address hidden> Sat, 01 Aug 2009 17:57:48 +0200

Changed in postfix-policyd (Ubuntu):
status: In Progress → Fix Released
Changed in postfix-policyd (Debian):
status: Unknown → Confirmed
Changed in postfix-policyd (Debian):
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.