am I right OR what's the right way

[Andrei Loukinykh]

 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"