From: JaMm <myjamm@gmail.com> To: sysadmins@lists.altlinux.org Subject: [Sysadmins] cyrus-sasl2 pam mysql не аутентифицирует Date: Mon, 4 Feb 2008 09:44:17 +1000 Message-ID: <200802040944.17661.myjamm@gmail.com> (raw) Здравствуйте! В системе (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 test@test -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 | | | | test@test | 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 mail@localhost 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 mail@localhost on mail 2 Init DB mail 2 Query SELECT password FROM accountuser WHERE username = 'test@test' 080202 3:25:52 2 Quit 080202 3:26:41 3 Connect mail@localhost 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 mail@localhost 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: [user=test@test] [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 + форумы и листы рассылки прочитал... Прошу помочь разобраться. -- С уважением, Андрей Степнов, администратор сахалинского сегмента корпоративной сети ДВО РАН
next reply other threads:[~2008-02-03 23:44 UTC|newest] Thread overview: 11+ messages / expand[flat|nested] mbox.gz Atom feed top 2008-02-03 23:44 JaMm [this message] 2008-02-04 23:00 ` JaMm 2008-02-05 5:48 ` Anton Kvashin 2008-02-05 22:38 ` JaMm 2008-02-06 6:59 ` Anton Kvashin 2008-02-07 5:01 ` Anton Kvashin 2008-02-05 7:15 ` Vladimir V. Kamarzin 2008-02-05 22:48 ` JaMm 2008-02-06 6:00 ` Vladimir V. Kamarzin 2008-02-07 6:41 ` Vladimir V. Kamarzin 2008-02-08 10:16 ` Vladimir V. Kamarzin
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=200802040944.17661.myjamm@gmail.com \ --to=myjamm@gmail.com \ --cc=sysadmins@lists.altlinux.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux sysadmins discussion This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/sysadmins/0 sysadmins/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 sysadmins sysadmins/ http://lore.altlinux.org/sysadmins \ sysadmins@lists.altlinux.org sysadmins@lists.altlinux.ru sysadmins@lists.altlinux.com public-inbox-index sysadmins Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.sysadmins AGPL code for this site: git clone https://public-inbox.org/public-inbox.git