Cyrus Auth thru Auxprop

[Sun Advocate Webmaster]

Hello,

I've never set up mail on linux, and am struggling to get Cyrus up and 
running. We have a need for IMAP, and after some long research, I feel 
Cyrus is our best bet.

I'm running Cyrus on SuSE Enterprise Linux 9. They won't help me with 
the configuration - we got 30 days installation support with the 
purchase, which doesn't include mail configuration.

I've been fighting Cyrus on the authentication. I googled around a bit, 
and it appeared that sasldb or auxprop was the way to go (we need 
virtual domains, and don't want to add console users, but don't want 
alot of complicated overhead). In /etc/imapd.conf, I added 
"sasl_pwcheck_method: sasldb" and restarted cyrus. I added a user via 
cyradm, and added a password using saslpasswd2. All as well... except I 
couldn't get in. The logs report "no mechanism available." So, I wanted 
to go the auxprop route, but auxprop wasn't installed/compiled. I had to 
rebuild the rpm using the SuSE source rpm, and added the -enable-sql 
option to the configure part of the spec file. After that was installed 
(rpm built, and installed) I changed "sasl_pwcheck_method" to "auxprop" 
and added these options to my imapd.conf:

sasl_auxprop_plugin: mysql
sql_engine: mysql
sasl_auto_transition: no
sasl_mysql_hostnames: localhost
sasl_mysql_user: cyrus
sasl_mysql_password: mailadmin
sasl_mysql_database: mail
sasl_mysql_statement: select password from users where username = '%u'
sasl_mysql_verbose: true

However, I now get these errors:

Apr 21 11:27:00 fs2 imap[27909]: auxpropfunc error no mechanism available
Apr 21 11:27:00 fs2 imap[27909]: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: sql
Apr 21 11:27:01 fs2 imap[27909]: could not find auxprop plugin, was 
searching for 'mysql'
Apr 21 11:27:06 fs2 imap[27909]: could not find auxprop plugin, was 
searching for 'mysql'
Apr 21 11:27:09 fs2 imap[27909]: could not find auxprop plugin, was 
searching for 'mysql'
Apr 21 11:27:12 fs2 imap[27909]: could not find auxprop plugin, was 
searching for 'mysql'
Apr 21 11:41:12 fs2 imap[28445]: auxpropfunc error no mechanism available
Apr 21 11:41:12 fs2 imap[28445]: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: sql
Apr 21 11:41:15 fs2 imap[28451]: auxpropfunc error no mechanism available
Apr 21 11:41:15 fs2 imap[28451]: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: sql
Apr 21 11:45:45 fs2 sasldblistusers2: auxpropfunc error no mechanism 
available
Apr 21 11:45:45 fs2 sasldblistusers2: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: sql

This is getting really frustrating. I have spent hours and hours on 
this, to no avail. Any help would be immensely appreciated.
---
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html