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

[Ben Sinclair]

I looked at the source and saw that the blank part was because of me not
filling in the where option, so I did, and it works better but still doesn't
actually let me in:

Feb  7 10:10:52 notes nss-mysql[2685]: getpwnam called for bbobo
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_read_conf_file: called for section
users
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_read_conf_file ended for section
users
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_db_connect: connection with
host=localhost,user=securesite,passwd=arrmemateys,database=securesite,port=3306
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_passwd_fill_struct called for user
bbobo
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_sqlprintf(): buffersize=1024,
len=193
Feb  7 10:10:52 notes sshd[2685]: _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 enabled
= 1
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_passwd_fill_struct: username ==
bbobo
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_passwd_fill_struct: password ==
password
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_passwd_fill_struct: uid == 2161
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_passwd_fill_struct: gid == 1008
Feb  7 10:10:52 notes sshd[2685]: _nss_mysql_passwd_fill_struct finished
sucessfully
Feb  7 10:10:55 notes sshd[2685]: getpwnam called for bbobo
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_read_conf_file: called for section
users
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_read_conf_file ended for section
users
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_passwd_fill_struct called for user
bbobo
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_sqlprintf(): buffersize=1024,
len=193
Feb  7 10:10:55 notes sshd[2685]: _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 enabled
= 1
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_passwd_fill_struct: username ==
bbobo
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_passwd_fill_struct: password ==
password
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_passwd_fill_struct: uid == 2161
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_passwd_fill_struct: gid == 1008
Feb  7 10:10:55 notes sshd[2685]: _nss_mysql_passwd_fill_struct finished
sucessfully
Feb  7 10:10:55 notes PAM_unix[2685]: authentication failure; (uid=0) ->
**unknown** for ssh service
Feb  7 10:10:57 notes sshd[2685]: Failed password for bbobo from 127.0.0.1 port
976


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

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


> 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
>
>
> _______________________________________________
> Nss-mysql-users mailing list
> address@hidden
> http://mail.freesoftware.fsf.org/mailman/listinfo/nss-mysql-users