Re: sql authentication

[Gabriele Bulfon <gbulfon@xxxxxxxxxxx>]

Thanks :) this is a good point I was investigating.

Do you mean that enabling virtdomains will let me login as "name.last@xxxxxxxxxx" 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 <berend@xxxxxxxxx>
A: Gabriele Bulfon <gbulfon@xxxxxxxxxxx>
Cc: info-cyrus@xxxxxxxxxxxxxxxxxxxx
Data: 26 gennaio 2011 10.18.59 CET
Oggetto: Re: sql authentication

>>>>> "Gabriele" == Gabriele Bulfon <gbulfon@xxxxxxxxxxx> writes:

Gabriele> I would like imapd to authenticate using my db, where
Gabriele> login is an email. I've seen many ways to accomplish
Gabriele> sql authentication, so I don't know which is the right
Gabriele> one. At last, how do I map the complete email to a
Gabriele> cyrus mailbox? For example, if a user succesfully
Gabriele> authenticate as name.lastname@xxxxxxxxxx, how does cyrus
Gabriele> translate 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

----
Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/