We are having some difficulties getting Airbyte to...
# feedback-and-requests
n
We are having some difficulties getting Airbyte to connect to an AWS RDS Postgres database as its configuration database. Any thoughts on where to go to try and sort out what we don't have configured correctly?
Copy code
2021-08-12 18:04:49 INFO i.a.s.ServerApp(getServer):171 - {workspace_app_root=/workspace/server/logs} - Creating config repository...
2021-08-12 18:04:50 INFO i.a.c.p.ConfigPersistenceBuilder(getDbPersistenceWithFileSeed):93 - {workspace_app_root=/workspace/server/logs} - Creating db-based config persistence, and loading seed and existing data from files
2021-08-12 18:04:50 INFO i.a.c.p.FileSystemConfigPersistence(createWithValidation):62 - {workspace_app_root=/workspace/server/logs} - Constructing file system config persistence (root: /configs)
2021-08-12 18:04:50 INFO i.a.c.p.FileSystemConfigPersistence(createWithValidation):71 - {workspace_app_root=/workspace/server/logs} - Config volume is ready (waiting time: 0 s)
2021-08-12 18:04:50 INFO i.a.c.p.ConfigPersistenceBuilder(getDbPersistence):103 - {workspace_app_root=/workspace/server/logs} - Use database config persistence.
2021-08-12 18:04:50 INFO i.a.c.EnvConfigs(getEnvOrDefault):302 - {workspace_app_root=/workspace/server/logs} - CONFIG_DATABASE_USER not found or empty, defaulting to xxxxxxxx
2021-08-12 18:04:50 INFO i.a.c.EnvConfigs(getEnvOrDefault):302 - {workspace_app_root=/workspace/server/logs} - CONFIG_DATABASE_PASSWORD not found or empty, defaulting to xxxxxxxx
2021-08-12 18:04:50 INFO i.a.c.EnvConfigs(getEnvOrDefault):302 - {workspace_app_root=/workspace/server/logs} - CONFIG_DATABASE_URL not found or empty, defaulting to jdbc:<postgresql://xxxxx.xxxxxx.us-east-1.rds.amazonaws.com:5432/airbyte>
2021-08-12 18:04:50 WARN i.a.d.Databases(createPostgresDatabaseWithRetry):55 - {workspace_app_root=/workspace/server/logs} - Waiting for database to become available...
2021-08-12 18:04:50 INFO i.a.d.i.BaseDatabaseInstance(lambda$isDatabaseConnected$3):128 - {workspace_app_root=/workspace/server/logs} - Testing airbyte configs database connection...
2021-08-12 18:04:54 INFO i.a.d.Databases(createPostgresDatabaseWithRetry):60 - {workspace_app_root=/workspace/server/logs} - Database is not ready yet. Please wait a moment, it might still be initializing...
These bits seem relevant.
2021-08-12 180450 INFO i.a.c.EnvConfigs(getEnvOrDefault):302 - {workspace_app_root=/workspace/server/logs} - CONFIG_DATABASE_USER not found or empty, defaulting to xxxxxxxx
2021-08-12 180450 INFO i.a.c.EnvConfigs(getEnvOrDefault):302 - {workspace_app_root=/workspace/server/logs} - CONFIG_DATABASE_PASSWORD not found or empty, defaulting to xxxxxxxx
2021-08-12 180450 INFO i.a.c.EnvConfigs(getEnvOrDefault):302 - {workspace_app_root=/workspace/server/logs} - CONFIG_DATABASE_URL not found or empty, defaulting to jdbc:postgresql://xxxxx.xxxxxx.us-east-1.rds.amazonaws.com:5432/airbyte
u
It is not picking up the configuration for user, password, and database endpoint. So it’s using literal x’s. How did you configure this connection? Was it through the UI or through a custom approach?
u
I should have specified that the xxxxx's were just there to replace the sensitive data. It actually has the user, password and host in the log.
u
ahh.
u
Have you validated that the database user can correctly connect to the same database and schema using a sql client? That would ensure it has all the correct permissions and a network route to the database.