I'm running airbyte locally, and when attempting t...
# announcements
b
I'm running airbyte locally, and when attempting to connect a PostgreSQL source, I'm given this error:
Copy code
The connection tests failed.
The received form did not pass validation
The database is publicly accessible and the host/port/username/password/database are correct.
j
Just to sanity check, that user has permissions for that database? Also, do you happen to know which Postgres version the server uses?
We’re planning on making these errors much more descriptive. For now, the best way to debug is to look at docker compose’s
airbyte-scheduler
logs. They should provide more information on why the connection check failed.
b
The user does have access. I created a
airbyte
user per the instructions in case it required the username be
airbyte
- that didn't work either.
Checking the version now, but its a relatively new RDS instance
11.6
j
If you run
docker run --rm -it postgres psql -d "<postgresql://USERNAME>:PASSWORD@HOST:PORT/DBNAME" -c "select now()"
locally, does it succeed with your credentials?
If it does succeed, can you DM me logs output by the
docker-compose up
call while you check the connection?
CRITICAL 0 tables were discovered across the entire cluster
. It looks like the Singer dependency we’re using behind the scene is failing the check if there are no tables in the source.
This is definitely not intended. I’ll create an issue for this and link it here later.
The fastest workaround to just get it working is to create a table in that database.