Certificate, login & php question ?

From: Jean-Gerard Pailloncy <jg(at)rilk(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Certificate, login & php question ?
Date: 2006-09-11 00:32:26
Message-ID: DF9539FE-33E8-4E10-BB66-075E719329EE@rilk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-09-11 03:39:59 Re: Certificate, login & php question ?
Previous Message Richard Broersma Jr 2006-09-10 20:44:40 Re: Database design and triggers...