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.