From: Alexei Takaseev <alexei@taf.ru>
To: ALT Linux Community <community@altlinux.ru>
Subject: Re: [Comm] postfix SASL AUTH problem
Date: Thu, 18 Nov 2004 22:57:07 +0800
Message-ID: <20041118225707.048ec280.alexei@taf.ru> (raw)
In-Reply-To: <20041118224920.694a4158.alexei@taf.ru>
On Thu, 18 Nov 2004 22:49:20 +0800
Alexei Takaseev <alexei@taf.ru> wrote:
> On Thu, 18 Nov 2004 17:23:34 +0300
> Grigory Fateyev <greg@anastasia.ru> wrote:
>
> > Здравствуйте!
> >
> > Поднял связку postfix+mysql+sasl2, ну и там разные рюшечки. Всё
> > работает хорошо, но smtp через SASL AUTH не работает. В логах:
> >
> > Nov 18 16:59:58 tandem postfix/smtpd[9049]: warning: SASL
> > authentication failure: no secret in database Nov 18 16:59:58 tandem
> > postfix/smtpd[9049]: warning: unknown[]: SASL CRAM-MD5
> > authentication failed
> >
> > И также с LOGIN PLAIN и другими.
> >
> > ## smtpd.conf ##
> > pwcheck_method: auxprop
> > auxprop_plugin: sql
> > mech_list: plain login cram-md5 digest-md5
> > sql_engine: mysql
> > sql_hostnames: localhost
> > sql_user: ...
> > sql_passwd: ...
> > sql_database: ...
> > sql_select: select password from users where email='%u'
> > #pwcheck_method: saslauthd
> > #mech_list: PLAIN LOGIN
> >
> > Что может быть не так?
>
> В каком виде хранятся пароли в БД? В случае с CRAM-MD5 они должны быть
> plaintext
Да, и еще, как _вообще_ выглядит запись пользователя в БД?
Как пример:
/usr/lib/sasl2/smtpd.conf:
auxprop_plugin: sql
mech_list: plain login gssapi digest-md5 cram-md5
sql_engine: pgsql
sql_user: mail
sql_passwd: XXX
sql_hostnames: localhost
sql_database: mail
sql_statement: select password from mailusers where username = '%u' and
domain_name = '%r' and active = 1
Запись в БД:
username | password | domain_name | active
----------+------------+-------------+--------
vasya | superpass | mydom.ru | 1
(1 запись)
next prev parent reply other threads:[~2004-11-18 14:57 UTC|newest]
Thread overview: 11+ messages / expand[flat|nested] mbox.gz Atom feed top
2004-11-18 14:23 Grigory Fateyev
2004-11-18 14:29 ` Artem Pastukhov
2004-11-18 14:46 ` Grigory Fateyev
2004-11-18 14:49 ` Artem Pastukhov
2004-11-18 17:00 ` Grigory Fateyev
2004-11-18 14:49 ` Alexei Takaseev
2004-11-18 14:57 ` Alexei Takaseev [this message]
2004-11-18 15:17 ` Grigory Fateyev
2004-11-18 16:53 ` Mikhael Korneev
2004-11-18 17:27 ` Grigory Fateyev
2004-11-18 17:54 ` Mikhael Korneev
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20041118225707.048ec280.alexei@taf.ru \
--to=alexei@taf.ru \
--cc=community@altlinux.ru \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
ALT Linux Community general discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 community community/ http://lore.altlinux.org/community \
mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
public-inbox-index community
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.community
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git