Query on sql lookups and order of searches

[Kent Oyer]

It should be @somedomain.co.uk (i.e. without the leading period)

-kent

Sent from my Verizon Wireless 4GLTE smartphone

----- Reply message -----
From: "Benedict White" <Benedict.White at cse-ltd.co.uk>
To: "amavis-users at amavis.org" <amavis-users at amavis.org>
Subject: Query on sql lookups and order of searches
Date: Wed, Aug 7, 2013 5:32 pm



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.

Kindest regards,

Benedict White

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.amavis.org/pipermail/amavis-users/attachments/20130808/f47b919e/attachment.html>