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, <tchristopoulos....@gmail.com> wrote:
>
> 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 connecting in ssl mode:
>>
>> DAL('postgres://postgres:password@server_addr/db_name
>> <http://postgres:draganova_si...@n1.theobviousthings.com/sshfw>',
>> driver_args={"sslmode":"require", "sslrootcert":"root.crt", "sslcert":
>> "postgresql.crt", "sslkey":"postgresql.key"})
>>
>> where sslrootcert, sslcert and sslkey must contain the full paths to the
>> files.
>>
>> On Sunday, June 26, 2016 at 7:21:43 AM UTC+2, Massimo Di Pierro wrote:
>>>
>>> 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 <sam...@gmail.com> 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 <mdipie...@cs.depaul.edu>
>>>>> 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 <sam...@gmail.com> 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 <mdipie...@cs.depaul.edu> 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 <sam...@gmail.com> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
