Olá lista, estou com sérios problemas para fazer funcionar o postfix + mysql +
sasl no lenny.
Já tenho funcionando pop + imap + maildrop + mysql perfeitamente.
Vou postar minhs confs para ajudar:
/etc/pam.d/smtp
auth required pam_mysql.so user=postfix passwd=nga host=localhost db=postfix
table=mailbox usercolumn=username passwdcolumn=password crypt=1
account required pam_mysql.so user=postfix passwd=nga host=localhost db=postfix
table=mailbox usercolumn=username passwdcolumn=password crypt=1
/etc/postfix/sasl/smtpd.conf
mech_list: plain login
allow_plaintext: true
auxprop_plugin: mysql
sql_hostnames: localhost
sql_user: postfix
sql_passwd: nga
sql_database: postfix
sql_select: select password from mailbox where username='%...@%r'
cat /etc/group |grep sasl
sasl:x:45:postfix
/etc/default/saslauthd
START=yes
DESC="SASL Authentication Daemon"
NAME="saslauthd"
MECHANISMS="pam"
MECH_OPTIONS=""
THREADS=5
OPTIONS="-c -m /var/run/saslauthd -r"
debian:~# tail -f /var/log/auth.log (ao tentar enviar uma mensagem pelo outlook
express)
Jan 13 19:12:07 debian postfix/smtpd[8183]: sql auxprop plugin using mysql
engine
debian:~# tail -f /var/log/syslog
Jan 13 19:13:03 debian postfix/smtpd[8183]: connect from unknown[192.168.1.100]
Jan 13 19:13:03 debian postfix/smtpd[8183]: warning: unknown[192.168.1.100]:
SASL LOGIN authentication failed: authentication failure
Jan 13 19:13:03 debian postfix/smtpd[8183]: lost connection after AUTH from
unknown[192.168.1.100]
Jan 13 19:13:03 debian postfix/smtpd[8183]: disconnect from
unknown[192.168.1.100]
-------------------------------------
Se no /etc/postfix/sasl/smtpd.conf troco a opção
auxprop_plugin: mysql
por
auxprop_plugin: sql
o auth.log fica assim:
debian:~# tail -f /var/log/auth.log
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql auxprop plugin using mysql
engine
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin Parse the username
christiano.liber...@dominio1.com.br
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin try and connect to a host
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin trying to open db
'postfix' on host 'localhost'
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin Parse the username
christiano.liber...@dominio1.com.br
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin try and connect to a host
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin trying to open db
'postfix' on host 'localhost'
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin Parse the username
christiano.liber...@dominio1.com.br
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin try and connect to a host
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin trying to open db
'postfix' on host 'localhost'
Jan 13 19:18:50 debian postfix/smtpd[8426]: begin transaction
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin create statement from
userPassword christiano.liberato dominio1.com.br
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin doing query select
password from mailbox where username='christiano.liber...@dominio1.com.br';
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin create statement from
cmusaslsecretPLAIN christiano.liberato dominio1.com.br
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin doing query select
password from mailbox where username='christiano.liber...@dominio1.com.br';
Jan 13 19:18:50 debian postfix/smtpd[8426]: commit transaction
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin Parse the username
christiano.liber...@dominio1.com.br
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin try and connect to a host
Jan 13 19:18:50 debian postfix/smtpd[8426]: sql plugin trying to open db
'postfix' on host 'localhost'
e o syslog continua igual acima.
O que quero dizer é o seguinte: o sasl não consegue falar com o mysql para
autenticar e assim meu outlook express fica sempre pedindo user e senha.
Não seria um bug?
Tudo de sasl instalado na minha maquina:
debian:~# dpkg -l |grep -i sasl
ri libsasl2-2 2.1.22.dfsg1-23+lenny1 Cyrus
SASL - authentication abstraction library
ii libsasl2-dev 2.1.22.dfsg1-23+lenny1 Cyrus
SASL - development files for authentication abstraction
ii libsasl2-modules 2.1.22.dfsg1-23+lenny1 Cyrus SASL
- pluggable authentication modules
ii libsasl2-modules-gssapi-heimdal 2.1.22.dfsg1-23+lenny1 Pluggable
Authentication Modules for SASL (GSSAPI)
ii libsasl2-modules-sql 2.1.22.dfsg1-23+lenny1 Cyrus SASL
- pluggable authentication modules (SQL)
ii sasl2-bin 2.1.22.dfsg1-23+lenny1 Cyrus
SASL - administration programs for SASL users database
Agradeço pelos esclarecimentos.
Att,
Christiano Liberato.
_________________________________________________________________
Agora é fácil compartilhar fotos no Messenger: solte todas na janelinha. Veja
como!
http://www.windowslive.com.br/public/tip.aspx/view/77?product=2&ocid=CRM-WindowsLive:dicaCompartilhamentoFotos:Tagline:WLCRM:On:WL:pt-BR:Messenger
