nss-mysql-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Ben Sinclair
Subject: Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL
Date: Thu, 7 Feb 2002 10:07:52 -0600

Doing a make clean added my debug messages:

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?

--
Ben Sinclair
Developer, SecureMailSite.com
address@hidden

----- Original Message -----
From: "Guillaume Morin" <address@hidden>
To: "Ben Sinclair" <address@hidden>
Cc: <address@hidden>
Sent: Thursday, February 07, 2002 10:06 AM
Subject: Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL


> Dans un message du 07 fév à  9:55, Ben Sinclair écrivait :
> > I removed PAM-MySQL and configured NSS-MySQL using the following:
> >
> >
./configure --sysconfdir=/etc --disable-static --enable-debug --disable-group -
> > -disable-shadow
>
> Is that 0.35 ?
>
> > In nsswitch.conf I have:
> >
> > passwd:         compat mysql
> > group:          compat
> > shadow:         compat
> >
> > If I ssh in as a real user, it works fine.
> >
> > If I ssh as a MySQL user, it doesn't allow me to login. In auth.log I get:
> >
> > Feb  7 09:51:31 notes nss-mysql[1879]: _nss_mysql_read_conf_file: called
for
> > section users
> > Feb  7 09:51:31 notes nss-mysql[1879]: _nss_mysql_read_conf_file ended for
> > section users
>
> Hmm, I am pretty sure that you should have more info in your log. You
> should try to do a 'make clean' in your source repository and do a make.
> Furtheremore, when you want to test your installation, you should use
> id, it is very practical.
>
> --
> Guillaume Morin <address@hidden>
>
>        Unwisely, Santa offered a teddy bear to James, unaware that he had
>              been mauled by a grizzly earlier that year (T. Burton)
>
> _______________________________________________
> Nss-mysql-users mailing list
> address@hidden
> http://mail.freesoftware.fsf.org/mailman/listinfo/nss-mysql-users




reply via email to

[Prev in Thread] Current Thread [Next in Thread]