[PARTIAL SOLVED] Re: Auth user with postgresql

[ktm at rice.edu]

On Tue, Feb 21, 2012 at 12:38:15AM +0100, Giuseppe Tofoni wrote:
> Hi
> Unfortunately the problem is partially solved.
> 
> postgres_query   "SELECT user FROM usertable "WHERE user=$user AND
> pwd=crypt($pass, pwd)";
> 
> The crypt function in postgresql works correctly only with the
> password created by the htpasswd program, but do not work with
> passwords created by PHP.
> 
> Best regards, and many thanks.
> 

You need to determine what "crypt" is being used in your PHP:

http://php.net/manual/en/function.crypt.php

Once you have that information, you should be able to figure out
what you will need to do.

Cheers,
Ken