{"id":371,"date":"2010-07-27T10:42:06","date_gmt":"2010-07-27T07:42:06","guid":{"rendered":"http:\/\/skeletor.org.ua\/?p=371"},"modified":"2014-08-19T12:11:13","modified_gmt":"2014-08-19T09:11:13","slug":"%d0%b4%d0%be%d0%bc%d0%b5%d0%bd-%d0%b0%d0%bb%d0%b8%d0%b0%d1%81-%d0%b4%d0%bb%d1%8f-postfixadmina","status":"publish","type":"post","link":"https:\/\/skeletor.org.ua\/?p=371","title":{"rendered":"\u0414\u043e\u043c\u0435\u043d \u0430\u043b\u0438\u0430\u0441 \u0434\u043b\u044f postfixadmin’a"},"content":{"rendered":"

\u0412 \u044d\u0442\u043e\u0439 \u0437\u0430\u043c\u0435\u0442\u043a\u0435 \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c \u0434\u043e\u043c\u0435\u043d \u0430\u043b\u0438\u0430\u0441 \u0447\u0435\u0440\u0435\u0437 postfixadmin<\/strong>. \u0427\u0442\u043e \u0434\u043e\u043b\u0436\u043d\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0432 \u0438\u0442\u043e\u0433\u0435:<\/p>\n

– \u043f\u0440\u0438\u0451\u043c \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439 \u043e\u0442 \u0430\u043b\u0438\u0430\u0441\u0430 \u0434\u043e\u043c\u0435\u043d\u0430<\/p>\n

<\/p>\n

\u0427\u0442\u043e \u0438\u043c\u0435\u0435\u043c: FreeBSD 8.0, postfixadmin-2.3_1<\/strong>, postfix-2.6.5,1, dovecot-1.2.10<\/strong>.<\/span><\/p>\n

1) \u041f\u0440\u0430\u0432\u0438\u043c postfix<\/span><\/strong><\/p>\n

\u0412 \u0444\u0430\u0439\u043b\u0435 main.cf<\/strong> \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0441\u0442\u0440\u043e\u0447\u043a\u0443<\/p>\n

mysql:\/usr\/local\/etc\/postfix\/mysql\/virtual_mailbox_alias_domain.cf<\/span><\/p><\/blockquote>\n

\u0432 \u0440\u0430\u0437\u0434\u0435\u043b virtual_alias_maps<\/strong><\/p>\n

\u0423 \u043c\u0435\u043d\u044f \u0435\u0449\u0451 \u0442\u0430\u043a\u043e\u0435 \u043f\u0440\u043e\u043f\u0438\u0441\u0430\u043d\u043e:<\/p>\n

virtual_alias_domains = $virtual_alias_maps<\/span><\/p><\/blockquote>\n

\u0422\u0430\u043a \u0436\u0435 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0441\u0442\u0440\u043e\u043a\u0443<\/p>\n

mysql:\/usr\/local\/etc\/postfix\/mysql\/virtual_domain_alias.cf<\/span><\/p><\/blockquote>\n

\u0432 \u0440\u0430\u0437\u0434\u0435\u043b virtual_mailbox_maps<\/strong><\/p>\n

#cat virtual_domain_alias.cf<\/span><\/p>\n

user = postfix
\npassword = postfix
\nhosts = localhost
\ndbname = postfix
\nquery = SELECT goto FROM alias,alias_domain
\nWHERE alias_domain.alias_domain = ‘%d’
\nAND alias.address=concat(‘%u’, ‘@’, alias_domain.target_domain)
\nAND alias.active = 1
\n<\/span><\/p>\n


\n<\/span><\/p>\n

#cat virtual_mailbox_alias_domain.cf<\/span><\/p>\n

user = postfix
\npassword = postfix
\nhosts = localhost
\ndbname = postfix
\nquery = SELECT username FROM mailbox, alias_domain
\nWHERE alias_domain.alias_domain = ‘%d’
\nAND mailbox.username=concat(‘%u’, ‘@’, alias_domain.target_domain )
\nAND mailbox.active = 1<\/span><\/p><\/blockquote>\n

2) \u041f\u0440\u0430\u0432\u0438\u043c dovecot<\/span><\/strong><\/p>\n

\u0412 \u0444\u0430\u0439\u043b\u0435 dovecot-sql.conf<\/strong> \u044f \u0434\u043e\u0431\u0430\u0432\u0438\u043b \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443 \u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u044b:<\/p>\n

OR username = ‘%n@domain.com.ua’<\/span><\/p><\/blockquote>\n

\u0412 \u0438\u0442\u043e\u0433\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c \u0442\u0430\u043a:<\/p>\n

password_query = SELECT password FROM mailbox WHERE username = ‘%u’ OR username = ‘%n@domain.com.ua’ AND active = ‘1’
\nuser_query = SELECT CONCAT(‘\/var\/spool\/vmail\/’,domain,’\/’,maildir) AS home FROM mailbox WHERE username = ‘%n@%d’ OR username = ‘%n@domain.com.ua’<\/span><\/p><\/blockquote>\n

\u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u043f\u0435\u0440\u0435\u0447\u0438\u0442\u044b\u0432\u0430\u0435\u043c \u043a\u043e\u043d\u0444\u0438\u0433\u0438 postfix’a<\/strong> \u0438 dovecot’a<\/strong>.<\/p>\n

\u041d\u0430 \u0432\u0441\u044f\u043a\u0438\u0439 \u0441\u043b\u0443\u0447\u0430\u0439 \u043f\u0430\u0440\u0443 \u0434\u0440\u0443\u0433\u0438\u0445 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u043e\u0432<\/p>\n

http:\/\/gfdsa.gfdsa.org\/2009\/03\/16\/alias_domain-postfixadmin-postfix-configuration\/
\nhttp:\/\/www.opennet.ru\/openforum\/vsluhforumID1\/89020.html<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0412 \u044d\u0442\u043e\u0439 \u0437\u0430\u043c\u0435\u0442\u043a\u0435 \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c \u0434\u043e\u043c\u0435\u043d \u0430\u043b\u0438\u0430\u0441 \u0447\u0435\u0440\u0435\u0437 postfixadmin. \u0427\u0442\u043e \u0434\u043e\u043b\u0436\u043d\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0432 \u0438\u0442\u043e\u0433\u0435: – \u043f\u0440\u0438\u0451\u043c \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439 \u043e\u0442 \u0430\u043b\u0438\u0430\u0441\u0430 \u0434\u043e\u043c\u0435\u043d\u0430<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,10],"tags":[],"class_list":["post-371","post","type-post","status-publish","format-standard","hentry","category-mail","category-others"],"_links":{"self":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts\/371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=371"}],"version-history":[{"count":3,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts\/371\/revisions"}],"predecessor-version":[{"id":4377,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=\/wp\/v2\/posts\/371\/revisions\/4377"}],"wp:attachment":[{"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skeletor.org.ua\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}