[PARTIAL SOLVED] Re: Auth user with postgresql

ktm at rice.edu ktm at rice.edu
Tue Feb 21 17:02:22 UTC 2012


On Tue, Feb 21, 2012 at 05:45:20PM +0100, Giuseppe Tofoni wrote:
> Hi,
> 
> In PHP I used    crypt($pass, CRYPT_STD_DES) and I tried with the
> following statement
> 
> postgres_query    "SELECT user FROM usertable WHERE user=$user AND
> pwd=crypt($pass, substr(pwd, 1, 2))";
> 
> but do not work,  some ideas?
> 
> Best regards
> 
> Giuseppe
> 

Are the encrypted passwords the same? If they are, are you certain you
are passing the correct password, i.e. stripping line ending correctly?

Ken



More information about the nginx mailing list