求救大神
搭建postfix郵件伺服器的過程，測試 echo "test" | maildrop -V 10 -d postmaster@extmail.org
出現如下結果，求大神解決啊
Jul 24 19:56:10 localhost authdaemond: received userid lookup request: postmaster@extmail.org
Jul 24 19:56:10 localhost authdaemond: authmysql: trying this module
Jul 24 19:56:10 localhost maildrop: Temporary authentication failure.
Jul 24 19:56:10 localhost authdaemond: authmysqllib: connected. Versions: header 50095, client 50095, server 50095
Jul 24 19:56:10 localhost authdaemond: SQL query: SELECT username,password,"",uidnumber,gidnumber, CONTACT('/home/data/domains/',homedir),.. .. CONTACT('/home/data/domains/',maildir),.. .. quota,...... .. name...... .. FROM mailbox..... .. WHERE username = 'postmaster@extmail.org'
Jul 24 19:56:10 localhost authdaemond: mysql_query failed, reconnecting: FUNCTION extmail.CONTACT does not exist
Jul 24 19:56:10 localhost authdaemond: authmysqllib: connected. Versions: header 50095, client 50095, server 50095
Jul 24 19:56:10 localhost authdaemond: mysql_query failed second time, giving up: FUNCTION extmail.CONTACT does not exist
Jul 24 19:56:10 localhost authdaemond: authmysql: TEMPFAIL - no more modules will be tried
《解決方案》
我又知道了，把CONCAT寫成CONTACT了。
