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:[email protected]/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 <[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.
