ec2上にdockerとrailsをデプロイしようと思っています。
しかし、We're sorry, but something went wrong.がでてしまいデプロイできません。logを見たところ
log
12020-11-23T12:11:33.019501Z 2 [Note] Access denied for user 'root'@'172.22.0.5' (using password: YES) 2
で止まっていることがわかりました。
いろいろサイトを見てみたところ自己解決できず質問させていただきました。
docker-compose.ymlが原因なのかと思うのですが解決方法がわからずもしわかる方がいれば教えてほしいです。。
宜しくお願いします。
databasesyml
1# MySQL. Versions 6.1.10 and up are supported. 2# 3# Install the MySQL driver 4# gem install mysql2 5# 6# Ensure the MySQL gem is defined in your Gemfile 7# gem 'mysql2' 8# 9# And be sure to use new-style password hashing: 10# https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html 11# 12default: &default 13 adapter: mysql2 14 encoding: utf8 15 pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %> 16 username: root 17 password: password 18 host: db 19 20development: 21 <<: *default 22 database: app_development 23 24# Warning: The database defined as "test" will be erased and 25# re-generated from your development database when you run "rake". 26# Do not set this db to the same as development or production. 27test: 28 <<: *default 29 database: app_test 30 31# As with config/secrets.yml, you never want to store sensitive information, 32# like your database password, in your source code. If your source code is 33# ever seen by anyone, they now have access to your database. 34# Instead, provide the password as a unix environment variable when you boot 35# the app. Read http://guides.rubyonrails.org/configuring.html#configuring-a-database 36# for a full rundown on how to provide these environment variables in a 37# production deployment. 38# 39# On Heroku and other platform providers, you may have a full connection URL 40# available as an environment variable. For example: 41# 42# DATABASE_URL="mysql2://myuser:mypass@localhost/somedatabase" 43# 44# You can use this database configuration with: 45# 46# production: 47# url: <%= ENV['DATABASE_URL'] %> 48# 49production: 50 <<: *default 51 database: <%= ENV['DB_NAME'] %> 52 username: <%= ENV['DB_USERNAME'] %> 53 password: <%= ENV['DB_PASSWORD'] %> 54 host: <%= ENV['DB_HOSTNAME'] %> 55
dockercomposeyml
1version: '3' 2services: 3 app: 4 build: 5 context: . 6 env_file: 7 - ./environments/db.env 8 command: bundle exec puma -C config/puma.rb 9 volumes: 10 - .:/music_app 11 - public-data:/music_app/public 12 - tmp-data:/music_app/tmp 13 - log-data:/music_app/log 14 depends_on: 15 - db 16 db: 17 image: mysql:5.7 18 environment: 19 MYSQL_ROOT_PASSWORD: strongrootpassword 20 env_file: 21 - ./environments/db.env 22 volumes: 23 - db-data:/var/lib/mysql 24 web: 25 build: 26 context: containers/nginx 27 volumes: 28 - public-data:/music_app/public 29 - tmp-data:/music_app/tmp 30 ports: 31 - 80:80 32 depends_on: 33 - app 34volumes: 35"docker-compose.yml" 38L, 736C
env
1DB_NAME=musicapp_production 2DB_USERNAME=admin 3DB_PASSWORD=052589Nao 4DB_HOSTNAME=RDSエンドポイント.amazonaws.com
あなたの回答
tips
プレビュー