Hi, Piotr Sikora

I followed your instructions but when I start nginx the following error:

nginx: [emerg] the duplicate "remote_passwd" variable in
/etc/nginx/nginx.conf:60

.........
location =/t1
{
internal;
more_set_headers -s 401 'WWW-Authenticate: Basic
realm="Cartella test1"';
postgres_escape $user $remote_user;

set_md5 $remote_passwd;
postgres_escape $pass $remote_passwd;

postgres_pass database;
postgres_query "SELECT user FROM usertable WHERE
user=$user AND pwd=$pass";
postgres_rewrite no_rows 401;
postgres_output none;
}
.............
How can I solve the problem?
Many thanks again.

Giuseppe

p.s.:it is normal to immediately start nginx requires authentication
to the database?

2012/2/17 Piotr Sikora <piotr.sikora@frickle.com>:
> Hi,
>
>
>> The login and password is okay, but in my database passwords are
>> stored in MD5, while the password is passed in the clear as I can
>> solve the problem?
>
>
> You can use "set_md5" directive from ngx_set_misc module [1]:
>
>   set_md5 $remote_passwd; /* must be before postgres escape */
>   postgres_escape $pass $remote_passwd;
>
> [1] https://github.com/agentzh/set-misc-nginx-module
>
>
> Best regards,
> Piotr Sikora < piotr.sikora@frickle.com >
>
> _______________________________________________
> nginx mailing list
> nginx@nginx.org
> http://mailman.nginx.org/mailman/listinfo/nginx

_______________________________________________
nginx mailing list
nginx@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx