[Sysadmins] cyrus-sasl2 pam mysql не аутентифицирует

[Vladimir V. Kamarzin]

>>>>> On 04 Feb 2008 at 04:44 "J" == JaMm  writes:

mysql>> select * from accountuser;
 J> +-----------+---------------+--------+-------------+
 J> | username  | password      | prefix | domain_name |
 J> +-----------+---------------+--------+-------------+
 J> | cyrus     | M.QD4KWNL1YNo |        |             |
 J> | test на test | 123           |        |             |
 J> | test      | 123           |        |             |
 J> | tst       |               |        |             |
 J> +-----------+---------------+--------+-------------+
----------- ????????? ????? -----------

????????? ???? ??????? ??????????? web-cyradm, ??????? accountuser ??? ???????? ??? ???:

mysql> select * from accountuser;
+-----------+---------------+--------+-------------+
| username  | password      | prefix | domain_name |
+-----------+---------------+--------+-------------+
| cyrus     | vjD5UKrOWumxs |        |             |
| xxxx0002 | 95LtBJGNVP9wc | xxxx  | x.ru    |
| xxxx0001 | cfS0NnZc/dezU | xxxx  | x.ru    |
| xxxx0005 | 82mRPY2JJo6r6 | xxxx  | x.ru    |
| xxxx0004 | 0aZQ4HovNwio2 | xxxx  | x.ru    |
+-----------+---------------+--------+-------------+
5 rows in set (0.06 sec

????? ?????????? ?????????? web-cyradm.

?? ?????? ??????:

# cat /etc/pam.d/imap
#%PAM-1.0
#auth     include       system-auth
#account  include       system-auth

auth sufficient pam_mysql.so user=mail passwd=xxxxxx  host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time

#auth sufficient pam_unix_auth.so

account required pam_mysql.so user=mail passwd=xxxxx host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time

#account  sufficient       pam_unix_acct.so

-- 
vvk

Russian Postfix irc: irc.freenode.net #postfix-ru