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

[rjwellsted]

** Description changed:

  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.
+ 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), from=sales at xxx.yyyyy.co.uk, to=rrrr at wwww.org.uk, 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
+ 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
+ -- end SQL

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