Cyrus-sasl2+MySQL+Cyrus-IMAPD+Postfix

[Tux]

On 1/30/06, Alexander Dalloz <ad+lists at uni-x.org> wrote:
>
> Am Mo, den 30.01.2006 schrieb Tux um 19:49:
>
> > Yes. I have the user cyrus in the database:
> >
> > mysql> use postfix;
> > mysql> select * from mailbox;
> >
> +------------------+------------------------------------+------------------+-------------------+-------+------------+---------------------+---------------------+--------+
> > | username         | password                           |
> name             |
> > maildir           | quota | domain     | created             |
> > modified         | active |
> >
> +------------------+------------------------------------+------------------+-------------------+-------+------------+---------------------+---------------------+--------+
> > | cyrus at xxxxxx.net | $1$f72ce909$raG3K8jW20BTlV9XQMcd1/ | Cyrus Admin
> User |
> > cyrus at xxxxxx.net/ |     0 | xxxxxx.net | 2006-01-30 05:33:10 |
> 2006-01-30
> > 05:33:10 |      1 |
> >
> +------------------+------------------------------------+------------------+-------------------+-------+------------+---------------------+---------------------+--------+
> > 1 row in set (0.00 sec)
>
> "cyrus" isn't in there, but "cyrus at xxxxxx.net".


What if I change the sasl_sql_select in imapd.conf to

sasl_sql_select: SELECT password FROM mailbox WHERE username='%u@%r'

in place of

sasl_sql_select: SELECT password FROM mailbox WHERE username='%u' AND realm
= '%r'

Thanks.
- Tushar

> and the following line in imapd.conf:
> >
> > # The list of userids with administrative rights.  Separate each userid
> > # with a space.  We recommend that administrator userids be separate
> from
> > # "admin" instances.
> > admins: cyrus
>
> Does not match the MySQL entry.
>
> > Should the username be specified as cyrus at yourdomain.tld in imapd.confor
> > on the cyradm command line? Also, can the MySQL version be a problem?
>
> First question: yes.
> Second question: no, most likely not.
>
> > - Tushar
>
> Alexander
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.andrew.cmu.edu/mailman/private/cyrus-sasl/attachments/20060130/9bc0bf83/attachment.html