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://cumin@localhost/cumin?sslmode=require
should be working, except for the square brackets, just omit them.
my uris look like this for example:
mysql://user:pass@host/dbname?charset=utf8&use_unicode=1&debug=True
HTH,
Frank
Am 05.06.2010 um 08:04 schrieb 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 that could be set
> through the PostgresConnection [2]. I have a Java background rather
> than a Python background, so that may be part of the problem.
>
> I think the connection is being created like this:
>
> connectionForURI("postgresql://cumin@localhost/cumin").getConnection()
>
> Is it possible for me to add something like listed in [1] to make the DB
> connection over SSL? I tried
> postgresql://cumin@localhost/cumin?[sslmode]=require, but that doesn't
> seem to work.
>
> [1]
> http://python.projects.postgresql.org/docs/1.0/driver.html#connection-keywords
>
> [2]
> http://svn.colorstudy.com/SQLObject/trunk/sqlobject/postgres/pgconnection.py
>
>
> Thanks!
>
> Aaron Pestel
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit. See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
|
