pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SLL with PHP?
3+ messages / 2 participants
[nested] [flat]

* SLL with PHP?
@ 2002-03-06 02:33  mark boylan <markboylan@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: mark boylan @ 2002-03-06 02:33 UTC (permalink / raw)
  To: pgsql-php


Hi.

Can anyone tell me if PHP is capable of connecting to pg using ssl?  If I 
put a "hostssl" line for my web server in my pg_hba.conf file, will all of 
the communication between the webserver and database server be encrypted?  
Can it be that simple?

Thanks :)

- Mark



_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: SLL with PHP?
@ 2002-03-06 02:50  Rod Taylor <rbt@zort.ca>
  parent: mark boylan <markboylan@hotmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Rod Taylor @ 2002-03-06 02:50 UTC (permalink / raw)
  To: mark boylan <markboylan@hotmail.com>; pgsql-php

Libpq does all of the work.  PHP has no notion of an encrypted
session, it just tells libpq to connect.

If you create a certificate for postgresql (see docs) libpq will
normally use an encrypted session by default.  By setting hostssl in
pg_hba.conf it will enforce that all connections must be encrypted to
connect -- kinda a guarentee.

Anyway, it is that simple.

--
Rod Taylor

This message represents the official view of the voices in my head

----- Original Message -----
From: "mark boylan" <markboylan@hotmail.com>
To: <pgsql-php@postgresql.org>
Sent: Tuesday, March 05, 2002 9:33 PM
Subject: [PHP] SLL with PHP?


>
> Hi.
>
> Can anyone tell me if PHP is capable of connecting to pg using ssl?
If I
> put a "hostssl" line for my web server in my pg_hba.conf file, will
all of
> the communication between the webserver and database server be
encrypted?
> Can it be that simple?
>
> Thanks :)
>
> - Mark
>
>
>
> _________________________________________________________________
> Send and receive Hotmail on your mobile device:
http://mobile.msn.com
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: SLL with PHP?
@ 2002-03-06 03:07  mark boylan <markboylan@hotmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: mark boylan @ 2002-03-06 03:07 UTC (permalink / raw)
  To: pgsql-php

Thanks Rod.

I did set up a certificate and I added the hostssl line.  Then when I logged 
into pg with SSH I got:

"SSL enabled connection. Chiper: DES-CBC3-SHA, bits: 168"

which was great.  But I was suprised that I was still able to connect 
normally with PHP.  I wasn't sure if it was working encrypted, or if I had 
set something up wrong.  Thanks for the help!

Everything should be this easy :)

- Mark




>From: "Rod Taylor" <rbt@zort.ca>
>To: "mark boylan" <markboylan@hotmail.com>, <pgsql-php@postgresql.org>
>Subject: Re: [PHP] SLL with PHP?
>Date: Tue, 5 Mar 2002 21:50:52 -0500
>
>Libpq does all of the work.  PHP has no notion of an encrypted
>session, it just tells libpq to connect.
>
>If you create a certificate for postgresql (see docs) libpq will
>normally use an encrypted session by default.  By setting hostssl in
>pg_hba.conf it will enforce that all connections must be encrypted to
>connect -- kinda a guarentee.
>
>Anyway, it is that simple.
>
>--
>Rod Taylor
>
>This message represents the official view of the voices in my head
>
>----- Original Message -----
>From: "mark boylan" <markboylan@hotmail.com>
>To: <pgsql-php@postgresql.org>
>Sent: Tuesday, March 05, 2002 9:33 PM
>Subject: [PHP] SLL with PHP?
>
>
> >
> > Hi.
> >
> > Can anyone tell me if PHP is capable of connecting to pg using ssl?
>If I
> > put a "hostssl" line for my web server in my pg_hba.conf file, will
>all of
> > the communication between the webserver and database server be
>encrypted?
> > Can it be that simple?
> >
> > Thanks :)
> >
> > - Mark
> >
> >
> >
> > _________________________________________________________________
> > Send and receive Hotmail on your mobile device:
>http://mobile.msn.com
> >
> >
> > ---------------------------(end of
>broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2002-03-06 03:07 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-06 02:33 SLL with PHP? mark boylan <markboylan@hotmail.com>
2002-03-06 02:50 ` Rod Taylor <rbt@zort.ca>
2002-03-06 03:07 Re: SLL with PHP? mark boylan <markboylan@hotmail.com>

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