Config help?

[David Reid]

I'm hopeful someone can tell me what's wrong with this config. The machine
is FreeBSD 5.2 with sasl 2.0.17 installed and working with the same config
for smtp via postfix. Imapd 2.2.3 doesn't seem to want to authenticate using
this config though :(

I see this in /var/log/messages.
Mar  2 09:38:59 sheridan kernel: pid 6826 (imapd), uid 1005: exited on
signal 10
Mar  2 09:38:59 sheridan master[6821]: process 6826 exited, signaled to
death by 10

 cyradm --user=cyrus localhost
IMAP Password:
               at
/usr/local/lib/perl5/site_perl/5.6.1/mach/Cyrus/IMAP/Admin.pm line 118
cyradm: cannot authenticate to server with  as cyrus

Any ideas? Thanks.

david

/etc/imapd.conf
configdirectory: /var/imap
partition-default: /var/spool/imap
admins: cyrus
allowanonymouslogin: no
allowplaintext: yes
servername: sheridan
autocreatequota: 10000
reject8bit: no
quotawarn: 90

sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: sql
sasl_mech_list: PLAIN LOGIN
sasl_auto_transition: no
sasl_sql_engine: mysql
sasl_sql_hostnames: localhost
sasl_sql_user: XXXXXX
sasl_sql_passwd: XXXXXX
sasl_sql_database: XXXXXX
sasl_sql_select: "select passwd from users where userid='%u@%r';"
sasl_sql_verbose: true

sievedir: /usr/sieve
sieve_maxscriptsize: 32
sieve_maxscripts: 5

---
Home Page: http://asg.web.cmu.edu/cyrus
Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html