[vwnc] [VWNC] PostgreSQL connection questions

Hello everybody,

I do have couple of questions about PostgreSQL connection in VW.

1. The PostgreSQL allows to set encoding for the Database as ASCII or
UTF8 among many others.  However the VW connection to the Postgres
(PostgreSQLConnection )the stringEncodingName is never set so it lazy
initializes itself to the #default.

Does it mean that the it is up to the client applications  to set
appropriate encoding ?  and is there any way do see the default encoding
  from the database itself upon connecting ?

2.  Is there any way to make VW to PostgreSql communication secure ?

The manual for the database states: "PostgreSQL has native support for
using SSL connections to encrypt client/server communications for
increased security. "

However it appears that VW communicates with the PostgreSql without any
data encryption by default.

Does anyone have any experience or information on how to set SSL
communication between  VW and PosgreSQL?


Any information is greatly appreciated.

Truly,

--Mark Pirogovsky
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Mark,

I don't have my head under the covers of the PostgreSQL drives much
these days as they just seem to work for all the things I need, but
let me try to address your questions.  All off the top of my head ....

On 01/12/2008, Mark Pirogovsky <[hidden email]> wrote:
>  1. The PostgreSQL allows to set encoding for the Database as ASCII or UTF8
> among many others.  However the VW connection to the Postgres
> (PostgreSQLConnection )the stringEncodingName is never set so it lazy
> initializes itself to the #default.

There are some tests that handle Ukrainian.  Do those give you enough
to work with?

>  Does it mean that the it is up to the client applications  to set
> appropriate encoding ?

Yes.  If the client does not want to use the defaults then it must set
the encoding in the connection.  IIRC the encoding only applies to the
content of character data fields.

>  and is there any way do see the default encoding
> from the database itself upon connecting ?

There is a query you can execute but I don't recall the details.

>  2.  Is there any way to make VW to PostgreSql communication secure ?

Tunnel over SSH.

>  The manual for the database states: "PostgreSQL has native support for
> using SSL connections to encrypt client/server communications for increased
> security.

I've not implemented that but would gladly merge in the code if
someone has.  (under the LGPL)

All the best,
    Bruce
--
Make the most of your skills - with OpenSkills
http://www.openskills.org/
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Yes, it's up to the client. If you look at StoreGlorp, it has an example of doing it. And in fact of testing to see if the database can support it, because the old public Store didn't. See StoreLoginFactory>#setPostgresqlSessionToUnicode:

At 11:44 AM 12/1/2008, Mark Pirogovsky wrote:

Hello everybody,

I do have couple of questions about PostgreSQL connection in VW.

1. The PostgreSQL allows to set encoding for the Database as ASCII or
UTF8 among many others.  However the VW connection to the Postgres
(PostgreSQLConnection )the stringEncodingName is never set so it lazy
initializes itself to the #default.

Does it mean that the it is up to the client applications  to set
appropriate encoding ?  and is there any way do see the default encoding
  from the database itself upon connecting ?

2.  Is there any way to make VW to PostgreSql communication secure ?

The manual for the database states: "PostgreSQL has native support for
using SSL connections to encrypt client/server communications for
increased security. "

However it appears that VW communicates with the PostgreSql without any
data encryption by default.

Does anyone have any experience or information on how to set SSL
communication between  VW and PosgreSQL?


Any information is greatly appreciated.

Truly,

--Mark Pirogovsky
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc