在virtual mail host 的認証問題
前幾天幫客戶安裝mail server的時後發現~~怎麼認証一直通不過
一直無法外部收信
後來看了mysql 的log
pam-mysql.5 的mysql.log如下
050929 14:09:17 41 Connect postfix@localhost on postfix
41 Init DB postfix
41 Query SELECT password FROM mailbox WHERE username is NULL johnpupu'
41 Quit
36 Query SELECT `goto` FROM alias WHERE address is NULL xxx.com.tw'
37 Query SELECT description FROM domain WHERE domain is NULL xxx.com.tw'
38 Query SELECT `goto` FROM alias WHERE address is NULL johnpupu@xxx.com.tw'
39 Query SELECT `goto` FROM alias WHERE address is NULL johnpupu@xxx.com.tw'
36 Query SELECT `goto` FROM alias WHERE address is NULL xxx.com.tw'
37 Query SELECT description FROM domain WHERE domain is NULL xxx.com.tw'
42 Connect postfix@localhost on postfix
42 Query SELECT maildir FROM mailbox WHERE username is NULL johnpupu@xxx.com.tw'
pam-mysql.6 version的mysql.log 如下
050929 14:05:28 224 Connect postfix@localhost on postfix
224 Init DB postfix
224 Query SELECT password FROM mailbox WHERE username is NULL johnpupu'
224 Quit
225 Connect postfix@localhost on postfix
225 Init DB postfix
225 Query SELECT 1, password FROM mailbox WHERE username is NULL johnpupu'
225 Quit
發現在6 和5 的版本上會一個1 的差異~~不過很奇的是~~這兩行都一樣select 不到資料
不知道為什麼裝了6 後在mail 上就認証不過
裝了5 就過了~~怪~~~
隨手附上pam-mysql5 的ports