[PARTIAL SOLVED] Re: Auth user with postgresql

[ktm at rice.edu]

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