No one having any clue...?
An attempt to summarise/emphasize:
1. Doing
testsaslauthd -u dbuser -p bar -s smtp
gives these lines in auth.log if I have the correct row in the mailbox table:
Code:
Sep 2 09:23:10 CR41539-1 saslauthd[3036]: pam_unix(smtp:auth): authentication failure; logname= uid=0 euid=0 tty= ruser= rhost= user=dbuser
Sep 2 09:23:11 CR41539-1 saslauthd[3036]: DEBUG: auth_pam: pam_authenticate failed: Authentication failure
Sep 2 09:23:11 CR41539-1 saslauthd[3036]: do_auth : auth failure: [user=dbuser] [service=smtp] [realm=] [mech=pam] [reason=PAM auth error]
and these lines if I mod. the db-row so that the select will not hit:
Code:
Sep 2 09:23:31 CR41539-1 saslauthd[3033]: pam_unix(smtp:auth): authentication failure; logname= uid=0 euid=0 tty= ruser= rhost= user=dbuser
Sep 2 09:23:31 CR41539-1 saslauthd[3033]: pam_mysql - SELECT returned no result.
Sep 2 09:23:33 CR41539-1 saslauthd[3033]: DEBUG: auth_pam: pam_authenticate failed: Authentication failure
Sep 2 09:23:33 CR41539-1 saslauthd[3033]: do_auth : auth failure: [user=dbuser] [service=smtp] [realm=] [mech=pam] [reason=PAM auth error]
So, if it reads the table and finds the user, why does the authentication fail?
2. System does not seem to use the config file smtpd.conf
Code:
CR41539-1:~# l /etc/postfix/sasl/smtpd.conf
-rwxr-xr-x 1 root root 475 Sep 2 09:22 /etc/postfix/sasl/smtpd.conf
at all.
3. Doing AUTH LOGIN test from an external telnet session does not seem to wake any saslauthd/pam at all, no rows in auth.log, except from
Code:
Sep 2 09:31:40 CR41539-1 postfix/smtpd[4225]: sql_select option missing
Sep 2 09:31:40 CR41539-1 postfix/smtpd[4225]: auxpropfunc error no mechanism available
Sep 2 09:31:40 CR41539-1 postfix/smtpd[4225]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
who appears at the same moment the telnet connects to the server.