wblist issues

[Dino Edwards]

I'm trying to whitelist/blacklist either a sender email address or a sender domain to an internal domain. So if I understand this correctly, I would get the ID of the sender from the mailaddr table. So for example if I wanted to blacklist @hotmail.com, in my mailddr table, the id for @hotmail.com is 410. Then I would get the ID of my internal domain from the users table so for example @mydirectmail.net in my users table is 460, I would put the wblist entry as follows:

rid	sid	wb
460	410	B

This does not seem to be working. However, if I whitelist/blacklist a sender domain to a specific recipient email address it works as well as whitelist/blacklist a sender email address to a recipient email address. 

Here's my wblist query from 50-users file:

$sql_select_white_black_list =
  'SELECT wb FROM wblist,mailaddr,users'
  . ' WHERE (users.id=?)'
  . ' AND (wblist.rid=users.id)'
  . ' AND (wblist.sid=mailaddr.id)'
  . ' AND (mailaddr.email IN (%k))';

Any idea what's going on here?

Thanks



-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6511 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.amavis.org/pipermail/amavis-users/attachments/20150910/11af3c9d/attachment.bin>