AWX 6.1.0 : Database relation Error

Archives AWX Project
,
1

Hi all,

I’m trying to install AWX 6.1.0 on my Ubuntu 16.04.5 with an external postgre database 9.6 in SLES 12.
Before to test this latest version, I had the AWX version 1.0.6.15 and .41 (yes it’s very old :slight_smile: ) with the same external database.

For this test, I have stop and delete my AWX containers (awx_task, web, rabbitMQ, memcache) and stop/delete my database.
So I recreate my DB from scratch with the same account and database name but when AWX 6.1.0 finished booting, I have the logs below on my DB and I don’t understand why…

Is there a cache or something in my Ubuntu server ?

======== From DB server - Logs ============

myAccount@postgres ERROR: must be owner of database awxbddpreprod
myAccount@postgres STATEMENT: ALTER DATABASE “awxbddpreprod” OWNER TO “myAccount”
[unknown]@[unknown] LOG: incomplete startup packet
myAccount@postgres ERROR: must be owner of database awxbddpreprod
myAccount@postgres STATEMENT: ALTER DATABASE “awxbddpreprod” OWNER TO “myAccount”
myAccount@awxbddpreprod ERROR: relation “conf_setting” does not exist at character 158
…
…

myAccount@awxbddpreprod ERROR: relation “django_migrations” does not exist at character 124

2

I believe those are Django error logs. For some reason or another Django is expecting that your “myAccount” user be the owner of the database it’s attempting to use, “awxbddpreprod”. When you deleted the database you probably deleted permissions attached to it as well.

Just log onto the postgres server and run the command in the logs - ALTER DATABASE “awxbddpreprod” OWNER TO “myAccount”. The next time you delete/create the database set the database owner as well.