|
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='%u@%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.liberato@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.liberato@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.liberato@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.liberato@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.liberato@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.liberato@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. Quer 25 GB de armazenamento gratuito na web? Conheça o Skydrive clicando aqui. |