{"id":115,"date":"2020-12-04T11:07:31","date_gmt":"2020-12-04T11:07:31","guid":{"rendered":"http:\/\/blogs.igalia.com\/adunaev\/?p=115"},"modified":"2021-02-17T10:45:04","modified_gmt":"2021-02-17T10:45:04","slug":"django-postgres-nginx-uwsgi","status":"publish","type":"post","link":"https:\/\/blogs.igalia.com\/adunaev\/2020\/12\/04\/django-postgres-nginx-uwsgi\/","title":{"rendered":"Django + Postgres + nginx + uWSGI = \u2764\ufe0f"},"content":{"rendered":"

To date, I set up a production web service thrice. (Yeah, I am a full stack dev!)<\/p>\n

The first time I did many mistakes. That website still works, I maintain and update it, but now it would be difficult to fix things, I would have to stop the service and have some quite stressful time re-configuring it.<\/p>\n

The second time I did it more or less right, but the deployment happened in the corporate network of the company that I no longer work for, so that knowledge is now lost to me.<\/p>\n

When I tried to do it the third time, I had to recall and google many things again. Now it works, so it is a good moment to write a note to myself in future.<\/p>\n

The plan<\/h3>\n

Five steps to quick and easy deployment<\/em> by Alex who likes to code:<\/p>\n

    \n
  1. Install nginx, uwsgi, python3, and postgres. (no-op)<\/li>\n
  2. Set up PostgreSQL.<\/li>\n
  3. Check out the Django project and set it up.<\/li>\n
  4. Configure uWSGI.<\/li>\n
  5. Configure nginx.<\/li>\n<\/ol>\n

    Setting up prerequisites is literally one call to the package manager (yes, I assume that we are on Linux). Too easy, I cannot write anything else about that. Other parts are longer.<\/p>\n

    PostgreSQL<\/h3>\n

    As user postgres<\/code>, run psql<\/code>. This will take us into the DBMS console. There, run the following:<\/p>\n

    CREATE DATABASE db-name;\nCREATE USER db-user WITH PASSWORD 'password';\nALTER ROLE db-user SET client_encoding TO 'utf8';\nALTER ROLE db-user SET default_transaction_isolation\n    TO 'read committed';\nALTER ROLE db-user SET timezone TO 'UTC';\nGRANT ALL PRIVILEGES ON DATABASE db-name TO db-user;\n<\/code><\/pre>\n
    Most commands above  are quite self-explanatory. The ALTER ROLE<\/code> ones are not mandatory but may be useful.<\/p>\n
    Now exit the DBMS console and proceed to the next part.<\/p>\n
    Django<\/h3>\n
    This part is the longest, it is in fact the actual deployment of the project, other parts are just\u2026 environment<\/em>.<\/p>\n
      \n
    1. Switch to the user that will normally do whatever is required regarding the source code, e.g., updating the checkout, editing the code and project configs, etc.  Let it be user project<\/em>.<\/li>\n
    2. Check out the project into the common location for websites, like \/var\/www<\/code> on Debian.  Let it be \/var\/www\/project<\/code> (we will need it later a few more times).<\/li>\n
    3. Create the virtual Python environment (venv<\/em>); modern versions of Python can do that themselves via python -m venv {directory name}<\/code>, I like to have it in the venv<\/code> directory directly within the Django project, so the full path would be \/var\/www\/project\/venv<\/code>.<\/li>\n
    4. Activate the venv and install Python requirements.  Do not deactivate it for the next few steps.<\/li>\n
    5. Edit the project settings.  See remarks below for some ideas about this.<\/li>\n
    6. Test that the project is configured properly by running manage.py migrate<\/code>.<\/li>\n
    7. Test even more that the project is configured properly by running manage.py runserver<\/code>.  Terminate the server after it starts normally.<\/li>\n
    8. Create the Django superuser by running manage.py createsuperuser<\/code>.  We may deactivate the venv now.<\/li>\n<\/ol>\n
      Remarks on preparing the project for deployment<\/h4>\n
      The web service always has some site-specific settings, and putting them under the version control would be a pain.  I like the idea of moving these settings into the separate file from the very beginning.  Create site_settings.py<\/code> near the standard settings.py<\/code>, cut and paste whatever is going to differ between hosts, and then add from .site_settings import *<\/code> into settings.py<\/code>.  Add site_settings.py<\/code> into .gitignore<\/code>.<\/p>\n
      We definitely want SECRET_KEY<\/code>, DEBUG<\/code>, and DATABASES<\/code> to stay in the site config.<\/p>\n
      uWSGI<\/h3>\n
      As root, create \/etc\/uwsgi\/apps-available\/project.ini<\/code> (the .ini<\/code> extension is important!) and put this inside:<\/p>\n
      [uwsgi]\n# The root directory of the Django project.\nchdir  = \/var\/www\/project\n# The Python module within the project that creates\n# the application.  It is already there, built into\n# every Django project.\nmodule = project.wsgi\n# The venv that should be used.\nhome   = \/var\/www\/project\/venv\n\n# Used to connect to the web server.\nsocket       = \/var\/www\/project\/socket\n# uWSGI has plugins for different platforms.\n# This may require to install something like\n# uwsgi-plugin-python3.\nplugins      = python37\n\n# Not important :-D but still needed.\nmaster       = true\nprocesses    = 5\nvacuum       = true\n<\/code><\/pre>\n
      Create a link to the newly created config to enable the application:<\/p>\n
      ln -s \/etc\/uwsgi\/apps-available\/project.ini \\\n        \/etc\/uwsgi\/apps-enabled\/project.ini\n<\/code><\/pre>\n
      Restart uwsgi and ensure that it runs with no errors.<\/p>\n
      nginx<\/h3>\n
      As user project<\/em>, create \/var\/www\/project\/project\/uwsgi_params<\/code> and put there this:<\/p>\n
      uwsgi_param QUERY_STRING $query_string;\nuwsgi_param REQUEST_METHOD $request_method;\nuwsgi_param CONTENT_TYPE $content_type;\nuwsgi_param CONTENT_LENGTH $content_length;\nuwsgi_param REQUEST_URI $request_uri;\nuwsgi_param PATH_INFO $document_uri;\nuwsgi_param DOCUMENT_ROOT $document_root;\nuwsgi_param SERVER_PROTOCOL $server_protocol;\nuwsgi_param REMOTE_ADDR $remote_addr;\nuwsgi_param REMOTE_PORT $remote_port;\nuwsgi_param SERVER_ADDR $server_addr;\nuwsgi_param SERVER_PORT $server_port;\nuwsgi_param SERVER_NAME $server_name;\n<\/code><\/pre>\n
      (This is in fact the standard file that is shipped with the nginx distribution.)<\/p>\n
      Now switch to root, create \/etc\/nginx\/sites-available\/project<\/code> and put this inside:<\/p>\n
      server {\n    listen      80;\n    server_name project.org;\n    charset     utf-8;\n\n    location \/static\/ {\n        alias \/var\/www\/project\/static\/;\n    }\n\n    location \/ {\n        \\# Connection to uWSGI.\n        uwsgi_pass unix:\/var\/www\/project\/socket;\n        include    \/var\/www\/project\/project\/uwsgi_params;\n    }\n}\n<\/code><\/pre>\n
      Create a link to the newly created config to enable the website:<\/p>\n
       ln -s \/etc\/nginx\/sites-available\/project \\\n    \/etc\/nginx\/sites-enabled\/project\n<\/code><\/pre>\n
      Restart nginx and ensure that it runs without errors.<\/p>\n
      That is it!<\/p>\n
      References<\/h3>\n