Symptoms

• When navigating to the Awingu environment, the authentication page does not function correctly.
• Various other issues.

In log files (usually inaccessible due to the inability to sign in), a similar error can be seen:

Aug 30 10:58:40 ats-auea-04801 manage.py[2829]: ('42000', "[42000] [unixODBC][FreeTDS][SQL Server]Database 'somedb' on server 'some.server.org' is not currently available.  Please retry the connection later.  If the problem persists, contact customer support, and pro
                                                Traceback (most recent call last):
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
                                                    self.connect()
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/utils/asyncio.py", line 33, in inner
                                                    return func(*args, **kwargs)
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 200, in connect
                                                    self.connection = self.get_new_connection(conn_params)
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/mssql/base.py", line 353, in get_new_connection
                                                    conn = Database.connect(connstr, **args)
                                                pyodbc.ProgrammingError: ('42000', "[42000] [unixODBC][FreeTDS][SQL Server]Database 'somedb' on server 'some.server.org' is not currently available.  Please retry the connection later.  If the problem persists, contact

                                                The above exception was the direct cause of the following exception:

                                                Traceback (most recent call last):
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django_q/cluster.py", line 602, in scheduler
                                                    with db.transaction.atomic(using=Schedule.objects.db):
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 189, in __enter__
                                                    if not connection.get_autocommit():
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 389, in get_autocommit
                                                    self.ensure_connection()
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/utils/asyncio.py", line 33, in inner
                                                    return func(*args, **kwargs)
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
                                                    self.connect()
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 90, in __exit__
                                                    raise dj_exc_value.with_traceback(traceback) from exc_value
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
                                                    self.connect()
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/utils/asyncio.py", line 33, in inner
                                                    return func(*args, **kwargs)
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 200, in connect
                                                    self.connection = self.get_new_connection(conn_params)
                                                  File "/opt/awingu/awingu-core/virtualenv/lib/python3.6/site-packages/mssql/base.py", line 353, in get_new_connection
                                                    conn = Database.connect(connstr, **args)
                                                django.db.utils.ProgrammingError: ('42000', "[42000] [unixODBC][FreeTDS][SQL Server]Database 'somedb' on server 'some.server.org' is not currently available.  Please retry the connection later.  If the problem persists,

Cause

Awingu is unable to connect to the specified external Microsoft SQL database.

Resolution