Re: SSL confirmation

Ah... ok

I need something like:

<datasources>
   <local-tx-datasource>
     <jndi-name>PostgresDS</jndi-name>

<connection-url>jdbc:postgresql://localhost:5432/beyarecords</
connection-url>
     <driver-class>org.postgresql.Driver</driver-class>
     <user-name>myName</user-name>
     <password>myPass</password>

     <sslmode>require</sslmode>

   </local-tx-datasource>

</datasources>

would that do the trick? Sorry for so many questions.. i have a lot to
learn about postgreSQL ;-)

regards

Andrew

On 5 Dec 2004, at 20:39, Michael Fuhr wrote:

> On Sun, Dec 05, 2004 at 08:07:26PM +0000, Andrew M wrote:
>
>> are you saying I need to do:
>>
>> 'select * from myTable where x=y sslmode=require'
>>
>> to make a request to the database a secure one? If so, as I am using
>> Hibernate, do you know how I would alter my maps to reflect this?
>
> No, "sslmode=require" would be part of the string that gets passed
> to libpq's PQconnectdb() or its ilk, i.e., the functions that make
> the initial connection to the database.  If you're using an abstraction
> layer that sits above libpq or an interface that implements the
> communications protocol without using libpq, then you may or may
> not have a way to specify such connection options.  Check your
> interface's documentation.
>
> If your interface sits above libpq but doesn't allow you to specify
> connection options like "sslmode=require", then setting environment
> variables might still work.  See the "Environment Variables" section
> of the "libpq - C Library" chapter in the PostgreSQL documentation.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>