good morning,
i've got many issues trying to configure cyrus-sasl-sql smtp AUTH.
here are some specs:
[root@rastaban ~]# /usr/sbin/pluginviewer -a
Installed auxprop mechanisms are:
sasldb
List of auxprop plugins follows
Plugin "sasldb" , API version: 4
supports store: yes
[root@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@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
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
