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 17:00:
>
> > root at mx1# cyradm --user cyrus localhost
> > IMAP Password:
> >               Invalid user at
>
> ^^^^^^^^^^^^
>
> > /usr/local/lib/perl5/site_perl/5.8.7/mach/Cyrus/IMAP/Admin.pm line 118
> > cyradm: cannot authenticate to server with  as cyrus
> >                                       ^^^^^^^
>
> > - Tushar
>
> Do you have the Cyrus-IMAPd admin user in your MySQL DB? Looking at your
> "sasl_sql_select" statement I suggest you make sure that you have
> "cyrus at yourdomain.tld" in the MySQL DB, as well defined that userid in
> imapd.conf as a valid admin.


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)


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

Should the username be specified as cyrus at yourdomain.tld in imapd.conf or
on the cyradm command line? Also, can the MySQL version be a problem?

Thanks.
- Tushar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.andrew.cmu.edu/mailman/private/cyrus-sasl/attachments/20060130/084ab23d/attachment-0001.html