Error when providing DATABASE_URL

[henninfi]

Hi

First off i want to thank all of you guys contributing to this project. A big shout-out to all of you.

Now, this is my first time asking for something in a repo, so please feel free to correct me if im doing this wrong.

I've used the quick-start docker-image exactly like it is from the guide (https://docs.fief.dev/self-hosting/quickstart/). At first run it runs perfectly. The docker container runs, i can access it, log in and everything seems to be working. But, as i do not want to run it as a sqlite db i've added the following to the docker run command:

-e "DATABASE_TYPE=POSTGRESQL"
-e "DATABASE_URL=postgresql://user:pw@host:port/db"

After this i cant access the localhost, as the browser shows this error:

"This page isn’t working right nowlocalhost didn’t send any data."

There do seem to be some kind of interaction to the DB because the docker run makes a new Schemas in the db by the name of a random UUID.

The same database works with the online FIEF-beta-solution, so the db-user should have suffecient permissions.

[fief-bailiff[bot]]

Hail, @henninfi 👋 Welcome to Fief's kingdom!

Our team will get back to you very soon to help.

In the meantime, take a minute to star our repository ⭐️

Farewell!

[frankie567]

Fief server probably shows an error in its logs that may help us find out what's wrong. If you run the following command:

docker logs -f fief-server

You'll see the log output. Try to access your server again and see what happens. If an error stack trace appears, share it with us.

[henninfi]

Thanks. I did that now. Dont know how much of it to copy/paste, but from the last line in my paste it seems i cant run it with sslmode=require. Is there a way to do this?

