Sendmail, SASL2 and mysql - Sendmail does not read Sendmail.conf completely !

[Christian Schulte]

Hi,

this is more related to cyrus-sasl than cyrus-imapd. If I put the 
following lines into my imapd.conf prepending sasl_ to each option, the 
imapd greatly authenticates users agains a mysql database as wanted.
This was not that hard to setup and worked after short time.

pwcheck_method: auxprop
auxprop_plugin: mysql
allowanonymouslogin: no
allowplaintext: yes
mech_list: PLAIN LOGIN
mysql_user: auser
mysql_passwd: apassword
mysql_hostnames: localhost
mysql_database: admin
mysql_statement: select password from SASLUser where login='%u' and 
domain='%r' and IMAP='YES'
mysql_verbose: yes

I now wanted to let sendmail-8.12.6 authenticate against the same users 
using the same mysql database. Therefore I compiled sendmail with 
-DSASL=2 and linked it against -lsasl2. That also worked at once.
If I setup sendmail in /usr/lib/sasl/Sendmail.conf to authenticate 
against /etc/sasldb2 all works so sasl seems to be compiled into 
sendmail correctly. After adding a user with saslpasswd2 with a 
password, sendmail could authenticate against the sasldb2 file. But if I 
put the above lines into /usr/lib/sasl/Sendmail.conf I cannot get it to 
work. First I thought that I had to configure it in 
/usr/lib/sasl2/Sendmail.conf but after extensivley using truss utility I 
saw that sendmail tried to read /usr/lib/sasl/Sendmail.conf

Here is, how far I got it to work:

First I saw in the truss output that mysql says something like "Access 
denied for user root at localhost (using password: NO)"
So sendmail actually tries to connect to the database and seems to read 
the options auxprop_plugin and pwcheck_method correctly. Because I was 
not able to get the configuration done and to let sendmail use the 
specified user and password, I changed the privileges of the mysql-user 
root so that sendmail can login to mysql with root at localhost without 
password. The next thing which then happens is, that sendmail 
successfully connects to mysql but then truss output says that mysql 
answers with something like "No database selected.".
As it seems to me, sendmail completely ignores all options other than 
auxprop_plugin and pwcheck_method. These two options are interpreted 
correctly but all other mysql related options get ignored. Why ? What am 
I doing wrong ? Would be great, if anybody, who has such setup running 
with sendmail could post here, how it is done and how one can tell 
sendmail to read the complete Sendmail.conf options correctly.