AWS re:Postを使用することにより、以下に同意したことになります AWS re:Post 利用規約

AWS Glue Connector will not connect to mongoDB Atlas

0

I get the error "InvalidInputException: Unable to resolve any valid connection" when I test my AWS Glue connection to my mongDB Atlas database.

I can connect with an identical string, user and password from a different client. Strangely, I can also run a glue job that connects with the same connection details in a python script.

質問済み 8ヶ月前337ビュー
1回答
1

Hi Laurence

follow the below solution step by step to resolve your issue.

  • Check Connection Details: Ensure that the connection details in your AWS Glue connection configuration are accurate and match the connection string used successfully from a different client. Pay close attention to any typos, extra spaces, or incorrect characters in the connection string, username, password, or other parameters.
  • Network Configuration: Verify that the network configuration of your AWS Glue environment allows outbound connections to MongoDB Atlas. This includes checking security groups, network ACLs (Access Control Lists), and any other networking settings that might be blocking or restricting outbound connections.
  • Security Settings in MongoDB Atlas: Double-check the security settings in MongoDB Atlas to ensure that the IP address or range associated with your AWS Glue environment is whitelisted and allowed to connect to the MongoDB cluster. Also, confirm that the user credentials used in the connection configuration have the necessary permissions to access the database.
  • Test Connection from AWS Glue Console: Try testing the connection directly from the AWS Glue console to see if you encounter the same error. This can help isolate whether the issue is specific to the Glue job or if it's related to the connection configuration itself.
  • Review Glue Job Configuration: If you're able to run a Glue job successfully using the same connection details in a Python script, review the configuration of the Glue job to ensure that it's consistent with the connection configuration used in the test.
エキスパート
回答済み 8ヶ月前
profile picture
エキスパート
レビュー済み 6ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