Allow PostgreSQL instances without TLS auth. #3148
ediskandarov
started this conversation in
General
Replies: 1 comment 5 replies
-
|
I think the problem is the opposite: the remote PostgreSQL host requires SSL. Try putting |
Beta Was this translation helpful? Give feedback.
5 replies
-
|
shall I file an issue? |
Beta Was this translation helpful? Give feedback.
-
|
Still getting an error after putting $ bash run.sh
+ docker run --rm -ti -p 10700:10700 -e EDGEDB_SERVER_GENERATE_SELF_SIGNED_CERT=1 -e EDGEDB_SERVER_PASSWORD=5940b661-749f-4472-ad65-a612df25e3e5 -e 'EDGEDB_SERVER_POSTGRES_DSN=postgres://edgedb_xcsm_user:[email protected]/edgedb_xcsm?sslmode=require' edgedb/edgedb:1-rc1
Bootstrapping EdgeDB instance on remote Postgres cluster...
WARNING 22 2021-11-07T07:55:37.967 py.warnings: /usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/args.py:507: DeprecationWarning: The `--postgres-dsn` option is deprecated, use `--backend-dsn` instead.
warnings.warn(
INFO 22 2021-11-07T07:55:38.252 edb.server: EdgeDB server (version: 1.0-rc.1+d2021093022.g1d9e3d8c7.cv202109220000) is starting.
INFO 22 2021-11-07T07:55:41.151 edb.server: Detected 97 backend connections available.
INFO 22 2021-11-07T07:55:42.156 edb.server: Creating template database...
================================= Exception occurred: connection was closed in the middle of operation =================================
1. asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation
-------------------------------------------------------------- Traceback ---------------------------------------------------------------
/usr/bin/edgedb-server, line 8, in <module>
> sys.exit(main())
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 829, in __call__
> return self.main(*args, **kwargs)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 782, in main
> rv = self.invoke(ctx)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 1066, in invoke
> return ctx.invoke(self.callback, **ctx.params)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 610, in invoke
> return callback(*args, **kwargs)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 552, in main
> server_main(**kwargs)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 541, in server_main
> asyncio.run(run_server(server_args))
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/asyncio/runners.py, line 44, in run
> return loop.run_until_complete(main)
uvloop/loop.pyx, line 1501, in uvloop.loop.Loop.run_until_complete
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 444, in run_server
> need_cluster_restart = await _init_cluster(cluster, args)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 141, in _init_cluster
> need_restart = await bootstrap.ensure_bootstrapped(cluster, args)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/bootstrap.py, line 1393, in ensure_bootstrapped
> await _bootstrap(ctx)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/bootstrap.py, line 1301, in _bootstrap
> conn = await cluster.connect(database=tpl_db)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/pgcluster.py, line 184, in connect
> conn = await asyncpg.connect(**conn_info)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/asyncpg/connection.py, line 2045, in connect
> return await connect_utils._connect(
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/asyncpg/connect_utils.py, line 776, in _connect
> return await _connect_addr(
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/asyncpg/connect_utils.py, line 671, in _connect_addr
> return await __connect_addr(params, timeout, False, *args)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/asyncpg/connect_utils.py, line 726, in __connect_addr
> await compat.wait_for(connected, timeout=timeout)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/asyncpg/compat.py, line 66, in wait_for
> return await asyncio.wait_for(fut, timeout)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/asyncio/tasks.py, line 447, in wait_for
> return fut.result()
asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation
ERROR: Could not bootstrap EdgeDB server instance. |
Beta Was this translation helpful? Give feedback.
-
|
after the second run edgedb says database is corrupted INFO 23 2021-11-07T07:58:19.764 edb.server: EdgeDB server (version: 1.0-rc.1+d2021093022.g1d9e3d8c7.cv202109220000) is starting.
INFO 23 2021-11-07T07:58:22.527 edb.server: Detected 97 backend connections available.
=========================================== Exception occurred: database instance is corrupt ===========================================
1. edb.errors.ConfigurationError: database instance is corrupt
-------------------------------------------------------------- Traceback ---------------------------------------------------------------
/usr/bin/edgedb-server, line 8, in <module>
> sys.exit(main())
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 829, in __call__
> return self.main(*args, **kwargs)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 782, in main
> rv = self.invoke(ctx)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 1066, in invoke
> return ctx.invoke(self.callback, **ctx.params)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/click/core.py, line 610, in invoke
> return callback(*args, **kwargs)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 552, in main
> server_main(**kwargs)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 541, in server_main
> asyncio.run(run_server(server_args))
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/asyncio/runners.py, line 44, in run
> return loop.run_until_complete(main)
uvloop/loop.pyx, line 1501, in uvloop.loop.Loop.run_until_complete
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 444, in run_server
> need_cluster_restart = await _init_cluster(cluster, args)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/main.py, line 141, in _init_cluster
> need_restart = await bootstrap.ensure_bootstrapped(cluster, args)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/bootstrap.py, line 1396, in ensure_bootstrapped
> await _start(ctx)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/bootstrap.py, line 1252, in _start
> conn = await _check_catalog_compatibility(ctx)
/usr/lib/x86_64-linux-gnu/edgedb-server-1-rc1/lib/python3.10/site-packages/edb/server/bootstrap.py, line 1186, in _check_catalog_compatibility
> raise errors.ConfigurationError(
--------------------------------------------------------------- Details ----------------------------------------------------------------
Details: The database instance does not appear to have been fully initialized or has been corrupted.
edb.errors.ConfigurationError: database instance is corrupt
ERROR: Could not bootstrap EdgeDB server instance. |
Beta Was this translation helpful? Give feedback.
-
|
This particular failure mode is a bug. |
Beta Was this translation helpful? Give feedback.
-
|
Opened #3149 |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi there, I'm trying to deploy EdgeDB on https://render.com with PostgreSQL SaaS as a remote DB for EdgeDB.
Would be good to have an option to allow plain text connections to remote backends.
EdgeDB could not initialise even with
EDGEDB_SERVER_INSECURE_DEV_MODE=1.(do not worry about passwords, that is a testing DB instance)
Beta Was this translation helpful? Give feedback.
All reactions