Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL

[Guillaume Morin]

Dans un message du 07 fév à 13:38, Ben Sinclair écrivait :
>
> Okay, I got it to work somewhat without PAM-MySQL and the latest OpenSSH.
> 
> I changed my nsswitch.conf and put mysql before compat.
> 
> If I try to ssh in, I get this:
> 
> Feb  7 13:33:43 notes ssh[3851]: _nss_mysql_passwd_fill_struct: SQL statement:
> select users.username,users.id +
> 2000,users.password,users.username,"/bin/bash",concat('/usr/sshomes/',username)
> ,1008 from users where users.id + 2000=0 and enabled = 1
> Feb  7 13:33:43 notes ssh[3851]: User not found...
> 
> The user isn't found because it's not putting in a username.

This is weird looks like it tries to look up uid 0 which is root... I do
not think this is the cause of your problem. I suppose there is a
previous call to getpwnam which returns 0 as uid because nss-mysql is
not correctly configured.

-- 
Guillaume Morin <address@hidden>

         Support the Debian GNU/Linux Project (http://www.debian.org/)