dockercompose:sqlalchemy.exc.ArgumentError:无法从字符串解析rfc1738 URL

Question

我正试图与docker一起为一个使用AWS红移和s3的数据管道项目启动气流。在运行docker build-t我的气流后。成功地，docker-compose up输出以下错误。我尝试了一系列postgres连接字符串，但都导致了相同的错误

docker-compose up错误：

webserver_1  | Traceback (most recent call last):
webserver_1  |   File "/usr/local/bin/airflow", line 25, in <module>
webserver_1  |     from airflow.configuration import conf
webserver_1  |   File "/usr/local/lib/python3.8/site-packages/airflow/__init__.py", line 47, in <module>
webserver_1  |     settings.initialize()
webserver_1  |   File "/usr/local/lib/python3.8/site-packages/airflow/settings.py", line 377, in initialize
webserver_1  |     configure_orm()
webserver_1  |   File "/usr/local/lib/python3.8/site-packages/airflow/settings.py", line 266, in configure_orm
webserver_1  |     engine = create_engine(SQL_ALCHEMY_CONN, **engine_args)
webserver_1  |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/__init__.py", line 479, in create_engine
webserver_1  |     return strategy.create(*args, **kwargs)
webserver_1  |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 54, in create
webserver_1  |     u = url.make_url(name_or_url)
webserver_1  |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 229, in make_url
webserver_1  |     return _parse_rfc1738_args(name_or_url)
webserver_1  |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 290, in _parse_rfc1738_args
webserver_1  |     raise exc.ArgumentError(
webserver_1  | sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string '"postgresql+psycopg2:///user:password@host:port/db"'
airflow_webserver_1 exited with code 1

以下是我到目前为止尝试过的连接字符串（隐私假值）：

sql_alchemy_conn = "postgresql://user:password@host:port/db"
sql_alchemy_conn = "postgresql+psycopg2://user:password@host:port/db"
sql_alchemy_conn = "postgresql+psycopg2:///user:password@host:port/db"

如果需要Dockerfile和docker-compose.yml文件，请告知我。现在，我猜错误与连接字符串格式有关

Answer 1

愚蠢的我只是需要删除aiffort.cfg中的引号：

sql_alchemy_conn = postgresql://user:password@host:port/db