Mail system configuration error

Mail system configuration error

Не заходит в почтовый ящик, а также не отправляется на него почта, в логе mail следующее:
May 18 15:36:25 localhost postfix/postfix-script[750]: starting the Postfix mail system
May 18 15:36:25 localhost postfix/master[756]: daemon started — version 2.10.1, configuration /etc/postfix
May 18 15:37:18 templateupdate postfix/postfix-script[756]: starting the Postfix mail system
May 18 15:37:18 templateupdate postfix/master[761]: daemon started — version 2.10.1, configuration /etc/postfix
Nov 23 12:40:47 templateupdate postfix/postfix-script[728]: starting the Postfix mail system
Nov 23 12:40:47 templateupdate postfix/master[732]: daemon started — version 2.10.1, configuration /etc/postfix
Dec 15 15:03:26 templateupdate postfix/postfix-script[740]: starting the Postfix mail system
Dec 15 15:03:26 templateupdate postfix/master[743]: daemon started — version 2.10.1, configuration /etc/postfix
Dec 15 15:04:18postfix/postfix-script[744]: starting the Postfix mail system
Dec 15 15:04:18postfix/master[749]: daemon started — version 2.10.1, configuration /etc/postfix
Dec 15 15:37:07dovecot: master: Dovecot v2.2.10 starting up for imap, pop3, lmtp (core dumps disabled)
Dec 15 15:37:07dovecot: master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Dec 15 15:37:13dovecot: ssl-params: Fatal: Error reading configuration: read(/var/run/dovecot/config) failed: Connection reset by peer
Dec 15 15:37:13dovecot: anvil: Fatal: Error reading configuration: read(/var/run/dovecot/config) failed: Connection reset by peer
Dec 15 15:37:13dovecot: master: Dovecot v2.2.10 starting up for imap, pop3, lmtp (core dumps disabled)
Dec 15 15:37:19dovecot: master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Dec 15 15:37:19dovecot: anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Dec 15 15:37:19dovecot: log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Dec 15 15:37:19dovecot: master: Dovecot v2.2.10 starting up for imap, pop3, lmtp (core dumps disabled)
Dec 15 15:37:19postfix/postfix-script[14249]: stopping the Postfix mail system
Dec 15 15:37:19 postfix/master[749]: terminating on signal 15
Dec 15 15:40:45dovecot: master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Dec 15 15:40:45dovecot: anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Dec 15 15:40:45dovecot: log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Dec 15 15:40:45dovecot: master: Dovecot v2.2.10 starting up for imap, pop3, lmtp (core dumps disabled)
Dec 15 15:54:00 dovecot: imap-login: Login: user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=18260, secured, session=
Dec 15 15:54:00 dovecot: imap: Error: user admin@***.com: Mail access for users with UID 500 not permitted (see first_valid_uid in config file, uid from userdb lookup).
Dec 15 15:54:00 dovecot: imap: Error: Invalid user settings. Refer to server log for more information.

Пробовал переустанавливать dovecot проблема не решилась, подскажите что делать?

Источник

PostfixAdmin Discussion

Forums

PostfixAdmin+Dovecot+PGSQL+SSL

Hello all, I am having an issue, sending mail externally. I had tested this functionality before implementing PostfixAdmin and PGSQL. I will provide config files upon request. Here is the error I receive:

Jul 22 13:36:14 mail postfix/postfix-script [8894] : starting the Postfix mail system
Jul 22 13:36:14 mail postfix/master [8895] : daemon started — version 2.6.6, configuration /etc/postfix
Jul 22 13:36:14 mail postfix/qmgr [8898] : 8992D604A7: from=double-bounce@mail.aperi.technology, size=1371, nrcpt=1 (queue active)
Jul 22 13:36:14 mail postfix/virtual [8902] : warning: pgsql query failed: fatal error from host localhost: ERROR: operator does not exist: boolean = integer?LINE 1: . WHERE username = ‘peter@aperi.technology’ AND active = 1? ^?HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.?
Jul 22 13:36:14 mail postfix/virtual [8902] : warning: table virtual_mailbox_maps: lookup peter@aperi.technology: Success
Jul 22 13:36:14 mail postfix/virtual [8902] : 8992D604A7: to=peter@aperi.technology, orig_to=

, relay=virtual, delay=369, delays=369/0.03/0/0.07, dsn=4.3.5, status=deferred (mail system configuration error)
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : warning: dict_nis_init: NIS domain name not set — NIS lookups disabled
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : connect from 216-82-214-57.static.grandenetworks.net [216.82.214.57]
Jul 22 13:36:18 mail dovecot: auth: Debug: auth client connected (pid=8905)
Jul 22 13:36:18 mail dovecot: auth: Debug: client in: AUTH#0111#011PLAIN#011service=smtp#011nologin#011lip=192.168.0.2#011rip=216.82.214.57#011secured#011resp=AHBldGVyQGFwZXJpLnRlY2hub2xvZ3kASXB3bm4wMGJz
Jul 22 13:36:18 mail dovecot: auth: Debug: sql(peter@aperi.technology,216.82.214.57): query: SELECT username AS user,password FROM mailbox WHERE username = ‘peter@aperi.technology’ AND active=’1′
Jul 22 13:36:18 mail dovecot: auth: Debug: client out: OK#0111#011user=peter@aperi.technology
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : warning: pgsql query failed: fatal error from host localhost: ERROR: operator does not exist: boolean = integer?LINE 1: . @’ || alias_domain.target_domain AND alias.active = 1 AND al. ^?HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.?
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : NOQUEUE: reject: RCPT from 216-82-214-57.static.grandenetworks.net [216.82.214.57] : 451 4.3.0 lawlfish.pc@gmail.com: Temporary lookup failure; from=peter@aperi.technology to=lawlfish.pc@gmail.com proto=ESMTP helo= [192.168.0.4] >
Jul 22 13:36:20 mail postfix/cleanup [8911] : 2514E605D0: message-id=20140722183620.2514E605D0@mail.aperi.technology
Jul 22 13:36:20 mail postfix/submission/smtpd [8905] : disconnect from 216-82-214-57.static.grandenetworks.net [216.82.214.57]
Jul 22 13:36:20 mail postfix/qmgr [8898] : 2514E605D0: from=double-bounce@mail.aperi.technology, size=1371, nrcpt=1 (queue active)
Jul 22 13:36:20 mail postfix/virtual [8902] : warning: table virtual_mailbox_maps: lookup peter@aperi.technology: Success
Jul 22 13:36:20 mail postfix/virtual [8902] : 2514E605D0: to=peter@aperi.technology, orig_to=

