postfix+dovecot+mysql не раскладывает внешнюю почту
Добавлено: 2011-01-21 11:28:51
Данный почтовик бросает всю почту из внешнего мира (например c mail.ru) в один и тот же ящик, не доводя письмо до адресата. Почту забираю fetchmail-ом. С отправкой проблем нет. Кстати внутри сети почта и принимается и отправляется. На чкм все это работает:
Debian 5
Apache 2.2.9
mysql 5.0.51
postfix
dovecot 1.0.15
fetchmail 6.3.9
конфиг довекота:
base_dir: /var/run/dovecot/
log_path: /var/log/dovecot.log
info_log_path: /var/log/dovecot.info
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: imap imaps pop3 pop3s
ssl_listen: 192.168.1.127
ssl_parameters_regenerate: 0
disable_plaintext_auth: no
verbose_ssl: yes
login_dir: /var/run/dovecot/login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(pop3): /usr/lib/dovecot/pop3-login
login_max_processes_count: 64
first_valid_uid: 5000
first_valid_gid: 5000
mail_access_groups: mail
mail_privileged_group: mail
mail_location: maildir:/home/vmail/%d/%n
mail_debug: yes
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/dovecot/pop3
mail_plugin_dir(default): /usr/lib/dovecot/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3
imap_client_workarounds(default): outlook-idle delay-newmail netscape-eoh tb-extra-mailbox-sep
imap_client_workarounds(imap): outlook-idle delay-newmail netscape-eoh tb-extra-mailbox-sep
imap_client_workarounds(pop3): outlook-idle
pop3_uidl_format(default):
pop3_uidl_format(imap):
pop3_uidl_format(pop3): %08Xu%08Xv
auth default:
mechanisms: plain login cram-md5 digest-md5
user: vmail
username_format: %Lu
verbose: yes
debug: yes
debug_passwords: yes
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
socket:
type: listen
client:
path: /var/spool/postfix/private/auth
mode: 438
master:
path: /var/run/dovecot/auth-master
mode: 438
конфиг Dovecot-sql.conf:
driver = mysql
connect = dbname=postfix user=postfix host=127.0.0.1 password=
default_pass_scheme = MD5-CRYPT
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT maildir, 5000 AS uid, 5000 AS gid FROM mailbox WHERE username = '%u'
конфиг postfix main.cf:
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 106
virtual_transport = dovecot
virtual_uid_maps = static:5000
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated,
reject_non_fqdn_hostname, reject_non_fqdn_sender, reject_non_fqdn_recipient,
reject_unauth_destination, reject_unauth_pipelining, reject_invalid_hostname
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_sasl_security_options = noanonymous
smtpd_sasl_security_options = noanonymous
mydestination = localhost
relayhost = 212.109.32.5
mynetworks = 127.0.0.0/8 192.168.1.0/24
mailbox_size_limit = 80000000000
recipient_delimiter =
inet_interfaces = all
inet_protocols = ipv4
master.cf:
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman unix - n n - - pipe
flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
${nexthop} ${user}
dovecot unix - n n - - pipe
flags=DRhu user=vmail:vmail argv=/usr/lib/dovecot/deliver -d ${recipient}
отправляю письмо с mail.ru на server@lgroup.com.ua, а приходит это письмо на tatarin_as@mail.ru
после fetchmail в логах лежит вот это:
dovecot.log - чистый
mail.log:
Jan 20 10:23:19 debian postfix/qmgr[562]: 349095BF16: from=<info@elwing.org>, size=5278, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/cleanup[6173]: 422A05C6A5: message-id=<4A19BF4866D5494E9C9C17A9F3C06FA7@MARCUS>
Jan 20 10:23:19 debian postfix/local[6174]: 349095BF16: to=<root@localhost>, relay=local, delay=0.08, delays=0.06/0/0/0.03, dsn=2.0.0, status=sent (forwarded as 422A05C6A5)
Jan 20 10:23:19 debian postfix/qmgr[562]: 422A05C6A5: from=<info@elwing.org>, size=5406, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/qmgr[562]: 349095BF16: removed
Jan 20 10:23:19 debian postfix/pipe[6175]: 422A05C6A5: to=<tatarin@lgroup.com.ua>, orig_to=<root@localhost>, relay=dovecot, delay=0.01, delays=0/0/0/0.01, dsn=2.0.0, status=sent (delivered via dovecot service)
Jan 20 10:23:19 debian postfix/qmgr[562]: 422A05C6A5: removed
Jan 20 10:23:19 debian postfix/smtpd[6169]: 7B4665BF16: client=localhost[127.0.0.1]
Jan 20 10:23:19 debian postfix/cleanup[6173]: 7B4665BF16: message-id=<1846044017.20110120102059@mail.ru>
Jan 20 10:23:19 debian postfix/qmgr[562]: 7B4665BF16: from=<tatarin_as@mail.ru>, size=1670, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/cleanup[6173]: 884605C6A5: message-id=<1846044017.20110120102059@mail.ru>
Jan 20 10:23:19 debian postfix/qmgr[562]: 884605C6A5: from=<tatarin_as@mail.ru>, size=1798, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/local[6174]: 7B4665BF16: to=<root@localhost>, relay=local, delay=0.07, delays=0.05/0/0/0.02, dsn=2.0.0, status=sent (forwarded as 884605C6A5)
Jan 20 10:23:19 debian postfix/qmgr[562]: 7B4665BF16: removed
Jan 20 10:23:19 debian postfix/pipe[6175]: 884605C6A5: to=<tatarin@lgroup.com.ua>, orig_to=<root@localhost>, relay=dovecot, delay=0.01, delays=0/0/0/0, dsn=2.0.0, status=sent (delivered via dovecot service)
Jan 20 10:23:19 debian postfix/qmgr[562]: 884605C6A5: removed
Jan 20 10:23:19 debian postfix/smtpd[6169]: disconnect from localhost[127.0.0.1]
dovecot.info:
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: tatarin@lgroup.com.ua
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: maildir=tatarin@lgroup.com.ua/
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: uid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: gid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: data=/home/vmail/lgroup.com.ua/tatarin
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: root=/home/vmail/lgroup.com.ua/tatarin, index=/home/vmail/lgroup.com.ua/tatarin, control=, inbox=
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: msgid=<4A19BF4866D5494E9C9C17A9F3C06FA7@MARCUS>: saved mail to INBOX
dovecot: 2011-01-20 10:23:19 Info: auth(default): master in: USER 1 tatarin@lgroup.com.ua service=deliver
dovecot: 2011-01-20 10:23:19 Info: auth-worker(default): sql(tatarin@lgroup.com.ua): SELECT maildir, 5000 AS uid, 5000 AS gid FROM mailbox WHERE username = 'tatarin@lgroup.com.ua'
dovecot: 2011-01-20 10:23:19 Info: auth(default): master out: USER 1 tatarin@lgroup.com.ua maildir=tatarin@lgroup.com.ua/ uid=5000 gid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: tatarin@lgroup.com.ua
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: maildir=tatarin@lgroup.com.ua/
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: uid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: gid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: data=/home/vmail/lgroup.com.ua/tatarin
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: root=/home/vmail/lgroup.com.ua/tatarin, index=/home/vmail/lgroup.com.ua/tatarin, control=, inbox=
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: msgid=<1846044017.20110120102059@mail.ru>: saved mail to INBOX
В результате вся почта в tatarin@lgroup.com.ua. Кстати папка создалась сама по себе, для проверки создал postfixmyadmin-ом юзера с таким же именем – теперь получаю всю почту, но только в один ящик.
Ковыряюсь уже дня два, чувствую что ошибка мелкая и где-то проблема в sql запросе, но где я так и не нашел.
Debian 5
Apache 2.2.9
mysql 5.0.51
postfix
dovecot 1.0.15
fetchmail 6.3.9
конфиг довекота:
base_dir: /var/run/dovecot/
log_path: /var/log/dovecot.log
info_log_path: /var/log/dovecot.info
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: imap imaps pop3 pop3s
ssl_listen: 192.168.1.127
ssl_parameters_regenerate: 0
disable_plaintext_auth: no
verbose_ssl: yes
login_dir: /var/run/dovecot/login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(pop3): /usr/lib/dovecot/pop3-login
login_max_processes_count: 64
first_valid_uid: 5000
first_valid_gid: 5000
mail_access_groups: mail
mail_privileged_group: mail
mail_location: maildir:/home/vmail/%d/%n
mail_debug: yes
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/dovecot/pop3
mail_plugin_dir(default): /usr/lib/dovecot/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3
imap_client_workarounds(default): outlook-idle delay-newmail netscape-eoh tb-extra-mailbox-sep
imap_client_workarounds(imap): outlook-idle delay-newmail netscape-eoh tb-extra-mailbox-sep
imap_client_workarounds(pop3): outlook-idle
pop3_uidl_format(default):
pop3_uidl_format(imap):
pop3_uidl_format(pop3): %08Xu%08Xv
auth default:
mechanisms: plain login cram-md5 digest-md5
user: vmail
username_format: %Lu
verbose: yes
debug: yes
debug_passwords: yes
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
socket:
type: listen
client:
path: /var/spool/postfix/private/auth
mode: 438
master:
path: /var/run/dovecot/auth-master
mode: 438
конфиг Dovecot-sql.conf:
driver = mysql
connect = dbname=postfix user=postfix host=127.0.0.1 password=
default_pass_scheme = MD5-CRYPT
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT maildir, 5000 AS uid, 5000 AS gid FROM mailbox WHERE username = '%u'
конфиг postfix main.cf:
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 106
virtual_transport = dovecot
virtual_uid_maps = static:5000
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated,
reject_non_fqdn_hostname, reject_non_fqdn_sender, reject_non_fqdn_recipient,
reject_unauth_destination, reject_unauth_pipelining, reject_invalid_hostname
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_sasl_security_options = noanonymous
smtpd_sasl_security_options = noanonymous
mydestination = localhost
relayhost = 212.109.32.5
mynetworks = 127.0.0.0/8 192.168.1.0/24
mailbox_size_limit = 80000000000
recipient_delimiter =
inet_interfaces = all
inet_protocols = ipv4
master.cf:
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman unix - n n - - pipe
flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
${nexthop} ${user}
dovecot unix - n n - - pipe
flags=DRhu user=vmail:vmail argv=/usr/lib/dovecot/deliver -d ${recipient}
отправляю письмо с mail.ru на server@lgroup.com.ua, а приходит это письмо на tatarin_as@mail.ru
после fetchmail в логах лежит вот это:
dovecot.log - чистый
mail.log:
Jan 20 10:23:19 debian postfix/qmgr[562]: 349095BF16: from=<info@elwing.org>, size=5278, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/cleanup[6173]: 422A05C6A5: message-id=<4A19BF4866D5494E9C9C17A9F3C06FA7@MARCUS>
Jan 20 10:23:19 debian postfix/local[6174]: 349095BF16: to=<root@localhost>, relay=local, delay=0.08, delays=0.06/0/0/0.03, dsn=2.0.0, status=sent (forwarded as 422A05C6A5)
Jan 20 10:23:19 debian postfix/qmgr[562]: 422A05C6A5: from=<info@elwing.org>, size=5406, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/qmgr[562]: 349095BF16: removed
Jan 20 10:23:19 debian postfix/pipe[6175]: 422A05C6A5: to=<tatarin@lgroup.com.ua>, orig_to=<root@localhost>, relay=dovecot, delay=0.01, delays=0/0/0/0.01, dsn=2.0.0, status=sent (delivered via dovecot service)
Jan 20 10:23:19 debian postfix/qmgr[562]: 422A05C6A5: removed
Jan 20 10:23:19 debian postfix/smtpd[6169]: 7B4665BF16: client=localhost[127.0.0.1]
Jan 20 10:23:19 debian postfix/cleanup[6173]: 7B4665BF16: message-id=<1846044017.20110120102059@mail.ru>
Jan 20 10:23:19 debian postfix/qmgr[562]: 7B4665BF16: from=<tatarin_as@mail.ru>, size=1670, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/cleanup[6173]: 884605C6A5: message-id=<1846044017.20110120102059@mail.ru>
Jan 20 10:23:19 debian postfix/qmgr[562]: 884605C6A5: from=<tatarin_as@mail.ru>, size=1798, nrcpt=1 (queue active)
Jan 20 10:23:19 debian postfix/local[6174]: 7B4665BF16: to=<root@localhost>, relay=local, delay=0.07, delays=0.05/0/0/0.02, dsn=2.0.0, status=sent (forwarded as 884605C6A5)
Jan 20 10:23:19 debian postfix/qmgr[562]: 7B4665BF16: removed
Jan 20 10:23:19 debian postfix/pipe[6175]: 884605C6A5: to=<tatarin@lgroup.com.ua>, orig_to=<root@localhost>, relay=dovecot, delay=0.01, delays=0/0/0/0, dsn=2.0.0, status=sent (delivered via dovecot service)
Jan 20 10:23:19 debian postfix/qmgr[562]: 884605C6A5: removed
Jan 20 10:23:19 debian postfix/smtpd[6169]: disconnect from localhost[127.0.0.1]
dovecot.info:
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: tatarin@lgroup.com.ua
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: maildir=tatarin@lgroup.com.ua/
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: uid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: gid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: data=/home/vmail/lgroup.com.ua/tatarin
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: root=/home/vmail/lgroup.com.ua/tatarin, index=/home/vmail/lgroup.com.ua/tatarin, control=, inbox=
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: msgid=<4A19BF4866D5494E9C9C17A9F3C06FA7@MARCUS>: saved mail to INBOX
dovecot: 2011-01-20 10:23:19 Info: auth(default): master in: USER 1 tatarin@lgroup.com.ua service=deliver
dovecot: 2011-01-20 10:23:19 Info: auth-worker(default): sql(tatarin@lgroup.com.ua): SELECT maildir, 5000 AS uid, 5000 AS gid FROM mailbox WHERE username = 'tatarin@lgroup.com.ua'
dovecot: 2011-01-20 10:23:19 Info: auth(default): master out: USER 1 tatarin@lgroup.com.ua maildir=tatarin@lgroup.com.ua/ uid=5000 gid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: tatarin@lgroup.com.ua
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: maildir=tatarin@lgroup.com.ua/
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: uid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: auth input: gid=5000
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: data=/home/vmail/lgroup.com.ua/tatarin
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: maildir: root=/home/vmail/lgroup.com.ua/tatarin, index=/home/vmail/lgroup.com.ua/tatarin, control=, inbox=
deliver(tatarin@lgroup.com.ua): 2011-01-20 10:23:19 Info: msgid=<1846044017.20110120102059@mail.ru>: saved mail to INBOX
В результате вся почта в tatarin@lgroup.com.ua. Кстати папка создалась сама по себе, для проверки создал postfixmyadmin-ом юзера с таким же именем – теперь получаю всю почту, но только в один ящик.
Ковыряюсь уже дня два, чувствую что ошибка мелкая и где-то проблема в sql запросе, но где я так и не нашел.