Certificate, login & php question ? - Mailing list pgsql-general

From Jean-Gerard Pailloncy
Subject Certificate, login & php question ?
Date
Msg-id DF9539FE-33E8-4E10-BB66-075E719329EE@rilk.com
Whole thread Raw
Responses Re: Certificate, login & php question ?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Hi,

I have setup an apache server with SSL.
I create a CA, serker.key, server.crt.
I create a user.key and user.cert.
Now the apache server accept only the correct certificate for login on a given directory.

I have a PHP script that query the database using the HTTP login/password as PostgreSQL user/password.

I plan to add the same SSL setup to PostreSQL.
1) Is it possible to use the SSL authentification done by apache with PostgreSQL ?
2) How the DN of the certificate is match against an PostgreSQL role ?

Any help is welcomed.
Pailloncy Jean-Gerard



Attachment

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Database design and triggers...
Next
From: Michael Fuhr
Date:
Subject: Re: Certificate, login & php question ?