Re: [Nss-mysql-users] nss-mysql +sshd

[Phillip Cockrell]

On Sat, 2004-02-21 at 20:12 -0700, Andreas J. Guelzow wrote:

> On Sat, 2004-02-21 at 18:41, Phillip Cockrell wrote:
> > I think this is PAM related, I have nss-mysql working locally, but it
> > doesn't even attempt to work with SSHD. When I try to use pam_mysql
> 
> Hi Phillip,
> 
> if you use nss-mysql, you should not need pam_mysql. I assume you are
> using pam, so nss-mysql is used as part of pam_unix.so.

Ok-- 

I have removed pam_mysql and I am looking at /etc/pam.d/ssh and I see
the following:

auth       required     pam_stack.so service=system-auth
auth       required     pam_shells.so
auth       required     pam_nologin.so
account    required     pam_stack.so service=system-auth
password   required     pam_stack.so service=system-auth
session    required     pam_stack.so service=system-auth


What does yours look like?

-Phil
> 
> You should check what is in your /etc/pam.d/ssh file and how it differs
> from the /etc/pam.d/login file. The latter is used for your regular
> logins (check /etc/pam.d/gdm for gdm logins) and the former for ssh.
> They should be virtually identical.
> 
> Andreas
> 
> 
> >  I
> > get the following from my database:
> > 
> >                    1278 Query       select login from tech where
> > login='NOUSER' and passwd=ENCRYPT('test',LEFT(passwd,2))
> >                    1278 Quit
> > 
> > I don't know why it is inserting 'NOUSER' instead of the valid username
> > that i am trying to login with.
> > 
> > Any help would be appreciated.
> > 
> > Phillip
> > 
> > On Fri, 2004-02-20 at 13:01 +0100, Erik Grinaker wrote:
> > 
> > > On Fri, 2004-02-20 at 10:26, Nenad Perić wrote:
> > > > When you configure your system to check for the passwords in the mysql
> > > > database, sshd automaticaly does the same. I have made that work on my
> > > > system. It was just connecting the system to interact with the database.
> > > > When your login prompt on the system asks the database for the password,
> > > > and you succesfuly log in, sshd should do the same without a problem.
> > > 
> > > I believe this is related to PAM. SSH may have a different PAM
> > > configuration than the rest of the system - check your configurations in
> > > /etc/pam.d/.
> > > 
> > > Make sure that the sshd config somehow calls the pam_mysql module (your
> > > system-auth config, or whatever your distro calls it, should be
> > > configured to do it - look at it for hints).
> > > 
> > > 
> > > -- 
> > > Erik Grinaker <address@hidden>
> > > http://erikg.wired-networks.net/
> > > 
> > > "We act as though comfort and luxury were the chief requirements of
> > > life, when all that we need to make us happy is something to be
> > > enthusiastic about."
> > >                                                       -- Albert Einstein
> > 
> > 
> > 
> > _______________________________________________
> > Nss-mysql-users mailing list
> > address@hidden
> > http://mail.nongnu.org/mailman/listinfo/nss-mysql-users
> -- 
> Prof. Dr. Andreas J. Guelzow
> Dept. of Mathematical & Computing Sciences
> Concordia University College of Alberta