, relay=virtual, delay=0.11, delays=0.07/0/0/0.03, dsn=4.3.5, status=deferred (mail system configuration error)

Источник

forum.lissyara.su

Русские солдаты не умирают — они отсутпают в рай, на перегруппировку

Не создаются почтовые ящики postfixadmin.

Модератор: xM

Не создаются почтовые ящики postfixadmin.

Услуги хостинговой компании Host-Food.ru

Да, отправлял. Создавал домены, создавал ящики, создавал админов. Уже чё тока не создавал. Папка пуста =(

хех, по крайней мере увидел хоть это «permin_sasl_authenticated». Ммда, чего тока не напишешь.

+========================================+
Добавлено спустя 10 минут
+========================================+
Вообщем порылся, нашёл пару багов. Исправил. Теперь при создании почтового ящика пишет вот это.

+=============+
спустя 2 минуты
+=============+
обратил внимание на эту строку
Oct 22 16:38:10 denison clamsmtpd: 10004D: couldn’t open cache file: Permission denied
После чего командой chown clamav:mail /tmp/clamav_temp
поменял владельцев директории. Начали создаваться ящики. Отлично. Но смущает эта запись млин.
warning: do not list domain denison.net.ru in BOTH mydestination and virtual_mailbox_domains

Вроде и в mydestination домен есть, и в virtual_mailbox_domains тоже есть. Чё ему надо.

Re: Не создаются почтовые ящики postfixadmin.

Непрочитанное сообщение Shvapsss » 2010-01-28 16:04:41

Прошу прощения что пишу в ЭТУ тему, чет не могу найти более подходящую.
Надеюсь письмо не будет без внимания.

Я на форуме задавал так же еще несколько вопросов но не смог продолжить тему потому что сел делать связку Postfix+Dovecot+Postfixadmin+roundcube.
Все настроил за исключением нескольких моментов.
1й момент заключается в том, что мне нужно выставить себе таймаут на отправку писем.
Например я приготовил 20 писем и жму отправить. Мне нужно что бы они уходили с промежутком в 2 секунды между каждым.
Что мне нужно прописать? какой параметр?

2й момент заключается в том что у меня ROUNDCUBE не отсылает письма. Грит мол не могу пройти аунтификацию. Привожу лог роундкуба.

Re: Не создаются почтовые ящики postfixadmin.

Re: Не создаются почтовые ящики postfixadmin.

Непрочитанное сообщение Shvapsss » 2010-01-29 12:19:36

Re: Не создаются почтовые ящики postfixadmin.

Ага. Dovecot настрой на работу по IMAP и POP3.

Re: Не создаются почтовые ящики postfixadmin.

Непрочитанное сообщение Григорий » 2011-02-26 19:09:20

Источник

unixforum.org

Форум для пользователей UNIX-подобных систем

• Темы без ответов
• Активные темы
• Поиск
• Статус форума

postfix + dovecot

Модератор: SLEDopit

postfix + dovecot

Сообщение rootmce » 02.01.2010 17:59

Re: postfix + dovecot

Сообщение rootmce » 02.01.2010 18:16

log_path = /var/log/dovecont/dovecont.log
cat /var/log/dovecont/dovecont.log

Ishu error)) Vremeno snayto.

Re: postfix + dovecot

Сообщение strah » 02.01.2010 18:36

Re: postfix + dovecot

Сообщение rootmce » 02.01.2010 18:52

Re: postfix + dovecot

Сообщение Kaz_n » 02.01.2010 21:03

Что за спам фильтр ? он вообще запущен?

Re: postfix + dovecot

Сообщение rootmce » 02.01.2010 22:40

Что за спам фильтр ? он вообще запущен?

Re: postfix + dovecot

Сообщение Kaz_n » 03.01.2010 10:39

Re: postfix + dovecot

Сообщение rootmce » 03.01.2010 11:27

Re: postfix + dovecot

Сообщение Kaz_n » 03.01.2010 12:28

попробуй ассассин в мастере запускать от имени vmail:mail, возможно довекот не принимает почту от user=spamfilter
смотри снова логи довекота

также у меня строка dovecot-а выглядит так:

dovecot unix — n n — — pipe
flags=DRhu user=vmail:mail argv=/usr/bin/spamc -u vmail -e /usr/lib/dovecot/deliver -f $ -d $

в твоем случае наверное
dovecot unix — n n — — pipe
flags=DRhu user=vmail:mail argv=/usr/local/bin/spamfilter -u vmail -e /usr/lib/dovecot/deliver -f $ -d $

