Re: [SQLObject] Creating SQL connection to Postgres over SSL

2010-07-02 Thread Oleg Broytman
On Fri, Jul 02, 2010 at 07:41:30PM +0400, Oleg Broytman wrote: >It only works with psycopg[12] backends, and those backends only > understand 'sslmode' parameter - not certificate/keyfile/CA. Sorry - psycopg *drivers*. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p.

Re: [SQLObject] Creating SQL connection to Postgres over SSL

2010-07-02 Thread Oleg Broytman
Hello. I just added 'sslmode' to PostgresConnection - see commit 4199 in the Subversion repository. The syntax is postgresql://cu...@localhost/cumin?sslmode=require It only works with psycopg[12] backends, and those backends only understand 'sslmode' parameter - not certificate/keyfile/CA.

Re: [SQLObject] Creating SQL connection to Postgres over SSL

2010-06-18 Thread Oleg Broytman
On Sat, Jun 05, 2010 at 01:04:37AM -0500, Aaron Pestel wrote: > postgresql://cu...@localhost/cumin?[sslmode]=require, but that doesn't > seem to work. Currently it's impossible. I added the request to my TODO list. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.

Re: [SQLObject] Creating SQL connection to Postgres over SSL

2010-06-05 Thread Frank Wagner
Hi Aaron, from what I have seen in the code my guess is that any parameter added to the connection uri is passed along to the database driver, if it isn“t amongst the ones specified in http://sqlobject.org/SQLObject.html#declaring-a-connection having said that, your approach postgresql://cu...

[SQLObject] Creating SQL connection to Postgres over SSL

2010-06-04 Thread Aaron Pestel
Hello, I'm working with a Python application that is using SQLObject to connect to Postgres. However, we need the connection from Python to the Postgres DB to be over SSL. It looks like the Postgres Python driver has an "sslmode" that can be set [1]. However, I'm having difficulty seeing how