NETBOX Upgrade

[umarkhan99]

Hello,
I am trying to upgrade Netbox to the latest version. I have installed Python version 3.9.6 in the /usr/bin directory. When I put the source for python to be /usr/bin/Python3.9, it gives an error saying it is a directory.

sudo PYTHON=/usr/bin/python3.8 ./upgrade.sh

NOTE: I installed python using the link below
https://phoenixnap.com/kb/how-to-install-python-3-centos-7

WHen I run python3.9 --version, I do show the latest version I installed. However, here is the error I get

/upgrade.sh: line 15: /usr/bin/Python-3.9.6: Is a directory                                                                                                                                        
./upgrade.sh: line 16: /usr/bin/Python-3.9.6: Is a directory                                                                                                                                        
--------------------------------------------------------------------                                                                                                                                
ERROR: Unsupported Python version: . NetBox requires                                                                                                                                                
Python 3.8 or later. To specify an alternate Python executable, set                                                                                                                                 
the PYTHON environment variable. For example:                                                                                                                                                       
                                                                                                                                                                                                    
  sudo PYTHON=/usr/bin/python3.8 ./upgrade.sh                                                                                                                                                       
                                                                                                                                                                                                    
To show your current Python version: /usr/bin/Python-3.9.6 -V                                                                                                                                       
--------------------------------------------------------------------

[candlerb]

The error says it's a directory, so I believe it.

WHen I run python3.9 --version, I do show the latest version I installed.

What do you see if you type these commands:

which python3.9
ls -ld /usr/bin/Python-3.9.6
ls -l /usr/bin/Python-3.9.6

NOTE: I installed python using the link below
https://phoenixnap.com/kb/how-to-install-python-3-centos-7

There are two different approaches in that post: one is to install new yum packages, and one is to install from source. Which did you use?

I have a suspicion that you untarred the source code tarball inside the /usr/bin directory (which is not the right place to put a source bundle; use your home directory).

[umarkhan99]

I get this
I am using the second option

/usr/local/bin/python3.9                                                                                                                                                                            
[root@local~]# ls -ld /usr/bin/Python-3.9.6                                                                                                                                                  
drwxrwxr-x. 17 1000 1000 4096 Jun 30 13:50 /usr/bin/Python-3.9.6                                                                                                                                    
[root@local~]# ls -l /usr/bin/Python-3.9.6                                                                                                                                                   
total 53016                                                                                                                                                                                         
-rw-rw-r--.  1 1000 1000    20687 Jun 28  2021 aclocal.m4                                                                                                                                           
drwxr-xr-x.  5 root root       82 Jun 30 13:06 build                                                                                                                                                
-rw-rw-r--.  1 1000 1000      630 Jun 28  2021 CODE_OF_CONDUCT.md                                                                                                                                   
-rwxrwxr-x.  1 1000 1000    44166 Jun 28  2021 config.guess                                                                                                                                         
-rw-r--r--.  1 root root   997469 Jun 30 13:50 config.log                                                                                                                                           
-rwxr-xr-x.  1 root root    41598 Jun 30 13:50 config.status                                                                                                                                        
-rwxrwxr-x.  1 1000 1000    36251 Jun 28  2021 config.sub                                                                                                                                           
-rwxrwxr-x.  1 1000 1000   513952 Jun 28  2021 configure                                                                                                                                            
-rw-rw-r--.  1 1000 1000   174676 Jun 28  2021 configure.ac                                                                                                                                         
drwxrwxr-x. 18 1000 1000     4096 Jun 28  2021 Doc                                                                                                                                                  
drwxrwxr-x.  2 1000 1000       54 Jun 28  2021 Grammar                                                                                                                                              
drwxrwxr-x.  4 1000 1000     4096 Jun 28  2021 Include                                                                                                                                              
-rwxrwxr-x.  1 1000 1000    15368 Jun 28  2021 install-sh                                                                                                                                           
drwxrwxr-x. 35 1000 1000     8192 Jun 30 13:06 Lib                                                                                                                                                  
-rw-r--r--.  1 root root 33917064 Jun 30 13:50 libpython3.9.a                                                                                                                                       
-rw-rw-r--.  1 1000 1000    13925 Jun 28  2021 LICENSE                                                                                                                                              
drwxrwxr-x.  8 1000 1000      164 Jun 28  2021 Mac                                                                                                                                                  
-rw-r--r--.  1 root root    80644 Jun 30 13:50 Makefile                                                                                                                                             
-rw-r--r--.  1 root root    71286 Jun 30 13:50 Makefile.pre                                                                                                                                         
-rw-rw-r--.  1 1000 1000    71540 Jun 28  2021 Makefile.pre.in                                                                                                                                      
drwxrwxr-x.  2 1000 1000     4096 Jun 30 13:50 Misc                                                                                                                                                 
drwxrwxr-x. 14 1000 1000     8192 Jun 30 13:50 Modules                                                                                                                                              
-rw-rw-r--.  1 1000 1000       82 Jun 28  2021 netlify.toml                                                                                                                                         
drwxrwxr-x.  4 1000 1000     4096 Jun 30 13:05 Objects                                                                                                                                              
drwxrwxr-x.  4 1000 1000     4096 Jun 30 13:04 Parser                                                                                                                                               
drwxrwxr-x.  6 1000 1000     4096 Jun 28  2021 PC                                                                                                                                                   
drwxrwxr-x.  2 1000 1000     8192 Jun 28  2021 PCbuild                                                                                                                                              
drwxrwxr-x.  2 1000 1000      137 Jun 30 13:50 Programs                                                                                                                                             
-rw-r--r--.  1 root root       26 Jun 30 13:50 pybuilddir.txt                                                                                                                                       
-rw-r--r--.  1 root root    47923 Jun 30 13:04 pyconfig.h                                                                                                                                           
-rw-rw-r--.  1 1000 1000    45702 Jun 28  2021 pyconfig.h.in                                                                                                                                        
-rwxr-xr-x.  1 root root 17879912 Jun 30 13:50 python                                                                                                                                               
drwxrwxr-x.  3 1000 1000     4096 Jun 30 13:50 Python                                                                                                                                               
-rw-r--r--.  1 root root     3087 Jun 30 13:50 python-config                                                                                                                                        
-rw-r--r--.  1 root root     2043 Jun 30 13:50 python-config.py                                                                                                                                     
-rw-r--r--.  1 root root    65392 Jun 30 13:06 python-gdb.py                                                                                                                                        
-rw-rw-r--.  1 1000 1000    10140 Jun 28  2021 README.rst                                                                                                                                           
-rw-rw-r--.  1 1000 1000   110067 Jun 28  2021 setup.py                                                                                                                                             
drwxrwxr-x. 23 1000 1000     4096 Jun 28  2021 Tools            ```


Yes, first I untarred it in the tmp directory but after facing this issue I moved it to /usr/bin directory. What should I do? or how do I find python3.9's source file to add when running the upgrade script.

Thanks for you help on this!

[candlerb]

# which python3.9
/usr/local/bin/python3.9

That's telling you where your python3.9 binary is. Hence you need:

sudo PYTHON=/usr/local/bin/python3.9 ./upgrade.sh

(note the /local/ in the path).

The directory /usr/bin/python3.9.6 should be moved somewhere else, such as to /var/tmp or your home directory, or even just deleted if you're sure it's all installed properly. Directories of source code don't belong in /usr/bin.

However, really this isn't a Netbox problem, this is a system administration problem. You might be best finding someone locally who is an experienced system administrator and can sit beside you and help you with this sort of thing.

[candlerb]

Aside: if you can edit your post, and put three backticks (```) on a line of their own before and after the screendump you posted, it should format in a way that's much easier to read.

