Installing / Upgrading Netbox 4.4.1 issues

[wriplee]

Hello, I have followed the detailed instruction to install Netbox 4.4.1 in my home lab

Linux crabby 6.14.0-29-generic #29~24.04.1-Ubuntu SMP PREEMPT_DYNAMIC Thu Aug 14 16:52:50 UTC 2 x86_64 x86_64 x86_64 GNU/Linux

each time I run the /opt/netbox/upgrade.sh script, I get the following errors related to django. I have spent quite of time trying to figure this out, I am not sure which user does not have permission to the schema public; , or if there is something I missed in the install process

rripley@crabby:/opt/netbox/netbox$ sudo /opt/netbox/upgrade.sh
You are installing (or upgrading to) NetBox version 4.4.1
Using Python 3.12.3
Removing old virtual environment...
Creating a new virtual environment at /opt/netbox-4.4.1/venv...
Updating pip (pip install --upgrade pip)...
Requirement already satisfied: pip in ./venv/lib/python3.12/site-packages (24.0)
Collecting pip
Using cached pip-25.2-py3-none-any.whl.metadata (4.7 k
.
.
.
Operations to perform:
Apply all migrations: account, auth, circuits, contenttypes, core, dcim, django_rq, extras, ipam, sessions, social_django, taggit, tenancy, thumbnail, users, virtualization, vpn, wireless
Running migrations:
Traceback (most recent call last):
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 103, in _execute
return self.cursor.execute(sql)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/psycopg/cursor.py", line 97, in execute
raise ex.with_traceback(None)
psycopg.errors.InsufficientPrivilege: permission denied for schema public
LINE 1: CREATE TABLE "django_migrations" ("id" bigint NOT NULL PRIMA...
^

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

Traceback (most recent call last):
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/migrations/recorder.py", line 78, in ensure_schema
editor.create_model(self.Migration)
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/base/schema.py", line 512, in create_model
self.execute(sql, params or None)
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/postgresql/schema.py", line 45, in execute
return super().execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/base/schema.py", line 204, in execute
cursor.execute(sql, params)
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 79, in execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 100, in _execute
with self.db.wrap_database_errors:
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 103, in _execute
return self.cursor.execute(sql)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox-4.4.1/venv/lib/python3.12/site-packages/psycopg/cursor.py", line 97, in execute
raise ex.with_traceback(None)
django.db.utils.ProgrammingError: permission denied for schema public
LINE 1: CREATE TABLE "django_migrations" ("id" bigint NOT NULL PRIMA...
^

[wriplee]

Issues resolved. i missed one tiny but important step:

\connect netbox;
GRANT CREATE ON SCHEMA public TO netbox;