python-3.x - Python Flask 应用程序无法连接到 redshift 数据库

Question

我的简单 python flask 应用程序无法连接到 redshift 数据库。记录的错误:

psycopg2.OperationalError: could not create SSL context: library has no ciphers FATAL: no pg_hba.conf entry for host "::ffff:0.0.0.0", user "admin", database "redshiftdb", SSL off

但是当我尝试使用没有 flask 的简单 python(simple.py) 时，相同的连接效果很好。

import psycopg2

conn = psycopg2.connect(database="redshiftdb", user = "admin", password = "admin!pwd", host = "remotehost", port = "5439")

print ("Opened database successfully")

但是对于 flask 它不起作用(init.py)。

from flask import Flask
import psycopg2

@app.route("/service")
def service():
    conn = psycopg2.connect(database="redshiftdb", user = "admin", password = "admin!pwd", host = "remotehost", port = "5439")
    return "Service is running!"

if __name__ == "__main__":
    app.run()

• ubuntu v12
• Python 版本:3.4
• psycopg2==2.7.5
• psycopg2-binary==2.7.5
• flask ==1.0.2

Answer 1

尝试从源代码构建 psycopg2

pip install -r requirements.txt

包含在requirements.txt中

psycopg2==2.7.5 --no-binary :all: