Heroku Deployment With MongoDB Error: Connection Refused

Question

pymongo.errors.ServerSelectionTimeoutError: localhost:27017: [Errno 111] Connection refused Hello their, I am having a little bit of trouble trying to deploy my Django site in python. I am getting this error(shown above) when trying to connect with my MongoDB atlas database. I read that I have to whitelist my IP, but when I did it did not work. Here is my views.py file:

class Initialize():
    def __init__(self, name):
        self.name = name
        myclient = pymongo.MongoClient('mongodb+srv://<MY Username>:<My Password>@cluster0-gicez.mongodb.net/test?retryWrites=true&w=majority')
        global mydb
        mydb = myclient[f"{self.name}"]
        global userData
        userData = mydb["userData"]
        global authData
        authData = mydb["auth_user"]
        global storesCollection
        storesCollection = mydb["stores"]
        global mycolPostalCodes
        mycolPostalCodes = mydb["postalCodes"]

When I was running my code before I tried deploying it, the code worked fine. Also, here is my settings.py file:

DATABASES = {
    'default': {
        'ENGINE': 'djongo',
        'NAME': 'cluster0',
        'HOST' : 'mongodb+srv://<my username>:<my password>@cluster0-gicez.mongodb.net/test?retryWrites=true&w=majority',
        'USER': '<my username>',
        'PASSWORD': '<my password>',
    }
}

Any help would be much appreciated. Thanks. Please message me for more information if needed.

D. SM · Accepted Answer · 2020-04-16 22:02:57Z

1

You need to whitelist the IP of the client, in this case Heroku. Their IP addresses are described here. Whitelisting your home/laptop IP does not allow Heroku to connect to your cluster.

To find out the address of a particular machine you could run e.g. the following code on the machine in question:

python -c "import urllib; print(urllib.urlopen('https://wtfismyip.com/text').read())"

edited Apr 16, 2020 at 22:02

answered Apr 16, 2020 at 3:10

D. SM

14.6k3 gold badges15 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Z_Rekhi Over a year ago

Hi, I did exactly what u said, and my database connection is working. In fact, it is filling the data. But I am still getting this error when I run python manage.py makemigrations

D. SM Over a year ago

You did not whitelist all ips or the documentation that Heroku provides is outdated/incomplete or you are running that command from a different computer.

Z_Rekhi · Accepted Answer · 2020-04-18 16:45:39Z

1

So, all I had to do was change my settings file. The way that I was connecting to mongodb atlas was outdated. So here is how I connected:

DATABASES = {
    'default': {
        'ENGINE': 'djongo',
        'CLIENT': {
            'host': 'mongodb+srv://{username}:{password}@cluster0-gicez.mongodb.net/test?retryWrites=true&w=majority',
            'username': {username},
            'password': {password},
            'authMechanism': 'SCRAM-SHA-1'
        }
    }
}

answered Apr 18, 2020 at 16:45

Z_Rekhi

871 silver badge7 bronze badges

Collectives™ on Stack Overflow

Heroku Deployment With MongoDB Error: Connection Refused

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related