Re: Problema com postfix + mysql + sasl no debian Lenny
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 <cristianoliberato@hotmail.com>:
> 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.
Reply to: