cyrus-imapd-2.2.3-4 auxprop sql whats missing?

[Khalid Mehmood]

>From the last one week I have been trying setup this
thing, but nothing seems to be working properly. This
is what I'm trying to setup:

RH 9
cyrus-imapd-2.2.3-4 rpm
cyrus-sasl-2.1.17-2 rpm
postfix-2.0.18-1.mysql.rh9 rpm
web-cyradm
mysql-3.23.58-1.9 rpm

##############
imapd.conf
#############
postmaster: postmaster
configdirectory: /var/lib/imap
partition-default: /var/spool/imap
admins: cyrus
virtdomains: yes
defaultdomain: xxx.com
allowanonymouslogin: no
autocreateinboxfolders: Sent | Drafts | Templates |
Trash
createonlogin: yes
allowplaintext: yes
servername: xxx.xxx.com
autocreatequota: 10000
reject8bit: no
quotawarn: 90
timeout: 30
poptimeout: 10
dracinterval: 0
drachost: localhost
sievedir: /var/lib/imap/sieve
sendmail: /usr/sbin/sendmail
hashimapspool: true
#loginrealms: xxx.com.xx
sasl_pwcheck_method: auxprop
sasl_mech_list: login plain
sasl_sql_engine: mysql
sasl_auxprop_plugin: sql sasldb
sasl_db_path: /etc/sasldb2
sasl_sql_user: mail
sasl_sql_passwd: xxx
sasl_sql_hostnames: localhost:3306
sasl_sql_database: mail
sasl_sql_select: SELECT password FROM accountuser
WHERE username = '%u'
sasl_sql_verbose: yes
sieve_maxscriptsize: 32
sieve_maxscripts: 5
#unixhierarchysep: yes
tls_cert_file: /usr/share/ssl/certs/cyrus-imapd.pem
tls_key_file: /usr/share/ssl/certs/cyrus-imapd.pem
#############################
smtpd.conf
#############################
pwcheck_method: auxprop
sasl_mech_list: login plain
sasl_sql_engine: mysql
sasl_auxprop_plugin: sql sasldb
sasl_db_path: /etc/sasldb2
sasl_sql_user: mail
sasl_sql_passwd: xxx
sasl_sql_hostnames: localhost:3306
sasl_sql_database: mail
sasl_sql_select: SELECT password FROM accountuser
WHERE username = '%u'
sasl_sql_verbose: yes
###################################
/etc/sysconfig/saslauthd
###################################
MECH="pam -n 0"
#SASL_AUTH_MECH="pam"
###########################
/var/log/maillog
#############################
Feb 20 14:33:02 ns imap[25139]: accepted connection
Feb 20 14:33:02 ns imap[25139]: badlogin: xxx.xxx.com
[127.0.0.1] plaintext cyrus SASL(-13): authentication
failure: checkpass failed
####################################
/usr/lib/sasl2 contents
#####################################
libanonymous.a          libdigestmd5.la        
liblogin.so         libsasldb.la
libanonymous.la         libdigestmd5.so        
liblogin.so.2       libsasldb.so
libanonymous.so         libdigestmd5.so.2      
liblogin.so.2.0.17  libsasldb.so.2
libanonymous.so.2       libdigestmd5.so.2.0.17 
libntlm.a           libsasldb.so.2.0.17
libanonymous.so.2.0.17  libgssapiv2.a          
libotp.a            libsql.a
libcrammd5.a            libgssapiv2.la         
libplain.a          libsql.la
libcrammd5.la           libgssapiv2.so         
libplain.la         libsql.so.2
libcrammd5.so           libgssapiv2.so.2       
libplain.so         libsql.so.2.0.17
libcrammd5.so.2         libgssapiv2.so.2.0.17  
libplain.so.2       smtpd.conf
libcrammd5.so.2.0.17    liblogin.a             
libplain.so.2.0.17
libdigestmd5.a          liblogin.la            
libsasldb.a
##############################################
/usr/sbin/saslauthd -v results
###############################################
saslauthd 2.1.17
authentication mechanisms: getpwent kerberos5 pam
rimap shadow ldap
###################################################

Looks like sasl auxprop function is the issue here,
somehow cyrus-imapd can't talk to mysql. I have tried
different combinations, but couldn't get this thing
up. Web-cyradm works fine if I add
sasl_pwcheck_method: auxprop saslauthd, but if I
remove saslauthd I can't authenticate to imapd server.
I did saslpasswd2 -c cyrus, but still can't
authenticate to server if I remove the saslauthd from
pwcheck_method. The question is why imapd can't use
auxprop sql function for authentication or if there is
something else missing in my configurations? Any help
would be greatly appreciated.

Thanks

Khan


__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
---
Home Page: http://asg.web.cmu.edu/cyrus
Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html