sql authentication

Gabriele Bulfon gbulfon at sonicle.com
Wed Jan 26 04:48:35 EST 2011

Yes, I thought about this as a possible way.
Thanks :)
Da: Simon Matter
A: Gabriele Bulfon
Cc: info-cyrus at lists.andrew.cmu.edu
Data: 26 gennaio 2011 9.56.11 CET
Oggetto: Re: sql authentication
I've been using cyrus imapd for years using saslauthd against unix
This way it's easy to understand the relation between a user and its
Now I want to integrate authentication with a sql backend, forgetting
about unix users.
I have a postgres db containing users and passwords.
These are actually a complete email and a password.
I would like imapd to authenticate using my db, where login is an email.
I've seen many ways to accomplish sql authentication, so I don't know
which is the right one.
At last, how do I map the complete email to a cyrus mailbox?
For example, if a user succesfully authenticate as
name.lastname at domain.com, how does
cyrus translate it into a user.mailbox?
I could be wrong but I think cyrus doesn't handle this case the way you
want it. I think the @domain.com part will be stripped as configured but
you end up with name.lastname, which will also be used as mailbox name. To
do this, the usual hack seems to be to enable unixhierarchysep and then
use mailbox names in the form of user/name.lastname.
Of course, I may be completely wrong because I have never used such thing
and it's some years ago when I looked at this last time.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20110126/7f180bc5/attachment.html 

More information about the Info-cyrus mailing list