[Top][All Lists]
[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:15:15 -0600 |
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
- Re: [Nss-mysql-users] Problems Compiling, (continued)
- Re: [Nss-mysql-users] Problems Compiling, Guillaume Morin, 2002/02/07
- Re: [Nss-mysql-users] Problems Compiling, Ben Sinclair, 2002/02/07
- Re: [Nss-mysql-users] Problems Compiling, Guillaume Morin, 2002/02/07
- Re: [Nss-mysql-users] Problems Compiling, Ben Sinclair, 2002/02/07
- [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Ben Sinclair, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Guillaume Morin, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Ben Sinclair, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Guillaume Morin, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Ben Sinclair, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Guillaume Morin, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL,
Ben Sinclair <=
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Ben Sinclair, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Guillaume Morin, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Ben Sinclair, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Guillaume Morin, 2002/02/07
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Ben Sinclair, 2002/02/07
- Message not available
- Re: [Nss-mysql-users] NSS-MySQL and PAM-MySQL, Guillaume Morin, 2002/02/07