в любом случае еще раз лог довекота

Re: postfix + dovecot

Сообщение rootmce » 03.01.2010 13:18

Re: postfix + dovecot

Сообщение skor » 03.01.2010 16:51

Re: postfix + dovecot

Сообщение rootmce » 03.01.2010 17:22

Ща гляну как это должно быть. секундочку!

Мда. мозг мне купить надо сходить. только вот куда не понятно((( В этом и была скорее всего ошибка)) Вот так надо:

Источник

PostfixAdmin Discussion

Forums

PostfixAdmin+Dovecot+PGSQL+SSL

Hello all, I am having an issue, sending mail externally. I had tested this functionality before implementing PostfixAdmin and PGSQL. I will provide config files upon request. Here is the error I receive:

Jul 22 13:36:14 mail postfix/postfix-script [8894] : starting the Postfix mail system
Jul 22 13:36:14 mail postfix/master [8895] : daemon started — version 2.6.6, configuration /etc/postfix
Jul 22 13:36:14 mail postfix/qmgr [8898] : 8992D604A7: from=double-bounce@mail.aperi.technology, size=1371, nrcpt=1 (queue active)
Jul 22 13:36:14 mail postfix/virtual [8902] : warning: pgsql query failed: fatal error from host localhost: ERROR: operator does not exist: boolean = integer?LINE 1: . WHERE username = ‘peter@aperi.technology’ AND active = 1? ^?HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.?
Jul 22 13:36:14 mail postfix/virtual [8902] : warning: table virtual_mailbox_maps: lookup peter@aperi.technology: Success
Jul 22 13:36:14 mail postfix/virtual [8902] : 8992D604A7: to=peter@aperi.technology, orig_to=

, relay=virtual, delay=369, delays=369/0.03/0/0.07, dsn=4.3.5, status=deferred (mail system configuration error)
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : warning: dict_nis_init: NIS domain name not set — NIS lookups disabled
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : connect from 216-82-214-57.static.grandenetworks.net [216.82.214.57]
Jul 22 13:36:18 mail dovecot: auth: Debug: auth client connected (pid=8905)
Jul 22 13:36:18 mail dovecot: auth: Debug: client in: AUTH#0111#011PLAIN#011service=smtp#011nologin#011lip=192.168.0.2#011rip=216.82.214.57#011secured#011resp=AHBldGVyQGFwZXJpLnRlY2hub2xvZ3kASXB3bm4wMGJz
Jul 22 13:36:18 mail dovecot: auth: Debug: sql(peter@aperi.technology,216.82.214.57): query: SELECT username AS user,password FROM mailbox WHERE username = ‘peter@aperi.technology’ AND active=’1′
Jul 22 13:36:18 mail dovecot: auth: Debug: client out: OK#0111#011user=peter@aperi.technology
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : warning: pgsql query failed: fatal error from host localhost: ERROR: operator does not exist: boolean = integer?LINE 1: . @’ || alias_domain.target_domain AND alias.active = 1 AND al. ^?HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.?
Jul 22 13:36:18 mail postfix/submission/smtpd [8905] : NOQUEUE: reject: RCPT from 216-82-214-57.static.grandenetworks.net [216.82.214.57] : 451 4.3.0 lawlfish.pc@gmail.com: Temporary lookup failure; from=peter@aperi.technology to=lawlfish.pc@gmail.com proto=ESMTP helo= [192.168.0.4] >
Jul 22 13:36:20 mail postfix/cleanup [8911] : 2514E605D0: message-id=20140722183620.2514E605D0@mail.aperi.technology
Jul 22 13:36:20 mail postfix/submission/smtpd [8905] : disconnect from 216-82-214-57.static.grandenetworks.net [216.82.214.57]
Jul 22 13:36:20 mail postfix/qmgr [8898] : 2514E605D0: from=double-bounce@mail.aperi.technology, size=1371, nrcpt=1 (queue active)
Jul 22 13:36:20 mail postfix/virtual [8902] : warning: table virtual_mailbox_maps: lookup peter@aperi.technology: Success
Jul 22 13:36:20 mail postfix/virtual [8902] : 2514E605D0: to=peter@aperi.technology, orig_to=

, relay=virtual, delay=0.11, delays=0.07/0/0/0.03, dsn=4.3.5, status=deferred (mail system configuration error)

Источник

Здравствуйте! Почему-то не приходит почта на сервер. Стоит связка Postfix + Dovecot + MySQL backend.
В логах почтового сервера, который должен принять почту, вижу это:

Feb  2 16:42:39 server postfix/smtpd[29994]: disconnect from forward5m.cmail.yandex.net[5.255.216.23] ehlo=2 starttls=1 mail=1 rcpt=1 data=1 quit=1 commands=7
Feb  2 16:42:39 server postfix/virtual[29999]: warning: recipient user1@sub.domain.ru: not found in virtual_uid_maps
Feb  2 16:42:39 server postfix/virtual[29999]: 89BE7C49FD: to=<user1@sub.domain.ru>, relay=virtual, delay=0.06, delays=0.03/0.01/0/0.01, dsn=4.3.5, status=deferred (mail system configuration error)
Feb  2 16:45:31 server postfix/qmgr[29240]: A6C78C49F5: from=<dart@domain.ru>, size=76780, nrcpt=1 (queue active)
Feb  2 16:45:31 server postfix/virtual[30040]: warning: recipient user1@sub.domain.ru: not found in virtual_uid_maps
Feb  2 16:45:31 server postfix/virtual[30040]: A6C78C49F5: to=<user1@sub.domain.ru>, relay=virtual, delay=2388, delays=2388/0.02/0/0.01, dsn=4.3.5, status=deferred (mail system configuration error)
Feb  2 16:45:59 server postfix/anvil[29996]: statistics: max connection rate 1/60s for (smtp:5.255.216.23) at Feb  2 16:42:39
Feb  2 16:45:59 server postfix/anvil[29996]: statistics: max connection count 1 for (smtp:5.255.216.23) at Feb  2 16:42:39
Feb  2 16:45:59 server postfix/anvil[29996]: statistics: max cache size 1 at Feb  2 16:42:39
Feb  2 16:50:31 server postfix/qmgr[29240]: 89BE7C49FD: from=<dart@domain.ru>, size=77443, nrcpt=1 (queue active)
Feb  2 16:50:31 server postfix/virtual[30143]: warning: recipient user1@sub.domain.ru: not found in virtual_uid_maps
Feb  2 16:50:31 server postfix/virtual[30143]: 89BE7C49FD: to=<user1@sub.domain.ru>, relay=virtual, delay=472, delays=472/0.02/0/0.04, dsn=4.3.5, status=deferred (mail system configuration error)
Feb  2 16:50:38 server postfix/smtpd[30145]: connect from forward8o.cmail.yandex.net[37.9.109.55]
Feb  2 16:50:38 server postfix/smtpd[30145]: E7F09C49FF: client=forward8o.cmail.yandex.net[37.9.109.55]

main.cf :

# See /usr/share/postfix/main.cf.dist for a commented, more complete version


# Debian specific:  Specifying a file name will cause the first
# line of that file to be used as the name.  The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

readme_directory = no

# TLS parameters
smtpd_tls_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem
smtpd_tls_key_file=/etc/ssl/private/ssl-cert-snakeoil.key
smtpd_use_tls=yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

smtpd_relay_restrictions = permit_mynetworks permit_sasl_authenticated defer_unauth_destination
myhostname = domain.ru
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = $myhostname,  localhost.domain.ru , localhost
relayhost = 
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
inet_protocols = all
# директория для хранения почты
virtual_mailbox_base = /var/mail/
virtual_mailbox_domains = proxy:mysql:/etc/postfix/sql/mysql-virtual_domains.cf
virtual_alias_maps =   proxy:mysql:/etc/postfix/sql/mysql-virtual_forwardings.cf,  mysql:/etc/postfix/sql/mysql-virtual_email2email.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/sql/mysql-virtual_mailboxes.cf
local_recipient_maps = $virtual_mailbox_maps
relay_domains =

mysql-virtual_domains.cf :

user = mail
password = pass
dbname = mail
query = SELECT domain  FROM domains WHERE domain = '%s'
hosts = 127.0.0.1

mysql-virtual_mailboxes.cf :

user = mail
password = pass
dbname = mail
query = SELECT CONCAT( SUBSTRING_INDEX(email, '@', -1), '/' , SUBSTRING_INDEX(email, '@', 1), '/' ) FROM users WHERE email = '%s'
hosts = 127.0.0.1

mysql-virtual_forwardings.cf

user = mail
password = pass
dbname = mail
query = SELECT destination FROM forwardings WHERE source = '%s'
hosts = 127.0.0.1

mysql-virtual_email2email.cf :

user = mail
password = pass
dbname = mail
query = SELECT destination FROM forwardings WHERE source = '%s'
hosts = 127.0.0.1

В чём может быть причина?

I’m trying to setup always_bcc to an archive account in order to copy all inbound and outbound mail into a mailbox that can be sucked up by a third-party cloud archive solution. Outbound, works fine, no issues. Inbound, and the whole thing falls apart. Everything sent in gets held in the postfix mail queue:

Mail ID     Sent    From    To      Size    Status   
5333C1C03F6 2014/12/18 22:15    *********@gmail.com archive@domain.tld user2@domain.tld     5.02 kB mail system configuration error
7D4F11C07B4 2014/12/18 22:15    *********@gmail.com archive@domain.tld  user1@domain.tld    5.53 kB mail system configuration error:

Logs don’t show anything:
mail.err

Dec 18 17:11:52 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: Duplicate namespace prefix: ""
Dec 18 17:11:52 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:12:59 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: Duplicate namespace prefix: ""
Dec 18 17:12:59 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:12:59 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: Duplicate namespace prefix: ""
Dec 18 17:12:59 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:15:40 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: list=yes requires prefix=a to end with separator
Dec 18 17:15:40 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:15:40 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: list=yes requires prefix=a to end with separator
Dec 18 17:15:40 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:15:42 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: list=yes requires prefix=a to end with separator
Dec 18 17:15:42 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:15:48 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: list=yes requires prefix=a to end with separator
Dec 18 17:15:48 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:17:35 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: list=yes requires prefix=a to end with separator
Dec 18 17:17:35 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 17:17:36 maple dovecot: imap(user1@domain.tld): Error: user user1@domain.tld: Initialization failed: namespace configuration error: list=yes requires prefix=a to end with separator
Dec 18 17:17:36 maple dovecot: imap(user1@domain.tld): Error: Invalid user settings. Refer to server log for more information.
Dec 18 21:07:48 maple dovecot: auth: Error: read(anvil-auth-penalty) failed: EOF
Dec 18 21:07:48 maple dovecot: auth: Error: net_connect_unix(anvil-auth-penalty) failed: Permission denied

mail.cf:

# See /usr/share/postfix/main.cf.dist for a commented, more complete version

# Debian specific:  Specifying a file name will cause the first
# line of that file to be used as the name.  The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

readme_directory = no

# SASL parameters
# --------------------------------
# Postfix 2.3 and later
# smtpd_sasl_path = smtpd
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/auth
# This is a new option as of Postfix 2.10, and is required in addition to
# smtpd_recipient_restrictions for things to work properly in this setup.
# smtpd_relay_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth-destination
smtpd_recipient_restrictions = permit_mynetworks permit_sasl_authenticated reject_unauth_destination check_relay_domains

# TLS parameters
#----------------------------------
smtpd_tls_cert_file = /etc/ssl/certs/postfix.pem
smtpd_tls_key_file = /etc/ssl/private/postfix.pem
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

# These are Postfix 2.3 and later.
#
# Enable (but don't force) all incoming smtp connections to use TLS.
# Enable (but don't force) all outgoing smtp connections to use TLS.
smtp_tls_security_level = may

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

# SMTPD parameters
# ---------------------------------

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h
# will it be a permanent error or temporary
unknown_local_recipient_reject_code = 450
# how long to keep message on queue before return as failed.
# some have 3 days, I have 16 days as I am backup server for some people
# whom go on holiday with their server switched off.
maximal_queue_lifetime = 7d
# max and min time in seconds between retries if connection failed
minimal_backoff_time = 1000s
maximal_backoff_time = 8000s
# how long to wait when servers connect before receiving rest of data
smtp_helo_timeout = 60s
# how many address can be used in one message.
# effective stopper to mass spammers, accidental copy in whole address list
# but may restrict intentional mail shots.
smtpd_recipient_limit = 16
# how many error before back off.
smtpd_soft_error_limit = 3
# how many max errors before blocking it.
smtpd_hard_error_limit = 12
# require proper helo at connections
smtpd_helo_required = yes

# General Host Configuration and Delivery Information
# ----------------------------------

myhostname = maple.domain.tld
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = 
relayhost = domain.tld.outbound10.mxlogic.net:25
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all

# This specifies where the virtual mailbox folders will be located.
virtual_mailbox_base = /var/vmail
# This is for the mailbox location for each user. The domainaliases
# map allows us to make use of Postfix Admin's domain alias feature.
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf, mysql:/etc/postfix/mysql_virtual_mailbox_domainaliases_maps.cf
# and their user id
virtual_uid_maps = static:150
# and group id
virtual_gid_maps = static:8
# This is for aliases. The domainaliases map allows us to make 
# use of Postfix Admin's domain alias feature.
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf, mysql:/etc/postfix/mysql_virtual_alias_domainaliases_maps.cf
# This is for domain lookups.
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf

# Integration with other packages
# ---------------------------------------

# Tell postfix to hand off mail to the definition for dovecot in master.cf
virtual_transport = dovecot

# Getting rid of unwanted headers. See: https://posluns.com/guides/header-removal/
header_checks = regexp:/etc/postfix/header_checks
# getting rid of x-original-to
enable_original_recipient = no
smtpd_tls_CAfile = /etc/ssl/certs/cacert.pem
smtpd_tls_session_cache_timeout = 3600s
smtpd_sasl_auth_enable = yes
smtpd_tls_security_level = may
smtpd_relay_restrictions = permit_mynetworks permit_sasl_authenticated reject_unauth_destination check_relay_domains
always_bcc = archive

I can’t even wrap my head around it since nothing makes sense. The moment I remove the always_bcc line, everything works fine.

Any thoughts, theories, or things that I’m just missing would be helpful!
Thanks!

Edit: Output of dovecot -n

# 2.2.9: /etc/dovecot/dovecot.conf
doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:21: 'imaps' protocol is no longer necessary, remove it
# OS: Linux 3.13.0-43-generic x86_64 Ubuntu 14.04.1 LTS ext4
auth_mechanisms = plain login
disable_plaintext_auth = no
first_valid_uid = 150
last_valid_uid = 150
mail_gid = mail
mail_location = maildir:/var/vmail/%d/%n
mail_uid = vmail
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
postmaster_address = postmaster@domain.tld
protocols = imap
service auth {
  unix_listener /var/spool/postfix/private/auth {
    group = postfix
    mode = 0660
    user = postfix
  }
  unix_listener auth-userdb {
    group = mail
    mode = 0600
    user = vmail
  }
}
service imap-login {
  inet_listener imap {
    port = 143
  }
  inet_listener imaps {
    port = 993
    ssl = yes
  }
}
ssl_cert = </etc/ssl/certs/dovecot.pem
ssl_key = </etc/ssl/private/dovecot.pem
userdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}

