# AWX Installation issue

**URL:** <https://forum.ansible.com/t/awx-installation-issue/29728>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [February 21, 2019, 2:53am UTC](https://forum.ansible.com/t/awx-installation-issue/29728 "2019-02-21T02:53:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bachu\_Prathap](https://avatars.discourse-cdn.com/v4/letter/b/6a8cbe/32.png) [@Bachu\_Prathap](https://forum.ansible.com/u/Bachu_Prathap)\
**Post date:** [February 21, 2019, 2:53am UTC](https://forum.ansible.com/t/awx-installation-issue/29728/1 "2019-02-21T02:53:05Z")

</div>

Hello Team

I am new to AWX, after installation, I see that awx page says “Server Error” and below exceptions, I see on awx\_tasks. Can someone help me on this issue?

2019-02-20 16:22:51,741 INFO exited: dispatcher (exit status 1; not expected)  
2019-02-20 16:22:52,744 INFO spawned: ‘dispatcher’ with pid 477  
2019-02-20 16:22:53,745 INFO success: dispatcher entered RUNNING state, process has stayed up for \> than 1 seconds (startsecs)  
2019-02-20 16:22:54,486 WARNING awx.conf.settings Database settings are not available, using defaults, error:  
Traceback (most recent call last):  
File “/usr/bin/awx-manage”, line 12, 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 356, in execute  
self.fetch\_command(subcommand).run\_from\_argv(self.argv)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 283, in run\_from\_argv  
self.execute(\*args, \*\*cmd\_options)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 327, in execute  
self.check()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 359, in check  
include\_deployment\_checks=include\_deployment\_checks,  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 346, in \_run\_checks  
return checks.run\_checks(\*\*kwargs)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/checks/registry.py”, line 81, in run\_checks  
new\_errors = check(app\_configs=app\_configs)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/checks/urls.py”, line 16, in check\_url\_config  
return check\_resolver(resolver)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/checks/urls.py”, line 26, in check\_resolver  
return check\_method()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/urls/resolvers.py”, line 256, in check  
for pattern in self.url\_patterns:  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/utils/functional.py”, line 35, in **get**  
res = instance. **dict** [[self.name](http://self.name)] = self.func(instance)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/urls/resolvers.py”, line 407, in url\_patterns  
patterns = getattr(self.urlconf\_module, “urlpatterns”, self.urlconf\_module)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/utils/functional.py”, line 35, in **get**  
res = instance. **dict** [[self.name](http://self.name)] = self.func(instance)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/urls/resolvers.py”, line 400, in urlconf\_module  
return import\_module(self.urlconf\_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/awx/urls.py”, line 17, in   
url(r’^sso/', include(‘social\_django.urls’, namespace=‘social’)),  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/conf/urls/ **init**.py”, line 50, in include  
urlconf\_module = import\_module(urlconf\_module)  
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/social\_django/urls.py”, line 6, in   
from . import views  
File “”, line 1023, in \_handle\_fromlist  
File “”, line 219, in \_call\_with\_frames\_removed  
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/social\_django/views.py”, line 10, in   
from .utils import psa  
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/social\_django/utils.py”, line 13, in   
BACKENDS = settings.AUTHENTICATION\_BACKENDS  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/conf/settings.py”, line 542, in **getattr\_without\_cache**  
return getattr(self.\_wrapped, name)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/conf/settings.py”, line 446, in **getattr**  
value = self.\_get\_local(name)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/conf/settings.py”, line 363, in \_get\_local  
self.\_preload\_cache()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/conf/settings.py”, line 325, in \_preload\_cache  
for setting in Setting.objects.filter(key\_\_in=settings\_to\_cache.keys(), user\_\_isnull=True).order\_by(‘pk’):  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 250, in **iter**  
self.\_fetch\_all()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 1121, in \_fetch\_all  
self.\_result\_cache = list(self.\_iterable\_class(self))  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 53, in **iter**  
results = compiler.execute\_sql(chunked\_fetch=self.chunked\_fetch)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 887, in execute\_sql  
cursor = self.connection.cursor()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 254, in cursor  
return self.\_cursor()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 229, in \_cursor  
self.ensure\_connection()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 213, in ensure\_connection  
self.connect()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py”, line 94, in **exit**  
six.reraise(dj\_exc\_type, dj\_exc\_value, traceback)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/utils/six.py”, line 685, in reraise  
raise value.with\_traceback(tb)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 213, in ensure\_connection  
self.connect()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 189, in connect  
self.connection = self.get\_new\_connection(conn\_params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/postgresql/base.py”, line 176, in get\_new\_connection  
connection = Database.connect(\*\*conn\_params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/psycopg2/ **init**.py”, line 130, in connect  
conn = \_connect(dsn, connection\_factory=connection\_factory, \*\*kwasync)  
OperationalError: invalid sslmode value: “\_\_omit\_place\_holder\_\_d378694810071be9256c264994bfb329b544bd3b”

Traceback (most recent call last):  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 213, in ensure\_connection  
self.connect()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 189, in connect  
self.connection = self.get\_new\_connection(conn\_params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/postgresql/base.py”, line 176, in get\_new\_connection  
connection = Database.connect(\*\*conn\_params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/psycopg2/ **init**.py”, line 130, in connect  
conn = \_connect(dsn, connection\_factory=connection\_factory, \*\*kwasync)  
psycopg2.OperationalError: invalid sslmode value: “\_\_omit\_place\_holder\_\_d378694810071be9256c264994bfb329b544bd3b”

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

Traceback (most recent call last):  
File “/usr/bin/awx-manage”, line 12, 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 356, in execute  
self.fetch\_command(subcommand).run\_from\_argv(self.argv)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 283, in run\_from\_argv  
self.execute(\*args, \*\*cmd\_options)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 330, in execute  
output = self.handle(\*args, \*\*options)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/management/commands/run\_dispatcher.py”, line 121, in handle  
reaper.reap()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/dispatch/reaper.py”, line 36, in reap  
me = instance or [Instance.objects.me](http://Instance.objects.me)()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/managers.py”, line 86, in me  
if node.exists():  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 673, in exists  
return self.query.has\_results(using=self.db)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/query.py”, line 517, in has\_results  
return compiler.has\_results()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 858, in has\_results  
return bool(self.execute\_sql(SINGLE))  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 887, in execute\_sql  
cursor = self.connection.cursor()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 254, in cursor  
return self.\_cursor()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 229, in \_cursor  
self.ensure\_connection()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 213, in ensure\_connection  
self.connect()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py”, line 94, in **exit**  
six.reraise(dj\_exc\_type, dj\_exc\_value, traceback)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/utils/six.py”, line 685, in reraise  
raise value.with\_traceback(tb)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 213, in ensure\_connection  
self.connect()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/base/base.py”, line 189, in connect  
self.connection = self.get\_new\_connection(conn\_params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/postgresql/base.py”, line 176, in get\_new\_connection  
connection = Database.connect(\*\*conn\_params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/psycopg2/ **init**.py”, line 130, in connect  
conn = \_connect(dsn, connection\_factory=connection\_factory, \*\*kwasync)  
django.db.utils.OperationalError: invalid sslmode value: “\_\_omit\_place\_holder\_\_d378694810071be9256c264994bfb329b544bd3b”

Regards  
Pratap Bachu

---

<div class="post-metadata">

**Author:** ![Darkhan](https://avatars.discourse-cdn.com/v4/letter/d/34f0e0/32.png) [@Darkhan](https://forum.ansible.com/u/Darkhan)\
**Post date:** [February 21, 2019, 9:38am UTC](https://forum.ansible.com/t/awx-installation-issue/29728/2 "2019-02-21T09:38:37Z")

</div>

When AWX starts for the first time it has to create the db tables. By the looks of it, your db connection fails.  
How did you configure the db in your inventory file?  
What installation method did you use for awx?  
Is your db in a container or external?

---

<div class="post-metadata">

**Author:** ![Foley\_John](https://avatars.discourse-cdn.com/v4/letter/f/e495f1/32.png) [@Foley\_John](https://forum.ansible.com/u/Foley_John)\
**Post date:** [February 21, 2019, 12:38pm UTC](https://forum.ansible.com/t/awx-installation-issue/29728/3 "2019-02-21T12:38:52Z")

</div>

Did you build from source? I recently built AWX from source and had similar problems. It compiled/built, but none of the settings for the DB, RabbitMQ, etc. made their way into the individual containers. I ended up modifying the /etc/tower/settings.py file on the various containers to reflect the database information. For some reason, I also commented out these lines, as it would not work without the comment:

if os.getenv(“DATABASE\_SSLMODE”, False):

DATABASES[‘default’][‘OPTIONS’] = {‘sslmode’: os.getenv(“DATABASE\_SSLMODE”)}

**John M. Foley**

**IT Specialist**

![http://www.loc.gov/staff/emailsig/logos/lloc.jpg](https://us1.discourse-cdn.com/ansible/original/2X/7/760622c1f5b048c15d45e97c76556e73baba2a14.jpeg)

---

<div class="post-metadata">

**Author:** ![Bachu\_Prathap](https://avatars.discourse-cdn.com/v4/letter/b/6a8cbe/32.png) [@Bachu\_Prathap](https://forum.ansible.com/u/Bachu_Prathap)\
**Post date:** [February 21, 2019, 12:42pm UTC](https://forum.ansible.com/t/awx-installation-issue/29728/4 "2019-02-21T12:42:43Z")

</div>

Yes, i did build from source. I uncommented and made sslmode as disable.

[root@#######installer]# grep sslmode inventory  
pg\_sslmode=disable  
[root@####### installer]#

> **(attachments)**
>
> ![image001.jpg](https://us1.discourse-cdn.com/ansible/original/2X/7/760622c1f5b048c15d45e97c76556e73baba2a14.jpeg)

---

<div class="post-metadata">

**Author:** ![Foley\_John](https://avatars.discourse-cdn.com/v4/letter/f/e495f1/32.png) [@Foley\_John](https://forum.ansible.com/u/Foley_John)\
**Post date:** [February 21, 2019, 12:51pm UTC](https://forum.ansible.com/t/awx-installation-issue/29728/5 "2019-02-21T12:51:42Z")

</div>

Did that fix it?

> **(attachments)**
>
> ![image001.jpg](https://us1.discourse-cdn.com/ansible/original/2X/7/760622c1f5b048c15d45e97c76556e73baba2a14.jpeg)

---

<div class="post-metadata">

**Author:** ![Uriel](https://avatars.discourse-cdn.com/v4/letter/u/53a042/32.png) [@Uriel](https://forum.ansible.com/u/Uriel)\
**Post date:** [February 21, 2019, 4:15pm UTC](https://forum.ansible.com/t/awx-installation-issue/29728/6 "2019-02-21T16:15:18Z")

</div>

I haven’t built the images in about a week but from

> 2019-02-20 16:22:54,486 WARNING awx.conf.settings Database settings are not available, using defaults, error:

it sounds like something prevented AWX from correctly loading your DATABASE settings in /etc/tower/settings.py? It could be that there’s a typo in a configuration item. Get into the web or task container and run  
`  
awx-manage print\_settings

`  
and inspect the DATABASE settings. Also, I think the default for pg\_sslmode is false, what happens if you just leave the variable commented out in the inventory file during installation?