Need more help gettign started via docker-compose.yml

ovizii

I downloaded your sample then went and changed user/paswords, but it looks like the user "app" is somewhere hard-coded as I get these errors from the stack:

r3-db   | 2023-04-03 12:42:16.456 UTC [72] FATAL:  password authentication failed for user "app"                                                       
r3-db   | 2023-04-03 12:42:16.456 UTC [72] DETAIL:  Role "app" does not exist.

btw. here is my changed compose file and the .env file

version: '3.3'                                                                                                                                         
# https://github.com/r3-team/r3                                                                                                                        
                                                                                                                                                       
services:                                                                                                                                              
    r3-db:                                                                                                                                             
        container_name: r3-db                                                                                                                          
        hostname: r3-db                                                                                                                                
        image: postgres:latest                                                                                                                         
        environment:                                                                                                                                   
            POSTGRES_PASSWORD: $POSTGRES_PASSWORD                                                                                                      
            POSTGRES_USER: r3                                                                                                                          
        restart: "no"                                                                                                                                  
        volumes:                                                                                                                                       
            - ./data/db:/var/lib/postgresql/data                                                                                                       
        networks:                                                                                                                                      
          - r3                                                                                                                                         
    r3:                                                                                                                                                
        build:                                                                                                                                         
            context: https://github.com/r3-team/r3_docker.git#main                                                                                     
            args:                                                                                                                                      
                r3_db_host: r3-db                                                                                                                      
                r3_os_arch: x64                                                                                                                        
                r3_version: ${R3_VERSION:-3.3}                                                                                                         
                im_policy: /etc/ImageMagick-6/policy.xml                                                                                               
        image: "r3/${R3_VERSION:-3.3}"                                                                                                                 
        container_name: r3-app                                                                                                                         
        hostname: r3-app                                                                                                                               
        depends_on:                                                                                                                                    
            - r3-db                                                                                                                                    
        ports:                                                                                                                                         
            - "14000:80"                                                                                                                               
        restart: "no"                                                                                                                                  
        volumes:                                                                                                                                       
            - ./data/app:/opt/r3/data                                                                                                                  
        networks:                                                                                                                                      
          - r3                                                                                                                                         
                                                                                                                                                       
networks:                                                                                                                                              
  r3:                                                                                                                                                  
    external: true                                                                                                                                     
    name: r3

POSTGRES_PASSWORD=supersecretpw
R3_VERSION=3.3

gabriel

Have you checked the file config.json? This file contains the database connection settings - by default the Postgres user (or 'role') is called app.

For the future: We could overwrite the specific parameter in the config file, if its different in the Dockerfile, now that I think about it.

Btw. welcome to the forum 🙂

ovizii

gabriel
Thanks for your reply. No I haven't checked anything out. All I found was the download link on your downloads section: https://rei3.de/en/downloads There is no mentioning of any config files or that I should git clone the repo or any other instructions so when I find a plain compose file, I try to get it up and running with as little effort as possible.

Maybe I should just wait for a doc section on how to get it up and running via a docker-compose.yml file.

gabriel

ovizii
The Docker Compose file is for testing / development instances. If you do not make any changes, it works out of the box with just docker compose up.

If you want to adjust it or create your own, you need to know how REI3 works - in this case, that it has a configuration file.

Here is a short documentation on how to use it: Link

ovizii

gabriel Thanks, I understand. It looks like it's not yet configurable via environmental variables. That is fine for testing, I'll use the original without any modifications to give it a try.

ovizii

OK, downloading a clean copy of the docker-compose.yml and starting it with docker compose up -d didn't work. It looks like I need to run it on my local machine and access it on localhost:14000 while I was trying to run it on a test server and access it via the server's IP or maybe there's another error here but here is my error from the lgos.

I'll come back to the project at a later date when this is all configurable :-)

these are the last few lines of docker compose logs -f

