Re: [web2py] Re: SSL database connections

2018-04-19 Thread Richard Vézina
It much easier to make ssh port fowarding remote 5432 to local 5433 for instance and then configure pgadmin to use the local port, everything goes to ssh tunnel between you and the server... ssh -L 5433:127.0.0.1:5432 your_user@remote_ip_or_dns Richard On Thu, Apr 19, 2018 at 1:47 PM, wrote: >

[web2py] Re: SSL database connections

2018-04-19 Thread tchristopoulos . ntc
How can someone get the .crt and .key files from the .pem files? Will this work for connecting to a remote DB stored on google cloud? On Monday, June 27, 2016 at 7:02:31 AM UTC-4, Dragan Matic wrote: > > Thanks Massimo, just in case anybody has the same problem, this is the > full syntax for co

Re: [web2py] Re: SSL database connections

2016-06-28 Thread Marlysson Silva
To better anwers, could create a new topic with a question. But basicaly it's a list using append (add in last position) where when remove a element, just make a list.pop() , removing top element (last position added). Em terça-feira, 28 de junho de 2016 03:10:36 UTC-3, Suchismita Debnath escr

Re: [web2py] Re: SSL database connections

2016-06-27 Thread Suchismita Debnath
how to apply the stsck concept in web2py for a google map? On Mon, Jun 27, 2016 at 4:32 PM, Dragan Matic wrote: > Thanks Massimo, just in case anybody has the same problem, this is the > full syntax for connecting in ssl mode: > > DAL('postgres://postgres:draganova_si...@n1.theobviousthings.com

[web2py] Re: SSL database connections

2016-06-27 Thread Dragan Matic
Thanks Massimo, just in case anybody has the same problem, this is the full syntax for connecting in ssl mode: DAL('postgres://postgres:draganova_si...@n1.theobviousthings.com/sshfw', driver_args={"sslmode":"require", "sslrootcert":"root.crt", "sslcert": "postgresql.crt", "sslkey":"postgresql.ke

[web2py] Re: SSL database connections

2016-06-25 Thread Massimo Di Pierro
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 connect

[web2py] Re: SSL database connections

2016-06-24 Thread Dragan Matic
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.