Caros,
Tenho Postfix com MySQL funcionando beleza e implementei o SASL para
autentica��o, por�m quando um client de email envia um email com
autentica��o por exemplo:
login: [EMAIL PROTECTED]
no log do saslauth aparece o seguinte:
Aug 28 17:45:57 matrix saslauthd[26816]: pam_sm_authenticate called.
Aug 28 17:45:57 matrix saslauthd[26816]: dbuser changed.
Aug 28 17:45:57 matrix saslauthd[26816]: dbpasswd changed.
Aug 28 17:45:57 matrix saslauthd[26816]: host changed.
Aug 28 17:45:57 matrix saslauthd[26816]: database changed.
Aug 28 17:45:57 matrix saslauthd[26816]: table changed.
Aug 28 17:45:57 matrix saslauthd[26816]: usercolumn changed.
Aug 28 17:45:57 matrix saslauthd[26816]: passwdcolumn changed.
Aug 28 17:45:57 matrix saslauthd[26816]: crypt changed.
Aug 28 17:45:57 matrix saslauthd[26816]: db_connect called.
Aug 28 17:45:57 matrix saslauthd[26816]: returning 0 .
Aug 28 17:45:57 matrix saslauthd[26816]: db_checkpasswd called.
Aug 28 17:45:57 matrix saslauthd[26816]: pam_mysql: where clause =
Aug 28 17:45:57 matrix saslauthd[26816]: SELECT password FROM virtual_users
WHERE id='fulano'
Aug 28 17:45:57 matrix saslauthd[26816]: pam_mysql: select returned more
than one result
Aug 28 17:45:57 matrix saslauthd[26816]: returning 7 after db_checkpasswd.
Aug 28 17:45:57 matrix saslauthd[26816]: do_auth : auth failure:
[user=fulano] [service=smtp] [realm=dominio.com.br] [mech=pam] [reason=PAM
auth error]
O problema � que o user precisa ser o email todo e nao apenas o user name.
Para fazer funcionar preciso colocar como login:
[EMAIL PROTECTED]@dominio.com.br
Ai fica assim no log:
Aug 28 17:45:57 matrix saslauthd[26816]: pam_sm_authenticate called.
Aug 28 17:45:57 matrix saslauthd[26816]: dbuser changed.
Aug 28 17:45:57 matrix saslauthd[26816]: dbpasswd changed.
Aug 28 17:45:57 matrix saslauthd[26816]: host changed.
Aug 28 17:45:57 matrix saslauthd[26816]: database changed.
Aug 28 17:45:57 matrix saslauthd[26816]: table changed.
Aug 28 17:45:57 matrix saslauthd[26816]: usercolumn changed.
Aug 28 17:45:57 matrix saslauthd[26816]: passwdcolumn changed.
Aug 28 17:45:57 matrix saslauthd[26816]: crypt changed.
Aug 28 17:45:57 matrix saslauthd[26816]: db_connect called.
Aug 28 17:45:57 matrix saslauthd[26816]: returning 0 .
Aug 28 17:45:57 matrix saslauthd[26816]: db_checkpasswd called.
Aug 28 17:45:57 matrix saslauthd[26816]: pam_mysql: where clause =
Aug 28 17:45:57 matrix saslauthd[26816]: SELECT password FROM virtual_users
WHERE id='[EMAIL PROTECTED]'
Aug 28 17:45:57 matrix saslauthd[26816]: pam_mysql: select returned more
than one result
Aug 28 17:45:57 matrix saslauthd[26816]: returning 7 after db_checkpasswd.
Aug 28 17:45:57 matrix saslauthd[26816]: do_auth : auth failure:
[EMAIL PROTECTED] [service=smtp] [realm=dominio.com.br]
[mech=pam] [reason=PAM auth error]
Alguem sabe como resolver esse problema ?
[]s
Emerson de Carvalho Paz
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.744 / Virus Database: 496 - Release Date: 24/8/2004
---------------------------------------------------------------------------
Esta lista � patrocinada pela Conectiva S.A. Visite http://www.conectiva.com.br
Arquivo: http://bazar2.conectiva.com.br/mailman/listinfo/linux-br
Regras de utiliza��o da lista: http://linux-br.conectiva.com.br
FAQ: http://www.zago.eti.br/menu.html
