mysql auxprop plugin problem

[Brad]

Hi all,

I am trying to get cyrus up and going on fc3 with postfix and mysql.  I
am using the MySQL-server-4.1.7-0 rpm's from mysql.org.  I also built
and installed MySQL-shared-compat for other dependencies.  My cyrus
rpm's are cyrus-sasl-2.1.19-3, cyrus-sasl-md5-2.1.19-3, cyrus-sasl-
plain-2.1.19-3, cyrus-sasl-devel-2.1.19-3, cyrus-sasl-sql-2.1.19-3,
cyrus-imapd-2.2.10-1.fc3, cyrus-imapd-utils-2.2.10-3.fc3, and cyrus-
imapd-devel-2.2.10-1.fc3.  I built the sasl rpm's from source rpm's and
included --enable-sql.  When I start cyrus-imap I get the following
errors in /var/log/messages:

 perl: unable to
dlopen /usr/lib/sasl2/libsql.so.2: /usr/lib/sasl2/libsql.so.2: undefined
symbol: compress

Dec 17 10:58:41 mybox pop[20869]: SQL engine 'mysql' not supported
Dec 17 10:58:41 mybox pop[20869]: auxpropfunc error no mechanism
available

and the same errors for IMAP.  I followed some other posts that suggest
it's a problem with not having zlib but I have zlib-1.2.1.2-1 and zlib-
devel-1.2.1.2-1 installed.  Here is a snippet from my imapd.conf:

admins: root, cyrus
allowanonymouslogin: no
sasl_pwcheck_method: auxprop
sasl_sql_engine: mysql
sasl_sql_database: mail
sasl_sql_select: SELECT password FROM accountuser WHERE username = '%u'
and domain_name = '%r'
auxprop_plugin: mysql
sasl_sql_verbose: yes
sasl_mech_list: PLAIN
allowplaintext: yes
sievedir: /usr/sieve
sendmail: /usr/sbin/sendmail
sieve_maxscriptsize: 32
sieve_maxscripts: 5
sasl_sql_user: mail
sasl_sql_passwd: password
sasl_sql_hostnames: localhost
imapidresponse: no
quotawarn: 90

Any help is appreciated.

Thanks,

Brad



---
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html