Email address as login name - Cyrus 2.2a + SASL2

[Erin]

I found it in the docs right after I got your email.

Thanks!

I am REAL happy to have this working now!


Erin


> -----Original Message-----
> From: Jure Pecar [mailto:pegasus at nerv.eu.org] 
> Sent: Monday, May 05, 2003 10:10 AM
> To: Erin
> Subject: Re: Email address as login name - Cyrus 2.2a + SASL2
> 
> 
> On Mon, 5 May 2003 09:17:23 -0700
> "Erin" <kahn at deadbbs.com> wrote:
> 
> > I am currently playing with Cyrus Imapd 2.2a and SASL2 
> (2.1.13) using 
> > auxprop mysql.
> > 
> > The only problem I am having is when I try to log into 
> Cyrus via pop3 
> > or imap SASl will fail to authenticate, it seems to be 
> stripping the 
> > '@' from the email address.
> > 
> > I know I probably just overlooked something small.
> > 
> > My log is below;
> > 
> > May  2 08:45:29 web imap[62712]: mysql plugin doing query select 
> > password from accountuser where username = 'test'
> 
> Domain part of the username is split into realm. So if you 
> have database populated with users in the form of 
> username at my.domain, then you should write your query as 
> select ... where username = '%u@%r'. However, i find it much 
> more manageable to have domains in a separate column, so my 
> query looks like select ... where user = '%r' and domain = '%r'.
> 
> --
> 
> Jure Pecar
>