質問編集履歴

Gemfileを追加

2019/03/27 06:49

投稿

k.chisato

スコア18

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -138,5 +138,90 @@
   password: <%= ENV['VER0_2_DATABASE_PASSWORD'] %>
 ```
+```Gemfile
+source 'https://rubygems.org'
+git_source(:github) { |repo| "https://github.com/#{repo}.git" }
+ruby '2.5.1'
+# Bundle edge Rails instead: gem 'rails', github: 'rails/rails'
+gem 'rails', '~> 5.2.2', '>= 5.2.2.1'
+# Use mysql as the database for Active Record
+gem 'mysql2', '0.5.2'
+# Use Puma as the app server
+gem 'puma', '~> 3.11'
+# Use SCSS for stylesheets
+gem 'sass-rails', '~> 5.0.7'
+# Use Uglifier as compressor for JavaScript assets
+gem 'uglifier', '>= 1.3.0'
+# See https://github.com/rails/execjs#readme for more supported runtimes
+# gem 'mini_racer', platforms: :ruby
+# Use CoffeeScript for .coffee assets and views
+gem 'coffee-rails', '~> 4.2'
+# Turbolinks makes navigating your web application faster. Read more: https://github.com/turbolinks/turbolinks
+gem 'turbolinks', '~> 5'
+# Build JSON APIs with ease. Read more: https://github.com/rails/jbuilder
+gem 'jbuilder', '~> 2.5'
+# Use Redis adapter to run Action Cable in production
+# gem 'redis', '~> 4.0'
+# Use ActiveModel has_secure_password
+# gem 'bcrypt', '~> 3.1.7'
+# Use ActiveStorage variant
+# gem 'mini_magick', '~> 4.8'
+# Use Capistrano for deployment
+# gem 'capistrano-rails', group: :development
+# Reduces boot times through caching; required in config/boot.rb
+gem 'bootsnap', '>= 1.1.0', require: false
+group :development, :test do
+  # Call 'byebug' anywhere in the code to stop execution and get a debugger console
+  gem 'byebug', platforms: [:mri, :mingw, :x64_mingw]
+end
+group :development do
+  # Access an interactive console on exception pages or by calling 'console' anywhere in the code.
+  gem 'web-console', '>= 3.3.0'
+  gem 'listen', '>= 3.0.5', '< 3.2'
+  # Spring speeds up development by keeping your application running in the background. Read more: https://github.com/rails/spring
+  gem 'spring'
+  gem 'spring-watcher-listen', '~> 2.0.0'
+end
+group :test do
+  # Adds support for Capybara system testing and selenium driver
+  gem 'capybara', '>= 2.15'
+  gem 'selenium-webdriver'
+  # Easy installation and use of chromedriver to run system tests with Chrome
+  gem 'chromedriver-helper'
+end
+# Windows does not include zoneinfo files, so bundle the tzinfo-data gem
+gem 'tzinfo-data', platforms: [:mingw, :mswin, :x64_mingw, :jruby]
+# アマゾンS3を追加
+gem 'aws-sdk-s3', require: false
+# 基本項目
+gem 'pry-rails'
+gem 'compass-rails', '3.1.0'
+gem 'sprockets', '3.7.2'
+gem 'hirb'
+gem 'hirb-unicode'
+# jQuery
+gem "jquery-rails"
+# ログイン
+gem 'devise'
+group :production do
+  gem 'rails_12factor'
+end
+```
 どなたかアドバイスを頂けると幸いです・・・

schema.rbとdatabase.ymlを追加

2019/03/27 06:49

投稿

k.chisato

スコア18

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -39,4 +39,104 @@
 State:        created
 ```
