Docker - PG :: ConnectionBad [英] Docker - PG::ConnectionBad

查看:397
本文介绍了Docker - PG :: ConnectionBad的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

使用Phusion乘客运行Rails,目前遇到postgres的麻烦,每当我运行构建命令我得到这个错误:

  PG :: ConnectionBad(无法连接到服务器:没有这样的文件或目录
服务器在本地运行,并在Unix域套接字上接受
连接/var/run/postgresql/.s.PGSQL.5432 ?
):

我的Dockerfile

  FROM phusion / passenger-customizable 
维护VodkaMD < support@nyvur.com>

ENV RACK_ENV = 生产 RAILS_ENV = 生产 SECRET_KEY_BASE = e09afa8b753cb175bcef7eb5f737accd02a4c16d9b6e5d475943605abd4277cdf47c488812d21d9c7117efd489d876f34be52f7ef7e88b21759a079339b198ce

ENV HOME /根
CMD [ / sbin目录/ my_init]

运行/pd_build/utilities.sh
运行/pd_build/ruby2.2.sh
运行/pd_build/python.sh
运行/pd_build/nodejs.sh

#自定义指令
RUN apt-get update&& apt-get install -y vim nano对话框net-tools build-essential wget
运行apt-get install -y postgresql-client --no-install-recommendations
RUN apt-get clean&& rm -rf / var / lib / apt / lists / * / tmp / * / var / tmp / *

#生成SSL证书
RUN mkdir / etc / nginx / ssl
#RUN openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/nginx/ssl/nginx.key -out /etc/nginx/ssl/nginx.crt

#启用Nginx和Passenger
运行rm -f / etc / service / nginx / down
#启用Redis
运行rm -f / etc / service / redis / down
#启用SSH
RUN rm -f / etc / service / sshd / down
#启用Postgres
运行rm -f / etc / service / postgres / down

#安装包的宝石
WORKDIR / tmp
添加Gemfile / tmp /
添加Gemfile.lock / tmp /
运行捆绑安装

#复制应用程序文件夹
RUN mkdir / home / app / Nyvur
添加。 / home / app / Nyvur
RUN chown -R app:app / home / app / Nyvur
WORKDIR / home / app / Nyvur
RUN bundle exec rake assets:precompile

#添加虚拟主机条目
RUN rm / etc / nginx / sites-enabled / default
COPY config / nginx_configs.conf /etc/nginx/sites-enabled/Nyvur.conf
ADD config / postgres-env.conf /etc/nginx/main.d/postgres-env.conf

运行mkdir -p / var / www / Nyvur / tmp / pids
RUN mkdir -p / var / www / Nyvur / tmp / sockets
RUN mkdir -p / var / www / Nyvur / log

RUN apt-get clean&& rm -rf / var / lib / apt / lists / * / tmp / * / var / tmp / *

EXPOSE 80 443
RUN包执行乘客起始-p 80 -e生产

我的docker-compose

  postgres:
restart:always
image:postgres:9.4。 4
ports:
- 5432:5432#将主机端口5432绑定到PostgreSQL端口5432
卷:
- ./db/dumps:/app-db-dumps
- ./db/postgres-setup.sql/docker-entrypoint-initdb.d/setup.sql
环境:
LC_ALL:C.UTF-8
POSTGRES_PASSWORD:3x1mpl3

mongo:
image:mongo:3.0.7
ports:
- 27017:27017
命令:--smallfiles --rest - auth

redis:
image:redis:3.0.4
ports:
- 6379:6379#将主机端口6379绑定到Redis端口6379

web:& app_base
build:。
ports:
- 80:80
卷:
- 。:/ Nyvur
链接:& app_links
- postgres:postgres.local
- redis:redis.local
环境:& app_environment
#PostgreSQL开发数据库:
#DATABASE_URL:postgres:// postgres:3x1mpl3@postgres.local:5432 / App_production ?pool = 25& encoding = unicode& schema_search_path = public
REDIS_URL:redis://redis.local:6379
SIDEKIQ_CONCURRENCY:5
SIDEKIQ_TIMEOUT:10
ENABLE_DEBUG_SERVER:true
RACK_ENV:production
RAILS_ENV:production

worker:
< ;: * app_base
ports:[]
命令:sidekiq -c 25 -e生产-q默认
环境:
SECRET_KEY_BASE:e09afa8b753cb175bcef7eb5f737accd02a4c16d9b6e5d475943605abd4277cdf47c488812d21d9c7117efd489d876f34be52f7ef7e88b21759a079339b198ce
环境:
#SECRET_KEY_BASE:
RAILS_ENV:生产

