postfix + mysql virtual mailbox - BBS

Carol avatar
By Carol
at 2009-05-04T12:04

Table of Contents

我在 FreeBSD 7.0R 上面 用 ports 裝了 postfix-2.5.6,1
在安裝 postfix 時有勾選要 MySQL
但是安裝完之後我在設定 main.cf 的時候

main.cf 指定 virtual domain 信箱的設定像這樣:
virtual_mailbox_domains = \
mysql:/usr/local/etc/postfix/mysql-virtual_mailbox_domains
virtual_mailbox_maps = \
mysql:/usr/local/etc/postfix/mysql-virtual_mailbox_maps

www# cat mysql-virtual_mailbox_domains
hosts = 127.0.0.1
user = postfix
password = zLDgAyumSD
dbname = postfix
query = SELECT virtual_domains FROM virtual_mailbox_domains
result_format = %s

www# cat mysql-virtual_mailbox_maps
hosts = 127.0.0.1
user = postfix
password = zLDgAyumSD
dbname = postfix
query = SELECT pathname FROM virtual_mailbox_maps WHERE email_address='%s'
result_format = %s

然後我就重新啟動 postfix,想說先測試local 端可不可以發送到外面
www# mail [email protected]
Subject: test mail
test mail from tony

結果我看 maillog 卻顯示:
May 4 08:54:42 www postfix/virtual[4929]: 09AA041A57: \
to=<[email protected]>, relay=virtual, \
delay=4.7, delays=4.4/0.11/0/0.12, dsn=5.1.1, \
status=bounced (unknown user: "[email protected]")

後來我把 virtual_mailbox_domains 和 virtual_mailbox_maps 拿掉再寄一次
卻可以寄出去 請問這是什麼原因呢?

--
Tags: BBS

All Comments

FreeBSD 7.2-RELEASE

Madame avatar
By Madame
at 2009-05-04T09:21
http://www.freebsd.org/releases/7.2R/announce.html The FreeBSD Release Engineering Team is pleased to announce the availability of FreeBSD 7.2-RELEASE. T ...

AMD 790x (with AMD SB750) Chip set o …

Queena avatar
By Queena
at 2009-05-03T15:26
※ 引述《dppman (*^o^*)》之銘言: : 請問一下, : 有人試過用AMD 790系列晶片組(搭AMD SB750) : 主機板內建的RAID功能嗎? : 在FreeBSD下抓得到RAID嗎?(device name是?) : 跟INTEL ICH10R比起來,效能如何? ...

AMD 790x (with AMD SB750) Chip set on-board RAID?

Eden avatar
By Eden
at 2009-05-02T22:22
請問一下, 有人試過用AMD 790系列晶片組(搭AMD SB750) 主機板內建的RAID功能嗎? 在FreeBSD下抓得到RAID嗎?(device name是?) 跟INTEL ICH10R比起來,效能如何? 謝謝:) - ...

/etc/rc.conf 問題

Zora avatar
By Zora
at 2009-04-30T18:13
※ 引述《mflo (殞浮流)》之銘言: : : Set it to and#34;YESand#34; to enable MySQL : : 文件都寫的很清楚,你沒有加上 mysql_enable : : 所以開機不會啟動,command line 鍵入 : : /usr/local/etc/rc.d/m ...

/etc/rc.conf 問題

Kama avatar
By Kama
at 2009-04-30T15:56
: Set it to and#34;YESand#34; to enable MySQL : 文件都寫的很清楚,你沒有加上 mysql_enable : 所以開機不會啟動,command line 鍵入 : /usr/local/etc/rc.d/mysql-server start 是不會 work 的 ...