Env Variable not working with NGINX and Rails

General Discussions
1

I described the problem in stackoverflow but the help that was suggested did not help me solve the problem. I believe it is some detail but I lack knowledge to realize.

FATAL: role “<%= ENV[‘DB_USER’] %>” does not exist

When I run the command

erb config/database.yml

the env variables are replaced in app container and running puma, the application reach the database. Only accessing by localhost:8081 that the problem occurs.

docker-compose:

version: '3'
networks:
  banco:
  web:
  fila:
services:
  db:
    image: postgres:9.6
    env_file:
      - './docker/.env.db'
    networks:
      - banco
  app:
    build: .
    links:
      - db
    env_file:
      - './docker/.env.web'
    networks:
      - banco
      - web
      - fila
    depends_on:
      - db
    expose:
      - "3000"
  frontend:
    image: nginx:1.13
    volumes:
      - ./docker/nginx/default:/etc/nginx/nginx.conf
      - ./docker/nginx/default.conf:/etc/nginx/conf.d/default.conf
    ports:
      - 8081:80
    networks:
      - web
    depends_on:
      - app

Dockerfile:

FROM centos:7.4.1708
LABEL maintainer 'Blabla'

# Pre install
RUN yum -y install initscripts; \
    yum clean all; \
    yum -y update;  \
    yum -y install svn git git-svn telnet; \
    yum -y install postgresql-devel gcc-c++ patch readline readline-devel zlib zlib-devel libcurl-devel ImageMagick ImageMagick-devel libyaml-devel libffi-devel openssl-devel make bzip2 autoconf automake libtool bison;

# Utils
RUN yum -y install bash-completion; \
    yum -y install yum-plugin-priorities; \
    yum -y install epel-release; \
    yum -y install http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el7.rf.x86_64.rpm; \
    yum -y install vim-enhanced; \
    yum -y install htop;

RUN gpg --keyserver hkp://keys.gnupg.net --recv-keys 409B6B1796C275462A1703113804BB82D39DC0E3 7D2BAF1CF37B13E2069D6956105BD0E739499BDB
RUN \curl -L https://get.rvm.io | bash -s stable
RUN /bin/bash -l -c "rvm requirements"
RUN /bin/bash -l -c "rvm install 2.3"
RUN /bin/bash -l -c "gem install bundler --no-ri --no-rdoc"

RUN mkdir /usr/app
WORKDIR /usr/app

COPY . /usr/app

RUN /bin/bash -l -c "bundle check || bundle install"

RUN /bin/bash -l -c "RAILS_ENV=production bundle exec rake generate_secret_token"

RUN /bin/bash -l -c "foreman export systemd /etc/systemd/system -u root -a redmine_visagio"

CMD ["/sbin/init"]

database.yml

default: &default
  adapter: postgresql
  encoding: utf8
  host: db
  database: <%= ENV['DB_NAME'] %>
  username: <%= ENV['DB_USER'] %>
  password: <%= ENV['DB_PASSWORD'] %>

development:
  <<: *default

test:
  <<: *default

production:
  <<: *default

nginx.conf:

user nginx;
worker_processes auto;
error_log /var/log/nginx/error.log;
pid /run/nginx.pid;
env DB_NAME;
env DB_USER;
env DB_PASSWORD;

# Load dynamic modules. See /usr/share/nginx/README.dynamic.
include /usr/share/nginx/modules/*.conf;

events {
    worker_connections 1024;
}

http {
    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

    access_log  /var/log/nginx/access.log  main;

    sendfile            on;
    tcp_nopush          on;
    tcp_nodelay         on;
    keepalive_timeout   65;
    types_hash_max_size 2048;

    include             /etc/nginx/mime.types;
    default_type        application/octet-stream;

    # Load modular configuration files from the /etc/nginx/conf.d directory.
    # See http://nginx.org/en/docs/ngx_core_module.html#include
    # for more information.
    include /etc/nginx/conf.d/*.conf;
}

Stackoverflow topic:
https://stackoverflow.com/questions/47722386/rails-not-replace-envs-value-in-database-yml