Re: [Nss-mysql-users] Proftpd not authenticating nss-mysql users

[Guillaume Morin]

Hi Mark,

Sorry for the delay, I am very busy atm.

Dans un message du 16 nov à 13:58, Mark Colasante écrivait :
> Nov 16 13:50:13 nwx2 sshd(pam_unix)[12678]: session opened for user mark
> by (uid=0)
> Nov 16 13:50:38 nwx2 sshd(pam_unix)[12678]: session closed for user mark
> Nov 16 13:50:43 nwx2 proftpd[12717]: nwx2.kmionline.com
> (dhcp9574238.columbus.rr.com[24.95.74.238]) - FTP session opened. 
> Nov 16 13:50:48 nwx2 proftpd[12717]: nwx2.kmionline.com
> (dhcp9574238.columbus.rr.com[24.95.74.238]) - no such user 'mark' 
> Nov 16 13:50:51 nwx2 proftpd[12717]: nwx2.kmionline.com
> (dhcp9574238.columbus.rr.com[24.95.74.238]) - FTP session closed.
> Nov 16 13:51:30 nwx2 proftpd[12720]: nwx2.kmionline.com
> (dhcp9574238.columbus.rr.com[24.95.74.238]) - FTP session opened. 
> Nov 16 13:51:35 nwx2 ftp(pam_unix)[12720]: session opened for user mcola
> by (uid=0)
> Nov 16 13:51:38 nwx2 proftpd[12720]: nwx2.kmionline.com
> (dhcp9574238.columbus.rr.com[24.95.74.238]) - FTP session closed. 
> Nov 16 13:51:38 nwx2 ftp(pam_unix)[12720]: session closed for user mcola
> Nov 16 13:52:01 nwx2 sshd(pam_unix)[12722]: session opened for user
> mcola by (uid=0)
> Nov 16 13:52:03 nwx2 sshd(pam_unix)[12722]: session closed for user
> mcola
> 
> Why is it that I get a "no such user" when attempting to login via ftp
> with an nss-mysql account?

It is weird. I'd say that there is an error in your configuration or in
your database. You should try to log the queries sent to the MySQL
server and compare the results between mcola and mark logins. If you
don't see anything obvious, please send them to me with a dump of your
database and your config files. I'll see what I can find.

Regards,

-- 
Guillaume Morin <address@hidden>

         Do you worry that you're not liked ? How long till you break
                                (Our Lady Peace)