Cyrus Auth thru Auxprop

[Simon Matter]

> 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

Maybe try this:

sasl_auxprop_plugin: sql
sql_engine: mysql
sasl_auto_transition: no
sasl_sql_hostnames: localhost
sasl_sql_user: cyrus
sasl_sql_password: mailadmin
sasl_sql_database: mail
sasl_sql_statement: select password from users where username = '%u'
sasl_sql_verbose: true

Simon

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


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