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

[Guillaume Morin]

Dans un message du 07 fév à 10:07, Ben Sinclair écrivait :
> Doing a make clean added my debug messages:

Ok, but that is pretty weird. I guess you have compiled nss-mysql, and
then run configure again with the debug statement, but the library
should have been completely rebuilt. I've tested it there, it works very
weird. Could you tell me if you use 0.35 ?

> Feb  7 10:01:45 notes sshd[2647]: _nss_mysql_passwd_fill_struct: SQL 
> statement:
> select users.username,users.id +
> 2000,users.password,"","/bin/bash",concat('/usr/sshomes/',username),1008 from
> users where users.username='bbobo' and users.id + 2000 is not null and ""
> Feb  7 10:01:45 notes sshd[2647]: User not found...
> 
> The problem is the "  and "" " on the end of the SQL statement. Do you know
> what generates that part?

I guess this is something like 

users.where_clause = "";

in nss-mysql.conf. Note it is bad empty statement. If you look more
closely at the comments in the configuration file, you'll see :

# NOTE: [users,groups].parameter =; makes parameter empty (valid)

Then replace it with

users.where_clause = ; 

HTH.

-- 
Guillaume Morin <address@hidden>

        Justice is lost, Justice is raped, Justice is done. (Metallica)