全错误日志

  =============== Phusion Passenger独立Web服务器启动=============== 
PID文件:/ home / app / Nyvur / passenger.80.pid
日志文件:/home/app/Nyvur/log/passenger.80.log
环境:生产
可通过http://0.0访问。 0.0 /

您可以按Ctrl-C停止Phusion乘客独立。
问题?检查https://www.phusionpassenger.com/library/admin/standalone/troubleshooting/
========================= ================================================== ==
应用程序107 stderr:stdin:不是一个tty
应用程序107 stdout:
应用程序107 stdout:I,[2015-12-17T17:34:39.223372#107] INFO - :** [Raven] Raven 0.12.3准备抓到错误
I,[2015-12-17T17:34:40.413454#127] INFO - :开始HEAD/为2015年12月127.0.0.1 -17 17:34:40 +0000
App 127 stdout:
F,[2015-12-17T17:34:41.543651#127]致命 - :
PG :: ConnectionBad不连接到服务器:没有这样的文件或目录
服务器是否在本地运行,并在Unix域套接字上接受
连接/var/run/postgresql/.s.PGSQL.5432?

activerecord(4.1.2)lib / active_record / connection_adapters / postgresql_adapter.rb:888:在'initialize'
activerecord(4.1.2)lib / active_record / connection_adapters / postgresql_adapter.rb:888:在new
activerecord(4.1.2)lib / activ中e_record / connection_adapters / postgresql_adapter.rb:888:`connect'
activerecord(4.1.2)lib / active_record / connection_adapters / postgresql_adapter.rb:568:in'initialize'
activerecord(4.1.2) lib / active_record / connection_adapters / postgresql_adapter.rb:41:在`new'
activerecord(4.1.2)lib / active_record / connection_adapters / postgresql_adapter.rb:41:在`postgresql_connection'
activerecord(4.1。 2)lib / active_record / connection_adapters / abstract / connection_pool.rb:435:在`new_connection'
activerecord(4.1.2)lib / active_record / connection_adapters / abstract / connection_pool.rb:445:在`checkout_new_connection'
activerecord(4.1.2)lib / active_record / connection_adapters / abstract / connection_pool.rb:416:在`acquire_connection'
activerecord(4.1.2)lib / active_record / connection_adapters / abstract / connection_pool.rb:351:在`block in checkout'
/usr/lib/ruby/2.2.0/monitor.rb:211:in`mon_synchronize'
activerecord(4.1.2)lib / activ e_record / connection_adapters / abstract / connection_pool.rb:350:in`checkout'
activerecord(4.1.2)lib / active_record / connection_adapters / abstract / connection_pool.rb:265:在'block in connection'
/usr/lib/ruby/2.2.0/monitor.rb:211:in`mon_synchronize'
activerecord(4.1.2)lib / active_record / connection_adapters / abstract / connection_pool.rb:264:在`connection'
activerecord(4.1.2)lib / active_record / connection_adapters / abstract / connection_pool.rb:541:在`retrieve_connection'
activerecord(4.1.2)lib / active_record / connection_handling.rb:113:在`retrieve_connection '
activerecord(4.1.2)lib / active_record / connection_handling.rb:87:在`connection'
activerecord(4.1.2)lib / active_record / query_cache.rb:51:在`restore_query_cache_settings'
activerecord(4.1.2)lib / active_record / query_cache.rb:43:在rescue in call
activerecord(4.1.2)lib / active_record / query_cache.rb:32:在`call'
activerecord(4.1.2)lib / active_r ecord / connection_adapters / abstract / connection_pool.rb:621:在`call'
actionpack(4.1.2)lib / action_dispatch / middleware / callbacks.rb:29:在`block in call'
activesupport 4.1.2)lib / active_support / callbacks.rb:82:在`run_callbacks'
actionpack(4.1.2)lib / action_dispatch / middleware / callbacks.rb:27:在`call'
actionpack 4.1.2)lib / action_dispatch / middleware / remote_ip.rb:76:在`call'
actionpack(4.1.2)lib / action_dispatch / middleware / debug_exceptions.rb:17:在`call'
actionpack(4.1.2)lib / action_dispatch / middleware / show_exceptions.rb:30:in`call'
railties(4.1.2)lib / rails / rack / logger.rb:38:在`call_app'
railties(4.1.2)lib / rails / rack / logger.rb:20:在`block in call'
activesupport(4.1.2)lib / active_support / tagged_logging.rb:68:在`block in标签'
activesupport(4.1.2)lib / active_support / tagged_logging.rb:26:在tagged
activesupport(4.1.2)lib / active_support / tagged_logging.rb:68:在tagged
railties(4.1.2)lib / rails / rack / logger.rb:20:在`call'
request_store(1.1.0)lib / request_store / middleware.rb:8:在`call'
actionpack(4.1.2)lib / action_dispatch / middleware / request_id.rb:21:在`call'
机架(1.5.2)lib / rack / methodoverride.rb:21:在`call'
机架(1.5.2)lib / rack / runtime.rb:17:在`call'
activesupport(4.1.2)lib / active_support / cache / strategy / local_cache_middleware.rb:26:调用'
机架(1.5.2)lib / rack / sendfile.rb:112:在`call'
sentry-raven(0.12.3)lib / raven / integrationations / rack.rb:61:在call
railties(4.1.2)lib / rails / engine.rb:514:在`call'
railties(4.1.2)lib / rails / application.rb:144:in`调用'
乘客(5.0.22)src / ruby​​_supportlib / phusion_passenger / rack / thread_handler_extension.rb:97:在'process_request'
乘客(5.0.22)src / ruby​​_supportlib / phusion_passenger / request_handler / thread_handler。 rb:160:在`accept_and_process_next_request'
乘客(5.0.22)src / ru by_supportlib / phusion_passenger / request_handler / thread_handler.rb:113:在`main_loop'
乘客(5.0.22)src / ruby​​_supportlib / phusion_passenger / request_handler.rb:416:在`block(3级)在start_threads'
乘客(5.0.22)src / ruby​​_supportlib / phusion_passenger / utils.rb:113:在`block in create_thread_and_abort_on_exception'


I,[2015-12-17T17:34:41.559638 #127] INFO - :Rendered /var/lib/gems/2.2.0/gems/actionpack-4.1.2/lib/action_dispatch/middleware/templates/rescues/_source.erb(0.6ms)
I, [2015-12-17T17:34:41.566011#127] INFO - :Rendered /var/lib/gems/2.2.0/gems/actionpack-4.1.2/lib/action_dispatch/middleware/templates/rescues/_trace.html .erb(1.1ms)
I,[2015-12-17T17:34:41.572608#127] INFO - :Rendered /var/lib/gems/2.2.0/gems/actionpack-4.1.2/lib /action_dispatch/middleware/templates/rescues/_request_and_response.html.erb(0.9ms)
I,[2015-12-17T17:34:41.572727#127] INFO - :Rendered /var/lib/gems/2.2 0.0 /宝石/动作拯救/布局(20.2ms)中的pack-4.1.2 / lib / action_dispatch / middleware / templates / rescues / diagnostics.erb
^ CERROR:
中止。

任何帮助都非常感激,我还在挂起Docker并开始制作。 / p>

解决方案

它尝试连接到Unix域套接字的事实指出了Rails应用程序中的配置问题。您的 docker-compose.yml 中有 DATABASE_URL ,但它被注释掉 - 取消注释,至少应该更接近(应用程序应该至少尝试开始连接到 postgres.local ,而不是本地Unix域套接字,因为Postgres在单独的容器中运行,因此不会存在) 。


Running Rails with Phusion Passenger, currently having trouble with postgres, whenever I run the build command I get this error:

 PG::ConnectionBad (could not connect to server: No such file or directory
     Is the server running locally and accepting
     connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 ):

My Dockerfile

FROM phusion/passenger-customizable
MAINTAINER VodkaMD <support@nyvur.com>

ENV RACK_ENV="production" RAILS_ENV="production" SECRET_KEY_BASE="e09afa8b753cb175bcef7eb5f737accd02a4c16d9b6e5d475943605abd4277cdf47c488812d21d9c7117efd489d876f34be52f7ef7e88b21759a079339b198ce"

ENV HOME /root
CMD ["/sbin/my_init"]

RUN /pd_build/utilities.sh
RUN /pd_build/ruby2.2.sh
RUN /pd_build/python.sh
RUN /pd_build/nodejs.sh

# Custom instructions
RUN apt-get update && apt-get install -y vim nano dialog net-tools build-essential wget
RUN apt-get install -y postgresql-client --no-install-recommends
RUN apt-get clean && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

# Generate SSL Certificate
RUN mkdir /etc/nginx/ssl
# RUN openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/nginx/ssl/nginx.key -out /etc/nginx/ssl/nginx.crt

# Enable Nginx and Passenger
RUN rm -f /etc/service/nginx/down
# Enable Redis
RUN rm -f /etc/service/redis/down
# Enable SSH
RUN rm -f /etc/service/sshd/down
# Enable Postgres
RUN rm -f /etc/service/postgres/down

# Install bundle of gems
WORKDIR /tmp
ADD Gemfile /tmp/
ADD Gemfile.lock /tmp/
RUN bundle install

# Copy application folder
RUN mkdir /home/app/Nyvur
ADD . /home/app/Nyvur
RUN chown -R app:app /home/app/Nyvur
WORKDIR /home/app/Nyvur
RUN bundle exec rake assets:precompile

# Add a virtual host entry
RUN rm /etc/nginx/sites-enabled/default
COPY config/nginx_configs.conf /etc/nginx/sites-enabled/Nyvur.conf
ADD config/postgres-env.conf /etc/nginx/main.d/postgres-env.conf

RUN mkdir -p /var/www/Nyvur/tmp/pids
RUN mkdir -p /var/www/Nyvur/tmp/sockets
RUN mkdir -p /var/www/Nyvur/log

RUN apt-get clean && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

EXPOSE 80 443
RUN bundle exec passenger start -p 80 -e production

My docker-compose

postgres:
  restart: always
  image: postgres:9.4.4
  ports:
    - "5432:5432" # Bind host port 5432 to PostgreSQL port 5432
  volumes:
    - ./db/dumps:/app-db-dumps
    - ./db/postgres-setup.sql/docker-entrypoint-initdb.d/setup.sql
  environment:
    LC_ALL: C.UTF-8
    POSTGRES_PASSWORD: 3x1mpl3

mongo:
  image: mongo:3.0.7
  ports:
    - "27017:27017"
  command: --smallfiles --rest --auth

redis:
  image: redis:3.0.4
  ports:
    - "6379:6379" # Bind host port 6379 to Redis port 6379

web: &app_base
  build: .
  ports:
    - "80:80"
  volumes:
    - .:/Nyvur
  links: &app_links
    - postgres:postgres.local
    - redis:redis.local
  environment: &app_environment
    # PostgreSQL Development Database:
    # DATABASE_URL: postgres://postgres:3x1mpl3@postgres.local:5432/App_production?pool=25&encoding=unicode&schema_search_path=public
    REDIS_URL: redis://redis.local:6379
    SIDEKIQ_CONCURRENCY: 5
    SIDEKIQ_TIMEOUT: 10
    ENABLE_DEBUG_SERVER: true
    RACK_ENV: production
    RAILS_ENV: production

worker:
  <<: *app_base
  ports: []
  command: sidekiq -c 25 -e production -q default
  environment:
    SECRET_KEY_BASE: e09afa8b753cb175bcef7eb5f737accd02a4c16d9b6e5d475943605abd4277cdf47c488812d21d9c7117efd489d876f34be52f7ef7e88b21759a079339b198ce
  environment:
    # SECRET_KEY_BASE:
    RAILS_ENV: production

Full error log

=============== Phusion Passenger Standalone web server started ===============
PID file: /home/app/Nyvur/passenger.80.pid
Log file: /home/app/Nyvur/log/passenger.80.log
Environment: production
Accessible via: http://0.0.0.0/

You can stop Phusion Passenger Standalone by pressing Ctrl-C.
Problems? Check https://www.phusionpassenger.com/library/admin/standalone/troubleshooting/
===============================================================================
App 107 stderr: stdin: is not a tty
App 107 stdout:
App 107 stdout: I, [2015-12-17T17:34:39.223372 #107]  INFO -- : ** [Raven] Raven 0.12.3 ready to catch errors
I, [2015-12-17T17:34:40.413454 #127]  INFO -- : Started HEAD "/" for 127.0.0.1 at 2015-12-17 17:34:40 +0000
App 127 stdout:
F, [2015-12-17T17:34:41.543651 #127] FATAL -- :
PG::ConnectionBad (could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
):
  activerecord (4.1.2) lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `initialize'
  activerecord (4.1.2) lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `new'
  activerecord (4.1.2) lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `connect'
  activerecord (4.1.2) lib/active_record/connection_adapters/postgresql_adapter.rb:568:in `initialize'
  activerecord (4.1.2) lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new'
  activerecord (4.1.2) lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in `new_connection'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in `checkout_new_connection'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `acquire_connection'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in `block in checkout'
  /usr/lib/ruby/2.2.0/monitor.rb:211:in `mon_synchronize'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in `checkout'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
  /usr/lib/ruby/2.2.0/monitor.rb:211:in `mon_synchronize'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
  activerecord (4.1.2) lib/active_record/connection_handling.rb:113:in `retrieve_connection'
  activerecord (4.1.2) lib/active_record/connection_handling.rb:87:in `connection'
  activerecord (4.1.2) lib/active_record/query_cache.rb:51:in `restore_query_cache_settings'
  activerecord (4.1.2) lib/active_record/query_cache.rb:43:in `rescue in call'
  activerecord (4.1.2) lib/active_record/query_cache.rb:32:in `call'
  activerecord (4.1.2) lib/active_record/connection_adapters/abstract/connection_pool.rb:621:in `call'
  actionpack (4.1.2) lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'
  activesupport (4.1.2) lib/active_support/callbacks.rb:82:in `run_callbacks'
  actionpack (4.1.2) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
  actionpack (4.1.2) lib/action_dispatch/middleware/remote_ip.rb:76:in `call'
  actionpack (4.1.2) lib/action_dispatch/middleware/debug_exceptions.rb:17:in `call'
  actionpack (4.1.2) lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'
  railties (4.1.2) lib/rails/rack/logger.rb:38:in `call_app'
  railties (4.1.2) lib/rails/rack/logger.rb:20:in `block in call'
  activesupport (4.1.2) lib/active_support/tagged_logging.rb:68:in `block in tagged'
  activesupport (4.1.2) lib/active_support/tagged_logging.rb:26:in `tagged'
  activesupport (4.1.2) lib/active_support/tagged_logging.rb:68:in `tagged'
  railties (4.1.2) lib/rails/rack/logger.rb:20:in `call'
  request_store (1.1.0) lib/request_store/middleware.rb:8:in `call'
  actionpack (4.1.2) lib/action_dispatch/middleware/request_id.rb:21:in `call'
  rack (1.5.2) lib/rack/methodoverride.rb:21:in `call'
  rack (1.5.2) lib/rack/runtime.rb:17:in `call'
  activesupport (4.1.2) lib/active_support/cache/strategy/local_cache_middleware.rb:26:in `call'
  rack (1.5.2) lib/rack/sendfile.rb:112:in `call'
  sentry-raven (0.12.3) lib/raven/integrations/rack.rb:61:in `call'
  railties (4.1.2) lib/rails/engine.rb:514:in `call'
  railties (4.1.2) lib/rails/application.rb:144:in `call'
  passenger (5.0.22) src/ruby_supportlib/phusion_passenger/rack/thread_handler_extension.rb:97:in `process_request'
  passenger (5.0.22) src/ruby_supportlib/phusion_passenger/request_handler/thread_handler.rb:160:in `accept_and_process_next_request'
  passenger (5.0.22) src/ruby_supportlib/phusion_passenger/request_handler/thread_handler.rb:113:in `main_loop'
  passenger (5.0.22) src/ruby_supportlib/phusion_passenger/request_handler.rb:416:in `block (3 levels) in start_threads'
  passenger (5.0.22) src/ruby_supportlib/phusion_passenger/utils.rb:113:in `block in create_thread_and_abort_on_exception'


I, [2015-12-17T17:34:41.559638 #127]  INFO -- :   Rendered /var/lib/gems/2.2.0/gems/actionpack-4.1.2/lib/action_dispatch/middleware/templates/rescues/_source.erb (0.6ms)
I, [2015-12-17T17:34:41.566011 #127]  INFO -- :   Rendered /var/lib/gems/2.2.0/gems/actionpack-4.1.2/lib/action_dispatch/middleware/templates/rescues/_trace.html.erb (1.1ms)
I, [2015-12-17T17:34:41.572608 #127]  INFO -- :   Rendered /var/lib/gems/2.2.0/gems/actionpack-4.1.2/lib/action_dispatch/middleware/templates/rescues/_request_and_response.html.erb (0.9ms)
I, [2015-12-17T17:34:41.572727 #127]  INFO -- :   Rendered /var/lib/gems/2.2.0/gems/actionpack-4.1.2/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (20.2ms)
^CERROR:
Aborting.

Any help is really appreciated, I'm still getting the hang of Docker and working on production.

解决方案

The fact that it's trying to connect to a Unix domain socket points to a configuration issue in the Rails application. Your docker-compose.yml has DATABASE_URL in it, but it's commented out -- uncommenting that should at least get closer (the application should at least attempt to start connecting to postgres.local instead of a local Unix domain socket which isn't going to exist since Postgres is running in a separate container).

这篇关于Docker - PG :: ConnectionBad的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
相关文章
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