SASL and MySQL: It just ain't working

[Mr Havercamp]

Thanks for the feedback Patrick.

A compile issue on my part; mysql was indeed not being compiled in as 
outlined by the compilation output;

checking for mysql_select_db in -lmysqlclient... no

An extension of Eric B.'s solution fixed the problem;

LIBS="-lcrypt -lz -lnsl -lm"; export LIBS

which I determined through the use of;

# mysql_config --libs

Unfortunately the issues persist. smtpd.conf appears to be read but sasl 
continues to fail. sasl was logging to /var/log/messages but the logging 
seems to have stopped.

I have set log_level in smtpd.conf to 5 (which is definitely being 
accessed because I removed the file and the sql_select option missing 
error started appearing in /var/log/messages) but nothing is logged.

If I could see some errors I'm sure I could get this working.

Patrick Ben Koetter wrote:
> * 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.
>>>
>>>       
>
>