[GH-ISSUE #151 ] Enviroment variables do not change port #85

Author

Owner

@ShockwaveNN commented on GitHub (Mar 6, 2019):

Seem trouble actual only for compose
Tred to use docker run env - and everything fine

docker run -it -p 80:80 -e POSTGRESQL_SERVER_HOST=192.168.1.1 -e POSTGRESQL_SERVER_PORT=1234 onlyoffice/documentserver:latest
Waiting for connection to the 192.168.1.1 host on port 1234

Define the two variables

How did you define them? Do you edit docker-compose or somehow else?

@ShockwaveNN commented on GitHub (Mar 6, 2019): Seem trouble actual only for compose Tred to use docker run env - and everything fine ``` docker run -it -p 80:80 -e POSTGRESQL_SERVER_HOST=192.168.1.1 -e POSTGRESQL_SERVER_PORT=1234 onlyoffice/documentserver:latest Waiting for connection to the 192.168.1.1 host on port 1234 ``` > Define the two variables How did you define them? Do you edit docker-compose or somehow else?

kerem commented

Author

Owner

@casKd-dev commented on GitHub (Mar 6, 2019):

Seem trouble actual only for compose
Tred to use docker run env - and everything fine

I actually used also docker run with the variables too, same result. Here is what i've tried:

docker-compose.yml

version: '2'
services:
  documentserver:
    image: onlyoffice/documentserver:latest
    environment:
      - HTTP_CHECK=GET office.redxen.eu/healthcheck
      - EXTRA_SETTINGS=http-check expect string true
      - POSTGRESQL_SERVER_HOST=HOST
      - POSTGRESQL_SERVER_PORT=PORT
      - POSTGRESQL_SERVER_DB_NAME=onlyoffice
      - POSTGRESQL_SERVER_USER=onlyoffice
      - POSTGRESQL_SERVER_PASS=PASSWORD
    stdin_open: true
    restart: always
    ports:
      - 3777:80
    volumes:
       - ./config/local.json:/etc/onlyoffice/documentserver/local.json

docker run

docker run -e POSTGRESQL_SERVER_HOST=HOST -e POSTGRESQL_SERVER_PORT=PORT -e POSTGRESQL_SERVER_DB_NAME=onlyoffice -e POSTGRESQL_SERVER_USER=onlyoffice -e POSTGRESQL_SERVER_PASSWORD=PASSWORD -v /root/onlyoffice/config/local.json:/etc/onlyoffice/documentserver/local.json onlyoffice/documentserver:latest

@casKd-dev commented on GitHub (Mar 6, 2019): > Seem trouble actual only for compose > Tred to use docker run env - and everything fine I actually used also docker run with the variables too, same result. Here is what i've tried: **docker-compose.yml** ``` version: '2' services: documentserver: image: onlyoffice/documentserver:latest environment: - HTTP_CHECK=GET office.redxen.eu/healthcheck - EXTRA_SETTINGS=http-check expect string true - POSTGRESQL_SERVER_HOST=HOST - POSTGRESQL_SERVER_PORT=PORT - POSTGRESQL_SERVER_DB_NAME=onlyoffice - POSTGRESQL_SERVER_USER=onlyoffice - POSTGRESQL_SERVER_PASS=PASSWORD stdin_open: true restart: always ports: - 3777:80 volumes: - ./config/local.json:/etc/onlyoffice/documentserver/local.json ``` **docker run** `docker run -e POSTGRESQL_SERVER_HOST=HOST -e POSTGRESQL_SERVER_PORT=PORT -e POSTGRESQL_SERVER_DB_NAME=onlyoffice -e POSTGRESQL_SERVER_USER=onlyoffice -e POSTGRESQL_SERVER_PASSWORD=PASSWORD -v /root/onlyoffice/config/local.json:/etc/onlyoffice/documentserver/local.json onlyoffice/documentserver:latest`

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (Mar 6, 2019):

@casKd-dev try to run your command without mounting local.json

@ShockwaveNN commented on GitHub (Mar 6, 2019): @casKd-dev try to run your command without mounting `local.json`

kerem commented

Author

Owner

@casKd-dev commented on GitHub (Mar 6, 2019):

@casKd-dev try to run your command without mounting local.json

Did that, no change. Forgot to add that the host is properly set.
So POSTGRESQL_SERVER_HOST is working but POSTGRESQL_SERVER_PORT is not. Maybe the variable has been changed?

@casKd-dev commented on GitHub (Mar 6, 2019): > @casKd-dev try to run your command without mounting `local.json` Did that, no change. Forgot to add that the host is properly set. So `POSTGRESQL_SERVER_HOST` is working but `POSTGRESQL_SERVER_PORT` is not. Maybe the variable has been changed?

kerem commented

Author

Owner

@casKd-dev commented on GitHub (Apr 10, 2019):

Okay, after a full re-install the port is still not defined. This needs some testing as i am not really sure where the problem really is.

docker-compose.yml related part:

documentserver:
    image: onlyoffice/documentserver
    environment:
      POSTGRESQL_SERVER_HOST: 'xxxxx'
      POSTGRESQL_SERVER_PORT: '31002'
      POSTGRESQL_SERVER_DB_NAME: 'onlyoffice'
      POSTGRESQL_SERVER_USER: 'onlyoffice'
      POSTGRESQL_SERVER_PASS: 'xxxxx'
      REDIS_SERVER_HOST: 'xxxxx'
      REDIS_SERVER_PORT: 'xxxxx'
      JWT_ENABLED: 'true'
      JWT_SECRET: 'xxxxxxxxxxxxx'
    ports:
    - target: 80
      published: xxxxx
      protocol: tcp
      mode: host
    stdin_open: true

The log output when starting the container:

Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
psql: could not connect to server: Connection timed out
 Is the server running on host "xxxxxxx" and accepting
 TCP/IP connections on port 5432?

@casKd-dev commented on GitHub (Apr 10, 2019): Okay, after a full re-install the port is still not defined. This needs some testing as i am not really sure where the problem really is. docker-compose.yml related part: ``` documentserver: image: onlyoffice/documentserver environment: POSTGRESQL_SERVER_HOST: 'xxxxx' POSTGRESQL_SERVER_PORT: '31002' POSTGRESQL_SERVER_DB_NAME: 'onlyoffice' POSTGRESQL_SERVER_USER: 'onlyoffice' POSTGRESQL_SERVER_PASS: 'xxxxx' REDIS_SERVER_HOST: 'xxxxx' REDIS_SERVER_PORT: 'xxxxx' JWT_ENABLED: 'true' JWT_SECRET: 'xxxxxxxxxxxxx' ports: - target: 80 published: xxxxx protocol: tcp mode: host stdin_open: true ``` The log output when starting the container: ``` Usage: grep [OPTION]... PATTERN [FILE]... Try 'grep --help' for more information. psql: could not connect to server: Connection timed out Is the server running on host "xxxxxxx" and accepting TCP/IP connections on port 5432? ```

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (Apr 22, 2019):

@casKd-dev Hi, I'm still was not able to reproduce your issue, could you provide minimal docker-compose.yml file in which your problem is reproduces?

@ShockwaveNN commented on GitHub (Apr 22, 2019): @casKd-dev Hi, I'm still was not able to reproduce your issue, could you provide minimal `docker-compose.yml` file in which your problem is reproduces?

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (Apr 22, 2019):

Oops, sorry didn't mean to close it

@ShockwaveNN commented on GitHub (Apr 22, 2019): Oops, sorry didn't mean to close it

kerem commented

Author

Owner

@casKd-dev commented on GitHub (May 1, 2019):

@casKd-dev Hi, I'm still was not able to reproduce your issue, could you provide minimal docker-compose.yml file in which your problem is reproduces?

@ShockwaveNN here it is

version: '3.7'
services:
  documentserver:
      image: onlyoffice/documentserver:latest
      stdin_open: true
      environment:
        POSTGRESQL_SERVER_HOST: 'localhost'
        POSTGRESQL_SERVER_PORT: '5444'
        POSTGRESQL_SERVER_DB_NAME: 'onlyoffice'
        POSTGRESQL_SERVER_USER: 'onlyoffice'
        POSTGRESQL_SERVER_PASS: 'password'
        REDIS_SERVER_HOST: 'localhost'
        REDIS_SERVER_PORT: '6377'
        JWT_ENABLED: 'true'
        JWT_SECRET: 'password111'
      ports:
        - '8080:80'

@casKd-dev commented on GitHub (May 1, 2019): > @casKd-dev Hi, I'm still was not able to reproduce your issue, could you provide minimal `docker-compose.yml` file in which your problem is reproduces? @ShockwaveNN here it is ```yaml version: '3.7' services: documentserver: image: onlyoffice/documentserver:latest stdin_open: true environment: POSTGRESQL_SERVER_HOST: 'localhost' POSTGRESQL_SERVER_PORT: '5444' POSTGRESQL_SERVER_DB_NAME: 'onlyoffice' POSTGRESQL_SERVER_USER: 'onlyoffice' POSTGRESQL_SERVER_PASS: 'password' REDIS_SERVER_HOST: 'localhost' REDIS_SERVER_PORT: '6377' JWT_ENABLED: 'true' JWT_SECRET: 'password111' ports: - '8080:80' ```

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (May 6, 2019):

@casKd-dev I don't think this is correct compose file, there is no service key. Is this just a part? Is there also postgres service in this compose file?

@ShockwaveNN commented on GitHub (May 6, 2019): @casKd-dev I don't think this is correct compose file, there is no `service` key. Is this just a part? Is there also postgres service in this compose file?

kerem commented

Author

Owner

@casKd-dev commented on GitHub (May 6, 2019):

@casKd-dev I don't think this is correct compose file, there is no service key. Is this just a part? Is there also postgres service in this compose file?

No, it is just a example i've written that is close to my example, i've changed it.

@casKd-dev commented on GitHub (May 6, 2019): > @casKd-dev I don't think this is correct compose file, there is no `service` key. Is this just a part? Is there also postgres service in this compose file? No, it is just a example i've written that is close to my example, i've changed it.

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (May 6, 2019):

@casKd-dev could you provide a full example? There is postgres server is located? In docker-compose or on real server?

@ShockwaveNN commented on GitHub (May 6, 2019): @casKd-dev could you provide a full example? There is postgres server is located? In docker-compose or on real server?

kerem commented

Author

Owner

@casKd-dev commented on GitHub (May 6, 2019):

@casKd-dev could you provide a full example? There is postgres server is located? In docker-compose or on real server?

@ShockwaveNN
It has the same behaviour for both cases, i will provide a full example then:

version: '3.7'
services:
  documentserver:
      image: onlyoffice/documentserver:latest
      stdin_open: true
      environment:
        POSTGRESQL_SERVER_HOST: 'postgres'
        POSTGRESQL_SERVER_PORT: '6377'
        POSTGRESQL_SERVER_DB_NAME: 'onlyoffice'
        POSTGRESQL_SERVER_USER: 'root'
        POSTGRESQL_SERVER_PASS: 'ExAmPLEPassword123'
      ports:
        - '8080:80'
  postgres:
    image: postgres
    environment:
      POSTGRES_PASSWORD: 'ExAmPLEPassword123'
    ports:
      - '6377:5432'

@casKd-dev commented on GitHub (May 6, 2019): > @casKd-dev could you provide a full example? There is postgres server is located? In docker-compose or on real server? @ShockwaveNN It has the same behaviour for both cases, i will provide a full example then: ```yaml version: '3.7' services: documentserver: image: onlyoffice/documentserver:latest stdin_open: true environment: POSTGRESQL_SERVER_HOST: 'postgres' POSTGRESQL_SERVER_PORT: '6377' POSTGRESQL_SERVER_DB_NAME: 'onlyoffice' POSTGRESQL_SERVER_USER: 'root' POSTGRESQL_SERVER_PASS: 'ExAmPLEPassword123' ports: - '8080:80' postgres: image: postgres environment: POSTGRES_PASSWORD: 'ExAmPLEPassword123' ports: - '6377:5432'

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (May 6, 2019):

@casKd-dev so DocumentServer trying to connect to postgres on 5444, but postgres is on 6777 port? Just a typo?
Also I'm not sure about networking between containers.
I think you should start by starting container with DocumentServer, attach to it into bash and check from bash that postgres server is available from DocumentServer container

@ShockwaveNN commented on GitHub (May 6, 2019): @casKd-dev so DocumentServer trying to connect to postgres on `5444`, but postgres is on 6777 port? Just a typo? Also I'm not sure about networking between containers. I think you should start by starting container with DocumentServer, attach to it into `bash` and check from `bash` that postgres server is available from DocumentServer container

kerem commented

Author

Owner

@casKd-dev commented on GitHub (May 6, 2019):

@casKd-dev so DocumentServer trying to connect to postgres on 5444, but postgres is on 6777 port? Just a typo?
Also I'm not sure about networking between containers.
I think you should start by starting container with DocumentServer, attach to it into bash and check from bash that postgres server is available from DocumentServer container

The container is accessible, i have tested that, but the DocumentServer doesn't use the environment variable for some reason, maybe the variable was removed in some previous commit so now it doesn't get used anymore?

No matter if the database is external or on the same docker network, it behaves the same. @ShockwaveNN

@casKd-dev commented on GitHub (May 6, 2019): > @casKd-dev so DocumentServer trying to connect to postgres on `5444`, but postgres is on 6777 port? Just a typo? > Also I'm not sure about networking between containers. > I think you should start by starting container with DocumentServer, attach to it into `bash` and check from `bash` that postgres server is available from DocumentServer container The container is accessible, i have tested that, but the DocumentServer doesn't use the environment variable for some reason, maybe the variable was removed in some previous commit so now it doesn't get used anymore? No matter if the database is external or on the same docker network, it behaves the same. @ShockwaveNN

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (May 6, 2019):

@casKd-dev ok then, still could you provide correct docker-compose? It's clearly different ports in your last one, or I'm can't understand something

@ShockwaveNN commented on GitHub (May 6, 2019): @casKd-dev ok then, still could you provide correct `docker-compose`? It's clearly different ports in your last one, or I'm can't understand something

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (May 6, 2019):

Also why REDIS_SERVER_HOST: 'postgres' postgres in that part

@ShockwaveNN commented on GitHub (May 6, 2019): Also why `REDIS_SERVER_HOST: 'postgres'` postgres in that part

kerem commented

Author

Owner

@casKd-dev commented on GitHub (May 6, 2019):

My bad, i have overlooked that. Now it should be fine @ShockwaveNN

@casKd-dev commented on GitHub (May 6, 2019): My bad, i have overlooked that. Now it should be fine @ShockwaveNN

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (May 7, 2019):

@casKd-dev but ports are still different
In DocumentServer container postgres port is 6377, in postgres container 6777

@ShockwaveNN commented on GitHub (May 7, 2019): @casKd-dev but ports are still different In DocumentServer container postgres port is 6377, in postgres container 6777

kerem commented

Author

Owner

@mamema commented on GitHub (Jun 4, 2019):

i have the same issue. try to set var to 3306 (mysql - mariadb 10) and the logs asking about "is there a server on 5432 port

@mamema commented on GitHub (Jun 4, 2019): i have the same issue. try to set var to 3306 (mysql - mariadb 10) and the logs asking about "is there a server on 5432 port

kerem commented

Author

Owner

@casKd-dev commented on GitHub (Jun 7, 2019):

@ShockwaveNN Did you use the Docker Hub version? Did you pull the latest version?

@casKd-dev commented on GitHub (Jun 7, 2019): @ShockwaveNN Did you use the Docker Hub version? Did you pull the latest version?

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (Jun 17, 2019):

@casKd-dev Hi, could you provide full docker-compose.yml for which I'll be able to reproduce your problem?

@ShockwaveNN commented on GitHub (Jun 17, 2019): @casKd-dev Hi, could you provide full `docker-compose.yml` for which I'll be able to reproduce your problem?

kerem commented

Author

Owner

@casKd-dev commented on GitHub (Jun 17, 2019):

@casKd-dev Hi, could you provide full docker-compose.yml for which I'll be able to reproduce your problem?

@ShockwaveNN
The problem can be reproduced with and without a postgres connection, it doesn't matter whatsoever as the variable is not set in the configurations. I've updated the example above to be correct.

@casKd-dev commented on GitHub (Jun 17, 2019): > @casKd-dev Hi, could you provide full `docker-compose.yml` for which I'll be able to reproduce your problem? @ShockwaveNN The problem can be reproduced with and without a postgres connection, it doesn't matter whatsoever as the variable is not set in the configurations. I've updated the example above to be correct.

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (Jun 17, 2019):

@casKd-dev which one, it's plenty of examples in this thread and all of them seems not updated, I think if you add example in next message it'll be easier to read :)

@ShockwaveNN commented on GitHub (Jun 17, 2019): @casKd-dev which one, it's plenty of examples in this thread and all of them seems not updated, I think if you add example in next message it'll be easier to read :)

kerem commented

Author

Owner

@casKd-dev commented on GitHub (Jun 17, 2019):

version: '3.7'
services:
  documentserver:
      image: onlyoffice/documentserver:latest
      stdin_open: true
      environment:
        POSTGRESQL_SERVER_HOST: 'postgres'
        POSTGRESQL_SERVER_PORT: '6377'
        POSTGRESQL_SERVER_DB_NAME: 'onlyoffice'
        POSTGRESQL_SERVER_USER: 'root'
        POSTGRESQL_SERVER_PASS: 'ExAmPLEPassword123'
      ports:
        - '8080:80'
  postgres:
    image: postgres
    environment:
      POSTGRES_PASSWORD: 'ExAmPLEPassword123'
    ports:
      - '6377:5432'

@casKd-dev commented on GitHub (Jun 17, 2019): > ```yaml > version: '3.7' > services: > documentserver: > image: onlyoffice/documentserver:latest > stdin_open: true > environment: > POSTGRESQL_SERVER_HOST: 'postgres' > POSTGRESQL_SERVER_PORT: '6377' > POSTGRESQL_SERVER_DB_NAME: 'onlyoffice' > POSTGRESQL_SERVER_USER: 'root' > POSTGRESQL_SERVER_PASS: 'ExAmPLEPassword123' > ports: > - '8080:80' > postgres: > image: postgres > environment: > POSTGRES_PASSWORD: 'ExAmPLEPassword123' > ports: > - '6377:5432' > ```

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (Jun 17, 2019):

@casKd-dev at least first problem I see at your code - there is no predefined network in your example, so documentserver container and postgres container do not see each other (see https://github.com/ONLYOFFICE/Docker-DocumentServer/blob/master/docker-compose.yml#L108)

@ShockwaveNN commented on GitHub (Jun 17, 2019): @casKd-dev at least first problem I see at your code - there is no predefined network in your example, so documentserver container and postgres container do not see each other (see https://github.com/ONLYOFFICE/Docker-DocumentServer/blob/master/docker-compose.yml#L108)

kerem commented

Author

Owner

@casKd-dev commented on GitHub (Jun 18, 2019):

@casKd-dev at least first problem I see at your code - there is no predefined network in your example, so documentserver container and postgres container do not see each other (see https://github.com/ONLYOFFICE/Docker-DocumentServer/blob/master/docker-compose.yml#L108)

There is no need for postgres at all, if you start the container without postgres but with the port changed you will see it will still attempt to connect to the default port. For testing purposes it makes no change. The case is not something that heavily depends on the dependencies themselves.

@casKd-dev commented on GitHub (Jun 18, 2019): > @casKd-dev at least first problem I see at your code - there is no predefined network in your example, so documentserver container and postgres container do not see each other (see https://github.com/ONLYOFFICE/Docker-DocumentServer/blob/master/docker-compose.yml#L108) There is no need for postgres at all, if you start the container without postgres but with the port changed you will see it will still attempt to connect to the default port. For testing purposes it makes no change. The case is not something that heavily depends on the dependencies themselves.

kerem commented

Author

Owner

@ShockwaveNN commented on GitHub (Jun 19, 2019):

@casKd-dev

if you start the container without postgres but with the port changed you will see it will still attempt to connect to the default port

How to reproduce it? This comment is still actual with latest version
https://github.com/ONLYOFFICE/Docker-DocumentServer/issues/151#issuecomment-470004572

But maybe I'm doing something wrong

@ShockwaveNN commented on GitHub (Jun 19, 2019): @casKd-dev >if you start the container without postgres but with the port changed you will see it will still attempt to connect to the default port How to reproduce it? This comment is still actual with latest version https://github.com/ONLYOFFICE/Docker-DocumentServer/issues/151#issuecomment-470004572 But maybe I'm doing something wrong

kerem commented