postfix没法通过sql认证

mjgzln

Mar 2 05:05:11 mjgmlb pop3d: Connection, ip=[127.0.0.1]
Mar 2 05:06:08 mjgmlb authdaemond: received auth request, service=pop3, authtype=login
Mar 2 05:06:08 mjgmlb authdaemond: authpam: trying this module
Mar 2 05:06:08 mjgmlb authdaemond: authpam: username 'abc@mjgmlb.kmip.net' not found in password file
Mar 2 05:06:08 mjgmlb authdaemond: authpam: REJECT - try next module
Mar 2 05:06:08 mjgmlb authdaemond: authmysql: trying this module
Mar 2 05:06:08 mjgmlb authdaemond: SQL query: SELECT username, "", password, '1000', '1000', '/var/mailbox/', maildir, quota,
Mar 2 05:06:08 mjgmlb authdaemond: authmysql: sysusername=<null>, sysuserid=1000, sysgroupid=1000, homedir=/var/mailbox/, add


postfix + cyrus-SASL 2 +courier-IMAP + MailScaner
+ Clamav + Extmail + Extman

mjgzln

/usr/local/etc/authlib/authmysqlrc:

MYSQL_SERVER localhost
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_DATABASE extmail
MYSQL_USERNAME extmail
MYSQL_PASSWORD mjgzln
MYSQL_USER_TABLE mailbox
MYSQL_LOGIN_FIELD username
#MYSQL_CRYPT_PWFIELD password
MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD '2001'
MYSQL_GID_FIELD '2000'
MYSQL_HOME_FIELD '/var/mailbox'
MYSQL_MAILDIR_FIELD maildir
MYSQL_NAME_FIELD name
MYSQL_QUOTA_FIELD quota
MYSQL_WHERE_CLAUSE active='1'
DEFAULT_DOMAIN mjgmlb.kmip.net

/usr/local/etc/authlib/authmodulelist:
authmodulelist="authuserdb authvchkpw authpam authldap authmysql authpgsql"
authmodulelistorig="authuserdb authvchkpw authpam authldap authmysql authpgsql"
daemons=5
authdaemonvar=/var/run/authdaemond
subsystem=mail
DEBUG_LOGIN=2
DEFAULTOPTIONS="wbnodsn=1"
LOGGEROPTS=""
version="authdaemond.mysql"

[ 本帖最后由 mjgzln 于 2006-3-3 10:12 编辑 ]

mjgzln

