Trying to connect to Azure-hosted postgres on version
2.17.1-stable+timestamp.2018.08.06.01.02.56
If I try and connect with:
db = DAL(
"postgres://dbname@dbname-postgres:p...@dbname-postgres.postgres.database.azure.com/dbname"
)
I get this:
Invalid URI string in DAL
I thought it might have to do with the @ so I encoded it:
db = DAL(
"postgres://dbname%40dbname-postgres:p...@dbname-postgres.postgres.database.azure.com/dbname"
)
OperationalError: could not create SSL context: library has no ciphers
FATAL: Invalid Username specified. Please check the Username and retry
connection. The Username should be in <username@hostname> format.
Connecting like this works totally fine:
import psycopg2
conn = psycopg2.connect("dbname='dbname' user='xw@dbname-postgres'
host='dbname-postgres.postgres.database.azure.com' password='pass'")
cur = conn.cursor()
Any ideas?
Thanks so much
--
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.
