[FUGSPBR] <OFF-TOPIC>-SASLAUTH

[Paulo Quartieri]

A quem ajudar possa:

Talvez este não seja o forum adequado para este tipo de pergunta, mas já
procurei em varios locais e nao consegui uma resposta satisfatória, então...

Seguinte:  Instalei num FreeBSD 5.2.1-RELEASE-p9 o (via ports, claro)
postfix+SASL2+Mysql+ com PAM.Beleza, posfix funciona bem. POstfixadmin
também. O problema eh o SASL.

Acontece q quando o cliente passa o EMail acontece o seguinte erro:

Jul 16 09:50:07 qbserver2 saslauthd[17233]: pam_sm_authenticate called.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: dbuser changed.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: dbpasswd changed.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: database changed.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: table changed.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: usercolumn changed.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: passwdcolumn changed.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: crypt changed.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: db_connect  called.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: returning 0 .
Jul 16 09:50:07 qbserver2 saslauthd[17233]: db_checkpasswd called.
Jul 16 09:50:07 qbserver2 saslauthd[17233]: pam_mysql: where clause =
Jul 16 09:50:07 qbserver2 saslauthd[17233]: SELECT password FROM mailbox
WHERE username='qb'
Jul 16 09:50:07 qbserver2 saslauthd[17233]: pam_mysql: select returned more
than one result
Jul 16 09:50:07 qbserver2 saslauthd[17233]: returning 9 after
db_checkpasswd.

O problema aqui eh q onde esta o WHERE username='qb' deveria estar
'qb em dominio.com.br' , como esta na conta de login do cliente e como está no
banco de dados.
Como faco para alterar isto? Obrigado...


#############################
o main.cf
virtual_alias_maps =
mysql:/usr/local/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:108
virtual_mailbox_base = /usr/local/virtual
virtual_mailbox_domains =
mysql:/usr/local/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps =
mysql:/usr/local/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_mailbox_limit = 100000000
virtual_minimum_uid = 108
virtual_transport = virtual
virtual_uid_maps = static:108
******** sasl *************
broken_sasl_auth_clients = yes
smtpd_sender_restrictions = permit_sasl_authenticated, permit_mynetworks
smtpd_recipient_restrictions = permit_sasl_authenticated , permit_mynetworks
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
###################################3
/usr/local/lib/sasl2/smtp.conf
pwcheck_method: saslauthd
#############################
# /etc/pam.d/smtp
auth    sufficient /usr/lib/pam_mysql.so user="postfix" passwd="xxxxx"
db="mail"
        table="mailbox" usercolumn="username" passwdcolumn="password"
crypt=1

account required /usr/lib/pam_mysql.so user="postfix" passwd="xxxxx"
db="mail"
        table="mailbox" usercolumn="username" passwdcolumn="password"
crypt=1


_______________________________________________________________
Para enviar um novo email para a lista: fugspbr em fugspbr.org
Sair da Lista: http://lists.fugspbr.org/listinfo.cgi
Historico: http://www4.fugspbr.org/lista/html/FUG-BR/