+以下schema.rb
+```
+ActiveRecord::Schema.define(version: 2019_03_19_064642) do
+  create_table "active_storage_attachments", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+    t.string "name", null: false
+    t.string "record_type", null: false
+    t.bigint "record_id", null: false
+    t.bigint "blob_id", null: false
+    t.datetime "created_at", null: false
+    t.index ["blob_id"], name: "index_active_storage_attachments_on_blob_id"
+    t.index ["record_type", "record_id", "name", "blob_id"], name: "index_active_storage_attachments_uniqueness", unique: true
+  end
+  create_table "active_storage_blobs", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+    t.string "key", null: false
+    t.string "filename", null: false
+    t.string "content_type"
+    t.text "metadata"
+    t.bigint "byte_size", null: false
+    t.string "checksum", null: false
+    t.datetime "created_at", null: false
+    t.index ["key"], name: "index_active_storage_blobs_on_key", unique: true
+  end
+  create_table "countries", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+    t.string "country"
+    t.string "capital"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.string "continent"
+    t.float "latitude", limit: 53
+    t.float "longitude", limit: 53
+  end
+  create_table "remove_latitude_from_countries", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+    t.integer "latitude"
+    t.integer "longitude"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+  create_table "stamps", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+    t.integer "user_id"
+    t.text "title"
+    t.text "description"
+    t.datetime "shooted_at"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.integer "country_id"
+  end
+  create_table "users", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+    t.string "email", default: "", null: false
+    t.string "encrypted_password", default: "", null: false
+    t.string "reset_password_token"
+    t.datetime "reset_password_sent_at"
+    t.datetime "remember_created_at"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.string "family_name"
+    t.string "first_name"
+    t.string "family_name_kana"
+    t.string "first_name_kana"
+    t.index ["email"], name: "index_users_on_email", unique: true
+    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
+  end
+  add_foreign_key "active_storage_attachments", "active_storage_blobs", column: "blob_id"
+end
+```
+以下database.yml
+```
+default: &default
+  adapter: mysql2
+  encoding: utf8
+  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
+  username: root
+  password:
+  socket: /var/lib/mysql/mysql.sock
+development:
+  <<: *default
+  database: ver0_2_development
+test:
+  <<: *default
+  database: ver0_2_test
+production:
+  <<: *default
+  database: ver0_2_production
+  username: ver0_2
+  password: <%= ENV['VER0_2_DATABASE_PASSWORD'] %>
+```
 どなたかアドバイスを頂けると幸いです・・・

質問内容を完結にしました！

2019/03/27 06:24

投稿

k.chisato

スコア18

title CHANGED Viewed

	@@ -1,1 +1,1 @@
1	- ClearDBアドオンを~~用いてHerokuにデプロイ出来~~ない！
1	+ HerokuにClearDBアドオンをしたらDBのテーブルが足りない。

body CHANGED Viewed

@@ -1,210 +1,42 @@
 ### 前提
