Pymongo connection issue in AWS Lambda

Question

How to connect AWS Lambda in python with MonboDB cluster, here is the sample code:
```
import pymongo
import json
from urllib.parse import quote_plus
username = quote_plus('user')
password = quote_plus('pwd')
cluster = 'ai-beta.60op4nu.mongodb.net'
authSource = 'database'
authMechanism = 'SCRAM-SHA-256'
uri = 'mongodb+srv://' + username + ':' + password + '@' + cluster + '/?authSource=' + authSource + '&authMechanism=' + authMechanism
print(uri)
try:
    client = pymongo.MongoClient(uri)
    result = client['truvideo']['dealers'].find()
    for x in result:
        print(x)
except Exception as e:
    print("An error occurred:", e)
```

But always i got en error like this:

```
An error occurred: ac-7itqhz7-shard-00-00.60op4nu.mongodb.net:27017: connection closed,ac-7itqhz7-shard-00-02.60op4nu.mongodb.net:27017: connection closed,ac-7itqhz7-shard-00-01.60op4nu.mongodb.net:27017: connection closed, Timeout: 30s, Topology Description: , , ]>
```

Answer

You got a timeout most probably because your Lambda function was not able to reach the database. Is your database in a VPC? If so, the Lambda should be attached to the VCP as well and the security groups should allow the connection. If your DB is on the internet, your Lambda function should have internet access, i.e., either it is not attached to a VPC, or, if attached, there should be a NAT Gateway in the VPC that lets the function access the internet.

Pymongo connection issue in AWS Lambda

Relevant content