cyrus-sasl sql trouble

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