maillog:
Mar  3 00:00:00 mjgmlb newsyslog[4740]: logfile turned over
Mar  3 05:04:39 mjgmlb postfix/postfix-script: starting the Postfix mail system
Mar  3 05:04:39 mjgmlb postfix/master[566]: daemon started -- version 2.2.5, configuration /usr/local/etc/postfix
Mar  3 05:04:40 mjgmlb postfix/qmgr[568]: 2438717283: from=<operator@mail.sharesky.cn>, size=699, nrcpt=1 (queue active)
Mar  3 05:04:40 mjgmlb postfix/qmgr[568]: warning: connect to transport smtp-amavis: Connection refused
Mar  3 05:04:42 mjgmlb authdaemond: modules="authuserdb authvchkpw authpam authldap authmysql authpgsql", daemons=5
Mar  3 05:04:42 mjgmlb authdaemond: Installing libauthuserdb
Mar  3 05:04:42 mjgmlb authdaemond: Shared object "libauthuserdb.so" not found, required by "authdaemond"
Mar  3 05:04:42 mjgmlb authdaemond: Installing libauthvchkpw
Mar  3 05:04:42 mjgmlb authdaemond: Shared object "libauthvchkpw.so" not found, required by "authdaemond"
Mar  3 05:04:42 mjgmlb authdaemond: Installing libauthpam
Mar  3 05:04:42 mjgmlb authdaemond: Installation complete: authpam
Mar  3 05:04:42 mjgmlb authdaemond: Installing libauthldap
Mar  3 05:04:42 mjgmlb authdaemond: Shared object "libauthldap.so" not found, required by "authdaemond"
Mar  3 05:04:42 mjgmlb authdaemond: Installing libauthmysql
Mar  3 05:04:42 mjgmlb authdaemond: Installation complete: authmysql
Mar  3 05:04:42 mjgmlb authdaemond: Installing libauthpgsql
Mar  3 05:04:42 mjgmlb authdaemond: Shared object "libauthpgsql.so" not found, required by "authdaemond"
Mar  3 05:04:45 mjgmlb postfix/postfix-script: fatal: the Postfix mail system is already running
Mar  3 05:05:40 mjgmlb postfix/qmgr[568]: warning: connect to transport smtp-amavis: Connection refused
Mar  3 05:06:40 mjgmlb postfix/qmgr[568]: warning: connect to transport smtp-amavis: Connection refused
Mar  3 05:08:40 mjgmlb last message repeated 2 times
Mar  3 05:10:40 mjgmlb last message repeated 2 times
Mar  3 05:11:01 mjgmlb postfix/pickup[567]: 173ED17338: uid=2 from=<operator>
Mar  3 05:11:01 mjgmlb postfix/cleanup[827]: 173ED17338: message-id=<20060302211100.173ED17338@mjgzln.kmip.net>
Mar  3 05:11:01 mjgmlb postfix/qmgr[568]: 173ED17338: from=<operator@mjgzln.kmip.net>, size=696, nrcpt=1 (queue active)
Mar  3 05:11:01 mjgmlb postfix/virtual[829]: 173ED17338: to=<operator@mjgzln.kmip.net>, orig_to=<operator>, relay=virtual, delay=1, status=bounced (unknown user: "operator@mjgzln.kmip.net")
Mar  3 05:11:01 mjgmlb postfix/cleanup[827]: DEA441734E: message-id=<20060302211101.DEA441734E@mjgzln.kmip.net>
Mar  3 05:11:01 mjgmlb postfix/qmgr[568]: DEA441734E: from=<>, size=2445, nrcpt=1 (queue active)
Mar  3 05:11:01 mjgmlb postfix/qmgr[568]: 173ED17338: removed
Mar  3 05:11:01 mjgmlb postfix/virtual[829]: DEA441734E: to=<operator@mjgzln.kmip.net>, relay=virtual, delay=0, status=bounced (unknown user: "operator@mjgzln.kmip.net")
Mar  3 05:11:01 mjgmlb postfix/qmgr[568]: DEA441734E: removed
Mar  3 05:11:40 mjgmlb postfix/qmgr[568]: warning: connect to transport smtp-amavis: Connection refused
Mar  3 05:12:40 mjgmlb postfix/qmgr[568]: warning: connect to transport smtp-amavis: Connection refused
Mar  3 05:14:40 mjgmlb last message repeated 2 times
Mar  3 05:15:27 mjgmlb postfix/smtpd[865]: connect from localhost.com[127.0.0.1]
Mar  3 05:15:40 mjgmlb postfix/qmgr[568]: warning: connect to transport smtp-amavis: Connection refused
Mar  3 05:16:40 mjgmlb postfix/qmgr[568]: warning: connect to transport smtp-amavis: Connection refused
Mar  3 05:16:44 mjgmlb postfix/smtpd[865]: warning: SASL authentication failure: cannot connect to Courier authdaemond: Permission denied
Mar  3 05:16:44 mjgmlb postfix/smtpd[865]: warning: localhost.com[127.0.0.1]: SASL login authentication failed
Mar  3 05:16:46 mjgmlb postfix/smtpd[865]: disconnect from localhost.com[127.0.0.1]

scyzxp

Mar  3 05:16:44 mjgmlb postfix/smtpd[865]: warning: SASL authentication failure: cannot connect to Courier authdaemond: Permission denied
权限的问题
http://www.toping.net/bbs
这里有详细的说明你去找一下