I browsed archived posts and had a look at github issues but didn't find anything relevant to my issue. It is however a rather entry level issue so apologies if this has been dealt with elsewhere.
I can see that user archivematica is being refused entry to the mysql server but that seems weird.
TASK [artefactual.archivematica-src : Run migrations] **************************
fatal: [am-local]: FAILED! => {"changed": false, "cmd": "./manage.py migrate --noinput --pythonpath=/usr/lib/archivematica/archivematicaCommon", "msg": "\n:stderr: Traceback (most recent call last):\n File \"./manage.py\", line 10, in <module>\n execute_from_command_line(sys.argv)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/management/__init__.py\", line 354, in execute_from_command_line\n utility.execute()\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/management/__init__.py\", line 346, in execute\n self.fetch_command(subcommand).run_from_argv(self.argv)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/management/base.py\", line 394, in run_from_argv\n self.execute(*args, **cmd_options)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/management/base.py\", line 444, in execute\n self.check()\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/management/base.py\", line 482, in check\n include_deployment_checks=include_deployment_checks,\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/checks/registry.py\", line 72, in run_checks\n new_errors = check(app_configs=app_configs)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/checks/model_checks.py\", line 28, in check_all_models\n errors.extend(model.check(**kwargs))\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/base.py\", line 1205, in check\n errors.extend(cls._check_fields(**kwargs))\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/base.py\", line 1282, in _check_fields\n errors.extend(field.check(**kwargs))\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py\", line 934, in check\n errors = super(AutoField, self).check(**kwargs)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py\", line 207, in check\n errors.extend(self._check_backend_specific_checks(**kwargs))\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py\", line 306, in _check_backend_specific_checks\n return connection.validation.check_field(self, **kwargs)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/mysql/validation.py\", line 18, in check_field\n field_type = field.db_type(connection)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py\", line 614, in db_type\n return connection.data_types[self.get_internal_type()] % data\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/__init__.py\", line 36, in __getattr__\n return getattr(connections[DEFAULT_DB_ALIAS], item)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/utils/functional.py\", line 59, in __get__\n res = instance.__dict__[
self.name] = self.func(instance)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py\", line 196, in data_types\n if self.features.supports_microsecond_precision:\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/utils/functional.py\", line 59, in __get__\n res = instance.__dict__[
self.name] = self.func(instance)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/mysql/features.py\", line 52, in supports_microsecond_precision\n return self.connection.mysql_version >= (5, 6, 4) and Database.version_info >= (1, 2, 5)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/utils/functional.py\", line 59, in __get__\n res = instance.__dict__[
self.name] = self.func(instance)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py\", line 371, in mysql_version\n with self.temporary_connection():\n File \"/usr/lib/python2.7/contextlib.py\", line 17, in __enter__\n return self.gen.next()\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 462, in temporary_connection\n cursor = self.cursor()\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 164, in cursor\n cursor = self.make_cursor(self._cursor())\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 135, in _cursor\n self.ensure_connection()\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 130, in ensure_connection\n self.connect()\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/utils.py\", line 98, in __exit__\n six.reraise(dj_exc_type, dj_exc_value, traceback)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 130, in ensure_connection\n self.connect()\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 119, in connect\n self.connection = self.get_new_connection(conn_params)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py\", line 276, in get_new_connection\n conn = Database.connect(**conn_params)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/MySQLdb/__init__.py\", line 81, in Connect\n return Connection(*args, **kwargs)\n File \"/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/MySQLdb/connections.py\", line 204, in __init__\n super(Connection, self).__init__(*args, **kwargs2)\ndjango.db.utils.OperationalError: (1045, \"Access denied for user 'archivematica'@'localhost' (using password: YES)\")\n", "path": "/usr/share/archivematica/virtualenvs/archivematica-dashboard/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin", "state": "absent", "syspath": ["/tmp/ansible_btDx7W", "/tmp/ansible_btDx7W/ansible_modlib.zip", "/tmp/ansible_btDx7W/ansible_modlib.zip", "/usr/lib/python2.7", "/usr/lib/python2.7/plat-x86_64-linux-gnu", "/usr/lib/python2.7/lib-tk", "/usr/lib/python2.7/lib-old", "/usr/lib/python2.7/lib-dynload", "/usr/local/lib/python2.7/dist-packages", "/usr/lib/python2.7/dist-packages"]}
to retry, use: --limit @/Users/hmalmqui/deploy-pub/playbooks/archivematica/singlenode.retry
PLAY RECAP *********************************************************************
am-local : ok=149 changed=25 unreachable=0 failed=1