ajuda relay autenticado

mrteam
(usa Fedora)

Enviado em 21/09/2008 - 11:40h

Olá pessoal estou usando o postfix com sasl e mysql e sempre que tento autenticar ele da esses erros:
no /var/log/mail.log:

Sep 21 14:29:16 XXXXX postfix/smtpd[26189]: connect from unknown[***.***.***.***]
Sep 21 14:29:23 XXXXX postfix/smtpd[26189]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Sep 21 14:29:23 XXXXX postfix/smtpd[26189]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Sep 21 14:29:23 XXXXX postfix/smtpd[26189]: warning: SASL authentication failure: no secret in database
Sep 21 14:29:23 XXXXX postfix/smtpd[26189]: warning: unknown[***.***.***.***]: SASL CRAM-MD5 authentication failed: authentication failure
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: warning: SASL authentication failure: no secret in database
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: warning: unknown[***.***.***.***]: SASL NTLM authentication failed: authentication failure
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Sep 21 14:29:24 XXXXX last message repeated 4 times
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: warning: SASL authentication failure: Password verification failed
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: warning: unknown[***.***.***.**]: SASL PLAIN authentication failed: authentication failure
Sep 21 14:29:25 XXXXX postfix/smtpd[26189]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
Sep 21 14:29:25 XXXXX last message repeated 5 times
Sep 21 14:29:25 XXXXX postfix/smtpd[26189]: warning: unknown[***.***.***.***]: SASL LOGIN authentication failed: authentication failure

no /var/log/auth.log:
Sep 21 14:29:15 XXXXX postfix/smtpd[26189]: sql_select option missing
Sep 21 14:29:15 XXXXX postfix/smtpd[26189]: auxpropfunc error no mechanism available
Sep 21 14:29:15 XXXXX postfix/smtpd[26189]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Sep 21 14:29:23 XXXXX postfix/smtpd[26189]: NTLM server step 1
Sep 21 14:29:23 XXXXX postfix/smtpd[26189]: client flags: ffff8207
Sep 21 14:29:24 XXXXX postfix/smtpd[26189]: NTLM server step 2


Meu /etc/pam.d/smtp
auth required pam_mysql.so user=******* passwd=****** host=127.0.0.1 db=***** table=mailbox usercolumn=username passwdcolumn=password crypt=1
account sufficient pam_mysql.so user=****** passwd=***** host=127.0.0.1 db=****** table=mailbox usercolumn=username passwdcolumn=password crypt=1

Meu /etc/postfix/sasl/smtp.conf
pwcheck_method: saslauthd
mech_list: plain login
allow_plaintext: true
auxprop_plugin: mysql
sql_hostnames: 127.0.0.1
sql_user: ******
sql_passwd: *****
sql_database: ******
sql_select: select password from mailbox where username = '%u'


Alguem pode me ajudar, to usando o debian etch?

reng.unip
(usa Debian)

Enviado em 31/10/2008 - 15:43h

Boa tarde, ao que me parece, deve estar faltando o arquivo /etc/sasldb2 ou ele não possui os direitos necessários.

"/etc/sasldb2: No such file or directory"

Reveja este ponto.

Abraço e espero ter te ajudado.

lanzelotti
(usa Ubuntu)

Enviado em 03/12/2009 - 19:12h

1 - warning: SASL authentication problema: unable to open Berkeley db /etc/sasldb2: No such file or directory

Este problema, no meu caso, o dono e o grupo do arquivo /etc/sasldb2 era root root, quando deveria estar root sasl, alterei e depois disso começou a gerar o seguinte erro:

2 - warning: SASL authentication failure: cannot connect to saslauthd server: No such file or directory

Este resolvi alterando o master.cf, que deve estar com a opção de chroot desativada:
==========================================================================
# service type private unpriv chroot wakeup maxproc command + args
# (yes) (yes) (yes) (never) (100)
# ==========================================================================
#smtp inet n - n - - smtpd

É necessário para que o módulo smtpd do postfix consiga acessar o pipe de comunicação do sasl.

Lembrado que o usuário postfix deve estar no grupo sasl:

#adduser postfix sasl

Reinicie os serviços postfix e saslauthd

!!! ;)