[umarkhan99]

Now I am getting this error on the web page.

Server Error
A database programming error was detected while processing this request. Common causes include the following:

Database migrations missing - When upgrading to a new NetBox release, the upgrade script must be run to apply any new database migrations. You can run migrations manually by executing python3 manage.py migrate from the command line.

Unsupported PostgreSQL version - Ensure that PostgreSQL version 10 or later is in use. You can check this by connecting to the database using NetBox's credentials and issuing a query for SELECT VERSION().

The complete exception is provided below:

<class 'django.db.utils.ProgrammingError'>

column extras_customfield.created does not exist
LINE 1: SELECT "extras_customfield"."id", "extras_customfield"."crea...
^

Python version: 3.9.6
NetBox version: 3.2.5
If further assistance is required, please post to the NetBox discussion forum on GitHub.

Home Page

[umarkhan99]

I am running postgres version 9.2....how do I upgrade it to 10 please?

[candlerb]

That's a postgres / system administration question.

One of the problems with running an old OS like CentOS 7 (which was released in 2014) is that it comes with old versions of much software in its standard package repos.

Therefore, you can either try to find newer Postgres packages for CentOS 7; or you can look at rebuilding this system from scratch with a newer OS. (I don't think there's an "official" in-place upgrade from CentOS 7 as far as I know)

CentOS 7 goes end-of-life in 2024 anyway, so this may be a good time to consider a rebuild.

The other Netbox requirement is Redis 4.0+, so you should check that as well.

[candlerb]

However: the exception that you showed doesn't appear to be because you have Postgres < 10.

Are you're upgrading from a version of Netbox older than 2.11.0? If so, you must first upgrade to 2.11.X (e.g. 2.11.12), and only then can you upgrade to 3.X.

This is because the database migrations were "squashed" in 3.0, and it only knows how to migrate from 2.11 or later.

[umarkhan99]

Gotcha.....I was upgrading from 2. something to the latest version. I will upgrade to 2.11.12 and see what happens. Thanks for your continous help!!

[umarkhan99]

I tried sudo git checkout v2.11.12 but it is not pulling the source code...any suggestions?

[umarkhan99]

How do I check the current version of netbox installed? I think I upgraded to v2.11.12

[umarkhan99]

I was able to upgrade it now....thank you so much!