2023-11-30 20:35:45 2023-11-30 19:35:45,536 CRIT Supervisor is running as root. Privileges were not dropped because no user is specified in the config file. If you intend to run as root, you can set user=root in the config file to avoid this message.
2023-11-30 20:35:45 2023-11-30 19:35:45,538 INFO supervisord started with pid 1
2023-11-30 20:35:46 2023-11-30 19:35:46,543 INFO spawned: 'fief-server' with pid 7
2023-11-30 20:35:46 2023-11-30 19:35:46,546 INFO spawned: 'fief-worker' with pid 8
2023-11-30 20:35:46 2023-11-30 19:35:46,551 INFO spawned: 'redis' with pid 9
2023-11-30 20:35:47 2023-11-30 19:35:47,569 INFO success: fief-server entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-11-30 20:35:47 2023-11-30 19:35:47,569 INFO success: fief-worker entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-11-30 20:35:47 2023-11-30 19:35:47,569 INFO success: redis entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-11-30 20:35:48 /usr/local/lib/python3.11/site-packages/pydantic_settings/sources.py:297: UserWarning: directory "/run/secrets" does not exist
2023-11-30 20:35:48 warnings.warn(f'directory "{self.secrets_path}" does not exist')
2023-11-30 20:35:50 [2023-11-30 19:35:50,133] [PID 8] [MainThread] [dramatiq.MainProcess] [INFO] Dramatiq '1.14.2' is booting up.
2023-11-30 20:35:50 /usr/local/lib/python3.11/site-packages/pydantic_settings/sources.py:297: UserWarning: directory "/run/secrets" does not exist
2023-11-30 20:35:50 warnings.warn(f'directory "{self.secrets_path}" does not exist')
2023-11-30 20:35:50 2023-11-30 19:35:50.094 | INFO | fief.worker::19 - Fief Worker started - {"version": "0.27.0"}
2023-11-30 20:35:50 2023-11-30 19:35:50.126 | INFO | dramatiq.cli:worker_process:412 - Worker process is ready for action. - {}
2023-11-30 20:35:50 [2023-11-30 19:35:50,134] [PID 20] [MainThread] [dramatiq.ForkProcess(1)] [INFO] Fork process 'dramatiq.middleware.prometheus:_run_exposition_server' is ready for action.
2023-11-30 20:35:50 /usr/local/lib/python3.11/site-packages/pydantic_settings/sources.py:297: UserWarning: directory "/run/secrets" does not exist
2023-11-30 20:35:50 warnings.warn(f'directory "{self.secrets_path}" does not exist')
2023-11-30 20:35:51 INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
2023-11-30 20:35:51 INFO [alembic.runtime.migration] Will assume transactional DDL.
2023-11-30 20:35:52 [2023-11-30 19:35:52,248] [PID 19] [MainThread] [dramatiq.ForkProcess(0)] [INFO] Fork process 'fief.scheduler:schedule' is ready for action.
2023-11-30 20:35:52 [2023-11-30 19:35:52,250] [PID 19] [MainThread] [apscheduler.scheduler] [INFO] Adding job tentatively -- it will be properly scheduled when the scheduler starts
2023-11-30 20:35:52 [2023-11-30 19:35:52,251] [PID 19] [MainThread] [apscheduler.scheduler] [INFO] Adding job tentatively -- it will be properly scheduled when the scheduler starts
2023-11-30 20:35:52 [2023-11-30 19:35:52,251] [PID 19] [MainThread] [apscheduler.scheduler] [INFO] Added job "Actor.send" to job store "default"
2023-11-30 20:35:52 [2023-11-30 19:35:52,252] [PID 19] [MainThread] [apscheduler.scheduler] [INFO] Added job "Actor.send" to job store "default"
2023-11-30 20:35:52 [2023-11-30 19:35:52,252] [PID 19] [MainThread] [apscheduler.scheduler] [INFO] Scheduler started
2023-11-30 20:35:52 INFO [alembic.runtime.migration] Running upgrade -> 274bc650f9a2, Initial migration
2023-11-30 20:35:55 INFO [alembic.runtime.migration] Running upgrade 274bc650f9a2 -> 696e383aabf2, Add alembic_revision column to Workspace
2023-11-30 20:35:55 INFO [alembic.runtime.migration] Running upgrade 696e383aabf2 -> 4c2bb65882d7, Add database_ssl_mode to Workspace
2023-11-30 20:35:56 INFO [alembic.runtime.migration] Running upgrade 4c2bb65882d7 -> 3b349d4ffa69, Add users_count column to Workspace
2023-11-30 20:35:56 INFO [alembic.runtime.migration] Running upgrade 3b349d4ffa69 -> 1f410bdb7d63, Add database_use_schema to Workspace
2023-11-30 20:35:57 INFO [alembic.runtime.migration] Running upgrade 1f410bdb7d63 -> c8cf076d3ffa, Add database_table_prefix to Workspace
2023-11-30 20:36:17 ╭───────────────────── Traceback (most recent call last) ──────────────────────╮
2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:145 in │
2023-11-30 20:36:17 │ init │
2023-11-30 20:36:17 │ │
2023-11-30 20:36:17 │ 142 │ │ │
2023-11-30 20:36:17 │ 143 │ │ if connection is None: │
2023-11-30 20:36:17 │ 144 │ │ │ try: │
2023-11-30 20:36:17 │ ❱ 145 │ │ │ │ self._dbapi_connection = engine.raw_connection() │
2023-11-30 20:36:17 │ 146 │ │ │ except dialect.loaded_dbapi.Error as err: │
2023-11-30 20:36:17 │ 147 │ │ │ │ Connection._handle_dbapi_exception_noconnection( │
2023-11-30 20:36:17 │ 148 │ │ │ │ │ err, dialect, engine │
2023-11-30 20:36:17 │ │
2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
2023-11-30 20:36:17 │ │ _allow_autobegin = True │ │
2023-11-30 20:36:17 │ │ _allow_revalidate = True │ │
2023-11-30 20:36:17 │ │ has_events = None │ │
2023-11-30 20:36:17 │ │ connection = None │ │
2023-11-30 20:36:17 │ │ dialect = <sqlalchemy.dialects.postgresql.psycopg2.PGDialect… │ │
2023-11-30 20:36:17 │ │ object at 0x7f14170f6c10> │ │
2023-11-30 20:36:17 │ │ engine = Engine(postgresql://default:@ep-tight-bonus-2096… │ │
2023-11-30 20:36:17 │ │ self = <sqlalchemy.engine.base.Connection object at │ │
2023-11-30 20:36:17 │ │ 0x7f141710aa90> │ │
2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │
2023-11-30 20:36:17 │ │
2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:3288 in │
2023-11-30 20:36:17 │ raw_connection │
2023-11-30 20:36:17 │ │
2023-11-30 20:36:17 │ 3285 │ │ │ :ref:dbapi_connections │
2023-11-30 20:36:17 │ 3286 │ │ │
2023-11-30 20:36:17 │ 3287 │ │ """ │
2023-11-30 20:36:17 │ ❱ 3288 │ │ return self.pool.connect() │
2023-11-30 20:36:17 │ 3289 │
2023-11-30 20:36:17 │ 3290 │
2023-11-30 20:36:17 │ 3291 class OptionEngineMixin(log.Identified): │
2023-11-30 20:36:17 │ │
2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │
2023-11-30 20:36:17 │ │ self = Engine(postgresql://default:@ep-tight-bonus-209614-pooler.us-… │ │
2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │
2023-11-30 20:36:17 │ │
2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py:452 in │
2023-11-30 20:36:17 │ connect │
2023-11-30 20:36:17 │ │
2023-11-30 20:36:17 │ 449 │ │ the pool. │
2023-11-30 20:36:17 │ 450 │ │ │
2023-11-30 20:36:17 │ 451 │ │ """ │
2023-11-30 20:36:17 │ ❱ 452 │ │ return _ConnectionFairy._checkout(self) │
2023-11-30 20:36:17 │ 453 │ │
2023-11-30 20:36:17 │ 454 │ def _return_conn(self, record: ConnectionPoolEntry) -> None: │
2023-11-30 20:36:17 │ 455 │ │ """Given a _ConnectionRecord, return it to the :class:_pool. │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────── locals ─────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py:1267 in │ 2023-11-30 20:36:17 │ _checkout │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 1264 │ │ fairy: Optional[_ConnectionFairy] = None, │ 2023-11-30 20:36:17 │ 1265 │ ) -> _ConnectionFairy: │ 2023-11-30 20:36:17 │ 1266 │ │ if not fairy: │ 2023-11-30 20:36:17 │ ❱ 1267 │ │ │ fairy = _ConnectionRecord.checkout(pool) │ 2023-11-30 20:36:17 │ 1268 │ │ │ │ 2023-11-30 20:36:17 │ 1269 │ │ │ if threadconns is not None: │ 2023-11-30 20:36:17 │ 1270 │ │ │ │ threadconns.current = weakref.ref(fairy) │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭──────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ cls = <class 'sqlalchemy.pool.base._ConnectionFairy'> │ │ 2023-11-30 20:36:17 │ │ fairy = None │ │ 2023-11-30 20:36:17 │ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ │ threadconns = None │ │ 2023-11-30 20:36:17 │ ╰─────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py:716 in │ 2023-11-30 20:36:17 │ checkout │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 713 │ │ if TYPE_CHECKING: │ 2023-11-30 20:36:17 │ 714 │ │ │ rec = cast(_ConnectionRecord, pool._do_get()) │ 2023-11-30 20:36:17 │ 715 │ │ else: │ 2023-11-30 20:36:17 │ ❱ 716 │ │ │ rec = pool._do_get() │ 2023-11-30 20:36:17 │ 717 │ │ │ 2023-11-30 20:36:17 │ 718 │ │ try: │ 2023-11-30 20:36:17 │ 719 │ │ │ dbapi_connection = rec.get_connection() │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────── locals ─────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ cls = <class 'sqlalchemy.pool.base._ConnectionRecord'> │ │ 2023-11-30 20:36:17 │ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/impl.py:169 in │ 2023-11-30 20:36:17 │ _do_get │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 166 │ │ │ try: │ 2023-11-30 20:36:17 │ 167 │ │ │ │ return self._create_connection() │ 2023-11-30 20:36:17 │ 168 │ │ │ except: │ 2023-11-30 20:36:17 │ ❱ 169 │ │ │ │ with util.safe_reraise(): │ 2023-11-30 20:36:17 │ 170 │ │ │ │ │ self._dec_overflow() │ 2023-11-30 20:36:17 │ 171 │ │ │ │ raise │ 2023-11-30 20:36:17 │ 172 │ │ else: │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ │ use_overflow = True │ │ 2023-11-30 20:36:17 │ │ wait = False │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:147 │ 2023-11-30 20:36:17 │ in __exit__ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 144 │ │ │ exc_type, exc_value, exc_tb = self._exc_info │ 2023-11-30 20:36:17 │ 145 │ │ │ assert exc_value is not None │ 2023-11-30 20:36:17 │ 146 │ │ │ self._exc_info = None # remove potential circular refere │ 2023-11-30 20:36:17 │ ❱ 147 │ │ │ raise exc_value.with_traceback(exc_tb) │ 2023-11-30 20:36:17 │ 148 │ │ else: │ 2023-11-30 20:36:17 │ 149 │ │ │ self._exc_info = None # remove potential circular refere │ 2023-11-30 20:36:17 │ 150 │ │ │ assert value is not None │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ exc_tb = <traceback object at 0x7f141710af00> │ │ 2023-11-30 20:36:17 │ │ exc_type = <class 'psycopg2.OperationalError'> │ │ 2023-11-30 20:36:17 │ │ exc_value = OperationalError('connection to server at │ │ 2023-11-30 20:36:17 │ │ "ep-tight-bonus-209614-pooler.us-east-1.postgres.vercel-sto… │ │ 2023-11-30 20:36:17 │ │ (52.20.107.131), port 5432 failed: ERROR: unsupported │ │ 2023-11-30 20:36:17 │ │ startup parameter: options\nconnection to server at │ │ 2023-11-30 20:36:17 │ │ "ep-tight-bonus-209614-pooler.us-east-1.postgres.vercel-sto… │ │ 2023-11-30 20:36:17 │ │ (52.20.107.131), port 5432 failed: ERROR: connection is │ │ 2023-11-30 20:36:17 │ │ insecure (try using sslmode=require)\n') │ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.util.langhelpers.safe_reraise object at │ │ 2023-11-30 20:36:17 │ │ 0x7f14170e8f40> │ │ 2023-11-30 20:36:17 │ │ traceback = None │ │ 2023-11-30 20:36:17 │ │ type_ = None │ │ 2023-11-30 20:36:17 │ │ value = None │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/impl.py:167 in │ 2023-11-30 20:36:17 │ _do_get │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 164 │ │ │ 2023-11-30 20:36:17 │ 165 │ │ if self._inc_overflow(): │ 2023-11-30 20:36:17 │ 166 │ │ │ try: │ 2023-11-30 20:36:17 │ ❱ 167 │ │ │ │ return self._create_connection() │ 2023-11-30 20:36:17 │ 168 │ │ │ except: │ 2023-11-30 20:36:17 │ 169 │ │ │ │ with util.safe_reraise(): │ 2023-11-30 20:36:17 │ 170 │ │ │ │ │ self._dec_overflow() │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ │ use_overflow = True │ │ 2023-11-30 20:36:17 │ │ wait = False │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py:393 in │ 2023-11-30 20:36:17 │ _create_connection │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 390 │ def _create_connection(self) -> ConnectionPoolEntry: │ 2023-11-30 20:36:17 │ 391 │ │ """Called by subclasses to create a new ConnectionRecord.""" │ 2023-11-30 20:36:17 │ 392 │ │ │ 2023-11-30 20:36:17 │ ❱ 393 │ │ return _ConnectionRecord(self) │ 2023-11-30 20:36:17 │ 394 │ │ 2023-11-30 20:36:17 │ 395 │ def _invalidate( │ 2023-11-30 20:36:17 │ 396 │ │ self, │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────── locals ─────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py:678 in │ 2023-11-30 20:36:17 │ __init__ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 675 │ │ │ 2023-11-30 20:36:17 │ 676 │ │ self.__pool = pool │ 2023-11-30 20:36:17 │ 677 │ │ if connect: │ 2023-11-30 20:36:17 │ ❱ 678 │ │ │ self.__connect() │ 2023-11-30 20:36:17 │ 679 │ │ self.finalize_callback = deque() │ 2023-11-30 20:36:17 │ 680 │ │ 2023-11-30 20:36:17 │ 681 │ dbapi_connection: Optional[DBAPIConnection] │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ connect = True │ │ 2023-11-30 20:36:17 │ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.pool.base._ConnectionRecord object at │ │ 2023-11-30 20:36:17 │ │ 0x7f1417592350> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py:902 in │ 2023-11-30 20:36:17 │ __connect │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 899 │ │ │ pool.logger.debug("Created new connection %r", connection │ 2023-11-30 20:36:17 │ 900 │ │ │ self.fresh = True │ 2023-11-30 20:36:17 │ 901 │ │ except BaseException as e: │ 2023-11-30 20:36:17 │ ❱ 902 │ │ │ with util.safe_reraise(): │ 2023-11-30 20:36:17 │ 903 │ │ │ │ pool.logger.debug("Error on connect(): %s", e) │ 2023-11-30 20:36:17 │ 904 │ │ else: │ 2023-11-30 20:36:17 │ 905 │ │ │ # in SQLAlchemy 1.4 the first_connect event is not used b │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f1417592350> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:147 │ 2023-11-30 20:36:17 │ in __exit__ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 144 │ │ │ exc_type, exc_value, exc_tb = self._exc_info │ 2023-11-30 20:36:17 │ 145 │ │ │ assert exc_value is not None │ 2023-11-30 20:36:17 │ 146 │ │ │ self._exc_info = None # remove potential circular refere │ 2023-11-30 20:36:17 │ ❱ 147 │ │ │ raise exc_value.with_traceback(exc_tb) │ 2023-11-30 20:36:17 │ 148 │ │ else: │ 2023-11-30 20:36:17 │ 149 │ │ │ self._exc_info = None # remove potential circular refere │ 2023-11-30 20:36:17 │ 150 │ │ │ assert value is not None │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ exc_tb = <traceback object at 0x7f141710aac0> │ │ 2023-11-30 20:36:17 │ │ exc_type = <class 'psycopg2.OperationalError'> │ │ 2023-11-30 20:36:17 │ │ exc_value = OperationalError('connection to server at │ │ 2023-11-30 20:36:17 │ │ "ep-tight-bonus-209614-pooler.us-east-1.postgres.vercel-sto… │ │ 2023-11-30 20:36:17 │ │ (52.20.107.131), port 5432 failed: ERROR: unsupported │ │ 2023-11-30 20:36:17 │ │ startup parameter: options\nconnection to server at │ │ 2023-11-30 20:36:17 │ │ "ep-tight-bonus-209614-pooler.us-east-1.postgres.vercel-sto… │ │ 2023-11-30 20:36:17 │ │ (52.20.107.131), port 5432 failed: ERROR: connection is │ │ 2023-11-30 20:36:17 │ │ insecure (try using sslmode=require)\n') │ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.util.langhelpers.safe_reraise object at │ │ 2023-11-30 20:36:17 │ │ 0x7f14170e9030> │ │ 2023-11-30 20:36:17 │ │ traceback = None │ │ 2023-11-30 20:36:17 │ │ type_ = None │ │ 2023-11-30 20:36:17 │ │ value = None │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/pool/base.py:898 in │ 2023-11-30 20:36:17 │ __connect │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 895 │ │ self.dbapi_connection = None │ 2023-11-30 20:36:17 │ 896 │ │ try: │ 2023-11-30 20:36:17 │ 897 │ │ │ self.starttime = time.time() │ 2023-11-30 20:36:17 │ ❱ 898 │ │ │ self.dbapi_connection = connection = pool._invoke_creator │ 2023-11-30 20:36:17 │ 899 │ │ │ pool.logger.debug("Created new connection %r", connection │ 2023-11-30 20:36:17 │ 900 │ │ │ self.fresh = True │ 2023-11-30 20:36:17 │ 901 │ │ except BaseException as e: │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ pool = <sqlalchemy.pool.impl.QueuePool object at 0x7f141710a290> │ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.pool.base._ConnectionRecord object at 0x7f1417592350> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/create.py:637 in │ 2023-11-30 20:36:17 │ connect │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 634 │ │ │ │ │ if connection is not None: │ 2023-11-30 20:36:17 │ 635 │ │ │ │ │ │ return connection │ 2023-11-30 20:36:17 │ 636 │ │ │ │ 2023-11-30 20:36:17 │ ❱ 637 │ │ │ return dialect.connect(*cargs, **cparams) │ 2023-11-30 20:36:17 │ 638 │ │ │ 2023-11-30 20:36:17 │ 639 │ │ creator = pop_kwarg("creator", connect) │ 2023-11-30 20:36:17 │ 640 │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ cargs = [] │ │ 2023-11-30 20:36:17 │ │ connection_record = <sqlalchemy.pool.base._ConnectionRecord object at │ │ 2023-11-30 20:36:17 │ │ 0x7f1417592350> │ │ 2023-11-30 20:36:17 │ │ cparams = { │ │ 2023-11-30 20:36:17 │ │ │ 'host': │ │ 2023-11-30 20:36:17 │ │ 'ep-tight-bonus-209614-pooler.us-east-1.postgres.ve… │ │ 2023-11-30 20:36:17 │ │ │ 'dbname': 'rankit_test_1', │ │ 2023-11-30 20:36:17 │ │ │ 'user': 'default', │ │ 2023-11-30 20:36:17 │ │ │ 'password': '', │ │ 2023-11-30 20:36:17 │ │ │ 'port': 5432, │ │ 2023-11-30 20:36:17 │ │ │ 'options': │ │ 2023-11-30 20:36:17 │ │ '-csearch_path=ecff1577-67f5-4caf-9bb0-99560bb6e2f8' │ │ 2023-11-30 20:36:17 │ │ } │ │ 2023-11-30 20:36:17 │ │ dialect = <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_… │ │ 2023-11-30 20:36:17 │ │ object at 0x7f14170f6c10> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py:615 in │ 2023-11-30 20:36:17 │ connect │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 612 │ │ 2023-11-30 20:36:17 │ 613 │ def connect(self, *cargs, **cparams): │ 2023-11-30 20:36:17 │ 614 │ │ # inherits the docstring from interfaces.Dialect.connect │ 2023-11-30 20:36:17 │ ❱ 615 │ │ return self.loaded_dbapi.connect(*cargs, **cparams) │ 2023-11-30 20:36:17 │ 616 │ │ 2023-11-30 20:36:17 │ 617 │ def create_connect_args(self, url): │ 2023-11-30 20:36:17 │ 618 │ │ # inherits the docstring from interfaces.Dialect.create_conne │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ cargs = () │ │ 2023-11-30 20:36:17 │ │ cparams = { │ │ 2023-11-30 20:36:17 │ │ │ 'host': │ │ 2023-11-30 20:36:17 │ │ 'ep-tight-bonus-209614-pooler.us-east-1.postgres.vercel-stora… │ │ 2023-11-30 20:36:17 │ │ │ 'dbname': 'rankit_test_1', │ │ 2023-11-30 20:36:17 │ │ │ 'user': 'default', │ │ 2023-11-30 20:36:17 │ │ │ 'password': '', │ │ 2023-11-30 20:36:17 │ │ │ 'port': 5432, │ │ 2023-11-30 20:36:17 │ │ │ 'options': │ │ 2023-11-30 20:36:17 │ │ '-csearch_path=ecff1577-67f5-4caf-9bb0-99560bb6e2f8' │ │ 2023-11-30 20:36:17 │ │ } │ │ 2023-11-30 20:36:17 │ │ self = <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 │ │ 2023-11-30 20:36:17 │ │ object at 0x7f14170f6c10> │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ /usr/local/lib/python3.11/site-packages/psycopg2/__init__.py:122 in connect │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ 119 │ │ kwasync['async_'] = kwargs.pop('async_') │ 2023-11-30 20:36:17 │ 120 │ │ 2023-11-30 20:36:17 │ 121 │ dsn = _ext.make_dsn(dsn, **kwargs) │ 2023-11-30 20:36:17 │ ❱ 122 │ conn = _connect(dsn, connection_factory=connection_factory, **kwas │ 2023-11-30 20:36:17 │ 123 │ if cursor_factory is not None: │ 2023-11-30 20:36:17 │ 124 │ │ conn.cursor_factory = cursor_factory │ 2023-11-30 20:36:17 │ 125 │ 2023-11-30 20:36:17 │ │ 2023-11-30 20:36:17 │ ╭───────────────────────────────── locals ─────────────────────────────────╮ │ 2023-11-30 20:36:17 │ │ connection_factory = None │ │ 2023-11-30 20:36:17 │ │ cursor_factory = None │ │ 2023-11-30 20:36:17 │ │ dsn = 'host=ep-tight-bonus-209614-pooler.us-east-1.postg… │ │ 2023-11-30 20:36:17 │ │ dbname=r'+116 │ │ 2023-11-30 20:36:17 │ │ kwargs = { │ │ 2023-11-30 20:36:17 │ │ │ 'host': │ │ 2023-11-30 20:36:17 │ │ 'ep-tight-bonus-209614-pooler.us-east-1.postgres.v… │ │ 2023-11-30 20:36:17 │ │ │ 'dbname': 'rankit_test_1', │ │ 2023-11-30 20:36:17 │ │ │ 'user': 'default', │ │ 2023-11-30 20:36:17 │ │ │ 'password': '', │ │ 2023-11-30 20:36:17 │ │ │ 'port': 5432, │ │ 2023-11-30 20:36:17 │ │ │ 'options': │ │ 2023-11-30 20:36:17 │ │ '-csearch_path=ecff1577-67f5-4caf-9bb0-99560bb6e2f… │ │ 2023-11-30 20:36:17 │ │ } │ │ 2023-11-30 20:36:17 │ │ kwasync = {} │ │ 2023-11-30 20:36:17 │ ╰──────────────────────────────────────────────────────────────────────────╯ │ 2023-11-30 20:36:17 ╰──────────────────────────────────────────────────────────────────────────────╯ 2023-11-30 20:36:17 OperationalError: connection to server at 2023-11-30 20:36:17 "ep-tight-bonus-209614-pooler.us-east-1.postgres.vercel-storage.com" 2023-11-30 20:36:17 (52.20.107.131), port 5432 failed: ERROR: unsupported startup parameter: 2023-11-30 20:36:17 options 2023-11-30 20:36:17 connection to server at 2023-11-30 20:36:17 "ep-tight-bonus-209614-pooler.us-east-1.postgres.vercel-storage.com" 2023-11-30 20:36:17 (52.20.107.131), port 5432 failed: ERROR: connection is insecure (try using 2023-11-30 20:36:17 sslmode=require`)

[frankie567]

Thanks! You may have set the DATABASE_SSL_MODE environment variable. Try to set it like this:

DATABASE_SSL_MODE=disable

[henninfi]

I ended up creating a new postresql db. This seems to have byen the issue. I got the issue with a free db hosted by render. Swapped to free db from aiven, and things worked.

Thanks for the tip anyway!