I want to upgrade ERPNext version 13.2.0 to 13.25

pradpreeonline · April 18, 2022, 4:29am

Hi,

I have the docker version of ERPNext ver: 13.2 installed in a ubuntu 20.04 VM in VirtualBox. MariaDB version is 10.3. This is a production environment. I would like to upgrade it to 13.25.

Can someone please explain what’s the best way to upgrade it to 13.25 safely without loosing any data? Will it also upgrade the Maria DB DB version? If not, is it a good idea to upgrade the DB too? If so, how?

My 2nd question is docker version of ErpNext good for production?

Thanks for your time in advance.

revant_one · April 18, 2022, 4:49am

can you share the docker-compose used to setup the v13.2.0

pradpreeonline · April 18, 2022, 5:00am

It was originally installed through a vagrant script and this is what I have in the script:

config.vm.provision “shell”, inline: <<-SHELL
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo apt update
sudo apt install apt-transport-https ca-certificates curl software-properties-common docker-compose -y
cd /root/
git clone GitHub - frappe/frappe_docker: Docker images for production and development setups of the Frappe framework and ERPNext
echo “LETSENCRYPT_EMAIL=email@example.com
ERPNEXT_VERSION=v13.2.0
FRAPPE_VERSION=v13.2.0
MARIADB_HOST=mariadb
…
INSTALL_APPS=erpnext
ENTRYPOINT_LABEL=traefik.http.routers.erpnext-nginx.entrypoints=websecure
CERT_RESOLVER_LABEL=traefik.http.routers.erpnext-nginx.tls.certresolver=myresolver
HTTPS_REDIRECT_RULE_LABEL=traefik.http.routers.http-catchall.rule=hostregexp({host:.+})
HTTPS_REDIRECT_ENTRYPOINT_LABEL=traefik.http.routers.http-catchall.entrypoints=web
HTTPS_REDIRECT_MIDDLEWARE_LABEL=traefik.http.routers.http-catchall.middlewares=redirect-to-https
HTTPS_USE_REDIRECT_MIDDLEWARE_LABEL=traefik.http.middlewares.redirect-to-https.redirectscheme.scheme=https
SKIP_NGINX_TEMPLATE_GENERATION=0” > /root/frappe_docker/.env
cd /root/frappe_docker/
docker-compose up -d

I tried changing the version here in the script but that didn’t do any good. After upgrade When I tried to log in, I saw INTERNAL SERVER ERROR.

pradpreeonline · April 19, 2022, 4:31am

Hello @revant_one, any recommendation?

revant_one · April 19, 2022, 5:08am

backup your files.

create fresh new installation.

restore backup.

I’ve never used any scripts to install ERPNext with containers

pradpreeonline · April 19, 2022, 5:24am

You mean run a site backup like this on the existing v13.2 and restore it on v13.25?

frappe@27c5ce9a650d:~/frappe-bench/sites$ bench --site example.com backup

frappe@97b2d7c1e09f:~/frappe-bench/sites$ bench --site example.com restore ./example.com/private/backups/20220414_085911-example_com-database.sql.gz

If yes, I already have tried without success. I believe I got an Internal Server Error when I tried to access erpnext after restoring.
I thought it could be due to the mismatch version of both Erpnext (13.2 vs 13.25) and Maria DB (10.3 vs 10.6)

What’s the correct way of upgrading from a lower version to higher?

revant_one · April 19, 2022, 7:08am

how did you install latest, there was a refactor, the script you used won’t work now after the refactor.

I cannot debug your VM. I won’t be able to help much.

I helped this post as access to the server was shared with me

pradpreeonline · April 19, 2022, 6:41pm

@revant_one, Thank you for the clarifications, I really appreciate it. It appears now that the way I was upgrading from 13.2 to 13.26 was wrong. I was simply taking docker containers down and changing the version in the .env environment variable file from 13.2 to 13.26 which wasn’t doing much as you confirmed that it wouldn’t work with the new version.

These are the steps I followed to install the new version:

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo apt update
sudo apt install apt-transport-https ca-certificates curl software-properties-common docker-compose -y
cd /root/
git clone GitHub - frappe/frappe_docker: Docker images for production and development setups of the Frappe framework and ERPNext
cd /root/frappe_docker/
docker-compose up -d

I immediately saw the env-production file that used to be readily available is no longer available for the production and I see an example.env file in there. I also see the docker-compose.yml file is gone from the /frappe_docker/ directory and there are two new files compose.yml and pwd.yml.

I’m not sure of my installation is complete as I cannot run the docker-cmpose up without the docker-compose.yml file, right?

