伺服器搭建手冊之FREEBSDUNIX郵件伺服器建設(七)

4、編輯/usr/local/etc/postfix/mysql_virtual_domains_maps.cf
#vi /usr/local/etc/postfix/mysql_virtual_domains_maps.cf

加入以下內容:

user = postfix

 

password = postfix

 

hosts = localhost

 

dbname = postfix

 

query = SELECT domain FROM domaininfo WHERE domain=’%s’

 

5、編輯/usr/local/etc/postfix/mysql_virtual_mailbox_maps.cf
#vi /usr/local/etc/postfix/mysql_virtual_mailbox_maps.cf

加入以下內容:

user = postfix

 

password = postfix

 

hosts = localhost

 

dbname = postfix

 

query = SELECT maildir FROM userinfo WHERE address=’%s’ AND active = 1

6、編輯/usr/local/etc/postfix/mysql_virtual_mailbox_limit_maps.cf

# vi /usr/local/etc/postfix/mysql_virtual_mailbox_limit_maps.cf

加下以下內容:

user = postfix
password = postfix
hosts = localhost
dbname = postfix
query = SELECT quota FROM userinfo WHERE address=’%s’

C、配置Courier-imap

1、修改Courier相關設置。

#vi /usr/local/etc/courier-imap/imapd:

找到這一句:

#IMAP_CAPABILITY=”IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE”

然後在這一句下面加上下面這句:

IMAP_CAPABILITY=”IMAP4rev1 CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA”

註:上面是一句設置文件,而不是兩句設置.

2、修改/usr/local/etc/courier-imap/pop3d

#vi /usr/local/etc/courier-imap/pop3d

找到下面這一句:

#POP3AUTH=”LOGIN CRAM-MD5 CRAM-SHA1″

取消註解符#號, 最後變成如下:

POP3AUTH=”LOGIN CRAM-MD5 CRAM-SHA1″

3、編輯修改/usr/local/etc/authlib/authmysqlrc

# mv /usr/local/etc/authlib/authmysqlrc  /usr/local/etc/authlib/authmysqlrc_bak

# vi /usr/local/etc/authlib/authmysqlrc

加入以下內容:

MYSQL_SERVER       localhost                                    //資料庫主機地址

 

MYSQL_USERNAME         postfix                                 //資料庫用戶名

 

MYSQL_PASSWORD         postfix                                 //資料庫密碼

 

MYSQL_PORT         0

 

MYSQL_OPT     0

 

MYSQL_DATABASE         postfix                                  //資料庫名稱

 

MYSQL_USER_TABLE   userinfo

 

MYSQL_CRYPT_PWFIELD    passwd

 

MYSQL_UID_FIELD        ‘125’

 

MYSQL_GID_FIELD        ‘125’

 

MYSQL_LOGIN_FIELD  address

 

MYSQL_HOME_FIELD   homedir

 

MYSQL_NAME_FIELD   realname

 

MYSQL_MAILDIR_FIELD    maildir

 

MYSQL_QUOTA_FIELD  quota

 

註:這裡得用tab鍵來跳格

以下文章點擊率最高

Loading…

     

如果這文章對你有幫助,請掃左上角微信支付-支付寶,給於打賞,以助博客運營