Boa tarde, Veja uma solução com dovecot para autenticação eu tenho usado ela e resolveu as dificuldades que tinha com sasl.
[ ]'s Júlio Henrique 2010/1/13 Christiano Rogerio Liberato <[email protected]>: > 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 > [email protected] > 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 > [email protected] > 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 > [email protected] > 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='[email protected]'; > 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='[email protected]'; > 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 > [email protected] > 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. -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
