Здравствуйте! В системе (altlinux server 4.0.1) установлены следующие пакеты cyrus-imapd-2.3.11-alt1 MySQL-server-5.0.51-alt1 cyrus-sasl2-2.1.22-alt2 postfix-2.4.6-alt3 Пользователи берутся из mysql. Привожу конфиги. ************************************************************************************************ pam.d/imap #%PAM-1.0 auth include system-auth account include system-auth
auth sufficient pam_mysql.so user=mail passwd=pass host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=0 #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=pass host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=0 #logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time account sufficient pam_unix_acct.so ************************************************************************************************* Таблицы в mysql созданы с помощью скриптов web-cyradm. ************************************************************************************************ sysconfig/saslauthd OPTIONS="-a pam -n 0" ************************************************************************************************ стартую mysqld --log=log.log service saslauthd start делаю # testsaslauthd -u test -p 123 0: NO "authentication failed" # testsaslauthd -u [EMAIL PROTECTED] -p 123 0: NO "authentication failed" # testsaslauthd -u cyrus -p pass 0: NO "authentication failed" # mysql -u mail -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.0.51-log ALT Linux MySQL RPM mysql> use mail; Database changed mysql> select * from accountuser; +-----------+---------------+--------+-------------+ | username | password | prefix | domain_name | +-----------+---------------+--------+-------------+ | cyrus | M.QD4KWNL1YNo | | | | [EMAIL PROTECTED] | 123 | | | | test | 123 | | | | tst | | | | +-----------+---------------+--------+-------------+ смотрим log mysql: mysqld, Version: 5.0.51-log (ALT Linux MySQL RPM). started with: Tcp port: 3306 Unix socket: mysql.sock Time Id Command Argument 080202 3:25:36 1 Connect [EMAIL PROTECTED] on mail 1 Init DB mail 1 Query SELECT password FROM accountuser WHERE username = 'test' 080202 3:25:38 1 Quit 080202 3:25:50 2 Connect [EMAIL PROTECTED] on mail 2 Init DB mail 2 Query SELECT password FROM accountuser WHERE username = '[EMAIL PROTECTED]' 080202 3:25:52 2 Quit 080202 3:26:41 3 Connect [EMAIL PROTECTED] on mail 3 Init DB mail 3 Query SELECT password FROM accountuser WHERE username = 'cyrus' 3 Query SELECT password FROM accountuser WHERE username = 'cyrus' 080202 3:26:43 3 Quit 080202 3:27:10 4 Connect [EMAIL PROTECTED] on 4 Query select @@version_comment limit 1 080202 3:27:16 4 Query SELECT DATABASE() 4 Init DB mail 080202 3:27:25 4 Query select * from accountuser 080202 3:29:05 4 Quit смотрим messages Feb 2 03:25:38 smtp saslauthd[30876]: do_auth : auth failure: [user=test] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] Feb 2 03:25:52 smtp saslauthd[30881]: do_auth : auth failure: [EMAIL PROTECTED] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] Feb 2 03:26:43 smtp saslauthd[30886]: do_auth : auth failure: [user=cyrus] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] то есть pam mysql запрос к базе выполняет, но почему то аутентификация не проходит? все возможные how -to + /usr/doc + форумы и листы рассылки прочитал... Прошу помочь разобраться. -- С уважением, Андрей Степнов, администратор сахалинского сегмента корпоративной сети ДВО РАН _______________________________________________ Sysadmins mailing list [email protected] https://lists.altlinux.org/mailman/listinfo/sysadmins
