谁帮我看看我的postfx+sasl+pam_mysql为什么不能认证

xiao2

Dec 24 19:24:25 iiuy saslauthd[6013]: pam_sm_authenticate called.
Dec 24 19:24:25 iiuy saslauthd[6013]: dbuser changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: dbpasswd changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: host changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: database changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: table changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: usercolumn changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: passwdcolumn changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: crypt changed.
Dec 24 19:24:25 iiuy saslauthd[6013]: db_connect  called.
Dec 24 19:24:25 iiuy saslauthd[6013]: returning 0 .
Dec 24 19:24:25 iiuy saslauthd[6013]: db_checkpasswd called.
Dec 24 19:24:25 iiuy saslauthd[6013]: pam_mysql: where clause =
Dec 24 19:24:25 iiuy saslauthd[6013]: SELECT password FROM virtual_users WHERE id='qq'
Dec 24 19:24:25 iiuy saslauthd[6013]: pam_mysql: select returned more than one result
Dec 24 19:24:25 iiuy saslauthd[6013]: returning 7 after db_checkpasswd.
Dec 24 19:24:25 iiuy saslauthd[6013]: do_auth         : auth failure: [user=qq] [service=smtp] [realm=iiuy.8866.org] [mech=pam
Dec 24 19:24:28 iiuy saslauthd[6014]: pam_sm_authenticate called.
Dec 24 19:24:28 iiuy saslauthd[6014]: dbuser changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: dbpasswd changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: host changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: database changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: table changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: usercolumn changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: passwdcolumn changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: crypt changed.
Dec 24 19:24:28 iiuy saslauthd[6014]: db_connect  called.
Dec 24 19:24:28 iiuy saslauthd[6014]: returning 0 .
Dec 24 19:24:28 iiuy saslauthd[6014]: db_checkpasswd called.
Dec 24 19:24:28 iiuy saslauthd[6014]: pam_mysql: where clause =
Dec 24 19:24:28 iiuy saslauthd[6014]: SELECT password FROM virtual_users WHERE id='qq'
Dec 24 19:24:28 iiuy saslauthd[6014]: pam_mysql: select returned more than one result
Dec 24 19:24:28 iiuy saslauthd[6014]: returning 7 after db_checkpasswd.
Dec 24 19:24:28 iiuy saslauthd[6014]: do_auth         : auth failure: [user=qq] [service=smtp] [realm=iiuy.8866.org] [mech=pam
Dec 24 20:46:31 iiuy proftpd[6100]: iiuy.8866.org (81.75.174.5[81.75.174.5]) - ANON anonymous: Login successful.
Dec 24 21:08:54 iiuy proftpd[6117]: iiuy.8866.org (81.75.174.5[81.75.174.5]) - ANON anonymous: Login successful.
Dec 24 21:08:57 iiuy proftpd[6118]: iiuy.8866.org (81.75.174.5[81.75.174.5]) - ANON anonymous: Login successful.

xiao2

up

fxdfbl

pam_mysql: select returned more than one result

因为你的数据库中有两个相同名字的用户~~~好像只能唯一的~~~所以你验证失败

如果你想多个用户并存的话，可能需要手工改一下源代码了~~~

yejr

我碰到的问题:
如果在mysql中id设置成'yejr',则会提示unknown user: "yejr@yejr.net",用改id测试smtp的时候提示"pam_mysql: select returned more than one result"，如果设置成'yejr@yejr.net',则smtp认证的时候提示:
sqlLog called.
pam_mysql: error: sqllog set but logtable not set
pam_mysql: error: sqllog set but logmsgcolumn not set
pam_mysql: error: sqllog set but logusercolumn not set
pam_mysql: error: sqllog set but loghostcolumn not set
pam_mysql: error: sqllog set but logtimecolumn not set
returning 0 .      
returning 0.
不知道到底该怎么设置才对

yejr

原帖由 "fxdfbl" 发表：
pam_mysql: select returned more than one result

因为你的数据库中有两个相同名字的用户~~~好像只能唯一的~~~所以你验证失败

如果你想多个用户并存的话，可能需要手工改一下源代码了~~~

源程序写的是如果返回结果不为1的话，都提示'more than one xxx',实际上可能是0个结果

xiao2

这个问题的解决是很奇怪，我把sasl换成底版本的，就没有问题了

yejr

你是从哪个版本换到哪个版本的呢？

xiao2

cyrus-sasl-2.1.17换成了2.1.12

yejr

我用的也是2.1.17,难道真的是这个有问题？
另外,courier-imap不是使用mysql的用户认证的,而是使用系统用户认证是怎么回事呢,我的编译参数:
./configure --without-ipv6 --enable-unicode --enable-workarounds-for-imap-client-bugs --with-mysql-libs=/usr/local/lib/mysql --with-mysql-includes=/usr/local/include/mysql

/usr/lib/courier-imap/etc/authmysqlrc设置如下:
MYSQL_SERVER    127.0.0.1
MYSQL_USERNAME  mail
MYSQL_PASSWORD  mail
MYSQL_SOCKET    /tmp/mysql.sock
MYSQL_PORT      3306
MYSQL_OPT       0
MYSQL_DATABASE  mail
MYSQL_USER_TABLE        virtual_users
MYSQL_CRYPT_PWFIELD     password
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD       id
MYSQL_HOME_FIELD        home
MYSQL_NAME_FIELD        name
MYSQL_MAILDIR_FIELD     maildir
MYSQL_QUOTA_FIELD       quota
MYSQL_WHERE_CLAUSE      imapok=1
DEFAULT_DOMAIN  yejr.net

yejr

[quote]原帖由 "xiao2"]cyrus-sasl-2.1.17换成了2.1.12[/quote 发表：


我头都大了，搞了一个多星期了还不行，版本换成2.1.12的问题依旧:
pam_mysql: error: sqllog set but logtable not set
pam_mysql: error: sqllog set but logmsgcolumn not set
pam_mysql: error: sqllog set but logusercolumn not set
pam_mysql: error: sqllog set but loghostcolumn not set
pam_mysql: error: sqllog set but logtimecolumn not set
returning 0 .
returning 0.