[Sqlalchemy-tickets] Issue #3153: postgresql+pg8000 fails to connect when postgresql server is usin
Brought to you by:
zzzeek
|
From: Sorin S. <iss...@bi...> - 2014-08-02 13:52:56
|
New issue 3153: postgresql+pg8000 fails to connect when postgresql server is using SSL https://bitbucket.org/zzzeek/sqlalchemy/issue/3153/postgresql-pg8000-fails-to-connect-when Sorin Sbarnea: postgresql+pg8000 fails to connect when postgresql server is using SSL pg8000/core.py", line 873, in __init__ raise InterfaceError("communication error", exc_info()[1]) sqlalchemy.exc.InterfaceError: (InterfaceError) ('communication error', error(61, 'Connection refused')) None None I even tried to use the same parameter as the one used in the psycopg2 and to append '&sslmode=require" to the URL but this has no effect. pg8000 has a parameter for enabling SSL, but this seems not to be supported by sqlalchemy or not documented. In fact the proper way to implement this would be to use SSL without having to ask for an additional parameter. A very good example is "psql" utility which works in both cases, without asking you to specify if is to use SSL or not. |