Try this:

db = DAL("postgres://xw@dbname-postgres:
p...@dbname-postgres.postgres.database.azure.com/dbname")

El vie., 28 de sep. de 2018 a la(s) 02:17, gb (gregb...@gmail.com) escribió:

> 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.
>

-- 
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.

Reply via email to