|
Julio, vc tem algum link ai para eu seguir como howto? Vc esta autenticando pop ou smtp? Porque de acordo com o apt-cache search no lenny debian:~# apt-cache search dovecot dovecot-common - secure mail server that supports mbox and maildir mailboxes dovecot-dev - header files for the dovecot mail server dovecot-imapd - secure IMAP server that supports mbox and maildir mailboxes dovecot-pop3d - secure POP3 server that supports mbox and maildir mailboxes o dovecot nao funciona com smtp. Att, Christiano Liberato. > Date: Thu, 14 Jan 2010 14:25:12 -0200 > Subject: Re: Problema com postfix + mysql + sasl no debian Lenny > From: julioh1203@gmail.com > To: cristianoliberato@hotmail.com > CC: debian-user-portuguese@lists.debian.org > > 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. > > > -- > To UNSUBSCRIBE, email to debian-user-portuguese-REQUEST@lists.debian.org > with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org > Quer 25 GB de armazenamento gratuito na web? Conheça o Skydrive clicando aqui. |