teratail
回答率
85.35%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問Docker・EC2で環境構築をしたが、パブリックIPを叩いても接続を拒否される

編集履歴

質問編集履歴

12

追記の削除

2020/10/15 12:10

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -13,60 +13,6 @@
13
13
  以下参考にしている記事です。
14
14
 
15
15
  [https://qiita.com/at-946/items/1e8acea19cc0b9f31b98](https://qiita.com/at-946/items/1e8acea19cc0b9f31b98)
16
-
17
-
18
-
19
- 【追記3】
20
-
21
- アプリのディレクトリ・ファイル一覧を記載します。
22
-
23
- -rw-rw-r-- 1 Yusaku Yusaku 1894 10月 11 07:59 Dockerfile
24
-
25
- -rw-rw-r-- 1 Yusaku Yusaku 2334 10月 11 07:59 Gemfile
26
-
27
- -rw-rw-r-- 1 Yusaku Yusaku 8290 10月 11 07:59 Gemfile.lock
28
-
29
- -rw-rw-r-- 1 Yusaku Yusaku 39 10月 11 07:59 Procfile
30
-
31
- -rw-rw-r-- 1 Yusaku Yusaku 374 10月 11 07:59 README.md
32
-
33
- -rw-rw-r-- 1 Yusaku Yusaku 227 10月 11 07:59 Rakefile
34
-
35
- drwxrwxr-x 11 Yusaku Yusaku 142 10月 11 07:59 app
36
-
37
- -rw-rw-r-- 1 Yusaku Yusaku 1722 10月 11 07:59 babel.config.js
38
-
39
- drwxrwxr-x 2 Yusaku Yusaku 97 10月 11 07:59 bin
40
-
41
- drwxrwxr-x 6 Yusaku Yusaku 329 10月 11 08:08 config
42
-
43
- -rw-rw-r-- 1 Yusaku Yusaku 130 10月 11 07:59 config.ru
44
-
45
- drwxrwxr-x 3 Yusaku Yusaku 54 10月 11 07:59 db
46
-
47
- -rw-rw-r-- 1 Yusaku Yusaku 355 10月 11 07:59 docker-compose.yml
48
-
49
- drwxrwxr-x 4 Yusaku Yusaku 33 10月 11 07:59 lib
50
-
51
- drwxrwxr-x 2 Yusaku Yusaku 42 10月 11 08:08 log
52
-
53
- drwxr-xr-x 771 root root 24576 10月 11 08:10 node_modules
54
-
55
- -rw-rw-r-- 1 Yusaku Yusaku 396 10月 11 07:59 package.json
56
-
57
- -rw-rw-r-- 1 Yusaku Yusaku 224 10月 11 07:59 postcss.config.js
58
-
59
- drwxrwxr-x 4 Yusaku Yusaku 186 10月 11 08:10 public
60
-
61
- drwxrwxr-x 9 Yusaku Yusaku 155 10月 11 07:59 spec
62
-
63
- drwxrwxr-x 2 Yusaku Yusaku 19 10月 11 07:59 storage
64
-
65
- drwxrwxr-x 5 Yusaku Yusaku 108 10月 11 08:11 tmp
66
-
67
- drwxrwxr-x 2 Yusaku Yusaku 19 10月 11 07:59 vendor
68
-
69
- -rw-rw-r-- 1 Yusaku Yusaku 326349 10月 11 07:59 yarn.lock
70
16
 
71
17
 
72
18
 

11

追記の修正

2020/10/15 12:10

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -20,17 +20,53 @@
20
20
 
21
21
  アプリのディレクトリ・ファイル一覧を記載します。
22
22
 
23
-
23
+ -rw-rw-r-- 1 Yusaku Yusaku 1894 10月 11 07:59 Dockerfile
24
+
24
-
25
+ -rw-rw-r-- 1 Yusaku Yusaku 2334 10月 11 07:59 Gemfile
26
+
27
+ -rw-rw-r-- 1 Yusaku Yusaku 8290 10月 11 07:59 Gemfile.lock
28
+
29
+ -rw-rw-r-- 1 Yusaku Yusaku 39 10月 11 07:59 Procfile
30
+
31
+ -rw-rw-r-- 1 Yusaku Yusaku 374 10月 11 07:59 README.md
32
+
33
+ -rw-rw-r-- 1 Yusaku Yusaku 227 10月 11 07:59 Rakefile
34
+
35
+ drwxrwxr-x 11 Yusaku Yusaku 142 10月 11 07:59 app
36
+
37
+ -rw-rw-r-- 1 Yusaku Yusaku 1722 10月 11 07:59 babel.config.js
38
+
39
+ drwxrwxr-x 2 Yusaku Yusaku 97 10月 11 07:59 bin
40
+
41
+ drwxrwxr-x 6 Yusaku Yusaku 329 10月 11 08:08 config
42
+
43
+ -rw-rw-r-- 1 Yusaku Yusaku 130 10月 11 07:59 config.ru
44
+
45
+ drwxrwxr-x 3 Yusaku Yusaku 54 10月 11 07:59 db
46
+
47
+ -rw-rw-r-- 1 Yusaku Yusaku 355 10月 11 07:59 docker-compose.yml
48
+
49
+ drwxrwxr-x 4 Yusaku Yusaku 33 10月 11 07:59 lib
50
+
51
+ drwxrwxr-x 2 Yusaku Yusaku 42 10月 11 08:08 log
52
+
25
- Dockerfile Rakefile config.ru node_modules storage
53
+ drwxr-xr-x 771 root root 24576 10月 11 08:10 node_modules
26
-
54
+
27
- Gemfile app db package.json tmp
55
+ -rw-rw-r-- 1 Yusaku Yusaku 396 10月 11 07:59 package.json
28
-
56
+
29
- Gemfile.lock babel.config.js docker-compose.yml postcss.config.js vendor
57
+ -rw-rw-r-- 1 Yusaku Yusaku 224 10月 11 07:59 postcss.config.js
30
-
58
+
31
- Procfile bin lib public yarn.lock
59
+ drwxrwxr-x 4 Yusaku Yusaku 186 10月 11 08:10 public
32
-
60
+
33
- README.md config log spec
61
+ drwxrwxr-x 9 Yusaku Yusaku 155 10月 11 07:59 spec
62
+
63
+ drwxrwxr-x 2 Yusaku Yusaku 19 10月 11 07:59 storage
64
+
65
+ drwxrwxr-x 5 Yusaku Yusaku 108 10月 11 08:11 tmp
66
+
67
+ drwxrwxr-x 2 Yusaku Yusaku 19 10月 11 07:59 vendor
68
+
69
+ -rw-rw-r-- 1 Yusaku Yusaku 326349 10月 11 07:59 yarn.lock
34
70
 
35
71
 
36
72
 

10

追記の修正

2020/10/15 11:51

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -32,8 +32,6 @@
32
32
 
33
33
  README.md config log spec
34
34
 
35
- [Yusaku@ip-172-31-38-16 komarigoto-hiroba]$
36
-
37
35
 
38
36
 
39
37
 

9

ディレクトリ・ファイル一覧の追記

2020/10/15 11:47

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -16,6 +16,28 @@
16
16
 
17
17
 
18
18
 
19
+ 【追記3】
20
+
21
+ アプリのディレクトリ・ファイル一覧を記載します。
22
+
23
+
24
+
25
+ Dockerfile Rakefile config.ru node_modules storage
26
+
27
+ Gemfile app db package.json tmp
28
+
29
+ Gemfile.lock babel.config.js docker-compose.yml postcss.config.js vendor
30
+
31
+ Procfile bin lib public yarn.lock
32
+
33
+ README.md config log spec
34
+
35
+ [Yusaku@ip-172-31-38-16 komarigoto-hiroba]$
36
+
37
+
38
+
39
+
40
+
19
41
  【追記2】
20
42
 
21
43
  database.ymlとdocker-compose.ymlの内容を追記いたします。

8

database.ymlとdocker-compose.ymlを追記

2020/10/15 11:46

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -17,6 +17,124 @@
17
17
 
18
18
 
19
19
  【追記2】
20
+
21
+ database.ymlとdocker-compose.ymlの内容を追記いたします。
22
+
23
+ ```ここに言語を入力
24
+
25
+ # database.yml
26
+
27
+
28
+
29
+ default: &default
30
+
31
+ adapter: mysql2
32
+
33
+ encoding: utf8
34
+
35
+ pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
36
+
37
+ username: root
38
+
39
+ password: pass
40
+
41
+ host: db # docker-compose.ymlのservice名
42
+
43
+
44
+
45
+ development:
46
+
47
+ <<: *default
48
+
49
+ database: myapp_development
50
+
51
+
52
+
53
+ test:
54
+
55
+ <<: *default
56
+
57
+ database: myapp_test
58
+
59
+
60
+
61
+ production:
62
+
63
+ <<: *default
64
+
65
+ host: <%= Rails.application.credentials.rds[:host] %>
66
+
67
+ database: <%= Rails.application.credentials.rds[:database] %>
68
+
69
+ username: <%= Rails.application.credentials.rds[:username] %>
70
+
71
+ password: <%= Rails.application.credentials.rds[:password] %>
72
+
73
+
74
+
75
+ ```
76
+
77
+
78
+
79
+
80
+
81
+ ```
82
+
83
+ #docker-compose.yml
84
+
85
+
86
+
87
+ version: '3'
88
+
89
+ services:
90
+
91
+ db:
92
+
93
+ image: mysql:5.7
94
+
95
+ environment:
96
+
97
+ MYSQL_ROOT_PASSWORD: pass
98
+
99
+ MYSQL_DATABASE: root
100
+
101
+ ports:
102
+
103
+ - "3306:3306"
104
+
105
+ volumes:
106
+
107
+ - /var/lib/mysql
108
+
109
+
110
+
111
+ web:
112
+
113
+ build: .
114
+
115
+ command: rails s -p 3000 -b '0.0.0.0'
116
+
117
+ volumes:
118
+
119
+ - .:/myapp
120
+
121
+ - /app/tmp
122
+
123
+ ports:
124
+
125
+ - "3000:3000"
126
+
127
+ links:
128
+
129
+ - db
130
+
131
+
132
+
133
+ ```
134
+
135
+
136
+
137
+
20
138
 
21
139
  使っているフレームワーク・ツールを記載します。
22
140
 

7

追記の修正

2020/10/13 11:12

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -20,15 +20,17 @@
20
20
 
21
21
  使っているフレームワーク・ツールを記載します。
22
22
 
23
- ・参考記事で指定されていないもの
23
+ - 参考記事で指定されていないもの
24
24
 
25
- MySQL, CircleCI, Github
25
+ MySQL(記事ではPostgreSQL), CircleCI, Github(記事ではGitlab)
26
26
 
27
27
 
28
28
 
29
- ・参考記事で指定されているもの
29
+ - 参考記事で指定されているもの
30
30
 
31
31
  Docker, docker-compose, Rails, RDS, AMI, EC2
32
+
33
+
32
34
 
33
35
 
34
36
 

6

フレームワーク・ツールについて記載をした

2020/10/13 10:19

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -16,7 +16,23 @@
16
16
 
17
17
 
18
18
 
19
- 【追記】
19
+ 【追記2】
20
+
21
+ 使っているフレームワーク・ツールを記載します。
22
+
23
+ ・参考記事で指定されていないもの
24
+
25
+ MySQL, CircleCI, Github
26
+
27
+
28
+
29
+ ・参考記事で指定されているもの
30
+
31
+ Docker, docker-compose, Rails, RDS, AMI, EC2
32
+
33
+
34
+
35
+ 【追記1】
20
36
 
21
37
  Railsアプリのlogディレクトリにあったdevelopment.logの内容を追記します。
22
38
 

5

ログの修正

2020/10/13 10:08

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -22,100 +22,40 @@
22
22
 
23
23
  ```ここに言語を入力
24
24
 
25
- ESC[1mESC[35m (4.1ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
25
+ ESC[1mESC[36mActiveRecord::InternalMetadata Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `ar_internal_metadata` (`key`, `value`, `created_at`, `updated_at`) VALUES ('environment', 'development', '2020-10-11 08:08:59.724641', '2020-10-11 08:08:59.724641')ESC[0m
26
26
 
27
- N.wait_timeout = 2147483ESC[0m
27
+ ESC[1mESC[35m (1.3ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
28
28
 
29
- ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_development` DEFAULT CHARACTER SET `utf8`ESC[0m
29
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT RELEASE_LOCK('7864839756650184315')ESC[0m
30
30
 
31
- ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
31
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
32
32
 
33
- N.wait_timeout = 2147483ESC[0m
33
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
34
34
 
35
- ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_test` DEFAULT CHARACTER SET `utf8`ESC[0m
35
+ ESC[1mESC[35m (17.8ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
36
36
 
37
- ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
37
+ ESC[1mESC[35m (2.4ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_development` DEFAULT CHARACTER SET `utf8`ESC[0m
38
38
 
39
- N.wait_timeout = 2147483ESC[0m
39
+ ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
40
40
 
41
- ESC[1mESC[35m (8.9ms)ESC[0m ESC[1mESC[35mCREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL PRIMARY KEY)ESC[0m
41
+ ESC[1mESC[35m (0.8ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_test` DEFAULT CHARACTER SET `utf8`ESC[0m
42
42
 
43
- ESC[1mESC[35m (7.6ms)ESC[0m ESC[1mESC[35mCREATE TABLE `ar_internal_metadata` (`key` varchar(255) NOT NULL PRIMARY KEY, `value` varchar(255), `created_at` datetime(6) NOT NULL, `updated_at` datetim
43
+ ESC[1mESC[35m (0.4ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
44
44
 
45
- e(6) NOT NULL)ESC[0m
46
-
47
- ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
48
-
49
- N.wait_timeout = 2147483ESC[0m
45
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
50
46
 
51
47
  ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT GET_LOCK('7864839756650184315', 0)ESC[0m
52
48
 
49
+ ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
50
+
51
+ ESC[1mESC[36mActiveRecord::InternalMetadata Load (0.3ms)ESC[0m ESC[1mESC[34mSELECT `ar_internal_metadata`.* FROM `ar_internal_metadata` WHERE `ar_internal_metadata`.`key` = 'environment' LIMIT 1
52
+
53
+ ESC[0m
54
+
55
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT RELEASE_LOCK('7864839756650184315')ESC[0m
56
+
57
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
58
+
53
59
  ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
54
60
 
55
- Migrating to CreateUsers (20200705111505)
56
-
57
- ESC[1mESC[35m (8.7ms)ESC[0m ESC[1mESC[35mCREATE TABLE `users` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255), `email` varchar(255), `created_at` datetime(6) NOT NULL, `updat
58
-
59
- ed_at` datetime(6) NOT NULL)ESC[0m
60
-
61
- ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
62
-
63
- ESC[1mESC[36mprimary::SchemaMigration Create (0.3ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200705111505')ESC[0m
64
-
65
- ESC[1mESC[35m (1.3ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
66
-
67
- Migrating to AddIndexToUsersEmail (20200705120517)
68
-
69
- ESC[1mESC[35m (7.8ms)ESC[0m ESC[1mESC[35mCREATE UNIQUE INDEX `index_users_on_email` ON `users` (`email`) ESC[0m
70
-
71
- ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
72
-
73
- ESC[1mESC[36mprimary::SchemaMigration Create (2.3ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200705120517')ESC[0m
74
-
75
- ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
76
-
77
- Migrating to AddPasswordDigestToUsers (20200705121724)
78
-
79
- ESC[1mESC[35m (17.0ms)ESC[0m ESC[1mESC[35mALTER TABLE `users` ADD `password_digest` varchar(255)ESC[0m
80
-
81
- ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
82
-
83
- ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200705121724')ESC[0m
84
-
85
- ESC[1mESC[35m (1.0ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
86
-
87
- Migrating to AddAdminToUsers (20200712064718)
88
-
89
- ESC[1mESC[35m (13.1ms)ESC[0m ESC[1mESC[35mALTER TABLE `users` ADD `admin` tinyint(1) DEFAULT FALSEESC[0m
90
-
91
- ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
92
-
93
- ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200712064718')ESC[0m
94
-
95
- ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
96
-
97
- Migrating to CreatePosts (20200712084946)
98
-
99
- ESC[1mESC[35m (8.4ms)ESC[0m ESC[1mESC[35mCREATE TABLE `posts` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `content` text, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL
100
-
101
- )ESC[0m
102
-
103
- ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
104
-
105
- ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200712084946')ESC[0m
106
-
107
- ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
108
-
109
- Migrating to AddUserIdToPosts (20200714113113)
110
-
111
- ESC[1mESC[35m (0.4ms)ESC[0m ESC[1mESC[31mDELETE FROM posts;ESC[0m
112
-
113
- ESC[1mESC[35m (11.2ms)ESC[0m ESC[1mESC[35mALTER TABLE `posts` ADD `user_id` bigint NOT NULLESC[0m
114
-
115
- ESC[1mESC[35m (5.5ms)ESC[0m ESC[1mESC[35mCREATE INDEX `index_posts_on_user_id` ON `posts` (`user_id`) ESC[0m
116
-
117
- ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
118
-
119
- ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200714113113')ESC[0m
120
-
121
61
  ```

4

ログの修正

2020/10/12 10:37

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -22,28 +22,100 @@
22
22
 
23
23
  ```ここに言語を入力
24
24
 
25
- @SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
25
+ ESC[1mESC[35m (4.1ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
26
26
 
27
- ESC[1mESC[35m (0.8ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_test` DEFAULT CHARACTER SET `utf8`ESC[0m
27
+ N.wait_timeout = 2147483ESC[0m
28
28
 
29
- ESC[1mESC[35m (0.4ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
29
+ ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_development` DEFAULT CHARACTER SET `utf8`ESC[0m
30
30
 
31
- ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
31
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
32
+
33
+ N.wait_timeout = 2147483ESC[0m
34
+
35
+ ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_test` DEFAULT CHARACTER SET `utf8`ESC[0m
36
+
37
+ ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
38
+
39
+ N.wait_timeout = 2147483ESC[0m
40
+
41
+ ESC[1mESC[35m (8.9ms)ESC[0m ESC[1mESC[35mCREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL PRIMARY KEY)ESC[0m
42
+
43
+ ESC[1mESC[35m (7.6ms)ESC[0m ESC[1mESC[35mCREATE TABLE `ar_internal_metadata` (`key` varchar(255) NOT NULL PRIMARY KEY, `value` varchar(255), `created_at` datetime(6) NOT NULL, `updated_at` datetim
44
+
45
+ e(6) NOT NULL)ESC[0m
46
+
47
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSIO
48
+
49
+ N.wait_timeout = 2147483ESC[0m
32
50
 
33
51
  ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT GET_LOCK('7864839756650184315', 0)ESC[0m
34
52
 
35
- ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
36
-
37
- ESC[1mESC[36mActiveRecord::InternalMetadata Load (0.3ms)ESC[0m ESC[1mESC[34mSELECT `ar_internal_metadata`.* FROM `ar_internal_metadata` WHERE `ar_internal_metadata`.`key` = 'environment' LIMIT 1ESC[0m
38
-
39
- ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT RELEASE_LOCK('7864839756650184315')ESC[0m
40
-
41
- ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
42
-
43
53
  ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
44
54
 
45
- (END)
55
+ Migrating to CreateUsers (20200705111505)
46
56
 
57
+ ESC[1mESC[35m (8.7ms)ESC[0m ESC[1mESC[35mCREATE TABLE `users` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255), `email` varchar(255), `created_at` datetime(6) NOT NULL, `updat
47
58
 
59
+ ed_at` datetime(6) NOT NULL)ESC[0m
60
+
61
+ ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
62
+
63
+ ESC[1mESC[36mprimary::SchemaMigration Create (0.3ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200705111505')ESC[0m
64
+
65
+ ESC[1mESC[35m (1.3ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
66
+
67
+ Migrating to AddIndexToUsersEmail (20200705120517)
68
+
69
+ ESC[1mESC[35m (7.8ms)ESC[0m ESC[1mESC[35mCREATE UNIQUE INDEX `index_users_on_email` ON `users` (`email`) ESC[0m
70
+
71
+ ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
72
+
73
+ ESC[1mESC[36mprimary::SchemaMigration Create (2.3ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200705120517')ESC[0m
74
+
75
+ ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
76
+
77
+ Migrating to AddPasswordDigestToUsers (20200705121724)
78
+
79
+ ESC[1mESC[35m (17.0ms)ESC[0m ESC[1mESC[35mALTER TABLE `users` ADD `password_digest` varchar(255)ESC[0m
80
+
81
+ ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
82
+
83
+ ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200705121724')ESC[0m
84
+
85
+ ESC[1mESC[35m (1.0ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
86
+
87
+ Migrating to AddAdminToUsers (20200712064718)
88
+
89
+ ESC[1mESC[35m (13.1ms)ESC[0m ESC[1mESC[35mALTER TABLE `users` ADD `admin` tinyint(1) DEFAULT FALSEESC[0m
90
+
91
+ ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
92
+
93
+ ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200712064718')ESC[0m
94
+
95
+ ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
96
+
97
+ Migrating to CreatePosts (20200712084946)
98
+
99
+ ESC[1mESC[35m (8.4ms)ESC[0m ESC[1mESC[35mCREATE TABLE `posts` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `content` text, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL
100
+
101
+ )ESC[0m
102
+
103
+ ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
104
+
105
+ ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200712084946')ESC[0m
106
+
107
+ ESC[1mESC[35m (1.1ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
108
+
109
+ Migrating to AddUserIdToPosts (20200714113113)
110
+
111
+ ESC[1mESC[35m (0.4ms)ESC[0m ESC[1mESC[31mDELETE FROM posts;ESC[0m
112
+
113
+ ESC[1mESC[35m (11.2ms)ESC[0m ESC[1mESC[35mALTER TABLE `posts` ADD `user_id` bigint NOT NULLESC[0m
114
+
115
+ ESC[1mESC[35m (5.5ms)ESC[0m ESC[1mESC[35mCREATE INDEX `index_posts_on_user_id` ON `posts` (`user_id`) ESC[0m
116
+
117
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
118
+
119
+ ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200714113113')ESC[0m
48
120
 
49
121
  ```

3

ログの修正

2020/10/12 10:19

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -22,23 +22,19 @@
22
22
 
23
23
  ```ここに言語を入力
24
24
 
25
- Migrating to AddContent2ToProgresses (20200804154109)
25
+ @SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
26
26
 
27
- ESC[1mESC[35m (13.1ms)ESC[0m ESC[1mESC[35mALTER TABLE `progresses` ADD `content_2` textESC[0m
27
+ ESC[1mESC[35m (0.8ms)ESC[0m ESC[1mESC[35mCREATE DATABASE `myapp_test` DEFAULT CHARACTER SET `utf8`ESC[0m
28
28
 
29
- ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
29
+ ESC[1mESC[35m (0.4ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
30
30
 
31
- ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200804154109')ESC[0m
31
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
32
32
 
33
- ESC[1mESC[35m (1.2ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
33
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT GET_LOCK('7864839756650184315', 0)ESC[0m
34
+
35
+ ESC[1mESC[35m (0.3ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
34
36
 
35
37
  ESC[1mESC[36mActiveRecord::InternalMetadata Load (0.3ms)ESC[0m ESC[1mESC[34mSELECT `ar_internal_metadata`.* FROM `ar_internal_metadata` WHERE `ar_internal_metadata`.`key` = 'environment' LIMIT 1ESC[0m
36
-
37
- ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
38
-
39
- ESC[1mESC[36mActiveRecord::InternalMetadata Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `ar_internal_metadata` (`key`, `value`, `created_at`, `updated_at`) VALUES ('environment', 'development', '2020-10-11 08:08:59.724641', '2020-10-11 08:08:59.724641')ESC[0m
40
-
41
- ESC[1mESC[35m (1.3ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
42
38
 
43
39
  ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT RELEASE_LOCK('7864839756650184315')ESC[0m
44
40
 
@@ -46,4 +42,8 @@
46
42
 
47
43
  ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
48
44
 
45
+ (END)
46
+
47
+
48
+
49
49
  ```

2

ログの追記

2020/10/12 10:04

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -17,6 +17,8 @@
17
17
 
18
18
 
19
19
  【追記】
20
+
21
+ Railsアプリのlogディレクトリにあったdevelopment.logの内容を追記します。
20
22
 
21
23
  ```ここに言語を入力
22
24
 

1

ログを追記しました

2020/10/11 22:08

投稿

hitoyasablue
hitoyasablue

スコア8

test CHANGED
File without changes
test CHANGED
@@ -13,3 +13,35 @@
13
13
  以下参考にしている記事です。
14
14
 
15
15
  [https://qiita.com/at-946/items/1e8acea19cc0b9f31b98](https://qiita.com/at-946/items/1e8acea19cc0b9f31b98)
16
+
17
+
18
+
19
+ 【追記】
20
+
21
+ ```ここに言語を入力
22
+
23
+ Migrating to AddContent2ToProgresses (20200804154109)
24
+
25
+ ESC[1mESC[35m (13.1ms)ESC[0m ESC[1mESC[35mALTER TABLE `progresses` ADD `content_2` textESC[0m
26
+
27
+ ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
28
+
29
+ ESC[1mESC[36mprimary::SchemaMigration Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `schema_migrations` (`version`) VALUES ('20200804154109')ESC[0m
30
+
31
+ ESC[1mESC[35m (1.2ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
32
+
33
+ ESC[1mESC[36mActiveRecord::InternalMetadata Load (0.3ms)ESC[0m ESC[1mESC[34mSELECT `ar_internal_metadata`.* FROM `ar_internal_metadata` WHERE `ar_internal_metadata`.`key` = 'environment' LIMIT 1ESC[0m
34
+
35
+ ESC[1mESC[35m (0.1ms)ESC[0m ESC[1mESC[35mBEGINESC[0m
36
+
37
+ ESC[1mESC[36mActiveRecord::InternalMetadata Create (0.2ms)ESC[0m ESC[1mESC[32mINSERT INTO `ar_internal_metadata` (`key`, `value`, `created_at`, `updated_at`) VALUES ('environment', 'development', '2020-10-11 08:08:59.724641', '2020-10-11 08:08:59.724641')ESC[0m
38
+
39
+ ESC[1mESC[35m (1.3ms)ESC[0m ESC[1mESC[35mCOMMITESC[0m
40
+
41
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT RELEASE_LOCK('7864839756650184315')ESC[0m
42
+
43
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[35mSET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483ESC[0m
44
+
45
+ ESC[1mESC[35m (0.2ms)ESC[0m ESC[1mESC[34mSELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASCESC[0m
46
+
47
+ ```