Auxprop SQL & Virtual Domains

[Peter Muir]

Hi,

On Tue, 26 Apr 2005, Jesper K. Pedersen wrote:

> On Tue, 26 Apr 2005 15:29:34 +0100 (BST)
> Peter Muir <peter at splendid.co.uk> wrote:
>
>> Hi,
>>
>> I'm using cyrus-imapd (version 2.2.12, cyrus-sasl version 2.1.20) with
>> the sql auxprop plugin to connect to a mysql database.  This works
>> well.
>>
>> I would like to use the virtual domains feature of cyrus 2.2 with the
>> 'userid' method but cannot find a way of passing the domain name
>> supplied, it seems to only pass the username - i.e. if I log in as
>> peter at splendid.co.uk, then %u expands to peter.  Can I
>>
>> a) get %u to expand to peter at splendid.co.uk
>>
>> or
>>
>> b) is there another variable that expands to splendid.co.uk
>>
>> TIA
>>
>
> %r is your realm - that is for example your splendid.co.uk
>
> So use %u@%r to get your desired result

Trying this the %r gets set to either the hostname of the machine or the 
value of 'servername: ' if it is set.

This is with

virtdomains: on
defaultdomain: splendid.co.uk

and watching the queries executed in the mysql log.

I haven't set any of the realm parameters in the config file.

I can post the whole config file if necessary,

Regards
---
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html