Is there a wiki page of how to install ErpNext 13.26 docker version in production that I could refer?

All I need is to have the latest version ErpNext installed and my data being restored on the new version.

revant_one · April 19, 2022, 11:48pm

github.com

frappe/frappe_docker/blob/main/docs/single-server-example.md

### Single Server Example

In this use case we have a single server with a static IP attached to it. It can be used in scenarios where one powerful VM has multiple benches and applications or one entry level VM with single site. For single bench, single site setup follow only up to the point where first bench and first site is added. If you choose this setup you can only scale vertically. If you need to scale horizontally you'll need to backup the sites and restore them on to cluster setup.

We will setup the following:

- Install docker and docker compose v2 on linux server.
- Install traefik service for internal load balancer and letsencrypt.
- Install MariaDB with containers.
- Setup project called `erpnext-one` and create sites `one.example.com` and `two.example.com` in the project.
- Setup project called `erpnext-two` and create sites `three.example.com` and `four.example.com` in the project.

Explanation:

Single instance of **Traefik** will be installed and act as internal loadbalancer for multiple benches and sites hosted on the server. It can also load balance other applications along with frappe benches, e.g. wordpress, metabase, etc. We only expose the ports `80` and `443` once with this instance of traefik. Traefik will also take care of letsencrypt automation for all sites installed on the server. _Why choose Traefik over Nginx Proxy Manager?_ Traefik doesn't need additional DB service and can store certificates in a json file in a volume.

Single instance of **MariaDB** will be installed and act as database service for all the benches/projects installed on the server.

Each instance of ERPNext project (bench) will have its own redis, socketio, gunicorn, nginx, workers and scheduler. It will connect to internal MariaDB by connecting to MariaDB network. It will expose sites to public through Traefik by connecting to Traefik network.

This file has been truncated. show original

pradpreeonline · April 20, 2022, 4:41am

Thanks @revant_one. I was able to install the latest version successfully. Thank you so much for the instructions.
Can you please tell me what command I would have to use to stop the services. In the older version I used

docker-compose down

and

docker-compose up -d

to run it.
Secondly will the site backup still work as I explained earlier? (Please note the backup would be from ErpNext 13.2 and the same has to be restored on 13.27.)
OR how can I restore my files and database from the old version to new version?

Touseef · April 20, 2022, 5:45am

Doesn’t bench update work for you?

I successfully upgraded V13.11 to V13.26. My installation method was manual and not docker though.

revant_one · April 20, 2022, 5:59am

check all projects with

docker compose ls

to stop/start try,

docker compose -p project-name stop

docker compose -p project-name start

do migrate after restore.

bench --site site.name migrate

bench update is not framework command, it’s not available inside container, migrate is framework command, it is available.

pradpreeonline · April 20, 2022, 4:28pm

This is what I get when I run the command to stop:

root@erp:~/frappe_docker# docker compose -p project-name stop
invalid interpolation format for x-backend-defaults.image: “required variable FRAPPE_VERSION is missing a value: No Frappe version set”. You may need to escape any $ with another $.

Did I miss a step or something to update the frappe version? I see it in the ~/gitops/erpnext-one.env file

and I don’t see a version in the compose.yml file

but not sure if the version has to be updated there or somewhere else?

revant_one · April 20, 2022, 6:51pm

try adding --env-file path/to/env to the command

pradpreeonline · April 21, 2022, 3:04am

I think I misunderstood the command you wanted me to run in your second last response. I was using the command wrong. I was trying to stop everything together in the old fashion and instead of using the actual project name I was typing “–project-name”, literally.
I tried this and it worked:

However when I tried to stop the other two services they didn’t stop.

revant_one · April 21, 2022, 4:31am

try running the commands from some other directory?
I think it picks up compose.yml from the directory even if you do docker compose -p traefik ...

pradpreeonline · April 21, 2022, 4:35am

Still the same:

revant_one · April 21, 2022, 4:37am

may be you can directly stop the containers?

docker stop traefik-traefik-1 mariadb-database

revant_one · April 21, 2022, 4:37am

i guess the erpnext-one redis didn’t stop because it picked up compose from root which doesn’t have redis.

pradpreeonline · April 21, 2022, 4:52am

You were right. erpnext-one redis didn’t stop. There is no “compose.yml” in /root/. It’s in /root/frappe_docker from where I was running the command.
Here is the directory structure:

I was able to directly stop the mariadb and traefik server using the command you provided.

docker stop traefik_traefik_1 mariadb-database

Not sure why redis will not stop and why they all will not stop the same way erpnext-one stopped.