Overview

All inbound emails are whitelisted even though there is no whitelist entry for the email address or domain.

Root Cause

Blank entries in the antispam2_whitelist table.

Resolution

Follow these steps to determine whether the blank entries are causing the problem:

1. Open the following file in any text editor: ...\GFI\MailEssentials\Antispam\DebugLogs\ase_whitelist.gfi_log.txt
2. Search the file for the following (with the quotes): entry IN ('')". The following is an example what to look for:

   2012-04-09,23:26:34,459,3,"#00001174","#0000152c","info ","ase_whitelist","SQL: SELECT TOP 1 id FROM antispam2_whitelist WHERE (type=1 OR type=5) AND entry IN ('')"

   2012-04-09,23:26:34,459,3,"#00001174","#0000152c","info ","ase_whitelist","[MIMEFromWhitelist] Found match in db ..."

To resolve the issue, follow these steps:

1. Stop the GFI MailEssentials services.
2. Open the config.mdb database with Microsoft Access.
3. Open the antispam2_whitelist table.
4. Sort the entry column from A to Z.
5. Delete any potential blank entries.
6. Start the services stopped in step 1.