<div style="font-family: Verdana; font-size: 12px;">Thanks :) this is a good point I was investigating.<br><br>Do you mean that enabling virtdomains will let me login as "name.last@domain.com" and cyrus<br>will run the select splitting the email into %u and %r?<br><br>Last but not least, my password is encrypted.<br>My applications usually encrypt the typed password with a selected algorithm, and matches<br>the two encrypted results. I may have no way do decrypt the saved password in the db.<br><div><br>Gabriele.<br></div><tt><br><br><br>----------------------------------------------------------------------------------<br><br>Da: Berend de Boer <berend@pobox.com><br>A: Gabriele Bulfon <gbulfon@sonicle.com> <br>Cc: info-cyrus@lists.andrew.cmu.edu <br>Data: 26 gennaio 2011 10.18.59 CET<br>Oggetto: Re: sql authentication<br><br></tt><blockquote style="border-left: 2px solid rgb(0, 0, 128); margin-left: 5px; padding-left: 5px;"><tt>>>>>> "Gabriele" == Gabriele Bulfon <gbulfon@sonicle.com> writes:<br><br> Gabriele> I would like imapd to authenticate using my db, where<br> Gabriele> login is an email. I've seen many ways to accomplish<br> Gabriele> sql authentication, so I don't know which is the right<br> Gabriele> one. At last, how do I map the complete email to a<br> Gabriele> cyrus mailbox? For example, if a user succesfully<br> Gabriele> authenticate as name.lastname@domain.com, how does cyrus<br> Gabriele> translate it into a user.mailbox?<br><br>This is how I do it, and you can indeed do it. There are some good<br>guides for them, I'm just giving some pointers. Authentication is done<br>with some SQL like this:<br><br> sasl_sql_select: select password from dm.virtual_user where lower(local_part) = '%u' and domain_name = '%r<br><br>and you need to have:<br><br> virtdomains: yes<br><br>those are the two key things.<br><br>-- <br>All the best,<br><br>Berend de Boer<br><br><br><br></tt></blockquote></div>