Problems setting up/running WebODM on Ubuntu 18.04 - django.db.utils.ProgrammingError: relation “auth_user” does not exist

[BR7]

Hello and Greetings to everyone here,

I am installing WebODM on Ubuntu 18.04 using the Docker instructions and am running into problems getting WebODM to start. I have looked through the forums here and spent some time with the Docker and Django docs but haven’t found anything that is working for me.

The two errors that I have spent the most time with are: [psql fe_sendauth no password supplied] and [django.db.utils.ProgrammingError: relation “auth_user” does not exist].

I have rebuilt and updated the app with no change in behavior, when I do ‘./webodm.sh start’ or ’ `./webodm.sh down && ./webodm.sh start’ I receive the following:

Checking for docker… OK
Checking for git… OK
Checking for docker-compose… OK
Tearing down WebODM…
docker-compose -f docker-compose.yml -f docker-compose.nodeodm.yml -f docker-compose.nodemicmac.yml down --remove-orphans
Removing webapp … done
Removing worker … done
Removing db … done
Removing broker … done
Removing webodm_node-odm_1 … done
Removing network webodm_default
Checking for docker… OK
Checking for git… OK
Checking for docker-compose… OK
Starting WebODM…

Using the following environment:

Host: localhost

Port: 8000
Media directory: appmedia
SSL: NO
SSL key:
SSL certificate:
SSL insecure port redirect: 80
Celery Broker: redis://broker
Default Nodes: 1

Make sure to issue a ./webodm.sh down if you decide to change the environment.

docker-compose -f docker-compose.yml -f docker-compose.nodeodm.yml start || docker-compose -f docker-compose.yml -f docker-compose.nodeodm.yml up --scale node-odm=1
Starting db … done
Starting node-odm … done
Starting broker … done
Starting worker … done
Starting webapp … done
ERROR: No containers to start
Creating network “webodm_default” with the default driver
Creating webodm_node-odm_1 …
Creating db …
Creating broker …
Creating webodm_node-odm_1
Creating db
Creating broker … done
Creating worker …
Creating worker … done
Creating webapp …
Creating webapp … done
Attaching to db, webodm_node-odm_1, broker, worker, webapp
db | LOG: database system was shut down at 2020-12-16 13:49:41 UTC
node-odm_1 | info: Authentication using NoTokenRequired
db | LOG: MultiXact member wraparound protections are now enabled
node-odm_1 | info: Listening on 0.0.0.0:6367 UDP for progress updates
db | LOG: database system is ready to accept connections
broker | 1:C 16 Dec 2020 13:51:20.020 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
broker | 1:C 16 Dec 2020 13:51:20.020 # Redis version=6.0.9, bits=64, commit=00000000, modified=0, pid=1, just started
broker | 1:C 16 Dec 2020 13:51:20.020 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
worker | Password for user postgres:
db | LOG: autovacuum launcher started
broker | 1:M 16 Dec 2020 13:51:20.022 * Running mode=standalone, port=6379.
node-odm_1 | info: No tasks dump found
worker | psql: fe_sendauth: no password supplied
worker | Postgres is unavailable - sleeping
broker | 1:M 16 Dec 2020 13:51:20.023 # Server initialized
node-odm_1 | info: Checking for orphaned directories to be removed…
worker | Password for user postgres:
broker | 1:M 16 Dec 2020 13:51:20.023 * Ready to accept connections
node-odm_1 | info: Server has started on port 3000
worker | psql: fe_sendauth: no password supplied
worker | Postgres is unavailable - sleeping
worker | Password for user postgres:
worker | psql: fe_sendauth: no password supplied
worker | Postgres is unavailable - sleeping
webapp | Password for user postgres:
webapp | psql: fe_sendauth: no password supplied
webapp | Postgres is unavailable - sleeping
worker | Password for user postgres:
worker | psql: fe_sendauth: no password supplied
worker | Postgres is unavailable - sleeping
webapp | Password for user postgres:
webapp | psql: fe_sendauth: no password supplied
webapp | Postgres is unavailable - sleeping
worker | Password for user postgres:
worker | psql: fe_sendauth: no password supplied
worker | Postgres is unavailable - sleeping

… and the app will continue in this loop as long as I have let it run.

Any ideas about where to go from here are appreciated. Thanks in advance!!

Some additional info that might help: after issuing ‘./webodm.sh start && ./webodm.sh resetadminpassword newpass’ the following occurs; I believe the last two lines might provide a clue as to what is going on:

Checking for docker… OK
Checking for git… OK
Checking for docker-compose… OK
Starting WebODM…

Using the following environment:

Host: localhost

Port: 8000
Media directory: appmedia
SSL: NO
SSL key:
SSL certificate:
SSL insecure port redirect: 80
Celery Broker: redis://broker
Default Nodes: 1

Make sure to issue a ./webodm.sh down if you decide to change the environment.

docker-compose -f docker-compose.yml -f docker-compose.nodeodm.yml start || docker-compose -f docker-compose.yml -f docker-compose.nodeodm.yml up --scale node-odm=1
Starting db … done
Starting node-odm … done
Starting broker … done
Starting worker … done
Starting webapp … done
Generated secret key
Traceback (most recent call last):
File “/usr/local/lib/python3.6/dist-packages/django/db/backends/utils.py”, line 85, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation “auth_user” does not exist
LINE 1: …user".“is_active”, “auth_user”.“date_joined” FROM "auth_user…
^

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

Traceback (most recent call last):
File “manage.py”, line 22, in
execute_from_command_line(sys.argv)
File “/usr/local/lib/python3.6/dist-packages/django/core/management/init.py”, line 381, in execute_from_command_line
utility.execute()
File “/usr/local/lib/python3.6/dist-packages/django/core/management/init.py”, line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File “/usr/local/lib/python3.6/dist-packages/django/core/management/base.py”, line 316, in run_from_argv
self.execute(*args, **cmd_options)
File “/usr/local/lib/python3.6/dist-packages/django/core/management/base.py”, line 353, in execute
output = self.handle(*args, **options)
File “/usr/local/lib/python3.6/dist-packages/django/core/management/commands/shell.py”, line 92, in handle
exec(sys.stdin.read())
File “”, line 1, in
File “/usr/local/lib/python3.6/dist-packages/django/db/models/query.py”, line 302, in getitem
qs._fetch_all()
File “/usr/local/lib/python3.6/dist-packages/django/db/models/query.py”, line 1186, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/local/lib/python3.6/dist-packages/django/db/models/query.py”, line 54, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File “/usr/local/lib/python3.6/dist-packages/django/db/models/sql/compiler.py”, line 1098, in execute_sql
cursor.execute(sql, params)
File “/usr/local/lib/python3.6/dist-packages/django/db/backends/utils.py”, line 68, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File “/usr/local/lib/python3.6/dist-packages/django/db/backends/utils.py”, line 77, in _execute_with_wrappers
return executor(sql, params, many, context)
File “/usr/local/lib/python3.6/dist-packages/django/db/backends/utils.py”, line 85, in _execute
return self.cursor.execute(sql, params)
File “/usr/local/lib/python3.6/dist-packages/django/db/utils.py”, line 89, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File “/usr/local/lib/python3.6/dist-packages/django/db/backends/utils.py”, line 85, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation “auth_user” does not exist
LINE 1: …user".“is_active”, “auth_user”.“date_joined” FROM "auth_user…
^

[BR7]

I found this post that seems similar to what I am trying to work through, except the problem here seems to be with the purchased installer running on Ubuntu 16.04 Server and I am trying to run WebODM in a Docker container on Ubuntu 18.04 Desktop… saving here for future reference if nothing else.

Fresh Install - ProgrammingError

Hello. I just did a fresh install of Ubuntu Server 16.04 LTS and using the WebODM Ubuntu Server Installer that I purchased to install. The Installer seems to run fine and finishes without an issue. When I load the URL in the browser I get the following error. I’d like some guidance as to what needs done to fix this. ProgrammingError at / relation “auth_user” does not exist LINE 1: SELECT COUNT() AS “__count” FROM “auth_user” WHERE "auth_us… ^ Request Method: GET Request URL: http://192.168…

[BR7]

Trying to work through the instructions here that point to the database migrations in Django having problems:

Fresh Install - ProgrammingError

Hey @kconley for some reason it looks like the database migrations did not run. Make sure that the PostgreSQL database is running via: sudo systemctl status postgresql It should indicate “Status: Running”. Then run the following: cd /webodm sudo su odm git pull origin master source python3-venv/bin/activate npm install pip install -r requirements.txt webpack --mode production python manage.py collectstatic --noinput python manage.py migrate

The instructions are as follows:

cd /webodm
sudo su odm
git pull origin master
source python3-venv/bin/activate
npm install
pip install -r requirements.txt
webpack --mode production
python manage.py collectstatic --noinput
python manage.py migrate

The first problem I run into is I have no odm user on my system; I remember seeing this user in the instructions for running the software as a service on Ubuntu 16.04, but not in the installation for Ubuntu instructions I started with… assuming I do not need to create user odm, moving on to next step.

‘git pull origin master’ returns
From GitHub - OpenDroneMap/WebODM: User-friendly, commercial-grade software for processing aerial imagery. 🛩

• branch master → FETCH_HEAD
  Already up to date.

Next, issuing ‘source python3-venv/bin/activate’ from /webodm as $user returns ‘bash: python3-venv/bin/activate: No such file or directory’

I am sure this might be an easier problem to solve if I were better versed in Linux and python, but I am working with the knowledge and skill I have so…

[BR7]

After reading through the Docker installation here: ‘Install Docker Engine on Ubuntu | Docker Documentation’ I decided to uninstall Docker and reinstall using their repository after removing the old installation and all images, containers and volumes (I hadn’t previously used Docker for anything so nothing lost except the non-functioning WebODM install).

I guess I had a previous installation through the apt repositories that was stepping on my attempts at getting Docker up and running correctly with WebODM; after reinstalling Docker, removing my WebODM root directory and following the installation steps at ‘https://docs.opendronemap.org/installation.html#linux’ I now have a working copy of WebODM.