Hi all I'm slightly in trouble with configuring SASL+CYRUS according to my needs. Please, tell me - if I wrong and where ... I need Cyrus to check PLAIN text passwords through Mysql database. (I'm planning to encrypt passwords on SSL level ...) For this to work , I do: (sasl-2.1.9, BerkeleyDB 4.0.14, cyrus imapd-2.1.9)
========SASL: ./configure --with-dblib=berkeley --with-bdb-libdir=/usr/local/BerkeleyDB/lib --with-bdb-incdir=/usr/local/BerkeleyDB/include --disable-krb4 --disable-gssapi --disable-cram --disable-digest --disable-otp --with-openssl=/usr/bin --with-mysql=/usr/local ========CYRUS: ./configure --with-db-dir=/usr/local/BerkeleyDB --with-openssl=/usr/bin ========/etc/imapd.conf: configdirectory: /var/imap partition-default: /var/spool/imap admins: cyrus sasl_pwcheck_method: auxprop unixhierarchysep: yes tls_cert_file: /var/imap/server.pem tls_key_file: /var/imap/server.pem sendmail: /usr/sbin/sendmail sasl_mysql_user: cyrus sasl_mysql_passwd: ****** sasl_mysql_database: mailusers sasl_mysql_statement: select password from users where login = '%u' In Mysql I have database 'mailusers' with users' passwords. ======== Cyrus imapd invitation (imtest -m login 127.0.0.1): S: * OK myserver Cyrus IMAP4 v2.1.9 server ready C: C01 CAPABILITY S: * CAPABILITY IMAP4 IMAP4rev1 ACL QUOTA LITERAL+ MAILBOX-REFERRALS NAMESPACE UIDPLUS ID NO_ATOMIC_RENAME UNSELECT CHILDREN MULTIAPPEND SORT THREAD=ORDEREDSUBJECT THREAD=REFERENCES IDLE STARTTLS S: C01 OK Completed Please enter your password: Now , if I understand it right, Cyrus must check passwords in Mysql database ? Or anything was set wrong? Now, when trying /usr/local/bin/imtest -m login -a <isername> 127.0.0.1 - I get in syslog: imtest: unable to dlopen /usr/lib/sasl2/libmysql.so.2: libmysqlclient.so.10: cannot open shared object file: No such file or directory Though it is in /usr/local/lib/mysql and SASL compiled with mysql support Best regards, Andrei V. Loukinykh , Evpatoria Ukrtelecom ISP, +380 6569 29376 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "UNIX is like a vigvam - no Windows, no Gates and an Apache inside"