Auth user with postgresql

[Piotr Sikora]

Hi,

> Hi reason, the password is not in MD5, but rather in DES (PHP -->
> crypt($verpas, CRYPT_STD_DES)
> What should I use instead of set_md5 ?
> DES on this page http://wiki.nginx.org/HttpSetMiscModule#Installation
> is never mentioned

I'm not aware of any module that would offer crypt() hashing for variables 
in nginx.conf.

On the bright side, PostgreSQL's crypt() [1] should help you. Could you 
please try:

    postgres_query   "SELECT user FROM usertable
                     "WHERE user=$user AND pwd=crypt($pass, pwd)";

[1] http://www.postgresql.org/docs/9.1/static/pgcrypto.html

Best regards,
Piotr Sikora < piotr.sikora at frickle.com >