UPDATE: Those dovecot namespace errors may be related to some fixes I tried before asking for further help. I’m going to try working on this again over the weekend to see if I can find any further errors in logs or anything else I can find to help me figure out what is going on. I’ll update here whatever I find. This issue is particularly confusing since I can’t seem to find anything that will point me in the right direction. I’m not particularly used to software or config issues that don’t present themselves in an error in some point in the process with clarity.

0 Пользователей и 1 Гость просматривают эту тему.

Модератор: xM

mserver# tail /var/log/maillog
Sep 13 09:42:40 mserver postfix/qmgr[1515]: 693CB8A01A: from=<a1@mfc.ru>, size=709, nrcpt=1 (queue active)
Sep 13 09:42:40 mserver postfix/smtp[1523]: 693CB8A01A: to=<a1@mfc.ru>, relay=mx1.mfc.ru[81.23.6.50]:25, delay=0.28, delays=0.11/0.01/0.15/0.01, dsn=5.0.0, status=bounced (host mx1.mfc.ru[81.23.6.50] said: 550 <a1@mfc.ru>, Sender unknown (in reply to MAIL FROM command))
Sep 13 09:42:40 mserver postfix/cleanup[1522]: AFFEB8A020: message-id=<20110913064240.AFFEB8A020@mserver.ru>
Sep 13 09:42:40 mserver postfix/qmgr[1515]: AFFEB8A020: from=<>, size=2607, nrcpt=1 (queue active)
Sep 13 09:42:40 mserver postfix/bounce[1524]: 693CB8A01A: sender non-delivery notification: AFFEB8A020
Sep 13 09:42:40 mserver postfix/qmgr[1515]: 693CB8A01A: removed
Sep 13 09:42:41 mserver postfix/smtp[1523]: AFFEB8A020: to=<a1@mfc.ru>, relay=mx1.mfc.ru[81.23.6.50]:25, delay=0.4, delays=0.01/0/0.33/0.05, dsn=5.0.0, status=bounced (host mx1.mfc.ru[81.23.6.50] said: 550 <a1@mfc.ru>, Recipient unknown (in reply to RCPT TO command))
Sep 13 09:42:41 mserver postfix/qmgr[1515]: AFFEB8A020: removed
Sep 13 09:42:45 mserver dovecot: pop3-login: Disconnected (auth failed, 1 attempts): user=<aovanesyan>, method=PLAIN, rip=192.168.9.50, lip=192.168.9.111
Sep 13 09:42:45 mserver dovecot: auth(default): new auth connection: pid=1525

