編集履歴

質問編集履歴

エラーコードを追加

2020/08/17 07:07

投稿

mikepp

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -543,3 +543,23 @@
 ```
+# 追記
+```ここに言語を入力
+~@yk golfour_aws % docker-compose run web rails db:migrate
+Starting golfour_aws_db_1 ... done
+Error response from daemon: OCI runtime create failed: container_linux.go:349: starting container process caused "exec: \"exec\": executable file not found in $PATH": unknown
+```

タイトルを編集

2020/08/17 07:07

投稿

mikepp

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -386,6 +386,10 @@
+docker-composed.yml：
 ``` docker-composed.yml
 version: '3'
@@ -454,6 +458,12 @@
+database.yml：
 ``` database.yml
 default: &default

タイトルを編集

2020/08/16 14:49

投稿

mikepp

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -386,7 +386,7 @@
-```docker-composed.yml
+``` docker-composed.yml
 version: '3'
@@ -454,7 +454,7 @@
-```database.yml
+``` database.yml
 default: &default

エラーコードを追加

2020/08/16 14:48

投稿

mikepp

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -513,3 +513,23 @@
 ```
+```ここに言語を入力
+~@yk golfour_aws % docker-compose run web bundle exec rake db:create
+Starting golfour_aws_db_1 ... done
+Can't connect to MySQL server on 'db' (111 "Connection refused")
+Couldn't create 'golfour_development' database. Please check your configuration.
+rake aborted!
+Mysql2::Error::ConnectionError: Can't connect to MySQL server on 'db' (111 "Connection refused")
+```

mysqlエラーを追加

2020/08/16 14:41

投稿

mikepp

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -377,3 +377,139 @@
 Mysql2::Error::ConnectionError: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
 ```
+# 追記
+```docker-composed.yml
+version: '3'
+services:
+  db:
+    image: mysql:8.0
+    command: --default-authentication-plugin=mysql_native_password
+    environment:
+      MYSQL_ROOT_PASSWORD: password
+      MYSQL_DATABASE: golfour_development
+      MYSQL_USER: yuki
+      MYSQL_PASSWORD: password
+      TZ: Asia/Tokyo
+    volumes:
+      - ./mysql/mysql_data:/var/lib/mysql
+      - ./logs:/var/log/mysql
+      - ./mysql/my.cnf:/etc/mysql/conf.d/my.cnf
+    ports:
+      - "4306:3306"
+  web:
+    build:
+      context: .
+      dockerfile: Dockerfile
+    command: /bin/sh -c "rm -f /workdir/tmp/pids/server.pid && bundle exec rails s -p 3000 -b '0.0.0.0'"
+    tty: true
+    stdin_open: true
+    depends_on:
+      - db
+    ports:
+      - "3000:3000"
+    volumes:
+      - .:/workdir
+```
+```database.yml
+default: &default
+  adapter: mysql2
+  encoding: utf8
+  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
+development:
+  <<: *default
+  database: golfour_development
+  username: yuki
+  password: password
+  host: db
+  socket: /tmp/mysql.sock
+test:
+  <<: *default
+  database: golfour_test
+  host: db
+  username: yuki
+  password: password
+  socket: /tmp/mysql.sock
+production:
+  <<: *default
+  database: <%= ENV['DB_NAME'] %>
+  username: <%= ENV['DB_USERNAME'] %>
+  password: <%= ENV['DB_PASSWORD'] %>
+  host: <%= ENV['DB_HOSTNAME'] %>
+```

mysqlエラーを追加

2020/08/16 14:39

投稿

mikepp

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -353,3 +353,27 @@
 ```
+# 追記
+```ここに言語を入力
+~@yk golfour_aws % docker-compose run web bundle exec rake db:create
+Starting golfour_aws_db_1 ... done
+Database 'golfour_development' already exists
+Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
+Couldn't create 'golfour_test' database. Please check your configuration.
+rake aborted!
+Mysql2::Error::ConnectionError: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
+```

ログを追記

2020/08/16 11:00

投稿

mikepp

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -309,3 +309,47 @@
 ```
+# 追記
+```ここに言語を入力
+~@yk golfour_aws % docker-compose ps
+      Name                     Command               State            Ports
+------------------------------------------------------------------------------------
+golfour_aws_db_1    docker-entrypoint.sh mysqld      Exit 1
+golfour_aws_web_1   /bin/sh -c rm -f /workdir/ ...   Up       0.0.0.0:3000->3000/tcp
+~@yk golfour_aws % docker-compose logs db
+Attaching to golfour_aws_db_1
+db_1   | 2020-08-16 12:54:40+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.21-1debian10 started.
+db_1   | 2020-08-16 12:54:41+09:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
+db_1   | 2020-08-16 12:54:41+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.21-1debian10 started.
+db_1   | 2020-08-16 12:55:16+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.21-1debian10 started.
+db_1   | 2020-08-16 12:55:17+09:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
+db_1   | 2020-08-16 12:55:17+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.21-1debian10 started.
+db_1   | 2020-08-16 13:01:38+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.21-1debian10 started.
+db_1   | 2020-08-16 13:01:38+09:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
+db_1   | 2020-08-16 13:01:38+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.21-1debian10 started.
+```