使用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.

已提问 7 个月前323 查看次数
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.
专家
已回答 7 个月前
profile picture
专家
已审核 5 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则