mserver# ps ax | grep sql
  775  ??  Is     0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-f
  855  ??  I      0:13.70 /usr/local/libexec/mysqld --defaults-extra-file=/var/

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=PostPass
default_pass_scheme = MD5
password_query = SELECT password FROM mailbox WHERE username = '%u'

Sep 13 13:36:57 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): query: SELECT password FROM mailbox WHERE username = 'a1'
Sep 13 13:36:57 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): unknown user
Sep 13 13:36:59 mserver dovecot: auth(default): client out: FAIL        1      user=a1
Sep 13 13:37:01 mserver postfix/smtpd[1504]: connect from unknown[192.168.9.50]
Sep 13 13:37:01 mserver postfix/smtpd[1504]: 36F068A034: client=unknown[192.168.9.50]

driver = mysql
connect = host=127.0.0.1 dbname=mailserver user=mailserver password=
default_pass_scheme = MD5-CRYPT
password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1'
user_query = SELECT maildir, 5000 AS uid, 5000 AS gid FROM mailbox WHERE username = '%u'

Sep 13 14:29:10 mserver dovecot: auth(default): client in: AUTH 1       PLAIN  service=pop3     lip=192.168.9.111       rip=192.168.9.50        lport=110      rport=52162      resp=<hidden>
Sep 13 14:29:10 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): query: SELECT password FROM mailbox WHERE username = 'a1' AND active = '1'
Sep 13 14:29:10 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): unknown user
Sep 13 14:29:12 mserver dovecot: auth(default): client out: FAIL        1      user=a1
Sep 13 14:29:17 mserver dovecot: pop3-login: Disconnected (auth failed, 1 attempts): user=<a1>, method=PLAIN, rip=192.168.9.50, lip=192.168.9.111
Sep 13 14:29:18 mserver dovecot: auth(default): new auth connection: pid=1638
Sep 13 14:29:20 mserver postfix/smtpd[1639]: connect from unknown[192.168.9.50]
Sep 13 14:29:20 mserver postfix/smtpd[1639]: 282C78A031: client=unknown[192.168.9.50]
Sep 13 14:29:20 mserver postfix/cleanup[1642]: 282C78A031: message-id=<>
Sep 13 14:29:20 mserver postfix/qmgr[1011]: 282C78A031: from=<a1@mfc.ru>, size=709, nrcpt=1 (queue active)
Sep 13 14:29:20 mserver postfix/smtpd[1639]: disconnect from unknown[192.168.9.50]

