| 2009-07-28 17:48:16 |
rjwellsted |
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.
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 |
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), from=sales@xxx.yyyyy.co.uk, to=rrrr@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 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 |
|
