Maia Whitelists & Virtual Domains

I think I figured it out - it was the amavisd.conf line.  It
had this for the
sql to select the black/white lists:

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

But I took a look in /usr/sbin/amavisd-new and found a
different sql call:

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

So I put that in and now it's working.

- Jason

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users