Verification error...

[Anders Norrbring]

I'm fighting with Postfix - MySQL - Cyrus-IMAP and Cyrus-SASL.  Everything works perfectly
well when I send mail locally (via telnet to postfix) without verification and it also
works perfectly good with IMAP and POP3 access.

But when I try to send mail from my Outlook to Postfix with SMTP-AUTH (same login and pass
as POP/IMAP) I get this in the log;

Feb 28 23:30:43 hulda saslauthd[797]: pam_mysql: where clause =
Feb 28 23:30:43 hulda saslauthd[797]: SELECT password FROM accountuser WHERE
username='tsnet0001 at hulda.the-server.net'
Feb 28 23:30:43 hulda saslauthd[797]: pam_mysql: select returned more than one result
Feb 28 23:30:43 hulda saslauthd[797]: returning 7 after db_checkpasswd.
Feb 28 23:30:43 hulda saslauthd[797]: DEBUG: auth_pam: pam_authenticate failed: Permission
denied
Feb 28 23:30:43 hulda saslauthd[797]: do_auth         : auth failure:
[user=tsnet0001 at hulda.the-server.net] [service=smtp] [realm=hulda.the-server.net]
[mech=pam] [reason=PAM auth error]


I don't get how I can get more than one result from pam_mysql?  Anyone got any ideas?

Thanks,
Anders Norrbring