SASL and MySQL: It just ain't working

[Mr Havercamp]

Hi Jo

Thanks for the prompt reply.

I have been adding the following options when running ./configure for 
mysql support;

--enable-sql --with-mysql=/usr/include/mysql

I am on CentOS4.4 and have installed MySQL v5 from RPMs via the MySQL 
website so /usr/include should be the correct location.

Is it possible that other configure options are interfering with the 
compilation of mysql support?

I've tried installing the CentOS RPMs, built RPMs from SRC rpms and have 
tried compiling the src from the tar.gz at 
ftp://ftp.andrew.cmu.edu/pub/cyrus-mail/cyrus-sasl-2.1.22.tar.gz but I 
always end up with the same results; i.e. no mysql support.

I apologise for the excessive number of beginner questions but I've 
spent 2 frustrating days trying to get this to work.

Regards


Hayden


Jo Rhett wrote:
> Mr Havercamp wrote:
>> Oct  3 11:21:15 lacy postfix/smtpd[16499]: SQL engine 'mysql' not 
>> supported
>> Oct  3 11:21:15 lacy postfix/smtpd[16499]: auxpropfunc error no 
>> mechanism available
>     ...        ...
>> If I change sql_engine: to pgsql the "SQL Engine... not supported" 
>> errors go away so I'm guessing there is a problem between cyrus-sasl 
>> and mysql only.
>
> Your configuration looked right to me, and I've done dozens of these. 
> It's pretty clear that you compiled sasl without mysql support. 
> Recompile sasl with mysql support enabled and you'll be fine.
>