From: Andreas Winkelmann (mlawinkelmann.de)
Date: Tue Sep 30 2003 - 17:36:22 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Glenn Kusardi wrote:

> OK, I was too fast...
>
> Sep 30 20:54:55 mosaiq saslauthd[15778]: pam_sm_authenticate called.
> Sep 30 20:54:55 mosaiq saslauthd[15778]: SELECT clear FROM users WHERE
> id='username.somedomain.demailserver.de'
> Sep 30 20:54:55 mosaiq saslauthd[15778]: pam_mysql: select returned more than one result
> Sep 30 20:54:55 mosaiq saslauthd[15778]: returning 7 after db_checkpasswd.
> Sep 30 20:54:55 mosaiq smtp(pam_unix)[15778]: check pass; user unknown
> Sep 30 20:54:55 mosaiq smtp(pam_unix)[15778]: authentication failure; logname= uid=0 euid=0 tty= ruser= rhost=
> Sep 30 20:54:57 mosaiq saslauthd[15778]: DEBUG: auth_pam: pam_authenticate failed: Permission denied
> Sep 30 20:54:57 mosaiq saslauthd[15778]: do_auth : auth
> failure: [user=username.domain.demailserver.de] [service=smtp]
> [realm=mailserver.de] [mech=pam] [reason=PAM auth error]
>
> The sql-statement is wrong. It should be:
> SELECT clear FROM users WHERE id='username.somedomain.de'
>
> Why is pam or postfix adding the domain of the mailserver to the
> where-statement?

Change:
smtpd_sasl_local_domain = $mydomain

To:
smtpd_sasl_local_domain =

in main.cf.

--
        Andreas

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]