Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 880B8476415 for ; Fri, 24 Jan 2003 03:28:52 -0500 (EST) Received: from cola.bit.te.ua (unknown [193.193.206.138]) by postgresql.org (Postfix) with ESMTP id 098D4476565 for ; Fri, 24 Jan 2003 03:07:04 -0500 (EST) Received: from cola.bit.te.ua (root@localhost) by cola.bit.te.ua (8.11.6/8.11.6) with SMTP id h0O872W25919 for ; Fri, 24 Jan 2003 10:07:02 +0200 Received: from mars.l5.city.int (IDENT:1000@mars.l5.city.int [10.0.1.33]) by cola.bit.te.ua (8.11.6/8.11.6) with ESMTP id h0O871W25905 for ; Fri, 24 Jan 2003 10:07:02 +0200 Received: (from sector119@localhost) by mars.l5.city.int (8.12.4/8.12.4/Submit) id h0O871Ut000944 for pgsql-php@postgresql.org; Fri, 24 Jan 2003 10:07:01 +0200 X-Authentication-Warning: mars.l5.city.int: sector119 set sender to sector119@mail.ru using -f Date: Fri, 24 Jan 2003 10:07:01 +0200 From: sector119@mail.ru To: pgsql-php@postgresql.org Subject: Re: connect to PostgreSQL over SSL from PHP Message-ID: <20030124080700.GA622@city.gov.te.ua> References: <20030123154805.GA15760@city.gov.te.ua> <3E301923.6020408@computer-systeme.de> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="X1bOJ3K7DJ5YkBrT" Content-Disposition: inline In-Reply-To: <3E301923.6020408@computer-systeme.de> User-Agent: Mutt/1.4i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/63 X-Sequence-Number: 1808 --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+zhBgCgnYcr bOASoqeX94PtOlFPiHjXDKQ= =qP+a -----END PGP SIGNATURE----- --X1bOJ3K7DJ5YkBrT--