you use postgres you can do: db = DAL(....., driver_args=dict(sslmode="require"))
should work fine. I do not know of other engines that support it but there is always a way to tell the driver. On Friday, 24 June 2016 05:53:37 UTC-5, Dragan Matic wrote: > > Has there been any progress in connecting through SSL with DAL? Searching > chapter 6 (DAL) of the web2py book for "ssl" or "secure" does not find > anything. > > > On Sunday, August 23, 2009 at 6:01:11 PM UTC+2, mdipierro wrote: >> >> We do not support that but now that I know it should be easy to add. >> We will add it in the next version. >> >> Please help us test it. Edit gluon.sql.py and change >> >> msg = \ >> "dbname='%s' user='%s' host='%s' port=%s >> password='%s'"\ >> % (db, user, host, port, passwd) >> self._pool_connection(lambda : psycopg2.connect(msg)) >> >> >> with >> >> msg = \ >> "dbname='%s' user='%s' host='%s' port=%s password='%s' >> sslmode='require'"\ >> % (db, user, host, port, passwd) >> self._pool_connection(lambda : psycopg2.connect(msg)) >> >> does it work? >> >> Massimo >> >> On Aug 23, 10:57 am, Don Lee <[email protected]> wrote: >> > 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:password@hostname/db’, pools=10, >> > > > > > secure=True) >> > >> > > > > > My production DB and web servers are running on a different >> machines. > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