password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1'
user_query = SELECT maildir FROM mailbox WHERE username = '%u'

  passdb sql {
     args = /usr/local/etc/dovecot-sql.conf
  }
  userdb static {
      args = /usr/local/etc/dovecot-sql.conf

Sep 14 10:02:21 limpteam dovecot: auth(default): client in: AUTH        1       PLAIN   service=imap    secured lip=192.168.0.90        rip=12.212.123.31    lport=993        rport=26410     resp=<hidden>
Sep 14 10:02:21 limpteam dovecot: auth-worker(default): sql(limp@domain.com,123.123.312.12): query: SELECT password FROM mailbox WHERE username = 'limp@domain.com' AND active = '1'
Sep 14 10:02:21 limpteam dovecot: auth(default): client out: OK 1       user=limp@domain.com
Sep 14 10:02:21 limpteam dovecot: auth(default): master in: REQUEST     1       73402   1
Sep 14 10:02:21 limpteam dovecot: auth(default): master out: USER       1       limp@domain.com  uid=5000        gid=5000        home=/mail/mail/limpteam.ru/limp@domain.com/

home_mailbox = Maildir/
virtual_minimum_uid = 1000
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000

virtual_mailbox_domains = mysql:/usr/local/etc/postfix/mysql-virtual-mailbox-domains.cf
virtual_mailbox_maps = mysql:/usr/local/etc/postfix/mysql-virtual-mailbox-maps.cf
virtual_alias_maps = mysql:/usr/local/etc/postfix/mysql-virtual-alias-maps.cf

passdb sql {
    # Path for SQL configuration file.
    # See /usr/local/share/examples/dovecot/dovecot-sql.conf
   args = /usr/local/etc/dovecot-sql.conf
  }

  userdb static {
    # Template for the fields. Can return anything a userdb could normally
    # return. For example:
    #
     args = uid=5000 gid=5000 home=/mail/mail/%d/%u/ allow_all_users=yes
    #
    # If you use deliver, it needs to look up users only from the userdb. This
    # of course doesn't work with static because there is no list of users.
    # Normally static userdb handles this by doing a passdb lookup. This works
    # with most passdbs, with PAM being the most notable exception. If you do
    # the user verification another way, you can add allow_all_users=yes to
    # the args in which case the passdb lookup is skipped.
    #
    }

  socket listen {
    master {
      # Master socket provides access to userdb information. It's typically
      # used to give Dovecot's local delivery agent access to userdb so it
      # can find mailbox locations.
      path = /var/run/dovecot/auth-master
      mode = 0600
      # Default user/group is the one who started dovecot-auth (root)
      user = virtual
      #group =
    }
    client {
      # The client socket is generally safe to export to everyone. Typical use
      # is to export it to your SMTP server so it can do SMTP AUTH lookups
      # using it.
      path = /var/spool/postfix/private/auth
      mode = 0660
user = postfix
group = postfix
    }
  }
}

