Closed StCyr closed 2 years ago
Thanks for reporting this @StCyr.
We haven't revisited our installation instructions for some time and it is definitely out of date. I have just gone through and made some edits that hopefully make the process more clear. https://github.com/DMPRoadmap/roadmap/wiki/Installation
@StCyr Thanks for reaching out about this. We like to keep track of local implementations of our shared codebase. Could you tell us a little about how and where you're using the tool?
@StCyr Thanks for reaching out about this. We like to keep track of local implementations of our shared codebase. Could you tell us a little about how and where you're using the tool?
Hello, can we talk about this in private?
Thanks for reporting this @StCyr.
We haven't revisited our installation instructions for some time and it is definitely out of date. I have just gone through and made some edits that hopefully make the process more clear. https://github.com/DMPRoadmap/roadmap/wiki/Installation
Hello, I've reviewed your updated installation instructions and made sure I've followed all the steps but it's still failing at bin/rails db:create
.
Here are some info about my environment:
config/database.yml:
defaults: &defaults
adapter: 'mysql2'
encoding: <% if ENV['DB_ADAPTER'] == "mysql2" %>"utf8mb4"<% end %>
<% if ENV["DB_ADAPTER"] == "postgresql" %>'username: postgres'<% end %>
username: <% if ENV["DB_ADAPTER"] != "postgresql" %>'root'<% end %>
password:
database: roadmap_<%= ENV['RAILS_ENV'] %>
pool: 16
development:
<<: *defaults
test:
<<: *defaults
Here's the full error message that I'm getting:
support@dmponline-dev:/usr/local/bin/roadmap$ sudo bin/rails db:create
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/associations.rb:1855: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/associations.rb:1368: warning: The called method `has_many' is defined here
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:12: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/query_cache.rb:95: warning: The called method `select_all' is defined here
rails aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'roadmap_development.identifier_schemes' doesn't exist: SELECT `identifier_schemes`.* FROM `identifier_schemes` WHERE ((`identifier_schemes`.`context` in (1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31)))
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `block in query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `synchronize'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:196:in `execute_and_free'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:33:in `exec_query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/database_statements.rb:478:in `select'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/database_statements.rb:70:in `select_all'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/query_cache.rb:106:in `select_all'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:12:in `select_all'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/querying.rb:41:in `find_by_sql'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bullet-7.0.1/lib/bullet/active_record52.rb:19:in `find_by_sql'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:560:in `block in exec_queries'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:584:in `skip_query_cache_if_necessary'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:547:in `exec_queries'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:422:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:200:in `records'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bullet-7.0.1/lib/bullet/active_record52.rb:46:in `records'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation/delegation.rb:71:in `each'
/usr/local/bin/roadmap/app/controllers/users/omniauth_callbacks_controller.rb:9:in `<class:OmniauthCallbacksController>'
/usr/local/bin/roadmap/app/controllers/users/omniauth_callbacks_controller.rb:8:in `<module:Users>'
/usr/local/bin/roadmap/app/controllers/users/omniauth_callbacks_controller.rb:3:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `block in require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `require'
/usr/local/bin/roadmap/config/initializers/ugent.rb:7:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `block in load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:663:in `block in load_config_initializer'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/notifications.rb:170:in `instrument'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:662:in `load_config_initializer'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:620:in `block (2 levels) in <class:Engine>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:619:in `each'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:619:in `block in <class:Engine>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:32:in `instance_exec'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:32:in `run'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:61:in `block in run_initializers'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:50:in `each'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:50:in `tsort_each_child'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:60:in `run_initializers'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/application.rb:361:in `initialize!'
/usr/local/bin/roadmap/config/environment.rb:7:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `block in require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/application.rb:337:in `require_environment!'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/application.rb:520:in `block in run_tasks_blocks'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/command.rb:48:in `invoke'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands.rb:18:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
bin/rails:4:in `<main>'
Caused by:
Mysql2::Error: Table 'roadmap_development.identifier_schemes' doesn't exist
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `block in query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `synchronize'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:196:in `execute_and_free'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:33:in `exec_query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/database_statements.rb:478:in `select'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/database_statements.rb:70:in `select_all'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/query_cache.rb:106:in `select_all'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:12:in `select_all'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/querying.rb:41:in `find_by_sql'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bullet-7.0.1/lib/bullet/active_record52.rb:19:in `find_by_sql'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:560:in `block in exec_queries'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:584:in `skip_query_cache_if_necessary'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:547:in `exec_queries'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:422:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation.rb:200:in `records'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bullet-7.0.1/lib/bullet/active_record52.rb:46:in `records'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/relation/delegation.rb:71:in `each'
/usr/local/bin/roadmap/app/controllers/users/omniauth_callbacks_controller.rb:9:in `<class:OmniauthCallbacksController>'
/usr/local/bin/roadmap/app/controllers/users/omniauth_callbacks_controller.rb:8:in `<module:Users>'
/usr/local/bin/roadmap/app/controllers/users/omniauth_callbacks_controller.rb:3:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `block in require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `require'
/usr/local/bin/roadmap/config/initializers/ugent.rb:7:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `block in load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:663:in `block in load_config_initializer'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/notifications.rb:170:in `instrument'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:662:in `load_config_initializer'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:620:in `block (2 levels) in <class:Engine>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:619:in `each'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/engine.rb:619:in `block in <class:Engine>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:32:in `instance_exec'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:32:in `run'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:61:in `block in run_initializers'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:50:in `each'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:50:in `tsort_each_child'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/initializable.rb:60:in `run_initializers'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/application.rb:361:in `initialize!'
/usr/local/bin/roadmap/config/environment.rb:7:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `block in require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:291:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/application.rb:337:in `require_environment!'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/application.rb:520:in `block in run_tasks_blocks'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/command.rb:48:in `invoke'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands.rb:18:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
bin/rails:4:in `<main>'
Tasks: TOP => db:create => db:load_config => environment
(See full trace by running task with --trace)
Nevermind, I've understand the issue lies in this Belgian specific ugent.rb
file.
Deleting this file gets me further in the installation process. I now have the following issue while running bin/rails db:schema:load
:
...
(all goes well up to this point)
...
-- create_table("answers", {:id=>:integer, :force=>:cascade})
rails aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: Cannot drop table 'answers' referenced by a foreign key constraint 'fk_rails_da7e58cf37' on table 'answers_question_options'.: DROP TABLE IF EXISTS `answers` CASCADE
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `block in query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `synchronize'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:340:in `drop_table'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:308:in `create_table'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:871:in `block in method_missing'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:840:in `block in say_with_time'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:840:in `say_with_time'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:860:in `method_missing'
/usr/local/bin/roadmap/db/schema.rb:28:in `block in <main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/schema.rb:50:in `instance_eval'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/schema.rb:50:in `define'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/schema.rb:46:in `define'
/usr/local/bin/roadmap/db/schema.rb:13:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `block in load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:245:in `load_schema'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:266:in `block in load_schema_current'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:313:in `each'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:265:in `load_schema_current'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/railties/databases.rake:258:in `block (3 levels) in <main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/command.rb:48:in `invoke'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands.rb:18:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
bin/rails:4:in `<main>'
Caused by:
Mysql2::Error: Cannot drop table 'answers' referenced by a foreign key constraint 'fk_rails_da7e58cf37' on table 'answers_question_options'.
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `block in query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `query'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `synchronize'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:340:in `drop_table'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:308:in `create_table'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:871:in `block in method_missing'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:840:in `block in say_with_time'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:840:in `say_with_time'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/migration.rb:860:in `method_missing'
/usr/local/bin/roadmap/db/schema.rb:28:in `block in <main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/schema.rb:50:in `instance_eval'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/schema.rb:50:in `define'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/schema.rb:46:in `define'
/usr/local/bin/roadmap/db/schema.rb:13:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:39:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `block in load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:257:in `load_dependency'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activesupport-5.2.7/lib/active_support/dependencies.rb:285:in `load'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:245:in `load_schema'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:266:in `block in load_schema_current'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:313:in `each'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/tasks/database_tasks.rb:265:in `load_schema_current'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/activerecord-5.2.7/lib/active_record/railties/databases.rake:258:in `block (3 levels) in <main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/command.rb:48:in `invoke'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/railties-5.2.7/lib/rails/commands.rb:18:in `<main>'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
/usr/local/bin/roadmap/vendor/bundle/ruby/2.7.0/gems/bootsnap-1.11.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
bin/rails:4:in `<main>'
Tasks: TOP => db:schema:load
(See full trace by running task with --trace)
support@dmponline-dev:/usr/local/bin/roadmap$
Hi @StCyr it would seem that your DB was partially created perhaps in a earlier attempt. You'll need to delete it completely to start the installation from scratch.
You will likely need to do this directly through MySQL: https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
Note, I am assuming this was a new (empty) DB when you started!
Hello,
I'm trying to install your program directly now (and not the one modified from here https://github.com/DMPbelgium/roadmap/issues/49).
I'm having an issue when running EDITOR=vim rails credentials:edit
:
root@dmponline-dev:/usr/local/bin/roadmap# EDITOR=vim rails credentials:edit
Could not find rake-13.0.6 in any of the sources
Run `bundle install` to install missing gems.
So, your installation instruction misses this bundle install
step before ;-)
👍🏻 thanks. I have updated the document
closing for now (will open another though ;-) )
What version of the DMPRoadmap code are you running? (e.g. v2.2.0)
master branch
Expected behaviour:
Should be able to install the application by following the installation instruction (https://github.com/DMPRoadmap/roadmap/wiki/Installation)
Actual behaviour:
Installation guide is a bit scarce on details
Some issues I have found:
Eventualy, I'm still stuck at the bin/rails db:setup phase of the bin/setup step (see also https://github.com/DMPbelgium/roadmap/issues/49) when it fails with the following output:
Addtional info
bundle install has run properly: