- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
What version of postgress are you using? Glue seems to use a postgresql driver incompatible with Postgresql14 by default because of scram as mentioned
You can follow a thread here how to resolve this issue. One option is to downgrade to v13.x https://repost.aws/questions/QUpkrhcfkYQtS2adbjpQ7quQ/cannot-connect-from-glue-to-rds-postgres
Also, you are aware that your RDS is public and accessible over the internet along with the Glue connection connecting to the Public IP Address of your RDS Instance with your configuration as it stands.
The tester is pending a driver upgrade and it's not able to handle scram authentication, which RDS will use by default.
Although is strange that your error log doesn't give you a clear message like: "org.postgresql.util.PSQLException: The authentication type 10 is not supported."
In practice, the tester is a convenience, the jobs and crawlers use their own drivers, so I suggest you give it a try to see if the issue is just with the tester.
Tried to run crawler but its failing with below error log 2023-06-27T13:50:58.524+05:30 [28ce2a66-4766-4e1b-8176-b2e3bec8dcd3] BENCHMARK : Running Start Crawl for Crawler rds-postgres-gtn-crawler 2023-06-27T13:51:45.894+05:30 [28ce2a66-4766-4e1b-8176-b2e3bec8dcd3] ERROR : Test connection failed for connection 'gtn-rds-postgres-conn'
If it is pg 14 or above, then try https://repost.aws/questions/QUpkrhcfkYQtS2adbjpQ7quQ/cannot-connect-from-glue-to-rds-postgres#AN6LQ9xtevS0S7-aIifzLfEw
Having the same issue. Trying to get data from DynamoDB to an Aurora V2 Postgres instance. If I use the "Test Connection" feature on the added connection I get "The authentication type 10 is not supported", then if I try to run the crawler anyway I get "Test connection failed for connection ...". So it appears as though the test is running even for the crawler. It looks like Postgres 14 came out about 2 years ago. Maybe I'm missing something, but it seems strange for one of AWS' flagship products to be 2 years behind in compatibility with one of the world's most popular database engines. Does moving from scram back to md5 pose a security risk? Maybe this is why AWS isn't interested in changing it? Because changing the configuration is a valid workaround? I assumed the change to scram was about improving security, but maybe that assumption is wrong.
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 4 Jahren
Followed all the steps mentioned in above answer, but getting below error message while running the crawler: 2023-06-27T17:21:49.443+05:30 [195c208a-88d6-4c01-a46a-267163bb2845] BENCHMARK : Running Start Crawl for Crawler rds-postgres-gtn-crawler 2023-06-27T17:31:37.172+05:30 [195c208a-88d6-4c01-a46a-267163bb2845] ERROR : Internal Service Exception
Take a look at this one now https://repost.aws/knowledge-center/glue-crawler-internal-service-exception
Try this https://repost.aws/questions/QUpkrhcfkYQtS2adbjpQ7quQ/cannot-connect-from-glue-to-rds-postgres#AN6LQ9xtevS0S7-aIifzLfEw