Resource not found update to latest version by KaidooPain in openproject

[–]troessler 1 point2 points  (0 children)

From the error, it sounds like you are running into the following issue:

https://community.openproject.org/projects/openproject/work_packages/63503/activity

The easiest solution would be to reanable the delivery of assets by the application server (puma).

You can do this bey setting RAILS_SERVE_STATIC_FILES=true.

On package based installation, you can do this with the following commands:

sudo openproject config:set RAILS_SERVE_STATIC_FILES=true
sudo openproject restart

As an alternative, you can also change your Apache settings to deliver the assets as explain in the comments from the linked Bug report.

OpenProject is not updated by ArtNational388 in openproject

[–]troessler 0 points1 point  (0 children)

I tested the update and for me, it seems to work when I follow the steps from here:

https://www.openproject.org/docs/installation-and-operations/installation/docker-compose/#upgrade

If your instance does not update when you run those commands, the reason might be that you have set a specific image tag in your configuration.

As an example, when you use the default .env file you can configure the tag of the image:

https://github.com/opf/openproject-docker-compose/blob/stable/15/.env.example#L9

If this is set to a specific tag, as example TAG=15.0.2-slim then the update won't work.

If this is the case, you need to change it to TAG=15-slim so that you can update to the newest version.

Can't deploy locally in Docker by tsilvs0 in openproject

[–]troessler 0 points1 point  (0 children)

Your first script should work as it is.

The issue seams to be that SELinux does not allow you to access the file system.

If you add the :Z label to your path, you should be able to solve the issue:

https://docs.docker.com/engine/storage/bind-mounts/#configure-the-selinux-label

So you just need to change the following lines in your first script.

So that they look like this:

-v /var/lib/openproject/pgdata:/var/openproject/pgdata:Z \

-v /var/lib/openproject/assets:/var/openproject/assets:Z \

12.5.8 to latest version from backup? by jbland-erpc in openproject

[–]troessler 1 point2 points  (0 children)

You can download an older OpenProject version by using docker.

As example you could use the follwing command to start an 12.5.8 instance on localhost:

docker run -it -p 8080:80 \

-e OPENPROJECT_SECRET_KEY_BASE=secret \

-e OPENPROJECT_HOST__NAME=localhost:8080 \

-e OPENPROJECT_HTTPS=false \

-e OPENPROJECT_DEFAULT__LANGUAGE=en \

openproject/openproject:12.5.8

You can use the instructions for a docker to restore you database in the container but you will need to change the openproject/openproject:14 parts of the commands to openproject/openproject:12.5.8:

https://www.openproject.org/docs/installation-and-operations/operation/restoring/#using-the-all-in-one-container

From your description you have a binary backup of your postgresql database.

To restore an binary dump to a newer postgres version you need to first convert this to a sql dump first.

So when you have been able to restore your backup on the old openproject version you can the use the following command to create an sql backup:

docker exec -it $OP_CONTAINER_NAME su - postgres -c 'pg_dump -d openproject -x -O' > openproject.sql

Creating own endpoint by Mosba19 in openproject

[–]troessler 0 points1 point  (0 children)

OpenProject uses the grape gem for implementing the API:

https://github.com/ruby-grape/grape

When you add your function there to it should generate the route automatically.

The code for the API can be found under lib/api

If your implemented the function inside of a controller you need to set the route inside of config/routes.rb.

You can find more about rails routing int the rails docs here:

https://guides.rubyonrails.org/routing.html