SASL and MySQL: It just ain't working

[Patrick Ben Koetter]

* Mr Havercamp <mrhavercamp at gmail.com>:
> 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

IIRC this is an old bug (?) where configure won't find the mysql libs. The
solution used to be this:

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


> 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.

Given the amount of documentation that is there for Cyrus SASL beginners to
understand what Cyrus SASL is and what can and needs to be done to configure
it, I'd say your two days are the lower limit of what it takes people when
they do it the first time.

p at rick




> 
> 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.
> >

-- 
The Book of Postfix
<http://www.postfix-book.com>
saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>