# Postgresql error in kubernetes installation

**URL:** <https://forum.ansible.com/t/postgresql-error-in-kubernetes-installation/29956>\
**Category:** AWX Project\
**Tags:** awx, kubernetes\
**Created:** [March 22, 2019, 3:53pm UTC](https://forum.ansible.com/t/postgresql-error-in-kubernetes-installation/29956 "2019-03-22T15:53:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Alexander](https://avatars.discourse-cdn.com/v4/letter/m/94ad74/32.png) [@Michael\_Alexander](https://forum.ansible.com/u/Michael_Alexander)\
**Post date:** [March 22, 2019, 3:53pm UTC](https://forum.ansible.com/t/postgresql-error-in-kubernetes-installation/29956/1 "2019-03-22T15:53:52Z")

</div>

Hi  
I’m trying to install AWX in a K8s cluster but i get the following error:

TASK [kubernetes : Migrate database] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
fatal: [localhost]: FAILED! =\> {“changed”: true, “cmd”: “kubectl -n awx exec ansible-tower-management – bash -c "awx-manage migrate --noinput"”, “delta”: “0:00:03.199232”, “end”: “2019-03-22 11:05:05.014685”, “msg”: “non-zero return code”, “rc”: 1, “start”: “2019-03-22 11:05:01.815453”, “stderr”: “Traceback (most recent call last):\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py", line 115, in load\_backend\n return import\_module(‘%s.base’ % backend\_name)\n File "/usr/lib64/python3.6/importlib/ **init**.py", line 126, in import\_module\n return \_bootstrap.\_gcd\_import(name[level:], package, level)\n File "", line 994, in \_gcd\_import\n File "", line 971, in \_find\_and\_load\n File "", line 941, in \_find\_and\_load\_unlocked\n File "", line 219, in \_call\_with\_frames\_removed\n File "", line 994, in \_gcd\_import\n File "", line 971, in \_find\_and\_load\n File "", line 941, in \_find\_and\_load\_unlocked\n File "", line 219, in \_call\_with\_frames\_removed\n File "", line 994, in \_gcd\_import\n File "", line 971, in \_find\_and\_load\n File "", line 953, in \_find\_and\_load\_unlocked\nModuleNotFoundError: No module named ‘awx.main.db’\n\nDuring handling of the above exception, another exception occurred:\n\nTraceback (most recent call last):\n File "/usr/bin/awx-manage", line 11, in \n load\_entry\_point(‘awx==3.0.1.0’, ‘console\_scripts’, ‘awx-manage’)()\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/ **init**.py", line 140, in manage\n execute\_from\_command\_line(sys.argv)\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/ **init**.py", line 364, in execute\_from\_command\_line\n utility.execute()\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/ **init**.py", line 338, in execute\n django.setup()\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/ **init**.py", line 27, in setup\n apps.populate(settings.INSTALLED\_APPS)\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/apps/registry.py", line 108, in populate\n app\_config.import\_models()\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/apps/config.py", line 202, in import\_models\n self.models\_module = import\_module(models\_module\_name)\n File "/usr/lib64/python3.6/importlib/ **init**.py", line 126, in import\_module\n return \_bootstrap.\_gcd\_import(name[level:], package, level)\n File "", line 994, in \_gcd\_import\n File "", line 971, in \_find\_and\_load\n File "", line 955, in \_find\_and\_load\_unlocked\n File "", line 665, in \_load\_unlocked\n File "", line 678, in exec\_module\n File "", line 219, in \_call\_with\_frames\_removed\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/contrib/auth/models.py", line 4, in \n from django.contrib.auth.base\_user import AbstractBaseUser, BaseUserManager\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/contrib/auth/base\_user.py", line 52, in \n class AbstractBaseUser(models.Model):\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/base.py", line 124, in **new** \n new\_class.add\_to\_class(‘\_meta’, Options(meta, app\_label))\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/base.py", line 325, in add\_to\_class\n value.contribute\_to\_class(cls, name)\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/options.py", line 214, in contribute\_to\_class\n self.db\_table = truncate\_name(self.db\_table, connection.ops.max\_name\_length())\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/ **init**.py", line 33, in **getattr** \n return getattr(connections[DEFAULT\_DB\_ALIAS], item)\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py", line 211, in **getitem** \n backend = load\_backend(db[‘ENGINE’])\n File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py", line 134, in load\_backend\n raise ImproperlyConfigured(error\_msg)\ndjango.core.exceptions.ImproperlyConfigured: ‘awx.main.db.profiled\_pg’ isn’t an available database backend.\nTry using ‘django.db.backends.XXX’, where XXX is one of:\n ‘mysql’, ‘oracle’, ‘postgresql’, ‘sqlite3’\nError was: No module named ‘awx.main.db’\ncommand terminated with exit code 1”, “stderr\_lines”: [“Traceback (most recent call last):”, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py", line 115, in load\_backend", " return import\_module(‘%s.base’ % backend\_name)“, " File "/usr/lib64/python3.6/importlib/ **init**.py", line 126, in import\_module”, " return \_bootstrap.\_gcd\_import(name[level:], package, level)“, " File "", line 994, in \_gcd\_import”, " File "", line 971, in \_find\_and\_load", " File "", line 941, in \_find\_and\_load\_unlocked", " File "", line 219, in \_call\_with\_frames\_removed", " File "", line 994, in \_gcd\_import", " File "", line 971, in \_find\_and\_load", " File "", line 941, in \_find\_and\_load\_unlocked", " File "", line 219, in \_call\_with\_frames\_removed", " File "", line 994, in \_gcd\_import", " File "", line 971, in \_find\_and\_load", " File "", line 953, in \_find\_and\_load\_unlocked", “ModuleNotFoundError: No module named ‘awx.main.db’”, “”, “During handling of the above exception, another exception occurred:”, “”, “Traceback (most recent call last):”, " File "/usr/bin/awx-manage", line 11, in “, " load\_entry\_point(‘awx==3.0.1.0’, ‘console\_scripts’, ‘awx-manage’)()”, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/ **init**.py", line 140, in manage", " execute\_from\_command\_line(sys.argv)“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/ **init**.py", line 364, in execute\_from\_command\_line”, " utility.execute()“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/ **init**.py", line 338, in execute”, " django.setup()“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/ **init**.py", line 27, in setup”, " apps.populate(settings.INSTALLED\_APPS)“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/apps/registry.py", line 108, in populate”, " app\_config.import\_models()“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/apps/config.py", line 202, in import\_models”, " self.models\_module = import\_module(models\_module\_name)“, " File "/usr/lib64/python3.6/importlib/ **init**.py", line 126, in import\_module”, " return \_bootstrap.\_gcd\_import(name[level:], package, level)“, " File "", line 994, in \_gcd\_import”, " File "", line 971, in \_find\_and\_load", " File "", line 955, in \_find\_and\_load\_unlocked", " File "", line 665, in \_load\_unlocked", " File "", line 678, in exec\_module", " File "", line 219, in \_call\_with\_frames\_removed", " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/contrib/auth/models.py", line 4, in “, " from django.contrib.auth.base\_user import AbstractBaseUser, BaseUserManager”, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/contrib/auth/base\_user.py", line 52, in “, " class AbstractBaseUser(models.Model):”, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/base.py", line 124, in **new**", " new\_class.add\_to\_class(‘\_meta’, Options(meta, app\_label))“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/base.py", line 325, in add\_to\_class”, " value.contribute\_to\_class(cls, name)“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/options.py", line 214, in contribute\_to\_class”, " self.db\_table = truncate\_name(self.db\_table, connection.ops.max\_name\_length())“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/ **init**.py", line 33, in **getattr** ”, " return getattr(connections[DEFAULT\_DB\_ALIAS], item)“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py", line 211, in **getitem** ”, " backend = load\_backend(db[‘ENGINE’])“, " File "/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py", line 134, in load\_backend”, " raise ImproperlyConfigured(error\_msg)“, “django.core.exceptions.ImproperlyConfigured: ‘awx.main.db.profiled\_pg’ isn’t an available database backend.”, “Try using ‘django.db.backends.XXX’, where XXX is one of:”, " ‘mysql’, ‘oracle’, ‘postgresql’, ‘sqlite3’”, “Error was: No module named ‘awx.main.db’”, “command terminated with exit code 1”], “stdout”: “”, “stdout\_lines”: }

PLAY RECAP \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
localhost : ok=21 changed=9 unreachable=0 failed=1

The Pods in my awx namespace are:

NAME READY STATUS RESTARTS AGE  
ansible-tower-management 1/1 Running 0 21m  
awx-0 4/4 Running 0 21m  
awx-postgresql-postgresql-0 0/1 Pending 0 22m

then I display the evento of the postgress pod an I get:

Events:  
Type Reason Age From Message

* * *

Warning FailedScheduling 2m28s (x31 over 17m) default-scheduler pod has unbound immediate PersistentVolumeClaims

Finally my inventory file only have these lines uncommented:

localhost ansible\_connection=local ansible\_python\_interpreter=“/usr/bin/env python”

[all:vars]  
dockerhub\_base=ansible

kubernetes\_context=awx-context  
kubernetes\_namespace=awx  
tiller\_namespace=kube-system

awx\_task\_hostname=awx  
awx\_web\_hostname=awxweb  
postgres\_data\_dir=/tmp/pgdocker  
host\_port=80

docker\_compose\_dir=/var/lib/awx

pg\_username=awx  
pg\_password=awxpass  
pg\_database=awx  
pg\_port=5432

rabbitmq\_password=awxpass  
rabbitmq\_erlang\_cookie=cookiemonster

admin\_user=admin  
admin\_password=Passw0rd

create\_preload\_data=False

secret\_key=awxsecret

awx\_alternate\_dns\_servers=“4.2.2.1,4.2.2.2”

project\_data\_dir=/var/lib/awx/projects

I don’t know what I’m doing bad.

If someone can help me … it will be appreciated.

Michael