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)
>

This is how my imapd.conf looks like:

configdirectory: /var/imap
partition-default: /var/spool/imap
unixhierarchysep: yes
altnamespace: yes
servername: xxxxxx.net
allowanonymouslogin: no
allowplaintext: yes
quotawarn: 80
admins: cyrus
autocreatequota: 102400
plaintextloginpause: 0
sieveusehomedir: false
sievedir: /var/imap/sieve
sendmail: /usr/local/sbin/postfix
postmaster: postmaster
sasl_pwcheck_method: auxprop
tls_cert_file: /var/imap/cyrus.pem
tls_key_file: /var/imap/cyrus.pem
lmtpsocket: /var/imap/socket/lmtp
idlesocket: /var/imap/socket/idle
notifysocket: /var/imap/socket/notify
virtdomains: yes
defaultdomain: xxxxxx.net
allowusermoves: yes
sasl_auxprop_plugin: sql
sasl_sql_engine: mysql
sasl_sql_user: postfix
sasl_sql_passwd: postfix
sasl_sql_database: postfix
sasl_sql_hostnames: localhost
sasl_sql_select: SELECT password FROM mailbox WHERE username='%u' AND
realm='%r'
sasl_sql_verbose: yes
sasl_mech_list: PLAIN LOGIN
sasl_password_format: crypt
sasl_log_level: 6
createonpost: yes
autocreateinboxfolders: spam
autosubscribeinboxfolders: spam
autocreate_sieve_script: /var/imap/phpscript
generate_compiled_sieve_script: yes

Do you see any problems here as STARTTLS / PLAIN goes?

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