r3.3_db   | 2023-04-03 13:34:16.031 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432                                                     
r3.3_db   | 2023-04-03 13:34:16.031 UTC [1] LOG:  listening on IPv6 address "::", port 5432                                                          
r3.3_db   | 2023-04-03 13:34:16.034 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"                                       
r3.3_db   | 2023-04-03 13:34:16.039 UTC [64] LOG:  database system was shut down at 2023-04-03 13:34:15 UTC                                          
r3.3_db   | 2023-04-03 13:34:16.045 UTC [1] LOG:  database system is ready to accept connections                                                     
r3.3_app  | E: 13:34:31 failed to open database connection, timeout reached, last error: failed to connect to `host=r3-db user=app database=app`: hostname resolving error (lookup r3-db on 127.0.0.11:53: no such host)                                                                                  
r3.3_app  | Shutting down...                                                                                                                         
r3.3_app  | E: 13:34:40 failed to connect to `host=r3-db user=app database=app`: hostname resolving error (lookup r3-db on 127.0.0.11:53: no such host)                                                                                                                                                   
r3.3_app exited with code 0

gabriel

I´ve had a look and the compose file worked on my test systems, locally and on test servers. It appears from your log that your application service cannot reach your database. I can only speculate what is going wrong there but I understand if you do not want to continue looking.

Docker has not been a big priority for us so far as most just setup REI3 directly on Linux or Windows servers.

Thank you for your feedback in any case.

ovizii

gabriel I totally understand. I just thought maybe I need to remove the .env file too apart from downloading the fresh docker-compose.yml file, and then I ran docker compose up -d this was the result.

I'm sure its on my end, I guess I'll revisit this whole thing when I have more time to actually figure it out or if/when there's more documentation available.

Thanks for taking the tiem to comment here and try and help.

docker compose up -d                                                                                                      
[+] Running 1/1                                                                                                                                        
 ! r3 Warning                                                                                                                                   1.5s   
[+] Building 35.4s (9/9) FINISHED                                                                                                                      
 => CACHED [internal] load git source https://github.com/r3-team/r3_docker.git#main                                                             0.8s   
 => [internal] load metadata for docker.io/library/debian:stable-slim                                                                           0.9s   
 => [auth] library/debian:pull token for registry-1.docker.io                                                                                   0.0s   
 => CACHED [1/5] FROM docker.io/library/debian:stable-slim@sha256:5cd86fc824e33ac3f9e4c9020c5b328958c6d5e1cb0af5d3154d03ca15fb5ddc              0.0s   
 => https://rei3.de/downloads/REI3_3.2_x64_linux.tar.gz                                                                                         0.2s   
 => [2/5] RUN bash -c 'mkdir -p /opt/r3/data/{certificates,files,temp,transfer}'  && apt-get update  && apt-get install imagemagick ghostscri  32.7s   
 => [3/5] WORKDIR /opt/r3                                                                                                                       0.2s   
 => [4/5] ADD https://rei3.de/downloads/REI3_3.2_x64_linux.tar.gz .                                                                             0.2s   
 => ERROR [5/5] RUN tar -xvf REI3_3.2_x64_linux.tar.gz r3 config_template.json  && sed -i "s/localhost/r3_db/g" config_template.json  && sed -  0.5s   
------                                                                                                                                                 
 > [5/5] RUN tar -xvf REI3_3.2_x64_linux.tar.gz r3 config_template.json         && sed -i "s/localhost/r3_db/g" config_template.json    && sed -i "s/  443/80/g" config_template.json  && chmod 755 r3 && chmod 644 config_template.json       && rm REI3_3.2_x64_linux.tar.gz:                               
#0 0.463                                                                                                                                               
#0 0.463 gzip: stdin: not in gzip format                                                                                                               
#0 0.464 tar: Child returned status 1                                                                                                                  
#0 0.464 tar: Error is not recoverable: exiting now                                                                                                    
------                                                                                                                                                 
failed to solve: process "/bin/sh -c tar -xvf REI3_${r3_version}_${r3_os_arch}_linux.tar.gz r3 config_template.json \t&& sed -i \"s/localhost/${r3_db  _host}/g\" config_template.json \t&& sed -i \"s/443/80/g\" config_template.json \t&& chmod 755 r3 && chmod 644 config_template.json \t&& rm REI3_${r3  _version}_${r3_os_arch}_linux.tar.gz" did not complete successfully: exit code: 2