dovecot - Mar 2007 - Question about auth-master, deliver, and SQL maps

I have been running Postfix/Dovecot with a Postgresql backend for
several months, and everything has been running great.

Now I want to add server side filtering, so I'm attempting to configure
deliver.

The SQL maps for Postfix are all keyed upon the recipient email address.
The SQL map (user_query) for Dovecot is keyed upon the IMAP login name,
which is potentially unrelated to the email address.

But when I configure deliver to use auth-master, it doesn't work right,
because it is passing the recipient email address as a key to
user_query, which is wrong.  Somehow, I need auth-master to use a
different SQL query from user_query when doing lookups for deliver.  In
essence, I want deliver to use the same SQL queries where were
previously used for the Postfix "virtual" delivery agent.

Is there any way to do this?

Richard Coleman
rcoleman at criticalmagic.com

On 7.3.2007, at 4.50, Richard Coleman wrote:
> But when I configure deliver to use auth-master, it doesn't work  
> right,
> because it is passing the recipient email address as a key to
> user_query, which is wrong.  Somehow, I need auth-master to use a
> different SQL query from user_query when doing lookups for  
> deliver.  In
> essence, I want deliver to use the same SQL queries where were
> previously used for the Postfix "virtual" delivery agent.
%s expands to IMAP, POP3 or deliver. You could use that in the  
user_query (or create a nice function which takes it and username as  
parameters).

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070307/d76b76e0/attachment.bin>