Query on sql lookups and order of searches
Benedict.White at cse-ltd.co.uk
Wed Aug 7 23:32:16 CEST 2013
I am running some tests on a server, and have an sql server (MariaDB) running the
schema that comes with the latest version of Amavisd-new. I use the same dsn for
storage and lookups.
What I'm trying to achieve is this:
I want to apply policy 1 to a user with an email of bob at somedomain.co.uk, and
A different policy (as it happens 12) to all other users at the same domain.
As I understand it from http://www.ijs.si/software/amavisd/README.lookups I can do this
by having an entry (users:email) I presume in users with @.somedomain.co.uk with a policy ID of 12
and another user with an email address bob at somedomain.co.uk with a policy id of 1.
However it seems if I do it like that the policy of 12 applies regardless. I've also tried
. at somedomain.co.uk but that just makes the policy for bob at somedomain.co.uk apply to all users.
More information about the amavis-users