Openproject installation issue

ol202# · 6. Mar 2022

I've installed openproject mounting existing data volumes. After starting it I got following error (see log file):

-----> Existing PostgreSQL cluster found in /var/openproject/pgdata.

stdout

19:03:55

-----> Setting PGVERSION=9.6 PGBIN=/usr/lib/postgresql/9.6/bin PGCONF_FILE=/etc/postgresql/9.6/main/postgresql.conf

stdout

19:03:56

-----> Starting the all-in-one OpenProject setup at /app/docker/prod/supervisord...

stdout

19:03:59

-----> Database cluster already exists, not modifying.

stdout

19:04:01

pg_ctl: could not open PID file "/var/openproject/pgdata/postmaster.pid": Permission denied

Please help solving it. Thanks

Rusty · 6. Mar 2022

Docker compose you used?

ol202# · 7. Mar 2022

Rusty said:
Docker compose you used?

openproject/community:12, if I understood correctly your question

Rusty · 7. Mar 2022

ol202# said:
openproject/community:12, if I understood correctly your question

Ok so this is installed via Package Center?

ol202# · 7. Mar 2022

using docker installed via package center
[automerge]1646646360[/automerge]

Synology

Open source project management software for classic, agile or hybrid project management: task management✓ Gantt charts✓ boards✓ team collaboration✓ time and cost reporting✓ FREE trial!

www.openproject.org

Rusty · 7. Mar 2022

ol202# said:
using docker installed via package center
[automerge]1646646360[/automerge]

Synology

Open source project management software for classic, agile or hybrid project management: task management✓ Gantt charts✓ boards✓ team collaboration✓ time and cost reporting✓ FREE trial!

www.openproject.org

Ok so it is docker installed. Back to my original question then. How did you configure your container(s)? Did you use docker-compose or Synology docker UI?

In any case, share some more info on that. Ports, volume maps etc..

ol202# · 7. Mar 2022

I used Synology UI, added existing folders (created in previous container) and changed ports to available ones. After doing this, new container did not start

ol202# · 7. Mar 2022

After changing mount paths, openproject container restarted without error but I could not access my old data stored in /pgdata and /assets.

Rusty · 7. Mar 2022

ol202# said:
After changing mount paths, openproject container restarted without error but I could not access my old data stored in /pgdata and /assets.

Could it be a permission problem of some sort? Can you try and access those mapped destinations using bash from within the container itself? Just to see if the container can actually see the data located in those folders?

ol202# · 7. Mar 2022

Rusty said:
Could it be a permission problem of some sort? Can you try and access those mapped destinations using bash from within the container itself? Just to see if the container can actually see the data located in those folders?

the error indicates permission issue directly:
"pg_ctl: could not open PID file "/var/openproject/pgdata/postmaster.pid": Permission denied".
please advise how can I access the folder using bash. thanks

Rusty · 7. Mar 2022

Using Terminal tab in Synology Docker UI, you can activate/create a new terminal window instancing bash command line.

Once the window is active then run commands that will allow you to look into those folders and their content.

ol202# · 7. Mar 2022

Rusty said:
Using Terminal tab in Synology Docker UI, you can activate/create a new terminal window instancing bash command line.

Once the window is active then run commands that will allow you to look into those folders and their content.

the only terminal window I could find in Docker UI is within container itself and it is not active

Rusty · 7. Mar 2022

ol202# said:
the only terminal window I could find in Docker UI is within container itself and it is not active

That's the one and the default one will not be active, but have you used the Create button to make a new one with a bash command?

ol202# · 7. Mar 2022

as container keeps stopping, I can't create a bash command
[automerge]1646664358[/automerge]
I've installed a new container using same image but mounting different folders. could not start the container neither. most probably it is a permission issue but I can't figure out what is missing.
[automerge]1646664762[/automerge]

ol202# · 8. Mar 2022

any idea what could be wrong?

Rusty · 8. Mar 2022

These image will not help out much.

Have you tried to run this container using the docker run command line as described in the documentation?

Code:

docker run -d -p 8080:80 --name openproject \
  -e SERVER_HOSTNAME=openproject.example.com \ # The public facing host name
  -e SECRET_KEY_BASE=secret \ # The secret key base used for cookies
  -v /var/lib/openproject/pgdata:/var/openproject/pgdata \
  -v /var/lib/openproject/assets:/var/openproject/assets \
  openproject/community:12

OpenProject on Docker all-in-one container

Open source project management software for classic, agile or hybrid project management: task management✓ Gantt charts✓ boards✓ team collaboration✓ time and cost reporting✓ FREE trial!

www.openproject.org

Try and log into your NAS as root and run the above code while changing the volume parameters (-v) to match your local destination (the same ones that you used using the Docker UI).

Try and run it like that and lets see how that goes.

ol202# · 8. Mar 2022

I've tried to run the container using the docker run command line as root but no luck.

So, problem solved as follows:
1. created pgdata and assets folders to be mounted
2. made sure the folders have the correct owner so the new container could read and write them.
(sudo chown -R 102 /volume1/openproject/*)
3. installed new container mounting empty assets and pgdata folders
4. stopped the container and copied data from old container to mounted folders (overwrite)
5. restarted the container and it works just fine.

thanks, Rusty, for your time

ol202# · 11. Mar 2022

Hi. I'm back with a new issue.
After stopping the container does not start showing following in Log:

-----> Existing PostgreSQL cluster found in /var/openproject/pgdata.

stdout