From: Pavlov Konstantin <thresh@cpms.ru> To: sisyphus@lists.altlinux.org, community@lists.altlinux.org Subject: [sisyphus] PAM, MySQL, sshd. Date: Mon, 19 Dec 2005 21:34:47 +0300 Message-ID: <20051219213447.5c275bb1@snowflake.cryo.net.ru> (raw) Привет всем. Есть задача сделать возможной авторизацию на сервере пользователей, данные о которых храняться в MySQL. Для этого использую: pam-mysql-0.7-alt9.pre3 (обновленная версия из sisyphus), nss-mysql-1.0-alt1 с http://savannah.nongnu.org/projects/nss-mysql/ (в сизифе пока нет) Пока смог достичь того, что пользователи могут логиниться локально (с клавиатуры :), посредством "su - username" и по FTP (proftpd). При логине по ssh выводит следующее: --- Dec 19 21:20:54 exchange sshd[29795]: Unknown username from 172.16.127.131 ... Dec 19 21:20:54 exchange sshd[29795]: pam_mysql - SELECT password FROM user WHERE user_name = 'ILLEGAL USER' Dec 19 21:20:54 exchange sshd[29795]: pam_mysql - SELECT returned no result. ... Dec 19 21:20:55 exchange sshd[29795]: pam_tcb(sshd:auth): Authentication failed for UNKNOWN USER from (uid=0) --- Собственно /etc/pam.d/sshd: --- #%PAM-1.0 auth required pam_userpass.so auth sufficient pam_mysql.so user=nssuser passwd=nsssqluser db=nss table=user usercolumn=user_name passwdcolumn=password crypt=0 verbose=1 use_first_pass auth required pam_tcb.so shadow fork prefix=$2a$ count=8 nullok nodelay blank_nolog use_first_pass auth required pam_nologin.so account include system-auth password include system-auth session include system-auth --- Подскажите, что не так? -- Best regards, Pavlov Konstantin, CPMS Network http://network.cpms.ru/ jid: thresh@altlinux.org
reply other threads:[~2005-12-19 18:34 UTC|newest] Thread overview: [no followups] expand[flat|nested] mbox.gz Atom feed
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=20051219213447.5c275bb1@snowflake.cryo.net.ru \ --to=thresh@cpms.ru \ --cc=community@lists.altlinux.org \ --cc=sisyphus@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 Sisyphus discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/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 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \ sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru public-inbox-index sisyphus Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.sisyphus AGPL code for this site: git clone https://public-inbox.org/public-inbox.git