- 论坛徽章:
- 8
|
//关键的地方的,搞了好一阵子。初始是,邮件地址:username@xyz.com pop3账号username,会出现密码不正确,除非pop3账号也填username@xyz.com,否则登陆不上。其实就是PASSWORD_QUERY的代码,改后就可以了,怪的是用where username='%u' 也不可以!!只能substring一下了
password_query = select username as user,password from mailbox where substring(username,1,instr(username,'@')-1) = '%n' And active='1'
user_query = select maildir as home,2002 as uid ,2002 as gid from mailbox where username='%u' And active='1'
楼主,下面这个语句还的要斟酌下
password_query = select username as user,password from mailbox where substring(username,1,instr(username,'@')-1) = '%n' And active='1'
如果你这样些的话,对下面两中情况没影响
1)单域
2)多域不同名用户
如果是多域中有相同用户呢?
如何处理? |
|