sql authentication

[Gabriele Bulfon]

Thanks :) this is a good point I was investigating.
Do you mean that enabling virtdomains will let me login as "name.last at domain.com" and cyrus
will run the select splitting the email into %u and %r?
Last but not least, my password is encrypted.
My applications usually encrypt the typed password with a selected algorithm, and matches
the two encrypted results. I may have no way do decrypt the saved password in the db.
Gabriele.
----------------------------------------------------------------------------------
Da: Berend de Boer
A: Gabriele Bulfon
Cc: info-cyrus at lists.andrew.cmu.edu
Data: 26 gennaio 2011 10.18.59 CET
Oggetto: Re: sql authentication
"Gabriele" == Gabriele Bulfon
writes:
GabrieleI would like imapd to authenticate using my db, where
Gabrielelogin is an email.  I've seen many ways to accomplish
Gabrielesql authentication, so I don't know which is the right
Gabrieleone.  At last, how do I map the complete email to a
Gabrielecyrus mailbox?  For example, if a user succesfully
Gabrieleauthenticate as name.lastname at domain.com, how does cyrus
Gabrieletranslate it into a user.mailbox?
This is how I do it, and you can indeed do it. There are some good
guides for them, I'm just giving some pointers. Authentication is done
with some SQL like this:
sasl_sql_select: select password from dm.virtual_user where lower(local_part) = '%u' and domain_name = '%r
and you need to have:
virtdomains: yes
those are the two key things.
--
All the best,
Berend de Boer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20110126/ecf42e75/attachment.html