+ユーザー登録を必要とするSNS的なアプリを開発中です。
-Heroku上にアプリケーションを作成するところまでは出来ています。
+いよいよα版を公開！と思ったら最後の最後につまづいています・・・
-![イメージ説明](d8a653e24349f477e2e7c7ffaacf4284.png)
-Herokuのバージョンは18、
-Rubyのバージョンは2.5.1、
-railsのバージョンは5.2.2.1です。
+[https://life-stamp-rally.herokuapp.com/users](https://life-stamp-rally.herokuapp.com/users)
+Heroku上にアプリケーションを作成し、ブラウザにトップページを表示するところまでは出来ています。
-DBは開発環境でMySQLを使っています。
+しかしログインページや新規会員登録に遷移すると下記エラーが発生。
-しかしその後にClearDBでアドオンをしたく下記コードをターミナルに打ち込むとエラーが発生します。
+![イメージ説明](39924f14a146771d44ff024d0c9c27a7.png)
-heroku addons:add cleardb
+HeidiSQLを使用してデータベースに接続をしてみると、
-```
-ec2-user:~/environment/ver0.2 (master) $ heroku addons:add cleardb
-Creating cleardb on ⬢ life-stamp-rally-ver0... !
- ▸    Couldn't find that app.
+本来あるはずのUsersテーブルがありませんでした！！
-```
-※”life-stamp-rally-ver0”というのは以前作成したcleardbです。
-　何故か選択されてしまい・・・
-ここで下記コードを打ち込んでアプリを選択して進むも、
-```
-heroku addons:add cleardb:ignite --app whispering-ridge-52187
-```
-次の下記コードで再びエラーが出てしまい・・・
-```
-heroku config | grep CLEARDB_DATABASE_URL
- ›   Error: Couldn't find that app.
- ›
- ›   Error ID: not_found
-```
-下記にターミナルの履歴を載せておきます。
+![イメージ説明](60a766501539d35d131db95049d7187c.png)
+※開発環境
+![イメージ説明](39a19a1ecafa28a5ea9e25cfa625b7ed.png)
-なお、Gemfileには下記を記載→bundle install済み。
+※HeidiSQL（herokuにデプロイしたアプリのデータベース）
-```
-group :production do
-  gem 'rails_12factor'
-end
-```
-個人的には一度色々リセット出来ればと思っています。
-しかしHeroku内のアプリは削除出来ても、ClearDBの設定？は削除できず・・
+Herokuのバージョンは18、
-### ターミナルの履歴全部
+Rubyのバージョンは2.5.1、
+railsのバージョンは5.2.2.1、
+DBは開発環境でMySQL（phpmyadmin）を使っています。
-```
-ec2-user:~/environment $ curl -OL https://cli-assets.heroku.com/heroku-linux-x64.tar.gz
-  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
-                                 Dload  Upload   Total   Spent    Left  Speed
-100 25.8M  100 25.8M    0     0  25.1M      0  0:00:01  0:00:01 --:--:-- 25.1M
-ec2-user:~/environment $ tar zxf heroku-linux-x64.tar.gz && rm -f heroku-linux-x64.tar.gz
-ec2-user:~/environment $ sudo mv heroku /usr/local
-mv: cannot move ‘heroku’ to ‘/usr/local/heroku’: Directory not empty
-ec2-user:~/environment $ echo 'PATH=/usr/local/heroku/bin:$PATH' >> $HOME/.bash_profile
-ec2-user:~/environment $ source $HOME/.bash_profile > /dev/null
-ec2-user:~/environment $ cd ver0.3
-ec2-user:~/environment/ver0.3 (master) $ heroku login
-heroku: Press any key to open up the browser to login or q to exit:
-Opening browser to https://cli-auth.heroku.com/auth/browser/909e9189-75d5-4365-b700-3e32e9429daa
- ›   Warning: Cannot open browser.
-Logging in... done
-Logged in as ★メールアドレス★
-ec2-user:~/environment/ver0.3 (master) $ bundle install
-The dependency tzinfo-data (>= 0) will be unused by any of the platforms Bundler is installing for. Bundler is installing for ruby but the dependency is only for x86-mingw32, x86-mswin32, x64-mingw32, java. To add those platforms to the bundle, run `bundle lock --add-platform x86-mingw32 x86-mswin32 x64-mingw32 java`.
-Using rake 12.3.2
-Using concurrent-ruby 1.1.5
-Using i18n 1.6.0
-Using minitest 5.11.3
-Using thread_safe 0.3.6
-Using tzinfo 1.2.5
-Using activesupport 5.2.2.1
-Using builder 3.2.3
-Using erubi 1.8.0
-Using mini_portile2 2.4.0
-Using nokogiri 1.10.1
-Using rails-dom-testing 2.0.3
-Using crass 1.0.4
-Using loofah 2.2.3
-Using rails-html-sanitizer 1.0.4
-Using actionview 5.2.2.1
-Using rack 2.0.6
-Using rack-test 1.1.0
-Using actionpack 5.2.2.1
-Using nio4r 2.3.1
-Using websocket-extensions 0.1.3
-Using websocket-driver 0.7.0
-Using actioncable 5.2.2.1
-Using globalid 0.4.2
-Using activejob 5.2.2.1
-Using mini_mime 1.0.1
-Using mail 2.7.1
-Using actionmailer 5.2.2.1
-Using activemodel 5.2.2.1
-Using arel 9.0.0
-Using activerecord 5.2.2.1
-Using mimemagic 0.3.3
-Using marcel 0.3.3
-Using activestorage 5.2.2.1
-Using public_suffix 3.0.3
-Using addressable 2.6.0
-Using io-like 0.3.0
-Using archive-zip 0.12.0
-Using aws-eventstream 1.0.2
-Using aws-partitions 1.144.0
-Using aws-sigv4 1.1.0
-Using http-2 0.10.1
-Using jmespath 1.4.0
-Using aws-sdk-core 3.47.0
-Using aws-sdk-kms 1.14.0
-Using aws-sdk-s3 1.32.0
-Using bcrypt 3.1.12
-Using bindex 0.5.0
-Using msgpack 1.2.9
-Using bootsnap 1.4.1
-Using bundler 2.0.1
-Using byebug 11.0.0
-Using regexp_parser 1.3.0
-Using xpath 3.2.0
-Using capybara 3.14.0
-Using ffi 1.10.0
-Using childprocess 0.9.0
-Using chromedriver-helper 2.1.0
-Using chunky_png 1.3.11
-Using coderay 1.1.2
-Using coffee-script-source 1.12.2
-Using execjs 2.7.0
-Using coffee-script 2.4.1
-Using method_source 0.9.2
-Using thor 0.20.3
-Using railties 5.2.2.1
-Using coffee-rails 4.2.2
-Using multi_json 1.13.1
-Using sass 3.4.25
-Using compass-core 1.0.3
-Using compass-import-once 1.0.5
-Using rb-fsevent 0.10.3
-Using rb-inotify 0.10.0
-Using compass 1.0.3
-Using sprockets 3.7.2
-Using sprockets-rails 3.2.1
-Using tilt 2.0.9
-Using sass-rails 5.0.7
-Using compass-rails 3.1.0
-Using orm_adapter 0.5.0
-Using responders 2.4.1
-Using warden 1.2.8
-Using devise 4.6.1
-Using hirb 0.7.3
-Using unicode-display_width 0.1.1
-Using hirb-unicode 0.0.5
-Using jbuilder 2.8.0
-Using jquery-rails 4.3.3
-Using ruby_dep 1.5.0
-Using listen 3.1.5
-Using mysql2 0.5.2
-Using pry 0.12.2
-Using pry-rails 0.3.9
-Using puma 3.12.0
-Using rails 5.2.2.1
-Using rails_serve_static_assets 0.0.5
-Using rails_stdout_logging 0.0.5
-Using rails_12factor 0.0.3
-Using rubyzip 1.2.2
-Using selenium-webdriver 3.141.0
-Using spring 2.0.2
-Using spring-watcher-listen 2.0.1
-Using turbolinks-source 5.2.0
-Using turbolinks 5.2.0
-Using uglifier 4.1.20
-Using web-console 3.7.0
-Bundle complete! 27 Gemfile dependencies, 106 gems now installed.
-Use `bundle info [gemname]` to see where a bundled gem is installed.
-ec2-user:~/environment/ver0.3 (master) $ git init
-Reinitialized existing Git repository in /home/ec2-user/environment/ver0.3/.git/
-ec2-user:~/environment/ver0.3 (master) $ heroku create
-Creating app... done, ⬢ whispering-ridge-52187
-https://whispering-ridge-52187.herokuapp.com/ | https://git.heroku.com/whispering-ridge-52187.git
-ec2-user:~/environment/ver0.3 (master) $ heroku addons:add cleardb
-Creating cleardb on ⬢ life-stamp-rally-ver0... free
-Created cleardb-tetrahedral-33673 as CLEARDB_PUCE_URL
-Use heroku addons:docs cleardb to view documentation
-ec2-user:~/environment/ver0.3 (master) $ heroku addons:add cleardb:ignite --app whispering-ridge-52187
-Creating cleardb:ignite on ⬢ whispering-ridge-52187... free
-Created cleardb-asymmetrical-62509 as CLEARDB_DATABASE_URL
-Use heroku addons:docs cleardb to view documentation
-ec2-user:~/environment/ver0.3 (master) $ heroku config | grep CLEARDB_DATABASE_URL
- ›   Error: Couldn't find that app.
- ›
- ›   Error ID: not_found
-ec2-user:~/environment/ver0.3 (master) $
-```
-### 試したこと
-アドオンするアプリの名前を、消してしまった”life-stamp-rally-ver0”に変更してみたところ、
-途中まで上手く行きましたが、最後に
+アドオンは普通に問題無く出来ている様に見えます・・・
 ```
+ec2-user:~/environment/ver0.3 (master) $ heroku addons:info cleardb
+=== cleardb-crystalline-67196
+Attachments:  life-stamp-rally::CLEARDB_DATABASE
+Installed at: Tue Mar 26 2019 02:24:55 GMT+0000 (Coordinated Universal Time)
+Owning app:   life-stamp-rally
+Plan:         cleardb:ignite
-heroku apps:info
+Price:        free
+State:        created
 ```
-で調べたところ
-```
-Repo Size:      0 KB
-```
-となりURLを叩いてもエラーとなってしまいました。
-![イメージ説明](e3c78b36354bba0591728f3813a9e736.png)
 どなたかアドバイスを頂けると幸いです・・・