Openproject installation issue

Currently reading
Openproject installation issue

11
2
NAS
DS218+
Operating system
  1. Windows
Mobile operating system
  1. Android
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:01pg_ctl: could not open PID file "/var/openproject/pgdata/postmaster.pid": Permission denied

Please help solving it. Thanks
 
using docker installed via package center
-- post merged: --

 
Upvote 0
using docker installed via package center
-- post merged: --

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..
 
Upvote 0
Last edited:
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
 
Upvote 0
After changing mount paths, openproject container restarted without error but I could not access my old data stored in /pgdata and /assets.
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
Last edited:
as container keeps stopping, I can't create a bash command
-- post merged: --

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.
-- post merged: --

error_terminal.jpg
 

Attachments

  • environment1.jpg
    environment1.jpg
    61.4 KB · Views: 39
  • environment2.jpg
    environment2.jpg
    59.8 KB · Views: 38
  • environment3.jpg
    environment3.jpg
    67.7 KB · Views: 37
  • volume.jpg
    volume.jpg
    40.7 KB · Views: 37
Upvote 0
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


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.
 
Upvote 0
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
 
Upvote 0
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
13:42:48-----> Setting PGVERSION=9.6 PGBIN=/usr/lib/postgresql/9.6/bin PGCONF_FILE=/etc/postgresql/9.6/main/postgresql.confstdout
13:42:49-----> Starting the all-in-one OpenProject setup at /app/docker/prod/supervisord...stdout
13:42:52-----> Database cluster already exists, not modifying.stdout
13:42:55pg_ctl: could not start serverstdout
13:42:55Examine the log output.stdout
13:42:55 waiting for server to start.... stopped waiting

Any idea how to fix it?
 
Upvote 0

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Similar threads

  • Question
Open an issue on that GitHub page. The developers will be glad to assist. OP has posted two threads on...
Replies
5
Views
1,379
I would like to thank you all for your efforts, but unfortunately still not working . But I found a...
Replies
23
Views
2,910
Those are two different layers: one is the management ui to perform actions on the api. the other is the...
Replies
12
Views
1,680

Welcome to SynoForum.com!

SynoForum.com is an unofficial Synology forum for NAS owners and enthusiasts.

Registration is free, easy and fast!

Back
Top