myhostname = mserver.ru
mydomain = mfc-tver.ru
mydestination = $myhostname
virtual_mailbox_domains = mfc-tver.ru
virtual_mailbox_base = /usr/mail
virtual_mailbox_maps = mysql:/usr/local/etc/postfix/mailbox-maps.cf
virtual_alias_maps = mysql:/usr/local/etc/postfix/alias-maps.cf
virtual_uid_maps = static:125
virtual_gid_maps = static:126

hosts = localhost
user = postfix
password = PostPass
dbname = postfix
query = SELECT CONCAT(user,'/') FROM users WHERE address='%s'

user = mailserver
password = 
hosts = localhost
dbname = mailserver
table = mailbox
select_field = maildir
where_field = username
additional_conditions = and active = '1'

user = mailserver
password = 
hosts = localhost
dbname = mailserver
table = domain
select_field = domain
where_field = domain
additional_conditions = and active = '1' and backupmx = '0'

user = mailserver
password = 
hosts = localhost
dbname = mailserver
query = SELECT goto FROM alias WHERE address='%s' AND active = '1'

postmap -q 'recipient@examle.ru' mysql:/path/mailbox_recipient.cf

Sep 14 07:40:15 mserver postfix/virtual[1371]: warning: maildir access problem for UID/GID=5000/5000: create maildir file /usr/mail//a1@mfc.ru/tmp/1315975215.P1371.mserver: Permission denied
Sep 14 07:40:15 mserver postfix/virtual[1371]: warning: perhaps you need to create the maildirs in advance

pw useradd virtual -g 5000 -u 5000 virtual -d /home/mail -m 
pw groupadd -g 5000 virtual

 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): query: SELECT password FROM mailbox WHERE username = 'a1' AND active = '1'
Sep 14 08:39:46 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): unknown user

password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1'
user_query = SELECT maildir, 125 AS uid, 126 AS gid FROM mailbox WHERE username = '%u'

postfix:*:125:125:Postfix Mail System:/var/spool/postfix:/usr/sbin/nologin

  userdb static {
      args = uid=125 gid=126 mail=maildir:/usr/mail/%u allow_all_users=yes
  }

# Месторасположение пользовательских почтовых ящиков. Это такой же параметр
# как и старый default_mail_env. Значение по умолчанию отсутствует, это
# означает, что Dovecot попытается найти ящики автоматически. Это не будет
# работать, если у пользователя до сих пор нет никакой почты, поэтому вы
# должны непосредственно указать Dovecot полный путь к ящику.
#
# Если вы используете mbox, указание пути к INBOX файлу (например, /var/mail/%u)
# недостаточно. Вам также необходимо указать Dovecot где находятся другие ящики
# и где Dovecot может расположить файлы с индексами. Это называется "корневая
# почтовая директория", и она должна быть указана первой в параметре mail_location.
#
# Существует несколько специальных переменных, которые вы можете использовать:
#
# %u - имя пользователя
# %n - пользовательская часть в user@domain, то же самое что и %u
# если не задана доменная часть
# %d - доменая часть в user@domain, пустая, если не указан домен
# %h - домашний каталог
#
# Смотрите doc/variables.txt для полного списка переменных.
#
# Некоторые примеры:
# mail_location = maildir:~/Maildir
# mail_location = mbox:~/mail:INBOX=/var/mail/%u
# mail_location = mbox:/var/mail/%d/%1n/%n:INDEX=/var/indexes/%d/%1n/%n
#

