From: sector119@mail.ru
To: pgsql-php@postgresql.org
Subject: Re: connect to PostgreSQL over SSL from PHP
Date: Fri, 24 Jan 2003 10:07:01 +0200
Message-ID: <20030124080700.GA622@city.gov.te.ua> (raw)
In-Reply-To: <3E301923.6020408@computer-systeme.de>
References: <20030123154805.GA15760@city.gov.te.ua>
<3E301923.6020408@computer-systeme.de>
On Thu, Jan 23, 2003 at 05:32:35PM +0100, Philipp Ottlinger wrote:
> Actually you should have an entry in your pga_hba_ident.conf which
> defines to use encryypted passwords.
hostssl all all 0.0.0.0 255.255.255.255 MD5
everyone have to connect to PG server using SSL
>
> SSL itself is an extrafeature used with TCP/IP - it's not database
> dependent. You need to configure a UNIX host that accepts SSL (https).
> Then you can put your PHP-Codes in secure-area-Code.
all users connected to web server using https, but it is connection
over SSL only between web server and user's browser!?
I need SSL crypt between web server and PostgreSQL server!
How am I able to do this?
>
> So - please have a "google" for SSL TCP IP IPSec or Tunneling...
> anything else depends on you configuration and your desired application.
>
For example if I connect to PostgreSQL server,
I am able to do like this:
ssh -L 4001:dbserver:5432 sector119@dbserver
psql -h localhost -p 4001 test
I create SSL tunnel over SSH and then connect to DB server over psql!
And I need to do the same connection to DB server over SSL using PHP,
without creating SSL tunnel over SSH!
---
For example:
Web server: 10.0.1.10
DB server: 10.0.1.102
User: 10.0.1.0/255.255.255.0
Web server: Apache; DB server: PostgreSQL
---
--
WBR, sector119
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: sector119@mail.ru
Subject: Re: connect to PostgreSQL over SSL from PHP
In-Reply-To: <20030124080700.GA622@city.gov.te.ua>
References: <20030123154805.GA15760@city.gov.te.ua> <3E301923.6020408@computer-systeme.de> <20030124080700.GA622@city.gov.te.ua>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox