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@xxxxxxxxx>:
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@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.
