Upgrade syntax error at or near "WITH ORDINALITY"

[Lon1]

Environment

• Python version: 3.6.8
• NetBox version: 2.10.2
• Centos7.8.2003
• VirtualBox 6.1.16r140961 (Qt5.6.2)

Steps to Reproduce

1. Fresh install of 2.10.2 on Centos7.8.2003 with Napalm as requirement, followed instructions in NetBox docs down to the upgrade.sh
2. sudo /opt/netbox/upgrade.sh

to complete without errors

[centos@centos7 netbox]$ sudo /opt/netbox/upgrade.sh
Creating a new virtual environment at /opt/netbox-2.10.2/venv...
Installing Python system packages (pip3 install wheel)...
Collecting wheel
Downloading https://files.pythonhosted.org/packages/65/63/39d04c74222770ed1589c0eaba06c05891801219272420b40311cd60c880/wheel-0.36.2-py2.py3-none-any.whl
Installing collected packages: wheel
Successfully installed wheel-0.36.2
You are using pip version 9.0.3, however version 20.3.3 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
Installing core dependencies (pip3 install -r requirements.txt)...
Collecting Django==3.1.3 (from -r requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/7f/17/16267e782a30ea2ce08a9a452c1db285afb0ff226cfe3753f484d3d65662/Django-3.1.3-py3-none-any.whl (7.8MB)
100% |████████████████████████████████| 7.8MB 91kB/s
Collecting django-cacheops==5.1 (from -r requirements.txt (line 2))
Downloading https://files.pythonhosted.org/packages/5d/0c/530f4f32e770c1f0df3ecc988f97ef548ae59ce5a49caae8bcad96afcaec/django_cacheops-5.1-py2.py3-none-any.whl
Collecting django-cors-headers==3.5.0 (from -r requirements.txt (line 3))
Downloading https://files.pythonhosted.org/packages/51/99/41898d5eddb68bc5545c08f5315e00d6036cc6f1aba5fd824042dd1b04ea/django_cors_headers-3.5.0-py3-none-any.whl
Collecting django-debug-toolbar==3.1.1 (from -r requirements.txt (line 4))
Downloading https://files.pythonhosted.org/packages/22/14/864c8805134fa25a8165f895c630cdd08d8ae4dd2d3557878624a9f686d2/django_debug_toolbar-3.1.1-py3-none-any.whl (197kB)
100% |████████████████████████████████| 204kB 1.7MB/s
Collecting django-filter==2.4.0 (from -r requirements.txt (line 5))
Downloading https://files.pythonhosted.org/packages/71/2b/b2fe483c3095b6222725dd05f9ad9e6ed6cb7347c154fdbd80238d36f1a8/django_filter-2.4.0-py3-none-any.whl (73kB)
100% |████████████████████████████████| 81kB 1.1MB/s
Collecting django-mptt==0.11.0 (from -r requirements.txt (line 6))
Downloading https://files.pythonhosted.org/packages/83/86/78a64e1aa72dc6156a1a4f1f830564c932b0900460607def7ccd56a1df80/django_mptt-0.11.0-py2.py3-none-any.whl (109kB)
100% |████████████████████████████████| 112kB 1.1MB/s
Collecting django-pglocks==1.0.4 (from -r requirements.txt (line 7))
Downloading https://files.pythonhosted.org/packages/59/76/2c7d104151316077dcaa103e1d5652ded6c32798c8d706570fb7b48385cb/django-pglocks-1.0.4.tar.gz
Collecting django-prometheus==2.1.0 (from -r requirements.txt (line 8))
Downloading https://files.pythonhosted.org/packages/9b/1b/af5e3c82da897618c90836e7ff3c17f6c3f1dfb82ba33cc20815b2a1f8be/django_prometheus-2.1.0-py2.py3-none-any.whl
Collecting django-rq==2.4.0 (from -r requirements.txt (line 9))
Downloading https://files.pythonhosted.org/packages/53/bb/fb8306b3cba7f6cbae57a1f4d17c3abd4aeb767c1febf97cf1d38d3c724f/django_rq-2.4.0-py2.py3-none-any.whl (46kB)
100% |████████████████████████████████| 51kB 210kB/s
Collecting django-tables2==2.3.3 (from -r requirements.txt (line 10))
Downloading https://files.pythonhosted.org/packages/dd/1d/27bcbfe4dc80c2e38ee80f2d2a35555a00b44731f6155c60a214a4494490/django_tables2-2.3.3-py2.py3-none-any.whl (91kB)
100% |████████████████████████████████| 92kB 1.1MB/s
Collecting django-taggit==1.3.0 (from -r requirements.txt (line 11))
Downloading https://files.pythonhosted.org/packages/56/3e/dde2d7151bc0c4ac65d225e611a85e54a897c551507e8eca2c06a083f3f4/django_taggit-1.3.0-py3-none-any.whl (45kB)
100% |████████████████████████████████| 51kB 1.0MB/s
Collecting django-timezone-field==4.0 (from -r requirements.txt (line 12))
Downloading https://files.pythonhosted.org/packages/b3/23/ac06d9dcc9450b8ed51a7f861630b5ae4c1779c53401c83703fb87fbef39/django_timezone_field-4.0-py3-none-any.whl
Collecting djangorestframework==3.12.2 (from -r requirements.txt (line 13))
Downloading https://files.pythonhosted.org/packages/8e/42/4cd19938181a912150e55835109b1933be26b776f3d4fb186491968dc41d/djangorestframework-3.12.2-py3-none-any.whl (957kB)
100% |████████████████████████████████| 962kB 581kB/s
Collecting drf-yasg[validation]==1.20.0 (from -r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/fc/5c/4584321c7a7fd85429f73fd4c3406b09309e3a071e250177739384a4ab48/drf_yasg-1.20.0-py2.py3-none-any.whl (1.6MB)
100% |████████████████████████████████| 1.6MB 447kB/s
Collecting gunicorn==20.0.4 (from -r requirements.txt (line 15))
Downloading https://files.pythonhosted.org/packages/69/ca/926f7cd3a2014b16870086b2d0fdc84a9e49473c68a8dff8b57f7c156f43/gunicorn-20.0.4-py2.py3-none-any.whl (77kB)
100% |████████████████████████████████| 81kB 1.4MB/s
Collecting Jinja2==2.11.2 (from -r requirements.txt (line 16))
Downloading https://files.pythonhosted.org/packages/30/9e/f663a2aa66a09d838042ae1a2c5659828bb9b41ea3a6efa20a20fd92b121/Jinja2-2.11.2-py2.py3-none-any.whl (125kB)
100% |████████████████████████████████| 133kB 1.1MB/s
Collecting Markdown==3.3.3 (from -r requirements.txt (line 17))
Downloading https://files.pythonhosted.org/packages/ac/ef/24a91ca96efa0d7802dffb83ccc7a3c677027bea19ec3c9ee80be740408e/Markdown-3.3.3-py3-none-any.whl (96kB)
100% |████████████████████████████████| 102kB 1.5MB/s
Collecting netaddr==0.8.0 (from -r requirements.txt (line 18))
Downloading https://files.pythonhosted.org/packages/ff/cd/9cdfea8fc45c56680b798db6a55fa60a22e2d3d3ccf54fc729d083b50ce4/netaddr-0.8.0-py2.py3-none-any.whl (1.9MB)
100% |████████████████████████████████| 1.9MB 289kB/s
Collecting Pillow==8.0.1 (from -r requirements.txt (line 19))
Downloading https://files.pythonhosted.org/packages/5f/19/d4c25111d36163698396f93c363114cf1cddbacb24744f6612f25b6aa3d0/Pillow-8.0.1-cp36-cp36m-manylinux1_x86_64.whl (2.2MB)
100% |████████████████████████████████| 2.2MB 259kB/s
Collecting psycopg2-binary==2.8.6 (from -r requirements.txt (line 20))
Downloading https://files.pythonhosted.org/packages/f2/1b/720b36697158113ca1b2221a8e96a470088ccf3770d182214689d1a96a07/psycopg2_binary-2.8.6-cp36-cp36m-manylinux1_x86_64.whl (3.0MB)
100% |████████████████████████████████| 3.0MB 197kB/s
Collecting pycryptodome==3.9.9 (from -r requirements.txt (line 21))
Downloading https://files.pythonhosted.org/packages/2b/6f/7e38d7c97fbbc3987539c804282c33f56b6b07381bf2390deead696440c5/pycryptodome-3.9.9-cp36-cp36m-manylinux1_x86_64.whl (13.7MB)
100% |████████████████████████████████| 13.7MB 62kB/s
Collecting PyYAML==5.3.1 (from -r requirements.txt (line 22))
Downloading https://files.pythonhosted.org/packages/64/c2/b80047c7ac2478f9501676c988a5411ed5572f35d1beff9cae07d321512c/PyYAML-5.3.1.tar.gz (269kB)
100% |████████████████████████████████| 276kB 1.3MB/s
Collecting svgwrite==1.4 (from -r requirements.txt (line 23))
Downloading https://files.pythonhosted.org/packages/1c/85/1dc25b36c3ac4f3fe285d33065fc0f2ea7bdfb9209d6369e01a3e8ef6252/svgwrite-1.4-py3-none-any.whl (66kB)
100% |████████████████████████████████| 71kB 1.7MB/s
Collecting sqlparse>=0.2.2 (from Django==3.1.3->-r requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/14/05/6e8eb62ca685b10e34051a80d7ea94b7137369d8c0be5c3b9d9b6e3f5dae/sqlparse-0.4.1-py3-none-any.whl (42kB)
100% |████████████████████████████████| 51kB 1.4MB/s
Collecting pytz (from Django==3.1.3->-r requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/89/06/2c2d3034b4d6bf22f2a4ae546d16925898658a33b4400cfb7e2c1e2871a3/pytz-2020.5-py2.py3-none-any.whl (510kB)
100% |████████████████████████████████| 512kB 438kB/s
Collecting asgiref<4,>=3.2.10 (from Django==3.1.3->-r requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/89/49/5531992efc62f9c6d08a7199dc31176c8c60f7b2548c6ef245f96f29d0d9/asgiref-3.3.1-py3-none-any.whl
Collecting six>=1.4.0 (from django-cacheops==5.1->-r requirements.txt (line 2))
Downloading https://files.pythonhosted.org/packages/ee/ff/48bde5c0f013094d729fe4b0316ba2a24774b3ff1c52d924a8a4cb04078a/six-1.15.0-py2.py3-none-any.whl
Collecting funcy<2.0,>=1.8 (from django-cacheops==5.1->-r requirements.txt (line 2))
Downloading https://files.pythonhosted.org/packages/66/89/479de0afbbfb98d1c4b887936808764627300208bb771fcd823403645a36/funcy-1.15-py2.py3-none-any.whl
Collecting redis>=3.0.0 (from django-cacheops==5.1->-r requirements.txt (line 2))
Downloading https://files.pythonhosted.org/packages/a7/7c/24fb0511df653cf1a5d938d8f5d19802a88cef255706fdda242ff97e91b7/redis-3.5.3-py2.py3-none-any.whl (72kB)
100% |████████████████████████████████| 81kB 1.4MB/s
Collecting django-js-asset (from django-mptt==0.11.0->-r requirements.txt (line 6))
Downloading https://files.pythonhosted.org/packages/aa/2d/98089cf51c8e83bc70723021390b94a3638a4a0ce30a47e2e70476b2095d/django_js_asset-1.2.2-py2.py3-none-any.whl
Collecting prometheus-client>=0.7 (from django-prometheus==2.1.0->-r requirements.txt (line 8))
Downloading https://files.pythonhosted.org/packages/f4/7e/ef341c67ed43ad2e39633a35c28b77bc555f9572f4df4fee11c2b467db00/prometheus_client-0.9.0-py2.py3-none-any.whl (53kB)
100% |████████████████████████████████| 61kB 1.7MB/s
Collecting rq>=1.2 (from django-rq==2.4.0->-r requirements.txt (line 9))
Downloading https://files.pythonhosted.org/packages/2e/47/a04457e5ff635d85af9dba41255ba3b23bf97c894c38967ceae0f7652611/rq-1.7.0-py2.py3-none-any.whl (62kB)
100% |████████████████████████████████| 71kB 1.7MB/s
Collecting ruamel.yaml>=0.15.34 (from drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/7e/39/186f14f3836ac5d2a6a042c8de69988770e8b9abb537610edc429e4914aa/ruamel.yaml-0.16.12-py2.py3-none-any.whl (111kB)
100% |████████████████████████████████| 112kB 1.3MB/s
Collecting inflection>=0.3.1 (from drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/59/91/aa6bde563e0085a02a435aa99b49ef75b0a4b062635e606dab23ce18d720/inflection-0.5.1-py2.py3-none-any.whl
Collecting coreapi>=2.3.3 (from drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/fc/3a/9dedaad22962770edd334222f2b3c3e7ad5e1c8cab1d6a7992c30329e2e5/coreapi-2.3.3-py2.py3-none-any.whl
Collecting uritemplate>=3.0.0 (from drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/bf/0c/60d82c077998feb631608dca3cc1fe19ac074e772bf0c24cf409b977b815/uritemplate-3.0.1-py2.py3-none-any.whl
Collecting coreschema>=0.0.4 (from drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/93/08/1d105a70104e078718421e6c555b8b293259e7fc92f7e9a04869947f198f/coreschema-0.0.4.tar.gz
Collecting packaging (from drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/b1/a7/588bfa063e7763247ab6f7e1d994e331b85e0e7d09f853c59a6eb9696974/packaging-20.8-py2.py3-none-any.whl
Collecting swagger-spec-validator>=2.1.0; extra == "validation" (from drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/09/de/e78cefbf5838b434b63a789264b79821cb2267f1498fbed23ef8590133e4/swagger_spec_validator-2.7.3-py2.py3-none-any.whl
Requirement already satisfied: setuptools>=3.0 in ./venv/lib/python3.6/site-packages (from gunicorn==20.0.4->-r requirements.txt (line 15))
Collecting MarkupSafe>=0.23 (from Jinja2==2.11.2->-r requirements.txt (line 16))
Downloading https://files.pythonhosted.org/packages/b2/5f/23e0023be6bb885d00ffbefad2942bc51a620328ee910f64abe5a8d18dd1/MarkupSafe-1.1.1-cp36-cp36m-manylinux1_x86_64.whl
Collecting importlib-metadata; python_version < "3.8" (from Markdown==3.3.3->-r requirements.txt (line 17))
Downloading https://files.pythonhosted.org/packages/7a/85/ac225e35048e050a6351b6f1251cdb2b6060092f2c6840aff1d6319941b1/importlib_metadata-3.3.0-py3-none-any.whl
Collecting importlib-resources; python_version < "3.7" (from netaddr==0.8.0->-r requirements.txt (line 18))
Downloading https://files.pythonhosted.org/packages/09/96/82da534e32f2b3a8ede339b31e053a34a2cbd992d5eb41ccc967bc9b2611/importlib_resources-4.1.0-py3-none-any.whl
Collecting click>=5.0.0 (from rq>=1.2->django-rq==2.4.0->-r requirements.txt (line 9))
Downloading https://files.pythonhosted.org/packages/d2/3d/fa76db83bf75c4f8d338c2fd15c8d33fdd7ad23a9b5e57eb6c5de26b430e/click-7.1.2-py2.py3-none-any.whl (82kB)
100% |████████████████████████████████| 92kB 1.2MB/s
Collecting ruamel.yaml.clib>=0.1.2; platform_python_implementation == "CPython" and python_version < "3.9" (from ruamel.yaml>=0.15.34->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/88/ff/ec25dc01ef04232a9e68ff18492e37dfa01f1f58172e702ad4f38536d41b/ruamel.yaml.clib-0.2.2-cp36-cp36m-manylinux1_x86_64.whl (549kB)
100% |████████████████████████████████| 552kB 469kB/s
Collecting itypes (from coreapi>=2.3.3->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/3f/bb/3bd99c7cd34d4a123b2903e16da364f6d2078b1c3a3530a8ad105c668104/itypes-1.2.0-py2.py3-none-any.whl
Collecting requests (from coreapi>=2.3.3->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/29/c1/24814557f1d22c56d50280771a17307e6bf87b70727d975fd6b2ce6b014a/requests-2.25.1-py2.py3-none-any.whl (61kB)
100% |████████████████████████████████| 61kB 1.8MB/s
Collecting pyparsing>=2.0.2 (from packaging->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/8a/bb/488841f56197b13700afd5658fc279a2025a39e22449b7cf29864669b15d/pyparsing-2.4.7-py2.py3-none-any.whl (67kB)
100% |████████████████████████████████| 71kB 813kB/s
Collecting jsonschema (from swagger-spec-validator>=2.1.0; extra == "validation"->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/c5/8f/51e89ce52a085483359217bc72cdbf6e75ee595d5b1d4b5ade40c7e018b8/jsonschema-3.2.0-py2.py3-none-any.whl (56kB)
100% |████████████████████████████████| 61kB 1.2MB/s
Collecting zipp>=0.5 (from importlib-metadata; python_version < "3.8"->Markdown==3.3.3->-r requirements.txt (line 17))
Downloading https://files.pythonhosted.org/packages/41/ad/6a4f1a124b325618a7fb758b885b68ff7b058eec47d9220a12ab38d90b1f/zipp-3.4.0-py3-none-any.whl
Collecting typing-extensions>=3.6.4; python_version < "3.8" (from importlib-metadata; python_version < "3.8"->Markdown==3.3.3->-r requirements.txt (line 17))
Downloading https://files.pythonhosted.org/packages/60/7a/e881b5abb54db0e6e671ab088d079c57ce54e8a01a3ca443f561ccadb37e/typing_extensions-3.7.4.3-py3-none-any.whl
Collecting certifi>=2017.4.17 (from requests->coreapi>=2.3.3->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/5e/a0/5f06e1e1d463903cf0c0eebeb751791119ed7a4b3737fdc9a77f1cdfb51f/certifi-2020.12.5-py2.py3-none-any.whl (147kB)
100% |████████████████████████████████| 153kB 1.0MB/s
Collecting idna<3,>=2.5 (from requests->coreapi>=2.3.3->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/a2/38/928ddce2273eaa564f6f50de919327bf3a00f091b5baba8dfa9460f3a8a8/idna-2.10-py2.py3-none-any.whl (58kB)
100% |████████████████████████████████| 61kB 2.1MB/s
Collecting chardet<5,>=3.0.2 (from requests->coreapi>=2.3.3->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/19/c7/fa589626997dd07bd87d9269342ccb74b1720384a4d739a1872bd84fbe68/chardet-4.0.0-py2.py3-none-any.whl (178kB)
100% |████████████████████████████████| 184kB 983kB/s
Collecting urllib3<1.27,>=1.21.1 (from requests->coreapi>=2.3.3->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/f5/71/45d36a8df68f3ebb098d6861b2c017f3d094538c0fb98fa61d4dc43e69b9/urllib3-1.26.2-py2.py3-none-any.whl (136kB)
100% |████████████████████████████████| 143kB 1.4MB/s
Collecting attrs>=17.4.0 (from jsonschema->swagger-spec-validator>=2.1.0; extra == "validation"->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/c3/aa/cb45262569fcc047bf070b5de61813724d6726db83259222cd7b4c79821a/attrs-20.3.0-py2.py3-none-any.whl (49kB)
100% |████████████████████████████████| 51kB 1.3MB/s
Collecting pyrsistent>=0.14.0 (from jsonschema->swagger-spec-validator>=2.1.0; extra == "validation"->drf-yasg[validation]==1.20.0->-r requirements.txt (line 14))
Downloading https://files.pythonhosted.org/packages/4d/70/fd441df751ba8b620e03fd2d2d9ca902103119616f0f6cc42e6405035062/pyrsistent-0.17.3.tar.gz (106kB)
100% |████████████████████████████████| 112kB 1.3MB/s
Building wheels for collected packages: django-pglocks, PyYAML, coreschema, pyrsistent
Running setup.py bdist_wheel for django-pglocks ... done
Stored in directory: /root/.cache/pip/wheels/52/36/e4/91f6930d10b2d715454ec59ded09c9e9af7b667ef557fb19ee
Running setup.py bdist_wheel for PyYAML ... done
Stored in directory: /root/.cache/pip/wheels/a7/c1/ea/cf5bd31012e735dc1dfea3131a2d5eae7978b251083d6247bd
Running setup.py bdist_wheel for coreschema ... done
Stored in directory: /root/.cache/pip/wheels/10/7b/ba/04fcd6b33e6123ca11a5f5ab56decb1a2d87ced028377a1377
Running setup.py bdist_wheel for pyrsistent ... done
Stored in directory: /root/.cache/pip/wheels/f0/b8/de/b593ad311be4eb458499d100db081e453576032272398b7ddc
Successfully built django-pglocks PyYAML coreschema pyrsistent
Installing collected packages: sqlparse, pytz, asgiref, Django, six, funcy, redis, django-cacheops, django-cors-headers, django-debug-toolbar, django-filter, django-js-asset, django-mptt, django-pglocks, prometheus-client, django-prometheus, click, rq, django-rq, django-tables2, django-taggit, django-timezone-field, djangorestframework, ruamel.yaml.clib, ruamel.yaml, inflection, MarkupSafe, Jinja2, coreschema, uritemplate, itypes, certifi, idna, chardet, urllib3, requests, coreapi, pyparsing, packaging, attrs, pyrsistent, zipp, typing-extensions, importlib-metadata, jsonschema, PyYAML, swagger-spec-validator, drf-yasg, gunicorn, Markdown, importlib-resources, netaddr, Pillow, psycopg2-binary, pycryptodome, svgwrite
Successfully installed Django-3.1.3 Jinja2-2.11.2 Markdown-3.3.3 MarkupSafe-1.1.1 Pillow-8.0.1 PyYAML-5.3.1 asgiref-3.3.1 attrs-20.3.0 certifi-2020.12.5 chardet-4.0.0 click-7.1.2 coreapi-2.3.3 coreschema-0.0.4 django-cacheops-5.1 django-cors-headers-3.5.0 django-debug-toolbar-3.1.1 django-filter-2.4.0 django-js-asset-1.2.2 django-mptt-0.11.0 django-pglocks-1.0.4 django-prometheus-2.1.0 django-rq-2.4.0 django-tables2-2.3.3 django-taggit-1.3.0 django-timezone-field-4.0 djangorestframework-3.12.2 drf-yasg-1.20.0 funcy-1.15 gunicorn-20.0.4 idna-2.10 importlib-metadata-3.3.0 importlib-resources-4.1.0 inflection-0.5.1 itypes-1.2.0 jsonschema-3.2.0 netaddr-0.8.0 packaging-20.8 prometheus-client-0.9.0 psycopg2-binary-2.8.6 pycryptodome-3.9.9 pyparsing-2.4.7 pyrsistent-0.17.3 pytz-2020.5 redis-3.5.3 requests-2.25.1 rq-1.7.0 ruamel.yaml-0.16.12 ruamel.yaml.clib-0.2.2 six-1.15.0 sqlparse-0.4.1 svgwrite-1.4 swagger-spec-validator-2.7.3 typing-extensions-3.7.4.3 uritemplate-3.0.1 urllib3-1.26.2 zipp-3.4.0
You are using pip version 9.0.3, however version 20.3.3 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
Installing local dependencies (pip3 install -r local_requirements.txt)...
Collecting napalm (from -r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/66/64/9413e85b3b7360d9c32adc3ad13b09454a994d300bc1907d8c8051afb3ae/napalm-3.2.0-py2.py3-none-any.whl (230kB)
100% |████████████████████████████████| 235kB 978kB/s
Collecting lxml>=4.3.0 (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/bd/78/56a7c88a57d0d14945472535d0df9fb4bbad7d34ede658ec7961635c790e/lxml-4.6.2-cp36-cp36m-manylinux1_x86_64.whl (5.5MB)
100% |████████████████████████████████| 5.5MB 141kB/s
Collecting netmiko>=3.1.0 (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/9b/5a/8db044231644359b1542a7d6e423aed7c925e62021c19d3f23256c3567cb/netmiko-3.3.2-py2.py3-none-any.whl (165kB)
100% |████████████████████████████████| 174kB 1.4MB/s
Collecting paramiko>=2.6.0 (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/95/19/124e9287b43e6ff3ebb9cdea3e5e8e88475a873c05ccdf8b7e20d2c4201e/paramiko-2.7.2-py2.py3-none-any.whl (206kB)
100% |████████████████████████████████| 215kB 1.4MB/s
Requirement already satisfied: pyYAML in ./venv/lib/python3.6/site-packages (from napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: requests>=2.7.0 in ./venv/lib/python3.6/site-packages (from napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: jinja2 in ./venv/lib/python3.6/site-packages (from napalm->-r local_requirements.txt (line 1))
Collecting junos-eznc>=2.2.1 (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/69/a7/5680c3ce87923e55247f8ca4b7953cee4af3672c986a229eac38973a8dc3/junos_eznc-2.5.4-py2.py3-none-any.whl (195kB)
100% |████████████████████████████████| 204kB 1.3MB/s
Collecting ciscoconfparse (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/bd/77/8721960202e943dc39b39e799158919648a238a56e23e4b00d43d040502b/ciscoconfparse-1.5.22-py3-none-any.whl (93kB)
100% |████████████████████████████████| 102kB 3.4MB/s
Collecting cffi>=1.11.3 (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/1c/1a/90fa7e7ee05d91d0339ef264bd8c008f57292aba4a91ec512a0bbb379d1d/cffi-1.14.4-cp36-cp36m-manylinux1_x86_64.whl (401kB)
100% |████████████████████████████████| 409kB 539kB/s
Collecting future (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/45/0b/38b06fd9b92dc2b68d58b75f900e97884c45bedd2ff83203d933cf5851c9/future-0.18.2.tar.gz (829kB)
100% |████████████████████████████████| 829kB 651kB/s
Collecting scp (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/b7/37/122d300034f2c8576158a7830e02c687730635e65a95f9eb2b4eb002554d/scp-0.13.3-py2.py3-none-any.whl
Collecting pyeapi>=0.8.2 (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/a2/30/05d37e23c3d718cccf475e6664afae37d96af6601c03d3c6eae4bb480ac4/pyeapi-0.8.4.tar.gz (138kB)
100% |████████████████████████████████| 143kB 1.3MB/s
Requirement already satisfied: setuptools>=38.4.0 in ./venv/lib/python3.6/site-packages (from napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: netaddr in ./venv/lib/python3.6/site-packages (from napalm->-r local_requirements.txt (line 1))
Collecting textfsm (from napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/bd/27/0b149b6da3e47cc8daebace6920093114392171a8f5c24f1f2ad9a9e9c4d/textfsm-1.1.0-py2.py3-none-any.whl
Requirement already satisfied: importlib-resources; python_version < "3.7" in ./venv/lib/python3.6/site-packages (from netmiko>=3.1.0->napalm->-r local_requirements.txt (line 1))
Collecting pyserial (from netmiko>=3.1.0->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/07/bc/587a445451b253b285629263eb51c2d8e9bcea4fc97826266d186f96f558/pyserial-3.5-py2.py3-none-any.whl (90kB)
100% |████████████████████████████████| 92kB 629kB/s
Collecting tenacity (from netmiko>=3.1.0->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/4e/e4/bcaf6978c0811fbb480acc9bd6e024b53390a61d153fa0be4f20a6c80d94/tenacity-6.3.1-py2.py3-none-any.whl
Collecting ntc-templates (from netmiko>=3.1.0->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/a0/d8/a45ce3a139fd5bd30849cadad4a8f0178a98c2ec238d9404b64e5a1599cf/ntc_templates-1.6.0-py3-none-any.whl (261kB)
100% |████████████████████████████████| 266kB 1.4MB/s
Collecting cryptography>=2.5 (from paramiko>=2.6.0->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/7c/b6/1f3dd48a22fcd56f19e6cfa95f74ff0a64b046306354e1bd2b936b7c9ab4/cryptography-3.3.1-cp36-abi3-manylinux1_x86_64.whl (2.7MB)
100% |████████████████████████████████| 2.7MB 191kB/s
Collecting bcrypt>=3.1.3 (from paramiko>=2.6.0->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/52/a7/51ab6481ac355517696477889d8ab232106a0ddadda642c54e47a2ab40b9/bcrypt-3.2.0-cp36-abi3-manylinux1_x86_64.whl (63kB)
100% |████████████████████████████████| 71kB 973kB/s
Collecting pynacl>=1.0.1 (from paramiko>=2.6.0->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/9d/57/2f5e6226a674b2bcb6db531e8b383079b678df5b10cdaa610d6cf20d77ba/PyNaCl-1.4.0-cp35-abi3-manylinux1_x86_64.whl (961kB)
100% |████████████████████████████████| 962kB 582kB/s
Requirement already satisfied: urllib3<1.27,>=1.21.1 in ./venv/lib/python3.6/site-packages (from requests>=2.7.0->napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: certifi>=2017.4.17 in ./venv/lib/python3.6/site-packages (from requests>=2.7.0->napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: chardet<5,>=3.0.2 in ./venv/lib/python3.6/site-packages (from requests>=2.7.0->napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: idna<3,>=2.5 in ./venv/lib/python3.6/site-packages (from requests>=2.7.0->napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: MarkupSafe>=0.23 in ./venv/lib/python3.6/site-packages (from jinja2->napalm->-r local_requirements.txt (line 1))
Collecting ncclient>=0.6.3 (from junos-eznc>=2.2.1->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/72/fd/ccae38393c22099229b68e8cdf061408b824e09ee207e2401c224398c5b0/ncclient-0.6.9.tar.gz (118kB)
100% |████████████████████████████████| 122kB 1.5MB/s
Collecting yamlordereddictloader (from junos-eznc>=2.2.1->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/56/e1/1ca77da64cc355f0de483095e841d96f2366f93b095b83869440a296c21d/yamlordereddictloader-0.4.0.tar.gz
Collecting transitions (from junos-eznc>=2.2.1->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/78/b2/433e58e5e927fbb4ac890e443f4e78b42bf8a4c61e98dfb8feedda1be11b/transitions-0.8.5-py2.py3-none-any.whl (78kB)
100% |████████████████████████████████| 81kB 1.7MB/s
Requirement already satisfied: six in ./venv/lib/python3.6/site-packages (from junos-eznc>=2.2.1->napalm->-r local_requirements.txt (line 1))
Requirement already satisfied: pyparsing in ./venv/lib/python3.6/site-packages (from junos-eznc>=2.2.1->napalm->-r local_requirements.txt (line 1))
Collecting dnspython (from ciscoconfparse->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/90/49/cb426577c28ca3e35332815b795a99e467523843fc83cc85ca0d6be2515a/dnspython-2.0.0-py3-none-any.whl (208kB)
100% |████████████████████████████████| 215kB 1.2MB/s
Collecting colorama (from ciscoconfparse->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/44/98/5b86278fbbf250d239ae0ecb724f8572af1c91f4a11edf4d36a206189440/colorama-0.4.4-py2.py3-none-any.whl
Collecting passlib (from ciscoconfparse->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/3b/a4/ab6b7589382ca3df236e03faa71deac88cae040af60c071a78d254a62172/passlib-1.7.4-py2.py3-none-any.whl (525kB)
100% |████████████████████████████████| 532kB 849kB/s
Collecting pycparser (from cffi>=1.11.3->napalm->-r local_requirements.txt (line 1))
Downloading https://files.pythonhosted.org/packages/ae/e7/d9c3a176ca4b02024debf82342dab36efadfc5776f9c8db077e8f6e71821/pycparser-2.20-py2.py3-none-any.whl (112kB)
100% |████████████████████████████████| 112kB 1.4MB/s
Requirement already satisfied: zipp>=0.4; python_version < "3.8" in ./venv/lib/python3.6/site-packages (from importlib-resources; python_version < "3.7"->netmiko>=3.1.0->napalm->-r local_requirements.txt (line 1))
Building wheels for collected packages: future, pyeapi, ncclient, yamlordereddictloader
Running setup.py bdist_wheel for future ... done
Stored in directory: /root/.cache/pip/wheels/8b/99/a0/81daf51dcd359a9377b110a8a886b3895921802d2fc1b2397e
Running setup.py bdist_wheel for pyeapi ... done
Stored in directory: /root/.cache/pip/wheels/79/ef/6e/dd05ab7877fd5988acde4b4276b8512465931b22c157392a62
Running setup.py bdist_wheel for ncclient ... done
Stored in directory: /root/.cache/pip/wheels/1b/20/84/09123cc69519652708f382d0711c7ee6699130f6a7111ecfef
Running setup.py bdist_wheel for yamlordereddictloader ... done
Stored in directory: /root/.cache/pip/wheels/cf/bd/88/1f973a38d0574e639260c1f381b04435213bf48076a0f495e8
Successfully built future pyeapi ncclient yamlordereddictloader
Installing collected packages: lxml, pycparser, cffi, cryptography, bcrypt, pynacl, paramiko, scp, pyserial, tenacity, future, textfsm, ntc-templates, netmiko, ncclient, yamlordereddictloader, transitions, junos-eznc, dnspython, colorama, passlib, ciscoconfparse, pyeapi, napalm
Successfully installed bcrypt-3.2.0 cffi-1.14.4 ciscoconfparse-1.5.22 colorama-0.4.4 cryptography-3.3.1 dnspython-2.0.0 future-0.18.2 junos-eznc-2.5.4 lxml-4.6.2 napalm-3.2.0 ncclient-0.6.9 netmiko-3.3.2 ntc-templates-1.6.0 paramiko-2.7.2 passlib-1.7.4 pycparser-2.20 pyeapi-0.8.4 pynacl-1.4.0 pyserial-3.5 scp-0.13.3 tenacity-6.3.1 textfsm-1.1.0 transitions-0.8.5 yamlordereddictloader-0.4.0
You are using pip version 9.0.3, however version 20.3.3 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
Applying database migrations (python3 netbox/manage.py migrate)...
Operations to perform:
Apply all migrations: admin, auth, circuits, contenttypes, dcim, extras, ipam, secrets, sessions, taggit, tenancy, users, virtualization
Running migrations:
Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying admin.0002_logentry_remove_auto_add... OK
Applying admin.0003_logentry_add_action_flag_choices... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Applying auth.0007_alter_validators_add_error_messages... OK
Applying auth.0008_alter_user_username_max_length... OK
Applying auth.0009_alter_user_last_name_max_length... OK
Applying auth.0010_alter_group_name_max_length... OK
Applying auth.0011_update_proxy_permissions... OK
Applying auth.0012_alter_user_first_name_max_length... OK
Applying tenancy.0001_initial... OK
Applying tenancy.0002_tenant_group_optional...Traceback (most recent call last):
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.SyntaxError: syntax error at or near "WITH ORDINALITY"
LINE 6: FROM unnest(c.conkey) WITH ORDINALITY co...
^

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

Traceback (most recent call last):
File "netbox/manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/core/management/init.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 330, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 371, in execute
output = self.handle(*args, **options)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 85, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/core/management/commands/migrate.py", line 245, in handle
fake_initial=fake_initial,
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 227, in apply_migration
state = migration.apply(state, schema_editor)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/migrations/operations/fields.py", line 236, in database_forwards
schema_editor.alter_field(from_model, from_field, to_field)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/base/schema.py", line 572, in alter_field
old_db_params, new_db_params, strict)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/postgresql/schema.py", line 168, in _alter_field
new_db_params, strict,
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/base/schema.py", line 584, in _alter_field
fk_names = self._constraint_names(model, [old_field.column], foreign_key=True)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/base/schema.py", line 1188, in _constraint_names
constraints = self.connection.introspection.get_constraints(cursor, model._meta.db_table)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/postgresql/introspection.py", line 167, in get_constraints
""", [table_name])
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/cacheops/transaction.py", line 93, in execute
result = self._no_monkey.execute(self, sql, params)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/netbox-2.10.2/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: syntax error at or near "WITH ORDINALITY"
LINE 6: FROM unnest(c.conkey) WITH ORDINALITY co...
^
[centos@centos7 netbox]$

[aphandoyo]

I have same issue in ver 2.10.4
Is there any solution ?

Thanks you.

[Lon1]

I'll post below my installation process on VirtualBox.

[candlerb]

What version of postgres are you running? Minimum required is 9.6.

[Lon1]

As I recall that was the problem. I'll post my installation process on VirtualBox, which included 9.6.

[Lon1]

Here was my complete installation on VirtualBox CentOS 7, with PostgreSQL 9.6 below:

# Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Install PostgreSQL:
sudo yum install -y postgresql96-server lib-devel

# Init the DB
sudo /usr/pgsql-9.6/bin/postgresql96-setup initdb
# (to remove the db use: $ sudo rm -rf /var/lib/pgsql/9.6/data)

# Modify the path
sudo visudo
# Change line
Defaults    secure_path = /sbin:/bin:/usr/sbin:/usr/bin
# TO
Defaults    secure_path = /sbin:/bin:/usr/sbin:/usr/bin:/usr/pgsql-9.6/bin

# This maybe needed to set the permissions correctly on our home directory
$ sudo chmod og+rX /home/centos
$ sudo chmod og+rX /home

# Verify path
sudo -u postgres printenv PATH

#CentOS configures ident host-based authentication for PostgreSQL by default. Because NetBox will need to authenticate using a username and password, 
#modify /var/lib/pgsql/9.6/data/pg_hba.conf to support MD5 authentication by changing ident to md5 for the lines below:
#
#host    all             all             127.0.0.1/32            md5
#host    all             all             ::1/128                 md5

sudo vi /var/lib/pgsql/9.6/data/pg_hba.conf

sudo systemctl start postgresql-9.6
sudo systemctl enable postgresql-9.6

# Try it out:
sudo -u postgres psql -l

# Database Creation
sudo -u postgres psql
psql (12.5 (Ubuntu 12.5-0ubuntu0.20.04.1))
Type "help" for help.

postgres=# CREATE DATABASE netbox;
CREATE DATABASE
postgres=# CREATE USER netbox WITH PASSWORD 'J5brHrAXFLQSif0K';
CREATE ROLE
postgres=# GRANT ALL PRIVILEGES ON DATABASE netbox TO netbox;
GRANT
postgres=# \q

# Verify installation
# For this verification to work, you need to change 'md5' above to 'trust' and then 'sudo service postgresql-9.6 restart'
sudo psql --username=netbox --password --host=localhost netbox
Password for user netbox: 
psql (12.5 (Ubuntu 12.5-0ubuntu0.20.04.1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

netbox=> \conninfo
You are connected to database "netbox" as user "netbox" on host "localhost" (address "127.0.0.1") at port "5432".
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
netbox=> \q

sudo service postgresql-9.6 restart

# Install Redis
# Good doc - https://www.linode.com/docs/guides/install-and-configure-redis-on-centos-7/
# https://computingforgeeks.com/how-to-install-latest-redis-on-centos-7/
sudo yum install epel-release
# Needed to install on Centos 7.8
sudo yum -y install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
sudo yum --enablerepo=remi install redis
sudo systemctl enable --now redis
sudo systemctl restart redis
sudo systemctl status redis
redis-cli 
> INFO
> exit

# Install System Packages
sudo yum install -y gcc python36 python36-devel python3-pip libxml2-devel libxslt-devel libffi-devel openssl-devel redhat-rpm-config
sudo pip3 install --upgrade pip

# Download NetBox Option "A"
sudo wget https://github.com/netbox-community/netbox/archive/v2.10.3.tar.gz
sudo tar -xzf v2.10.3.tar.gz -C /opt

# Assign symlink
# Make a symlink - easy to change to other versions by changing the link
sudo rm -i /opt/netbox
sudo ln -s /opt/netbox-2.10.3 /opt/netbox/
ls -l /opt | grep netbox
lrwxrwxrwx  1 root root         13 Jul 20 13:44 netbox -> netbox-2.9.0/
drwxr-xr-x  2 root root       4096 Jul 20 13:44 netbox-2.9.0

# Create the NetBox System User
sudo groupadd --system netbox
sudo adduser --system -g netbox netbox
sudo chown --recursive netbox /opt/netbox/netbox/media/

# Configuration
cd /opt/netbox/netbox/netbox/
sudo cp configuration.example.py configuration.py
# Generate a secret key and add to the configuration.py below
python3 ../generate_secret_key.py
sudo vi configuration.py
# Make Changes to:
# ALLOWED_HOSTS = ['netbox.example.com', '192.0.2.123'] 
# OR
# ALLOWED_HOSTS = ['*']
# DATABASE = {
#    'NAME': 'netbox',               # Database name
#    'USER': 'netbox',               # PostgreSQL username
#    'PASSWORD': 'J5brHrAXFLQSif0K', # PostgreSQL password
#    'HOST': 'localhost',            # Database server
#    'PORT': '',                     # Database port (leave blank for default)
#    'CONN_MAX_AGE': 300,            # Max database connection age (seconds)
#}
#
# REDIS = {
#    'tasks': {
#        'HOST': 'localhost',      # Redis server
#        'PORT': 6379,             # Redis port
#        'PASSWORD': '',           # Redis password (optional)
#        'DATABASE': 0,            # Database ID
#        'SSL': False,             # Use SSL (optional)
#    },
#    'caching': {
#        'HOST': 'localhost',
#        'PORT': 6379,
#        'PASSWORD': '',
#        'DATABASE': 1,            # Unique ID for second database
#        'SSL': False,
#    }
#}
#
# 

# Add Napalm requirement
sudo su
echo napalm >> /opt/netbox/local_requirements.txt
exit

# Run the Upgrade Script
sudo /opt/netbox/upgrade.sh

source /opt/netbox/venv/bin/activate
(venv) $ cd /opt/netbox/netbox
(venv) $ python3 manage.py createsuperuser
Username: admin
Email address: name@mydomain.com
Password: admin
Password (again): admin
Superuser created successfully.

(venv) $ python3 manage.py runserver 0.0.0.0:8000 --insecure
Performing system checks...

System check identified no issues (0 silenced).
November 17, 2020 - 16:08:13
Django version 3.1.3, using settings 'netbox.settings'
Starting development server at http://0.0.0.0:8000/
Quit the server with CONTROL-C.

Next, connect to the name or IP of the server (as defined in ALLOWED_HOSTS) on port 8000; 
for example, http://127.0.0.1:8000/. You should be greeted with the NetBox home page.

[Lon1]

Thank you! Not used to this here ;)

[DanSheps]

Did this run properly after the fact?

[Lon1]

As far as I can tell at the moment. It was meant for a developer/test environment only. It is far from being workable in production. Did you try it?

[aphandoyo]

Here was my complete installation on VirtualBox CentOS 7, with PostgreSQL 9.6 below:

# Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Install PostgreSQL:
sudo yum install -y postgresql96-server lib-devel

# Init the DB
sudo /usr/pgsql-9.6/bin/postgresql96-setup initdb
# (to remove the db use: $ sudo rm -rf /var/lib/pgsql/9.6/data)

# Modify the path
sudo visudo
# Change line
Defaults    secure_path = /sbin:/bin:/usr/sbin:/usr/bin
# TO
Defaults    secure_path = /sbin:/bin:/usr/sbin:/usr/bin:/usr/pgsql-9.6/bin

# This maybe needed to set the permissions correctly on our home directory
$ sudo chmod og+rX /home/centos
$ sudo chmod og+rX /home

# Verify path
sudo -u postgres printenv PATH

#CentOS configures ident host-based authentication for PostgreSQL by default. Because NetBox will need to authenticate using a username and password, 
#modify /var/lib/pgsql/9.6/data/pg_hba.conf to support MD5 authentication by changing ident to md5 for the lines below:
#
#host    all             all             127.0.0.1/32            md5
#host    all             all             ::1/128                 md5

sudo vi /var/lib/pgsql/9.6/data/pg_hba.conf

sudo systemctl start postgresql-9.6
sudo systemctl enable postgresql-9.6

# Try it out:
sudo -u postgres psql -l

# Database Creation
sudo -u postgres psql
psql (12.5 (Ubuntu 12.5-0ubuntu0.20.04.1))
Type "help" for help.

postgres=# CREATE DATABASE netbox;
CREATE DATABASE
postgres=# CREATE USER netbox WITH PASSWORD 'J5brHrAXFLQSif0K';
CREATE ROLE
postgres=# GRANT ALL PRIVILEGES ON DATABASE netbox TO netbox;
GRANT
postgres=# \q

# Verify installation
# For this verification to work, you need to change 'md5' above to 'trust' and then 'sudo service postgresql-9.6 restart'
sudo psql --username=netbox --password --host=localhost netbox
Password for user netbox: 
psql (12.5 (Ubuntu 12.5-0ubuntu0.20.04.1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

netbox=> \conninfo
You are connected to database "netbox" as user "netbox" on host "localhost" (address "127.0.0.1") at port "5432".
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
netbox=> \q

sudo service postgresql-9.6 restart

# Install Redis
# Good doc - https://www.linode.com/docs/guides/install-and-configure-redis-on-centos-7/
# https://computingforgeeks.com/how-to-install-latest-redis-on-centos-7/
sudo yum install epel-release
# Needed to install on Centos 7.8
sudo yum -y install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
sudo yum --enablerepo=remi install redis
sudo systemctl enable --now redis
sudo systemctl restart redis
sudo systemctl status redis
redis-cli 
> INFO
> exit

# Install System Packages
sudo yum install -y gcc python36 python36-devel python3-pip libxml2-devel libxslt-devel libffi-devel openssl-devel redhat-rpm-config
sudo pip3 install --upgrade pip

# Download NetBox Option "A"
sudo wget https://github.com/netbox-community/netbox/archive/v2.10.3.tar.gz
sudo tar -xzf v2.10.3.tar.gz -C /opt

# Assign symlink
# Make a symlink - easy to change to other versions by changing the link
sudo rm -i /opt/netbox
sudo ln -s /opt/netbox-2.10.3 /opt/netbox/
ls -l /opt | grep netbox
lrwxrwxrwx  1 root root         13 Jul 20 13:44 netbox -> netbox-2.9.0/
drwxr-xr-x  2 root root       4096 Jul 20 13:44 netbox-2.9.0

# Create the NetBox System User
sudo groupadd --system netbox
sudo adduser --system -g netbox netbox
sudo chown --recursive netbox /opt/netbox/netbox/media/

# Configuration
cd /opt/netbox/netbox/netbox/
sudo cp configuration.example.py configuration.py
# Generate a secret key and add to the configuration.py below
python3 ../generate_secret_key.py
sudo vi configuration.py
# Make Changes to:
# ALLOWED_HOSTS = ['netbox.example.com', '192.0.2.123'] 
# OR
# ALLOWED_HOSTS = ['*']
# DATABASE = {
#    'NAME': 'netbox',               # Database name
#    'USER': 'netbox',               # PostgreSQL username
#    'PASSWORD': 'J5brHrAXFLQSif0K', # PostgreSQL password
#    'HOST': 'localhost',            # Database server
#    'PORT': '',                     # Database port (leave blank for default)
#    'CONN_MAX_AGE': 300,            # Max database connection age (seconds)
#}
#
# REDIS = {
#    'tasks': {
#        'HOST': 'localhost',      # Redis server
#        'PORT': 6379,             # Redis port
#        'PASSWORD': '',           # Redis password (optional)
#        'DATABASE': 0,            # Database ID
#        'SSL': False,             # Use SSL (optional)
#    },
#    'caching': {
#        'HOST': 'localhost',
#        'PORT': 6379,
#        'PASSWORD': '',
#        'DATABASE': 1,            # Unique ID for second database
#        'SSL': False,
#    }
#}
#
# 

# Add Napalm requirement
sudo su
echo napalm >> /opt/netbox/local_requirements.txt
exit

# Run the Upgrade Script
sudo /opt/netbox/upgrade.sh

source /opt/netbox/venv/bin/activate
(venv) $ cd /opt/netbox/netbox
(venv) $ python3 manage.py createsuperuser
Username: admin
Email address: name@mydomain.com
Password: admin
Password (again): admin
Superuser created successfully.

(venv) $ python3 manage.py runserver 0.0.0.0:8000 --insecure
Performing system checks...

System check identified no issues (0 silenced).
November 17, 2020 - 16:08:13
Django version 3.1.3, using settings 'netbox.settings'
Starting development server at http://0.0.0.0:8000/
Quit the server with CONTROL-C.

Next, connect to the name or IP of the server (as defined in ALLOWED_HOSTS) on port 8000; 
for example, http://127.0.0.1:8000/. You should be greeted with the NetBox home page.

Impressive.
It works. 👍
Thank you @Lon1

[centaur0927]

solove my problem, thankyou@Lon1