Azure web app crashes when initializing mongo DB client

Question

I have created Cosmos DB account with MongoDB driver and want to access it from flask server. Here is the simplest example I'm trying:

from flask import Flask
from pymongo import MongoClient


url = 'monbodb://<my_db_name>.documents.azure.com:10255/?ssl=true
username = '<my_db_name>'
password = '<my_password>'
client = MongoClient(url, username=username, password=password)
app = Flask(__name__)


@app.route('/ping', methods=['GET'])
def ping():
    return 'pong!'


if __name__ == '__main__':
    app.run()

I deploy it with git and at the end it says the deployment was successful. But really app has crashed because webpage is not accessible, saying "The page cannot be displayed because an internal server error has occurred.". I guess issue is with SSL, because removing '/?ssl=true' does allow access app webpage but it this case DB is not accessible! What is with issue and how can it be fixed?

Answer 1

I tried to access my mongo db in my azure flask web app and it works well for me. You could refer to my working steps and codes.

view.py

from datetime import datetime
from flask import render_template
from jaygongflask import app
import pymongo

@app.route('/mongo')
def mongo():
    uri = "mongodb://<account name>:<your account key>@<account name>.documents.azure.com:10255/?ssl=true&replicaSet=globaldb"
    client = pymongo.MongoClient(uri)
    db = client['db']
    coll = db['coll']
    doc= coll.find_one()
    return render_template(
        'mongo.html',
        title='Mongo',
        message='Mongo query result.',
        queryResult = doc
    )

Publish your flask project and add the web.config.

web.config:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <appSettings>
    <add key="WSGI_HANDLER" value="<Your Project Name>.app"/>
    <add key="PYTHONPATH" value="D:\home\site\wwwroot"/>
    <add key="WSGI_LOG" value="D:\home\LogFiles\wfastcgi.log"/>
  </appSettings>
  <system.webServer>
    <handlers>
      <add name="PythonHandler" path="*" verb="*" modules="FastCgiModule" scriptProcessor="D:\home\Python361x64\python.exe|D:\home\Python361x64\wfastcgi.py" resourceType="Unspecified" requireAccess="Script"/>
    </handlers>
  </system.webServer>
</configuration>

Switch to the Kudu CMD and commands cd Python361x64 and touch get-pip.py and copy the content of the url https://bootstrap.pypa.io/get-pip.py into the get-pip.py via Edit button, then run python get-pip.py to install the pip tool.

Here, I use python361x64 extension. So I run the command python -m pip install pyodbc in KUDU.

Get query result

Access the url http://***.azurewebsites.net/mongo .

More deployment details , please refer to this tutorial.

Hope it helps you.