connect to PostgreSQL over SSL from PHP

--Nq2Wo0NMKNjxTN9z
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

hi

How am I able to connect to PostgreSQL over SSL from PHP?

--=20
WBR, sector119

--Nq2Wo0NMKNjxTN9z
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+MA61cBYIdwDdknERAmAhAJwOjsM33NXYDEv4e0FQgpYHLifPyACf RFiX
ZTu3R/ghhj6pn0L5c2Vnkl4=
=qh8v
-----END PGP SIGNATURE-----

--Nq2Wo0NMKNjxTN9z--

Re: connect to PostgreSQL over SSL from PHP

--X1bOJ3K7DJ5YkBrT
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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=20
> 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

>=20
> SSL itself is an extrafeature used with TCP/IP - it's not database=20
> dependent. You need to configure a UNIX host that accepts SSL (https).=20
> 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?

>=20
> So - please have a "google" for SSL TCP IP IPSec or Tunneling...
> anything else depends on you configuration and your desired application.
>=20

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
---

--=20
WBR, sector119

--X1bOJ3K7DJ5YkBrT
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+MPQkcBYIdwDdknERAlNEAKCoAkj0GOxvgaoq7DV6ESBrH+zhBgCg nYcr
bOASoqeX94PtOlFPiHjXDKQ=
=qP+a
-----END PGP SIGNATURE-----

--X1bOJ3K7DJ5YkBrT--