Yes. PostgreSQL allows for an SSL connection between the client and the
server. This can be done with psycopg2, for example:
import psycopg2 as database
db = database.connect (host="db.host.com",
sslmode="require",
database="dbname",
user="dbuser",
password="dbpass")
On Sun, Aug 23, 2009 at 10:04 AM, mdipierro <[email protected]> wrote:
>
> Then I do not understand what you mean by "secure connection". Is
> there a secure connection function provided by postgresql and psycopg2
> that web2py is not using and should be using?
>
> Massimo
>
> On Aug 23, 8:14 am, Don <[email protected]> wrote:
> > I do not have SSH access to the DB server. Can I use psycopg2
> > directly to create the connection?
> >
> > On Aug 23, 8:59 am, mdipierro <[email protected]> wrote:
> >
> > > Yes but not this way.
> > > You have to open an ssh tunner outside web2py and then instruct web2py
> > > to connect to the database using the port used by the tunnel.
> >
> > > Massimo
> >
> > > On Aug 23, 7:47 am, Don <[email protected]> wrote:
> >
> > > > Is it possible to define a secure database connection?
> >
> > > > Ex: db = DAL(‘postgres://user:passw...@hostname/db’, pools=10,
> > > > secure=True)
> >
> > > > My production DB and web servers are running on a different machines.
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
