PostFix和SASL,PAM_MySql认证用户问题

skirnir

按照wxy的文章安装以后，出现以下问题，用户pop认证无法通过。我在数据库中使用的是wert@xxx.com的账号存储，但是当pam_mysql查询数据库的时候却总是查询wert的密码，没有了那个域。
[auth.log]
Dec  8 18:54:03 mail saslauthd[7670]: pam_sm_authenticate called.
Dec  8 18:54:03 mail saslauthd[7670]: dbuser changed.
Dec  8 18:54:03 mail saslauthd[7670]: dbpasswd changed.
Dec  8 18:54:03 mail saslauthd[7670]: host changed.
Dec  8 18:54:03 mail saslauthd[7670]: database changed.
Dec  8 18:54:03 mail saslauthd[7670]: table changed.
Dec  8 18:54:03 mail saslauthd[7670]: usercolumn changed.
Dec  8 18:54:03 mail saslauthd[7670]: passwdcolumn changed.
Dec  8 18:54:03 mail saslauthd[7670]: crypt changed.
Dec  8 18:54:03 mail saslauthd[7670]: sqllog changed.
Dec  8 18:54:03 mail saslauthd[7670]: db_connect  called.
Dec  8 18:54:03 mail saslauthd[7670]: returning 0 .
Dec  8 18:54:03 mail saslauthd[7670]: db_checkpasswd called.
Dec  8 18:54:03 mail saslauthd[7670]: pam_mysql: where clause =
Dec  8 18:54:03 mail saslauthd[7670]: SELECT PASSWORD FROM USER WHERE USERNAME='wert'
Dec  8 18:54:03 mail saslauthd[7670]: sqlLog called.
Dec  8 18:54:03 mail saslauthd[7670]: returning 0 .
Dec  8 18:54:03 mail saslauthd[7670]: returning 0.
Dec  8 18:54:03 mail saslauthd[7670]: pam_mysql: acct_mgmt called but not implemented. Dont panic though
而且在进行smtp认证的时候，却显示找不到用户，可是我明明数据库中有这个用户名的呀
Dec  9 02:05:06 mail saslauthd[7668]: pam_sm_authenticate called.
Dec  9 02:05:06 mail saslauthd[7668]: dbuser changed.
Dec  9 02:05:06 mail saslauthd[7668]: dbpasswd changed.
Dec  9 02:05:06 mail saslauthd[7668]: host changed.
Dec  9 02:05:06 mail saslauthd[7668]: database changed.
Dec  9 02:05:06 mail saslauthd[7668]: table changed.
Dec  9 02:05:06 mail saslauthd[7668]: usercolumn changed.
Dec  9 02:05:06 mail saslauthd[7668]: passwdcolumn changed.
Dec  9 02:05:06 mail saslauthd[7668]: crypt changed.
Dec  9 02:05:06 mail saslauthd[7668]: sqllog changed.
Dec  9 02:05:06 mail saslauthd[7668]: db_connect  called.
Dec  9 02:05:06 mail saslauthd[7668]: returning 0 .
Dec  9 02:05:06 mail saslauthd[7668]: db_checkpasswd called.
Dec  9 02:05:06 mail saslauthd[7668]: pam_mysql: where clause =
Dec  9 02:05:06 mail saslauthd[7668]: SELECT PASSWORD FROM USER WHERE USERNAME='wert@xxx.com'
Dec  9 02:05:06 mail saslauthd[7668]: pam_mysql: select returned more than one result
Dec  9 02:05:06 mail saslauthd[7668]: returning 7 after db_checkpasswd.
Dec  9 02:05:06 mail smtp(pam_unix)[7668]: check pass; user unknown
Dec  9 02:05:06 mail smtp(pam_unix)[7668]: authentication failure; logname= uid=0 euid=0 tty= ruser= rhost=
Dec  9 02:05:08 mail saslauthd[7668]: DEBUG: auth_pam: pam_authenticate failed: Permission denied
Dec  9 02:05:08 mail saslauthd[7668]: do_auth         : auth failure: [user=wert@xxx.com] [service=smtp] [realm=] [mech=pam] [\
reason=PAM auth error]