cyrus-sasl sql trouble

[Patrick Ben Koetter]

* l.rossi at ptm-engineering.it <l.rossi at ptm-engineering.it>:
> good morning,
>  i've got many issues trying to configure cyrus-sasl-sql smtp AUTH.
>  here are some specs:
> 
>  [root at rastaban ~]# /usr/sbin/pluginviewer -a
>  Installed auxprop mechanisms are:
>  sasldb
>  List of auxprop plugins follows
>  Plugin "sasldb" ,       API version: 4
>          supports store: yes
> 
> 
>  [root at rastaban ~]# rpm -qa | grep cyrus
>  cyrus-sasl-md5-2.1.22-4
>  cyrus-sasl-lib-2.1.22-4
>  cyrus-sasl-plain-2.1.22-4
>  cyrus-sasl-2.1.22-4
>  cyrus-sasl-sql-2.1.22-4
>  cyrus-sasl-devel-2.1.22-4
>  cyrus-sasl-gssapi-2.1.22-4
> 
> the plugins are located in /usr/lib/sasl2/
> 
>  my /usr/lib/sasl2/smtpd.conf:
> 
>  [root at rastaban cyrus-sasl-2.1.21]# cat /usr/lib/sasl2/smtpd.conf
>  pwcheck_method: auxprop
>  mech_list: PLAIN LOGIN
>  auxprop_plugin: sql
>  sql_engine: mysql
>  sql_hostnames: localhost
>  sql_database: postdb
>  sql_user: ***
>  sql_passwd: ***
>  sql_select: SELECT clear FROM postfix_users WHERE email = '%u@%r'
> 
> 
> 
>  and my auth.log:
> 
>  Mar 21 11:07:48 rastaban postfix/smtpd[30417]: sql_select option missing
>  Mar 21 11:07:48 rastaban postfix/smtpd[30417]: auxpropfunc error no
>  mechanism available

What is smtpd_sasl_security_options set to?
This seems more like a Postfix problem. You should take this to the Postfix
mailing list.

p at rick



>  Mar 21 11:07:48 rastaban postfix/smtpd[30417]: _sasl_plugin_load failed
>  on sasl_auxprop_plug_init for plugin: sql
> 
>  simply many plugins don't work.
> 
>  i tried to recompile from source (with a client.c patch) but without
>  goals!
> 
>  i tried the same configuration in 2 different cento's, but none's
>  working.
> 
>  any idea?
> 
> 
> Thanks a lot!
> 
> luca rossi
> 

-- 
The Book of Postfix
<http://www.postfix-book.com>
saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>