Доброе время суток! возникла проблема по настройки postfix по статье.
https://www.opennet.ru/base/net/postfix_mail_guide.txt.html
Перечитал много статей по этому вопросу советовали:
sql_select: select smtppassword from user_accounts where smtplogin='%u' изменить на
sql_select: select smtppassword from user_accounts where smtplogin='%u@%r' не помогло
пробовал этот же запрос дать на прямую в базу... выводит все как надо. Пользователь с правами доступа создан! Я в ступоре!

Заранее всем Спасибо!

Что имеем:
6.4-RELEASE FreeBSD
postfix-2.5.4,1
cyrus-sasl-2.1.22_1

на что ругаются логи

Jul 20 12:37:05 mail postfix/smtpd[16008]: connect from unknown[91.196.76.34]
Jul 20 12:37:05 mail postfix/smtpd[16008]: warning: SASL authentication failure: no secret in database
Jul 20 12:37:05 mail postfix/smtpd[16008]: warning: unknown[91.196.76.34]: SASL NTLM authentication failed: authentication failure
Jul 20 12:37:05 mail postfix/smtpd[16008]: warning: SASL authentication failure: no secret in database
Jul 20 12:37:05 mail postfix/smtpd[16008]: warning: unknown[91.196.76.34]: SASL NTLM authentication failed: authentication failure

main.conf

alias_database = hash:/etc/mail/aliases
alias_maps = hash:/etc/mail/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/local/sbin
config_directory = /usr/local/etc/postfix
daemon_directory = /usr/local/libexec/postfix
default_privs = nobody
disable_vrfy_command = yes
home_mailbox = Maildir/
html_directory = no
inet_interfaces = all
local_recipient_maps =
mail_owner = postfix
mailq_path = /usr/local/bin/mailq
manpage_directory = /usr/local/man
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
mydomain = example.org
myhostname = mail.example.org
mynetworks = 127.0.0.0/8
newaliases_path = /usr/local/bin/newaliases
queue_directory = /var/spool/postfix
readme_directory = no
sample_directory = /usr/local/etc/postfix
mynetworks = 127.0.0.0/8
newaliases_path = /usr/local/bin/newaliases
queue_directory = /var/spool/postfix
readme_directory = no
sample_directory = /usr/local/etc/postfix
sendmail_path = /usr/local/sbin/sendmail
setgid_group = maildrop
smtpd_banner = $myhostname ESMTP
smtpd_helo_required = yes
smtpd_helo_restrictions = check_recipient_access, hash:/usr/local/etc/postfix/postmaster_access,                            check_helo_access, hash:/usr/local/etc/postfix/helo_access,                            permit_sasl_authenticated,                            reject_invalid_hostname,                            reject_unknown_hostname,                            reject_non_fqdn_hostname
smtpd_recipient_restrictions = permit_sasl_authenticated,                                reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
transport_maps = pgsql:/usr/local/etc/postfix/transport.cf
unknown_local_recipient_reject_code = 550
virtual_alias_maps = pgsql:/usr/local/etc/postfix/alias.cf
virtual_gid_maps = static:126
virtual_mailbox_base = /
virtual_mailbox_maps = pgsql:/usr/local/etc/postfix/mailbox.cf
virtual_uid_maps = static:125

smtpdconf
pwcheck_method: auxprop
log_level: 9
auxprop_plugin: sql
sql_engine: pgsql
sql_hostnames: localhost
sql_database: mailbase
sql_user: postfix
sql_passwd: postfix
sql_select: select smtppassword from user_accounts where smtplogin='%u'
sql_verbose: yes