I found the solution... The default path on unraid is not supported by Postgress

I changed /mnt/user to /mnt/cache and it works... Bu I have read that is is not the safest way to do things and I can't tell why...

And here is a quick and dirty (and functionnal) letsencrypt / nginx .conf example
(replace "server_name openproject.* with the name of your chosen subdomain and upstream_app openproject with the name of your container)
 

# Open Project server

server {
    listen 443 ssl;

    server_name openproject.*;

    include /config/nginx/ssl.conf;

    client_max_body_size 0;


    location / {
	include /config/nginx/proxy.conf;
	resolver 127.0.0.11 valid=30s;
	set $upstream_app openproject;
	set $upstream_port 80;
	set $upstream_proto http;
	proxy_pass $upstream_proto://$upstream_app:$upstream_port;
	}
}

 

Edited October 24, 20205 yr by Normand_Nadon

Anyone updated to Version 11 already? Any issues or something to consider?

On 11/3/2020 at 10:50 AM, paschtin said:

Anyone updated to Version 11 already? Any issues or something to consider?

 

I tried this by changing the repository to 11.  Everything downloads and installs but then you get a server error trying to connect to openproject.

 

Edit: I added this again using the template directly and left it for a while longer and it worked - I may not have been patient enough!

Edited January 31, 20215 yr by Dean Admin
Addition

If someone have problems with the default user and password (like i was), here is the guide that i used:

• open the container console
• change the users password with rails console:

RAILS_ENV=production bundle exec rails c
u = User.find_by_login "admin"
u.password=u.password_confirmation='my new password'
u.save

• exit

What are the chances of an update to the latest version?

What are the chances of an update to the latest version?

I did not try, so dont Trust my words. But you can just edit the Version of the docker template to the Version or to latest.

Cheers

Gesendet von meinem Redmi Note 8 Pro mit Tapatalk

Hello, sorry to bother but I am having a hell of a time getting my reverse proxy to work. I am using cloudflare in conjunction with Nginx (GUI version). I read through the docs for Openproject but some of the configuration is over my head. I thought it would be as simple as forwarding the local ip:port (which I remapped with an env variable from 8080) with SSL in the Nginx container like all my other stuff but no dice. Ive played around with a bunch of combinations of setups and atm I have added the SERVER_HOSTNAME=project.mydomain.com & in Openproject > settings > hostname=project.mydomain.com & protocol=HTTP. I am not sure what to try next and any advice would be wonderful. Cheers

Hello, sorry to bother but I am having a hell of a time getting my reverse proxy to work. I am using cloudflare in conjunction with Nginx (GUI version). I read through the docs for Openproject but some of the configuration is over my head. I thought it would be as simple as forwarding the local ip:port (which I remapped with an env variable from 8080) with SSL in the Nginx container like all my other stuff but no dice. Ive played around with a bunch of combinations of setups and atm I have added the SERVER_HOSTNAME=project.mydomain.com & in Openproject > settings > hostname=project.mydomain.com & protocol=HTTP. I am not sure what to try next and any advice would be wonderful. Cheers

There is always a solution

Did you follow some nginx config of this topic, because some users had postet theyr config?

I am wondering if you try to use port 8080 for ssl that would be confusing.

So my First step is to Check your Port forwardings, are you shure they do work?
Second is to Check the config of nginx and last to Check the reverse proxy settings.
So lets go step by step.

Cheers

Gesendet von meinem Redmi Note 8 Pro mit Tapatalk

2 minutes ago, knex666 said:

There is always a solution

Did you follow some nginx config of this topic, because some users had postet theyr config?

I am wondering if you try to use port 8080 for ssl that would be confusing.

So my First step is to Check your Port forwardings, are you shure they do work?
Second is to Check the config of nginx and last to Check the reverse proxy settings.
So lets go step by step.

Hey thanks for the quick reply. So first, I am sure my port forwardings and Nginx is working correctly on 10 other containers I have on proxy. Now, I haven't used custom configs much unless I am laying Authelia SSO on top of something so I am a bit wet behind the hears in this area.

So in this case I have not input anything into the custom config area. Maybe this is my problem. I only have basic stuff like caching assets & block common exploits on. My SSL cert is a letsencrypt that blankets my domain (*.mydomain.com).

I have remapped the OP container port to 3021 but I can try it with 8080.

Hey thanks for the quick reply. So first, I am sure my port forwardings and Nginx is working correctly on 10 other containers I have on proxy. Now, I haven't used custom configs much unless I am laying Authelia SSO on top of something so I am a bit wet behind the hears in this area.
So in this case I have not input anything into the custom config area. Maybe this is my problem. I only have basic stuff like caching assets & block common exploits on. My SSL cert is a letsencrypt that blankets my domain (*.mydomain.com).
I have remapped the OP container port to 3021 but I can try it with 8080.

Okay, can you post your anon ngix proxy to Check that.
Blank out Domains etc.

Cheers

Gesendet von meinem Redmi Note 8 Pro mit Tapatalk

12 minutes ago, knex666 said:

Okay, can you post your anon ngix proxy to Check that.
Blank out Domains etc.

Cheers

Gesendet von meinem Redmi Note 8 Pro mit Tapatalk
 

 

Hold the phone. My dumb brain put ".cmo" instead of ".com" for the proxy domain. It works as expected now, thanks for the help; sorry for wasting time ha.

I am having some problems connecting to this docker container from outside the firewall.  I can access the container fine inside the firewall.  I am using swag/nginx for my proxy.  I have that setup with nextcloud on a proxynet network.  I have added the openproject.subdomain.conf file to the swag/nginx proxy-conf folder. 

 

what do I do next?

 

I am thinking I have to add the openproject container to the proxynet, but then it can't use the same IP, and I get stuck there

 

problem is resolved.  I made a new subdomain at cloudflare for my account, my router is already setup to route all incoming ssl and port 80 traffic to my swag container.  I used the above conf file with a small change at the resolver, and pointed it at the IP address for my openproject server.  the last thing I had to do was allow host access to custom networks on the docker settings since my swag container is on a private subnetwork.  and then everything just worked.  

 

thanks for the great container

Edited March 1, 20224 yr by Ben deBoer
further along in the issue

Is it possible to use this the mariadb docker container?  If so, how?

12 hours ago, eds said:

Is it possible to use this the mariadb docker container?  If so, how?

sorry, what?

6 hours ago, knex666 said:

sorry, what?

The docker appears to be using a database (PostgreSQL).  If so, can mysql docker database be used instead?

3 hours ago, eds said:

The docker appears to be using a database (PostgreSQL).  If so, can mysql docker database be used instead?

If you did not set it up already just give it a try. I didnt check it and I dont know the req of openp

8 hours ago, knex666 said:

If you did not set it up already just give it a try. I didnt check it and I dont know the req of openp

 

I am going to assume from your answer, that's a no.  No worries.

Is there someone who know's how to get OpenProject 12.0.10 working with Nginx Proxy manager?

I think that I've tried everything. My local IP where the docker image runs inside Unraid docker is 192.168.2.244.

Ive tried http and https on both sides (Nginx and Openprojects) but that doesn't resolve anything.

Nginx Proxy Manager has project.myurl.nl (for explain) forward to my internal IP and port 8080, at the function custom locations i've been the same settings but added the following configuration rules:

    set $upstream_app openproject;
    set $upstream_port 80;
    set $upstream_proto http;

 

Has someone any idea? from local to local IP works Openproject good, only from outside to the URL doesn't work and gives an "502 Bad gateway" message.

Other docker functions with Nginx Proxy Manager works fine (like Nextcloud)

 

Hope someone could help. thanks al lot!

Wesley

Edited April 16, 20224 yr by WesleyL

Hi, 

 

I am not using port forwarding, I prefer a ssh tunnel with reverse port forwarding, so my configurations looks a bit different but should work as well.

I left out the redirection from http to https and the ssh certificates because that is self explaining.

 

location /{
        proxy_pass http://IP:8877;
        proxy_set_header Host $host;
        proxy_set_header X-Forwarded-Proto $scheme;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_max_temp_file_size 16384m;
        client_max_body_size 0;
    }

 

Give it a try, I hope we will find a solution for you.

 

Cheers
 

Thanks for you’re help. 
So far it will not work, I’ll think the problem is that I am using nginx proxy manager and not the normal nginx

 

when i’ll use the script above (also change the ip and Port) it doesn’t work, i’ll get also the 502 bad Gateway  error when opening the url.

 

Maybe you’ve got the solution for this nginx version and openproject?

 

cheers!

Edited April 17, 20224 yr by WesleyL

14 hours ago, WesleyL said:

Thanks for you’re help. 
So far it will not work, I’ll think the problem is that I am using nginx proxy manager and not the normal nginx

 

when i’ll use the script above (also change the ip and Port) it doesn’t work, i’ll get also the 502 bad Gateway  error when opening the url.

 

Maybe you’ve got the solution for this nginx version and openproject?

 

cheers!

 

Can you check if you can curl the openhab site from within the nginx proxy Manager by exec it into it? 

I’ve got the problem solved included the script above!

the problem was Nginx is in bridge and the openprojects was in br0, they can’t communicate to each other.

Openproject in br0 gives to the other containers some issue, so for now I’ve get the setting in docker settings that br0 may communicate to all the other networks. 
 

better is openprojects in another network but that isn’t possible for now.

 

thanks a lot!

Recent update broke my docker.

 

Following error:

 

Quote

DATABASE INCOMPATIBILITY ERROR

Database server version mismatch: Required version is 10.0.0, but current version is 9.6.24

 

Any idea how to update the db?

the latest update broke my server as well.  I had it setup with SWAG to provide a reverse proxy, but now that proxy is just giving me a 502 error.  I have docker setup to communicate with other containers, or did that feature get broken?

On 6/7/2022 at 1:11 AM, Ben deBoer said:

the latest update broke my server as well.

Use community 12.1