非常简明的debian sarge + postfix + mysql + AMaViS + webmail + web admin安装配

wanglu624

一直没有配置成功，于是又仔细看了一遍英文原版，发现楼主翻译的竟有很多错误！后来人一定要认真看原文！

monq

好文章，但我完成之后的mail.log是这样的，大家能帮我看看吗？
好像没有跑到mysql中去查找用户，怎么用上了一个/etc/aliases.db文件？

mail.log

1. 
   
2. May 16 17:41:37 www postfix/postfix-script: starting the Postfix mail system
   
3. May 16 17:41:37 www postfix/master[32511]: daemon started -- version 2.1.5
   
4. May 16 17:41:47 www postfix/smtpd[32515]: connect from localhost[127.0.0.1]
   
5. May 16 17:42:24 www postfix/trivial-rewrite[32516]: warning: do not list domain example.com in BOTH mydestination and virtual_m
   
6. ailbox_domains
   
7. May 16 17:42:24 www postfix/smtpd[32515]: 60C8B4AB18: client=localhost[127.0.0.1]
   
8. May 16 17:42:35 www postfix/cleanup[32520]: 60C8B4AB18: message-id=<20060516094212.60C8B4AB18@example.com>
   
9. May 16 17:42:35 www postfix/qmgr[32513]: 60C8B4AB18: from=<tinnyliu@gmail.com>, size=331, nrcpt=1 (queue active)
   
10. May 16 17:42:35 www postfix/trivial-rewrite[32516]: warning: do not list domain example.com in BOTH mydestination and virtual_m
    
11. ailbox_domains
    
12. May 16 17:42:35 www postfix/local[32523]: fatal: open database /etc/aliases.db: No such file or directory
    
13. May 16 17:42:36 www postfix/master[32511]: warning: process /usr/lib/postfix/local pid 32523 exit status 1
    
14. May 16 17:42:36 www postfix/master[32511]: warning: /usr/lib/postfix/local: bad command startup -- throttling
    
15. May 16 17:42:37 www postfix/smtpd[32515]: disconnect from localhost[127.0.0.1]
    

复制代码

main.cf

1. 
   
2. #======= BASE ==============
   
3. #mail_spool_directory = /var/mail/
   
4. myhostname = example.com
   
5. mydomain = example.com
   
6. inet_interfaces = all
   
7. #home_mailbox=Maildir/
   
8. mydestination = $myhostname, $mydomain, $transport_maps
   
9. local_recipient_maps =
   
10. #mailbox_command= /usr/lib/courier-imap/bin/deliverquota -w 90 ~/Maildir
    
11. #mailbox_command = /usr/local/maildrop/bin/maildrop
    
12. #local_destination_concurrency_limit = 1
    
13. #======= MYSQL =============
    
14. #transport_maps = mysql:/etc/postfix/mysql_transport.cf
    
15. virtual_alias_domains =
    
16. virtual_mailbox_base = /home/vmail
    
17. virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    
18. virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
    
19. virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf mysql:/etc/postfix/mysql-virtual_email2email.cf
    
20. #virtual_uid_maps = mysql:/etc/postfix/uids.cf
    
21. #virtual_gid_maps = mysql:/etc/postfix/gids.cf
    
22. virtual_uid_maps = static:5000
    
23. virtual_gid_maps = static:5000
    
24. #======= Quota ============
    
25. #50MB
    
26. virtual_mailbox_limit = 250000000
    
27. #5MB
    
28. message_size_limit = 50000000
    
29. virtual_mailbox_limit_inbox = no
    
30. #virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql_quota.cf
    
31. virtual_mailbox_limit_override = yes
    
32. virtual_maildir_extended = yes
    
33. virtual_create_maildirsize = yes
    
34. #====== SASL ================
    
35. smtpd_sasl_auth_enable = yes
    
36. smtpd_sasl_security_options = noanonymous
    
37. broken_sasl_auth_clients = yes
    
38. smtpd_recipient_restrictions = permit_mynetworks permit_sasl_authenticated reject_unauth_destination
    
39. #permit_sasl_authenticated permit_auth_destination reject
    
40. #smtpd_sasl_local_domain = $mydomain
    
41. smtpd_client_restrictions = permit_sasl_authenticated
    
42. smtpd_use_tls = yes
    
43. smtpd_tls_cert_file = /etc/postfix/smtpd.cert
    
44. smtpd_tls_key_file = /etc/postfix/smtpd.key
    

复制代码

mysql-virtual_domains.cf

1. 
   
2. user = provider_admin
   
3. password = 123456
   
4. dbname = provider
   
5. table = domains
   
6. select_field = 'virtual'
   
7. where_field = domain
   
8. hosts = 127.0.0.1
   

复制代码

mysql-virtual_email2email.cf

1. 
   
2. user = provider_admin
   
3. password = 123456
   
4. dbname = provider
   
5. table = users
   
6. select_field = email
   
7. where_field = email
   
8. hosts = 127.0.0.1

复制代码

mysql-virtual_forwardings.cf

1. user = provider_admin
   
2. password = 123456
   
3. dbname = provider
   
4. table = forwardings
   
5. select_field = destination
   
6. where_field = source
   
7. hosts = 127.0.0.1

复制代码

mysql-virtual_mailboxes.cf

1. user = provider_admin
   
2. password = 123456
   
3. dbname = provider
   
4. table = users
   
5. select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
   
6. where_field = email
   
7. hosts = 127.0.0.1

复制代码

我安装的与postfix相关的软件

1. 
   
2. www:~# dpkg -l postfix*
   
3. Desired=Unknown/Install/Remove/Purge/Hold
   
4. | Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
   
5. |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
   
6. ||/ Name                      Version                   Description
   
7. +++-=========================-=========================-==================================================================
   
8. ii  postfix                   2.1.5-9                   A high-performance mail transport agent
   
9. ii  postfix-doc               2.1.5-9                   Postfix documentation
   
10. un  postfix-ldap              <none>                    (no description available)
    
11. ii  postfix-mysql             2.1.5-9                   MYSQL map support for Postfix
    
12. un  postfix-pcre              <none>                    (no description available)
    
13. un  postfix-pgsql             <none>                    (no description available)
    
14. un  postfix-snap              <none>                    (no description available)
    
15. un  postfix-snap-tls          <none>                    (no description available)
    
16. ii  postfix-tls               2.1.5-9                   TLS and SASL support for Postfix
    
17. 
    

复制代码