Sep 14 10:30:18 mserver dovecot: auth(default): client in: AUTH 1       PLAIN   service=pop3    lip=192.168.9.111       rip=192.168.9.50        lport=110       rport=51323     resp=<hidden>
Sep 14 10:30:18 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): query: SELECT password FROM mailbox WHERE username = 'a1' AND active = '1'
Sep 14 10:30:18 mserver dovecot: auth-worker(default): sql(a1,192.168.9.50): unknown user
Sep 14 10:30:20 mserver dovecot: auth(default): client out: FAIL        1       user=a1
Sep 14 10:30:21 mserver postfix/smtpd[1730]: connect from unknown[192.168.9.50]
Sep 14 10:30:21 mserver postfix/smtpd[1730]: 0D1808A066: client=unknown[192.168.9.50]
Sep 14 10:30:21 mserver postfix/cleanup[1733]: 0D1808A066: message-id=<>
Sep 14 10:30:21 mserver postfix/smtpd[1730]: disconnect from unknown[192.168.9.50]
Sep 14 10:30:21 mserver postfix/qmgr[999]: 0D1808A066: from=<a1@mfc.ru>, size=685, nrcpt=1 (queue active)
Sep 14 10:30:21 mserver postfix/virtual[1734]: warning: recipient a1@mfc.ru: bad uid 125 in virtual_uid_maps
Sep 14 10:30:21 mserver postfix/virtual[1734]: 0D1808A066: to=<a1@mfc.ru>, relay=virtual, delay=0.1, delays=0.1/0/0/0, dsn=4.3.5, status=deferred (mail system configuration error)
Sep 14 10:30:25 mserver dovecot: pop3-login: Disconnected (auth failed, 1 attempts): user=<a1>, method=PLAIN, rip=192.168.9.50, lip=192.168.9.111
Sep 14 10:30:25 mserver dovecot: auth(default): new auth connection: pid=1779

// Mailboxes
// If you want to store the mailboxes per domain set this to 'YES'.
// Examples:
//   YES: /usr/local/virtual/domain.tld/username@domain.tld
//   NO:  /usr/local/virtual/username@domain.tld
$CONF['domain_path'] = 'NO';
// If you don't want to have the domain in your mailbox set this to 'NO'.
// Examples:
//   YES: /usr/local/virtual/domain.tld/username@domain.tld
//   NO:  /usr/local/virtual/domain.tld/username
// Note: If $CONF['domain_path'] is set to NO, this setting will be forced to YES.
$CONF['domain_in_mailbox'] = 'YES'

## Dovecot configuration file

protocols = imap pop3
disable_plaintext_auth = no
shutdown_clients = yes

syslog_facility = mail

ssl = no

## Login processes

login_max_processes_count = 2
login_max_connections = 4
login_greeting = Fast Windows POP3server Ready.
mail_privileged_group = mail
mail_location = maildir:/usr/mail/%d/%u/

mail_debug = yes
dotlock_use_excl = yes

verbose_proctitle = yes

first_valid_uid =125
last_valid_uid = 125

max_mail_processes = 4

maildir_copy_with_hardlinks = yes

#protocol imap {
#  login_greeting_capability = yes
#  imap_client_workarounds = delay-newmail netscape-eoh tb-extra-mailbox-sep
#}

protocol pop3 {
  pop3_uidl_format = %08Xu%08Xv
  pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
}

auth_verbose = yes
auth_debug = yes

auth_debug_passwords = no
auth_worker_max_count = 10

auth default {
  mechanisms = plain

  passdb sql {
     args = /usr/local/etc/dovecot-sql.conf
  }

  userdb static {
      args = uid=125 gid=126 mail=maildir:/usr/mail/%u/ allow_all_users=yes
  }

  socket listen {
    client {
          path = /var/spool/postfix/private/auth
          mode = 0660
          user = postfix
          group = postfix
    }
  }

}

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=*****
default_pass_scheme = MD5
password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1'
user_query = SELECT maildir, 125 AS uid, 126 AS gid FROM mailbox WHERE username = '%u'

queue_directory = /var/spool/postfix
command_directory = /usr/local/sbin
daemon_directory = /usr/local/libexec/postfix
data_directory = /var/db/postfix
mail_owner = postfix
unknown_local_recipient_reject_code = 550
mynetworks_style = subnet
debug_peer_level = 2
debugger_command =
         PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
         ddd $daemon_directory/$process_name $process_id & sleep 5
sendmail_path = /usr/local/sbin/sendmail
newaliases_path = /usr/local/bin/newaliases
mailq_path = /usr/local/bin/mailq
setgid_group = maildrop
html_directory = /usr/local/share/doc/postfix
manpage_directory = /usr/local/man
sample_directory = /usr/local/etc/postfix
readme_directory = /usr/local/share/doc/postfix
#===================
mynetworks = 192.168.9.50, 127.0.0.1/8
receive_override_options = no_address_mappings
#-------------------
myhostname = mserver.ru
mydomain = mfc-tver.ru
mydestination = $myhostname
virtual_mailbox_domains = mfc-tver.ru
virtual_mailbox_base = /usr/mail/
virtual_mailbox_maps = mysql:/usr/local/etc/postfix/mailbox-maps.cf
virtual_alias_maps = mysql:/usr/local/etc/postfix/alias-maps.cf
virtual_mailbox_domains = mysql:/usr/local/etc/postfix/mailbox-domain.cf
virtual_uid_maps = static:125
virtual_gid_maps = static:126
#====================
smtpd_recipient_restrictions =
        permit_mynetworks
        permit_auth_destination
        reject_unauth_destination

hosts = localhost
user = postfix
password = PostPass
dbname = postfix
table = mailbox
select_field = maildir
where_field = username
additional_conditions = and active ='1'

hosts = localhost
user = postfix
password = PostPass
dbname = postfix
table = domain
select_field = domain
where_field = domain
additional_conditions = and active ='1' and backupmx ='0'

hosts = localhost
user = postfix
password = PostPass
dbname = postfix
query = SELECT goto FROM alias WHERE address='%s' and active = '1'