Hello, I'm trying to setup my Postgres DB as a des...
# ask-community-for-troubleshootingi
Isaline L.
07/14/2021, 1:15 PMHello, I'm trying to setup my Postgres DB as a destination with Airbyte running locally. It works fine when I use a super user, but doesn't work with my dedicated Airbyte user. I can connect without an issue when accessing the DB directly with that user, but Airbyte gets a "Could not connect with provided configuration. ERROR: permission denied for database <database>".
Any idea? The DB is hosted on AWS RDS, but the IP is allowed (and again, it works when using a super user, and when accessing it via other tools).
Thanks in advance!
✅ 1
u
[DEPRECATED] Marcos Marx
07/14/2021, 1:19 PM
It works fine when I use a super user, but doesn't work with my dedicated Airbyte user.this works fine when connecting using Airbyte but with the super user?
i
Isaline L.
07/14/2021, 1:23 PMYep, if I use the super user in my Airbyte config it works.
Isaline L.
07/14/2021, 1:23 PMSo it seems than it's not a problem with the database itself.
u
[DEPRECATED] Marcos Marx
07/14/2021, 1:24 PM
Can you confirm you gave the right permissions to
airbyte[DEPRECATED] Marcos Marx
07/14/2021, 1:24 PM
i
Isaline L.
07/14/2021, 1:41 PMI confirm indeed.
Isaline L.
07/14/2021, 1:49 PMIt would give me a different error though, since I can access the DB with the airbyte user? 🤔
u
[DEPRECATED] Marcos Marx
07/14/2021, 1:55 PM
Probably, if you dont have access to your database the error should be: Could access database IP-POSTGRES-RDS. not permission denied
[DEPRECATED] Marcos Marx
07/14/2021, 1:55 PM
did you commit the grant schema for the airbyte user? (not pro on Postgres syntax if this is needed)
i
Isaline L.
07/14/2021, 2:14 PMI don't think that's necessary indeed, I can see that they are set the correct way in DB.. I'm probably doing something so stupid I can't see it. 😅
I'll try again later with a clearer mind, thanks for you help in any case. 🙂
Isaline L.
07/14/2021, 2:23 PMWell actually, found the culprit!
airbyte rocket 1
Isaline L.
07/14/2021, 2:25 PMThe user needs to be able to create schema as well, I checked my logs, the connection succeeded, but then it was trying to create the schema (if not exists), and that's what was going wrong.
Isaline L.
07/14/2021, 2:26 PMI don't know how easy that would be, but it would be pretty useful to add the details from the error.
Isaline L.
07/14/2021, 2:27 PMThe actual error was
Copy code
ERROR: permission denied for database <schema>
STATEMENT: CREATE SCHEMA IF NOT EXISTS <schema>Isaline L.
07/14/2021, 2:27 PM(Note that I could have thought earlier about checking the logs too. 😅 )