search

gate-sso / gate

Gate is MFA Enabled SSO Platform that supports SAML, OAuth, Linux shell login and CAS
https://gate-sso.github.io
MIT License
203 stars 53 forks source link

rake app:setup fails #136

Closed Rubueno closed 5 years ago

Rubueno commented 5 years ago

When running rake app:setup in the directory of gate, it will fail on a mysql syntax error:

/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_utils.rb:10: warning: already initialized constant FileUtils::RUBY
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_utils.rb:10: warning: previous definition of RUBY was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_utils.rb:109: warning: already initialized constant FileUtils::LN_SUPPORTED
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_utils.rb:109: warning: previous definition of LN_SUPPORTED was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_utils_ext.rb:17: warning: already initialized constant Rake::FileUtilsExt::DEFAULT
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_utils_ext.rb:17: warning: previous definition of DEFAULT was here
WARNING: Possible conflict with Rake extension: String#ext already exists
WARNING: Possible conflict with Rake extension: String#pathmap already exists
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:44: warning: already initialized constant Rake::FileList::ARRAY_METHODS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:44: warning: previous definition of ARRAY_METHODS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:47: warning: already initialized constant Rake::FileList::MUST_DEFINE
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:47: warning: previous definition of MUST_DEFINE was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:51: warning: already initialized constant Rake::FileList::MUST_NOT_DEFINE
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:51: warning: previous definition of MUST_NOT_DEFINE was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:55: warning: already initialized constant Rake::FileList::SPECIAL_RETURN
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:55: warning: previous definition of SPECIAL_RETURN was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:61: warning: already initialized constant Rake::FileList::DELEGATING_METHODS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:61: warning: previous definition of DELEGATING_METHODS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:86: warning: already initialized constant Rake::FileList::GLOB_PATTERN
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:86: warning: previous definition of GLOB_PATTERN was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:381: warning: already initialized constant Rake::FileList::DEFAULT_IGNORE_PATTERNS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:381: warning: previous definition of DEFAULT_IGNORE_PATTERNS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:387: warning: already initialized constant Rake::FileList::DEFAULT_IGNORE_PROCS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/file_list.rb:387: warning: previous definition of DEFAULT_IGNORE_PROCS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:3: warning: already initialized constant Rake::VERSION
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:3: warning: previous definition of VERSION was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: already initialized constant Rake::Version::MAJOR
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: previous definition of MAJOR was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: already initialized constant Rake::Version::MINOR
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: previous definition of MINOR was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: already initialized constant Rake::Version::BUILD
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: previous definition of BUILD was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: already initialized constant Rake::Version::OTHER
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:6: warning: previous definition of OTHER was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:8: warning: already initialized constant Rake::Version::NUMBERS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/version.rb:8: warning: previous definition of NUMBERS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/linked_list.rb:110: warning: already initialized constant Rake::LinkedList::EMPTY
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/linked_list.rb:110: warning: previous definition of EMPTY was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/scope.rb:41: warning: already initialized constant Rake::Scope::EMPTY
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/scope.rb:41: warning: previous definition of EMPTY was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/promise.rb:12: warning: already initialized constant Rake::Promise::NOT_SET
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/promise.rb:12: warning: previous definition of NOT_SET was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:13: warning: already initialized constant Rake::CommandLineOptionError
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:13: warning: previous definition of CommandLineOptionError was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:41: warning: already initialized constant Rake::Application::DEFAULT_RAKEFILES
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:41: warning: previous definition of DEFAULT_RAKEFILES was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/task_arguments.rb:108: warning: already initialized constant Rake::EMPTY_TASK_ARGS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/task_arguments.rb:108: warning: previous definition of EMPTY_TASK_ARGS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/invocation_chain.rb:55: warning: already initialized constant Rake::InvocationChain::EMPTY
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/invocation_chain.rb:55: warning: previous definition of EMPTY was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/early_time.rb:21: warning: already initialized constant Rake::EARLY
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/early_time.rb:21: warning: previous definition of EARLY was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/late_time.rb:17: warning: already initialized constant Rake::LATE
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/late_time.rb:17: warning: previous definition of LATE was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:4: warning: already initialized constant Rake::Backtrace::SYS_KEYS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:4: warning: previous definition of SYS_KEYS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:5: warning: already initialized constant Rake::Backtrace::SYS_PATHS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:5: warning: previous definition of SYS_PATHS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:8: warning: already initialized constant Rake::Backtrace::SUPPRESSED_PATHS
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:8: warning: previous definition of SUPPRESSED_PATHS was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:12: warning: already initialized constant Rake::Backtrace::SUPPRESSED_PATHS_RE
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:12: warning: previous definition of SUPPRESSED_PATHS_RE was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:16: warning: already initialized constant Rake::Backtrace::SUPPRESS_PATTERN
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/backtrace.rb:16: warning: previous definition of SUPPRESS_PATTERN was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake.rb:70: warning: already initialized constant FileList
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake.rb:70: warning: previous definition of FileList was here
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake.rb:71: warning: already initialized constant RakeFileUtils
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake.rb:71: warning: previous definition of RakeFileUtils was here
** Invoke app:setup (first_time)
** Execute app:setup
bundle install
`/home/gate` is not a directory.
Bundler will use `/tmp/bundler/home/vagrant' as your home directory temporarily.
Using rake 12.3.2
Using concurrent-ruby 1.1.3
Using i18n 1.1.1
Using minitest 5.11.3
Using thread_safe 0.3.6
Using tzinfo 1.2.5
Using activesupport 5.1.6.1
Using builder 3.2.3
Using erubi 1.7.1
Using mini_portile2 2.3.0
Using nokogiri 1.8.5
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.1.6.1
Using rack 2.0.6
Using rack-test 1.1.0
Using actionpack 5.1.6.1
Using nio4r 2.3.1
Using websocket-extensions 0.1.3
Using websocket-driver 0.6.5
Using actioncable 5.1.6.1
Using globalid 0.4.1
Using activejob 5.1.6.1
Using mini_mime 1.0.1
Using mail 2.7.1
Using actionmailer 5.1.6.1
Using activemodel 5.1.6.1
Using arel 8.0.0
Using activerecord 5.1.6.1
Using public_suffix 3.0.3
Using addressable 2.5.2
Using ansi 1.5.0
Using ast 2.4.0
Using execjs 2.7.0
Using autoprefixer-rails 9.4.2
Using bcrypt 3.1.12
Using bindex 0.5.0
Using popper_js 1.14.5
Using rb-fsevent 0.10.3
Using ffi 1.9.25
Using rb-inotify 0.9.10
Using sass-listen 4.0.0
Using sass 3.7.2
Using bootstrap 4.1.3
Using bundler 2.0.1
Using regexp_parser 1.3.0
Using xpath 3.2.0
Using capybara 3.12.0
Using chronic 0.10.2
Using coderay 1.1.2
Using coffee-script-source 1.12.2
Using coffee-script 2.4.1
Using method_source 0.9.2
Using thor 0.19.4
Using railties 5.1.6.1
Using coffee-rails 4.2.2
Using i18n_data 0.8.0
Using money 6.13.1
Using sixarm_ruby_unaccent 1.2.0
Using unicode_utils 1.4.0
Using countries 2.1.4
Using json 2.1.0
Using docile 1.3.1
Using simplecov-html 0.10.2
Using simplecov 0.16.1
Using tins 1.20.2
Using term-ansicolor 1.7.0
Using coveralls 0.8.22
Using safe_yaml 1.0.4
Using crack 0.4.3
Using database_cleaner 1.7.0
Using orm_adapter 0.5.0
Using responders 2.4.0
Using warden 1.2.8
Using devise 4.5.0
Using diff-lcs 1.3
Using factory_bot 4.11.1
Using factory_bot_rails 4.11.1
Using faker 1.9.1
Using multipart-post 2.0.0
Using faraday 0.15.4
Using figaro 1.1.1
Using font-awesome-rails 4.7.0.4
Using hashdiff 0.3.7
Using hashie 3.5.7
Using hirb 0.7.3
Using mime-types-data 3.2018.0812
Using mime-types 3.2.2
Using multi_xml 0.6.0
Using httparty 0.16.3
Using jaro_winkler 1.5.1
Using multi_json 1.13.1
Using jbuilder 2.8.0
Using jquery-rails 4.3.3
Using jwt 2.1.0
Using systemu 2.6.5
Using macaddr 1.7.1
Using mock_redis 0.19.0
Using mysql2 0.4.10
Using newrelic_rpm 5.5.0.348
Using oauth2 1.4.1
Using omniauth 1.8.1
Using omniauth-oauth2 1.5.0
Using omniauth-google-oauth2 0.5.3
Using request_store 1.4.1
Using paper_trail 10.1.0
Using parallel 1.12.1
Using paranoia 2.4.1
Using parser 2.5.3.0
Using powerpack 0.1.2
Using pry 0.12.2
Using puma 3.12.0
Using sprockets 3.7.2
Using sprockets-rails 3.2.1
Using rails 5.1.6.1
Using rails-controller-testing 1.0.4
Using rainbow 3.0.0
Using rdoc 6.0.4
Using redis 4.0.3
Using rotp 4.0.2
Using rspec-support 3.8.0
Using rspec-core 3.8.0
Using rspec-expectations 3.8.2
Using rspec-mocks 3.8.0
Using rspec-rails 3.8.1
Using ruby-progressbar 1.10.0
Using unicode-display_width 1.4.0
Using rubocop 0.61.1
Using rubocop-rspec 1.30.1
Using ruby-saml 1.8.0
Using uuid 2.3.9
Using saml_idp 0.7.2 from https://github.com/gate-sso/saml_idp (at master@cd646cb)
Using tilt 2.0.9
Using sass-rails 5.0.7
Using sdoc 1.0.0
Using shoulda-matchers 3.1.2
Using simplecov-console 0.4.2
Using temple 0.8.0
Using slim 4.0.1
Using slim-rails 3.2.0
Using timecop 0.9.1
Using turbolinks-source 5.2.0
Using turbolinks 5.2.0
Using uglifier 4.1.20
Using web-console 3.7.0
Using webmock 3.4.2
Using whenever 0.10.0
Bundle complete! 45 Gemfile dependencies, 149 gems now installed.
Bundled gems are installed into `./.local`
bundle exec rake db:drop db:create db:migrate
`/home/gate` is not a directory.
Bundler will use `/tmp/bundler/home/vagrant' as your home directory temporarily.
Dropped database 'gate_development'
Dropped database 'gate_test'
Created database 'gate_development'
Created database 'gate_test'
== 20160419122430 DeviseCreateUsers: migrating ================================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:users, {:id=>:integer})
   -> 0.0127s
-- add_index(:users, :email, {:unique=>true})
   -> 0.0214s
-- add_index(:users, :reset_password_token, {:unique=>true})
   -> 0.0218s
== 20160419122430 DeviseCreateUsers: migrated (0.0563s) =======================

== 20160419132647 AddProviderToUsers: migrating ===============================
-- add_column(:users, :provider, :string)
   -> 0.0204s
-- add_column(:users, :uid, :string)
   -> 0.0087s
== 20160419132647 AddProviderToUsers: migrated (0.0292s) ======================

== 20160419144739 AddNameToUsers: migrating ===================================
-- add_column(:users, :name, :string)
   -> 0.0156s
== 20160419144739 AddNameToUsers: migrated (0.0157s) ==========================

== 20160427123146 AddAuthKeyToUser: migrating =================================
-- add_column(:users, :auth_key, :string)
   -> 0.0115s
== 20160427123146 AddAuthKeyToUser: migrated (0.0116s) ========================

== 20160427123233 AddProvisioningUriToUser: migrating =========================
-- add_column(:users, :provisioning_uri, :string)
   -> 0.0185s
== 20160427123233 AddProvisioningUriToUser: migrated (0.0188s) ================

== 20160519042340 AddActiveToUsers: migrating =================================
-- add_column(:users, :active, :boolean)
   -> 0.0097s
== 20160519042340 AddActiveToUsers: migrated (0.0098s) ========================

== 20160519064340 AddDefaultValueToUsers: migrating ===========================
-- change_column(:users, :active, :boolean, {:default=>true})
   -> 0.0070s
== 20160519064340 AddDefaultValueToUsers: migrated (0.0072s) ==================

== 20160615044834 CreateHosts: migrating ======================================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:hosts, {:id=>:integer})
   -> 0.0080s
-- add_index(:hosts, :host_pattern)
   -> 0.0207s
== 20160615044834 CreateHosts: migrated (0.0290s) =============================

== 20160615045052 AddAdminToUser: migrating ===================================
-- add_column(:users, :admin, :boolean, {:default=>false})
   -> 0.0099s
== 20160615045052 AddAdminToUser: migrated (0.0099s) ==========================

== 20160615112805 AddUserToHost: migrating ====================================
-- add_reference(:hosts, :user, {:type=>:integer, :index=>true, :foreign_key=>true})
   -> 0.0450s
== 20160615112805 AddUserToHost: migrated (0.0451s) ===========================

== 20160628140022 AddDeletedAtToHost: migrating ===============================
-- add_column(:hosts, :deleted_at, :datetime)
   -> 0.0087s
-- add_index(:hosts, :deleted_at)
   -> 0.0205s
== 20160628140022 AddDeletedAtToHost: migrated (0.0294s) ======================

== 20160628140440 AddDeletedByToHost: migrating ===============================
-- add_column(:hosts, :deleted_by, :integer)
   -> 0.0114s
-- add_index(:hosts, :deleted_by)
   -> 0.0220s
== 20160628140440 AddDeletedByToHost: migrated (0.0335s) ======================

== 20160629043358 AddHomedirToUser: migrating =================================
-- add_column(:users, :home_dir, :string)
   -> 0.0120s
== 20160629043358 AddHomedirToUser: migrated (0.0120s) ========================

== 20160629043415 AddShellToUser: migrating ===================================
-- add_column(:users, :shell, :string)
   -> 0.0119s
== 20160629043415 AddShellToUser: migrated (0.0120s) ==========================

== 20160629075435 CreateGroups: migrating =====================================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:groups, {:id=>:integer})
   -> 0.0038s
-- add_index(:groups, :name)
   -> 0.0213s
== 20160629075435 CreateGroups: migrated (0.0253s) ============================

== 20160701090045 CreateGroupAssociations: migrating ==========================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:group_associations, {:id=>:integer})
   -> 0.0082s
== 20160701090045 CreateGroupAssociations: migrated (0.0083s) =================

== 20160701112600 AddDeletedPropertiesToGroup: migrating ======================
-- add_column(:groups, :deleted_by, :integer)
   -> 0.0081s
-- add_column(:groups, :deleted_at, :datetime)
   -> 0.0112s
== 20160701112600 AddDeletedPropertiesToGroup: migrated (0.0194s) =============

== 20160707115313 CreateAccessTokens: migrating ===============================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:access_tokens, {:id=>:integer})
   -> 0.0067s
== 20160707115313 CreateAccessTokens: migrated (0.0069s) ======================

== 20160714115228 AddPublicKeyToUser: migrating ===============================
-- add_column(:users, :public_key, :text)
   -> 0.0121s
== 20160714115228 AddPublicKeyToUser: migrated (0.0122s) ======================

== 20160908081651 CreateHostMachines: migrating ===============================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:host_machines, {:id=>:integer})
   -> 0.0041s
== 20160908081651 CreateHostMachines: migrated (0.0042s) ======================

== 20161003145832 CreateHostAccessGroups: migrating ===========================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:host_access_groups, {:id=>:integer})
   -> 0.0117s
== 20161003145832 CreateHostAccessGroups: migrated (0.0120s) ==================

== 20170803140620 AddUserLoginIdToUser: migrating =============================
-- add_column(:users, :user_login_id, :string)
   -> 0.0097s
-- add_index(:users, :user_login_id)
   -> 0.0192s
== 20170803140620 AddUserLoginIdToUser: migrated (0.0291s) ====================

== 20171013115441 CreateVersions: migrating ===================================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:versions, {:options=>"ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci", :id=>:integer})
   -> 0.0071s
-- add_index(:versions, [:item_type, :item_id])
   -> 0.0191s
== 20171013115441 CreateVersions: migrated (0.0263s) ==========================

== 20171016064705 RemoveIndexGroupName: migrating =============================
-- remove_index(:groups, [:name])
   -> 0.0067s
== 20171016064705 RemoveIndexGroupName: migrated (0.0068s) ====================

== 20171016071526 AddUniqueIndexOnGroupsName: migrating =======================
-- add_index(:groups, :name, {:unique=>true})
   -> 0.0217s
== 20171016071526 AddUniqueIndexOnGroupsName: migrated (0.0218s) ==============

== 20171031060034 CreateGroupAdmin: migrating =================================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:group_admins, {:id=>:integer})
   -> 0.0071s
== 20171031060034 CreateGroupAdmin: migrated (0.0074s) ========================

== 20171031060217 AddForeignKeyRefOnGroupAdmin: migrating =====================
-- add_foreign_key(:group_admins, :groups)
   -> 0.0101s
-- add_foreign_key(:group_admins, :users)
   -> 0.0061s
== 20171031060217 AddForeignKeyRefOnGroupAdmin: migrated (0.0164s) ============

== 20171031100758 CreateVpns: migrating =======================================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:vpns, {:id=>:integer})
   -> 0.0061s
== 20171031100758 CreateVpns: migrated (0.0062s) ==============================

== 20171031101026 CreateVpnGroupAssociation: migrating ========================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:vpn_group_associations, {:id=>:integer})
   -> 0.0061s
== 20171031101026 CreateVpnGroupAssociation: migrated (0.0065s) ===============

== 20171031103518 AddForeignKeyRefOnVpnGroupAssociation: migrating ============
-- add_foreign_key(:vpn_group_associations, :groups)
   -> 0.0100s
-- add_foreign_key(:vpn_group_associations, :vpns)
   -> 0.0076s
== 20171031103518 AddForeignKeyRefOnVpnGroupAssociation: migrated (0.0178s) ===

== 20171031113123 CreateVpnGroupUserAssociation: migrating ====================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:vpn_group_user_associations, {:id=>:integer})
   -> 0.0062s
== 20171031113123 CreateVpnGroupUserAssociation: migrated (0.0065s) ===========

== 20171031121702 AddForeignKeyRefOnVpnGroupUserAssociation: migrating ========
-- add_foreign_key(:vpn_group_user_associations, :users)
   -> 0.0062s
-- add_foreign_key(:vpn_group_user_associations, :groups)
   -> 0.0080s
-- add_foreign_key(:vpn_group_user_associations, :vpns)
   -> 0.0069s
== 20171031121702 AddForeignKeyRefOnVpnGroupUserAssociation: migrated (0.0214s)

== 20171102071909 AddIpAddressToVpns: migrating ===============================
-- add_column(:vpns, :ip_address, :string)
   -> 0.0054s
== 20171102071909 AddIpAddressToVpns: migrated (0.0055s) ======================

== 20171107114249 RemoveUrlFromVpns: migrating ================================
-- remove_column(:vpns, :url, :string)
   -> 0.0068s
== 20171107114249 RemoveUrlFromVpns: migrated (0.0069s) =======================

== 20171108130234 AddUserIdToAccessToken: migrating ===========================
-- add_column(:access_tokens, :user_id, :integer)
   -> 0.0062s
== 20171108130234 AddUserIdToAccessToken: migrated (0.0063s) ==================

== 20171108130353 AddForeignKeyRefOnAccessTokens: migrating ===================
-- add_foreign_key("access_tokens", "users")
   -> 0.0101s
== 20171108130353 AddForeignKeyRefOnAccessTokens: migrated (0.0101s) ==========

== 20171124090240 AddUuidToVpns: migrating ====================================
-- add_column(:vpns, :uuid, :string)
   -> 0.0072s
== 20171124090240 AddUuidToVpns: migrated (0.0072s) ===========================

== 20171124114427 CreateVpnDomainNameServers: migrating =======================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:vpn_domain_name_servers, {:id=>:integer})
   -> 0.0077s
== 20171124114427 CreateVpnDomainNameServers: migrated (0.0078s) ==============

== 20171124114830 CreateVpnSearchDomains: migrating ===========================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:vpn_search_domains, {:id=>:integer})
   -> 0.0036s
== 20171124114830 CreateVpnSearchDomains: migrated (0.0037s) ==================

== 20171124115925 CreateVpnSupplementalMatchDomains: migrating ================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:vpn_supplemental_match_domains, {:id=>:integer})
   -> 0.0042s
== 20171124115925 CreateVpnSupplementalMatchDomains: migrated (0.0043s) =======

== 20180104081814 AddProductNameToUsers: migrating ============================
-- add_column(:users, :product_name, :string)
   -> 0.0094s
== 20180104081814 AddProductNameToUsers: migrated (0.0094s) ===================

== 20180202102206 CreateSamlServiceProviders: migrating =======================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:saml_service_providers, {:id=>:integer})
   -> 0.0041s
== 20180202102206 CreateSamlServiceProviders: migrated (0.0044s) ==============

== 20180214050204 AddApiKeyToHostMachines: migrating ==========================
-- add_column(:host_machines, :api_key, :string)
   -> 0.0062s
== 20180214050204 AddApiKeyToHostMachines: migrated (0.0063s) =================

== 20180214052451 CreateIpAddresses: migrating ================================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:ip_addresses, {:id=>:integer})
   -> 0.0085s
-- add_index(:ip_addresses, :address)
   -> 0.0207s
-- add_index(:ip_addresses, :mac_address)
   -> 0.0183s
== 20180214052451 CreateIpAddresses: migrated (0.0478s) =======================

== 20180214052644 AddHostMachineToIpAddress: migrating ========================
-- add_reference(:ip_addresses, :host_machine, {:type=>:integer, :index=>true, :foreign_key=>true})
   -> 0.0466s
== 20180214052644 AddHostMachineToIpAddress: migrated (0.0467s) ===============

== 20180219150818 AddDescriptionToGroup: migrating ============================
-- add_column(:groups, :description, :string)
   -> 0.0093s
== 20180219150818 AddDescriptionToGroup: migrated (0.0093s) ===================

== 20180222135930 AddAccessKeyToHostMachine: migrating ========================
-- add_column(:host_machines, :access_key, :string)
   -> 0.0092s
== 20180222135930 AddAccessKeyToHostMachine: migrated (0.0093s) ===============

== 20180222140000 AddAccessKeyToUser: migrating ===============================
-- add_column(:users, :access_key, :string)
   -> 0.0093s
== 20180222140000 AddAccessKeyToUser: migrated (0.0095s) ======================

== 20180227051732 CreateApiResources: migrating ===============================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:api_resources, {:id=>:integer})
   -> 0.0044s
== 20180227051732 CreateApiResources: migrated (0.0045s) ======================

== 20180301010021 AddUserToApiResources: migrating ============================
-- add_reference(:api_resources, :user, {:type=>:integer, :index=>true, :foreign_key=>true})
   -> 0.0280s
== 20180301010021 AddUserToApiResources: migrated (0.0285s) ===================

== 20180301010035 AddGroupToApiResources: migrating ===========================
-- add_reference(:api_resources, :group, {:type=>:integer, :index=>true, :foreign_key=>true})
   -> 0.0351s
== 20180301010035 AddGroupToApiResources: migrated (0.0351s) ==================

== 20180306231200 AddDeactivatedAtToUsers: migrating ==========================
-- add_column(:users, :deactivated_at, :datetime)
   -> 0.0189s
== 20180306231200 AddDeactivatedAtToUsers: migrated (0.0190s) =================

== 20180311082600 RenameAccessKeyInApiResources: migrating ====================
-- rename_column(:api_resources, :access_key, :hashed_access_key)
   -> 0.0094s
== 20180311082600 RenameAccessKeyInApiResources: migrated (0.0095s) ===========

== 20180311161200 RenameTokenInAccessTokens: migrating ========================
-- rename_column(:access_tokens, :token, :hashed_token)
   -> 0.0090s
== 20180311161200 RenameTokenInAccessTokens: migrated (0.0092s) ===============

== 20180318083000 CreateIndexesToSpeedupNssController: migrating ==============
-- add_index(:users, :uid)
   -> 0.0201s
-- add_index(:access_tokens, :hashed_token)
   -> 0.0191s
-- add_index(:host_machines, :access_key)
   -> 0.0192s
-- add_index(:host_access_groups, [:host_machine_id, :group_id])
   -> 0.0195s
-- add_index(:group_associations, [:group_id, :user_id])
   -> 0.0262s
-- add_index(:groups, :gid)
   -> 0.0200s
== 20180318083000 CreateIndexesToSpeedupNssController: migrated (0.1246s) =====

== 20180613074108 CreateOrganisations: migrating ==============================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:organisations, {:id=>:integer})
   -> 0.0056s
== 20180613074108 CreateOrganisations: migrated (0.0060s) =====================

== 20180613165050 DropSamlServiceProviders: migrating =========================
-- drop_table(:saml_service_providers)
   -> 0.0019s
== 20180613165050 DropSamlServiceProviders: migrated (0.0019s) ================

== 20180723175600 UpdateOrganisationsForSaml: migrating =======================
-- rename_column(:organisations, :url, :website)
   -> 0.0126s
-- rename_column(:organisations, :email_domain, :domain)
   -> 0.0101s
-- add_column(:organisations, :country, :string)
   -> 0.0080s
-- add_column(:organisations, :state, :string)
   -> 0.0094s
-- add_column(:organisations, :address, :string)
   -> 0.0115s
-- add_column(:organisations, :unit_name, :string)
   -> 0.0086s
-- add_column(:organisations, :admin_email_address, :string)
   -> 0.0071s
-- add_column(:organisations, :slug, :string)
   -> 0.0092s
-- add_column(:organisations, :cert_fingerprint, :string)
   -> 0.0085s
-- add_column(:organisations, :cert_key, :text)
   -> 0.0070s
-- add_column(:organisations, :cert_private_key, :text)
   -> 0.0079s
== 20180723175600 UpdateOrganisationsForSaml: migrated (0.1005s) ==============

== 20181002023107 AddDefaultAdminsToHostMachines: migrating ===================
-- add_column(:host_machines, :default_admins, :boolean, {:default=>true})
   -> 0.0062s
== 20181002023107 AddDefaultAdminsToHostMachines: migrated (0.0062s) ==========

== 20181016093315 CreateSamlAppConfigs: migrating =============================
-- adapter_name()
   -> 0.0000s
-- adapter_name()
   -> 0.0000s
-- create_table(:saml_app_configs, {:id=>:integer})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json, `organisation_id` int, `app_name` varchar(255), `created_at` datetime NOT ' at line 1: CREATE TABLE `saml_app_configs` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `group_id` int, `sso_url` varchar(255), `config` json, `organisation_id` int, `app_name` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_saml_app_configs_on_group_id`  (`group_id`),  INDEX `index_saml_app_configs_on_organisation_id`  (`organisation_id`), CONSTRAINT `fk_rails_c98355f25f`
FOREIGN KEY (`group_id`)
  REFERENCES `groups` (`id`)
, CONSTRAINT `fk_rails_4cefca6b96`
FOREIGN KEY (`organisation_id`)
  REFERENCES `organisations` (`id`)
) ENGINE=InnoDB
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `_query'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `block in query'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:119:in `handle_interrupt'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:119:in `query'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/mysql/database_statements.rb:26:in `execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:849:in `block in method_missing'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:818:in `block in say_with_time'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:818:in `say_with_time'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:838:in `method_missing'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration/compatibility.rb:45:in `create_table'
/tmp/gate/db/migrate/20181016093315_create_saml_app_configs.rb:3:in `change'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:792:in `exec_migration'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:775:in `block in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:774:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:953:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1300:in `ddl_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1200:in `each'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1200:in `migrate_without_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1148:in `block in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1317:in `with_advisory_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1148:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1007:in `up'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:985:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/usr/local/rbenv/versions/2.4.3/bin/bundle:23:in `load'
/usr/local/rbenv/versions/2.4.3/bin/bundle:23:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json, `organisation_id` int, `app_name` varchar(255), `created_at` datetime NOT ' at line 1: CREATE TABLE `saml_app_configs` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `group_id` int, `sso_url` varchar(255), `config` json, `organisation_id` int, `app_name` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_saml_app_configs_on_group_id`  (`group_id`),  INDEX `index_saml_app_configs_on_organisation_id`  (`organisation_id`), CONSTRAINT `fk_rails_c98355f25f`
FOREIGN KEY (`group_id`)
  REFERENCES `groups` (`id`)
, CONSTRAINT `fk_rails_4cefca6b96`
FOREIGN KEY (`organisation_id`)
  REFERENCES `organisations` (`id`)
) ENGINE=InnoDB
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `_query'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `block in query'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:119:in `handle_interrupt'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:119:in `query'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/mysql/database_statements.rb:26:in `execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:849:in `block in method_missing'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:818:in `block in say_with_time'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:818:in `say_with_time'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:838:in `method_missing'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration/compatibility.rb:45:in `create_table'
/tmp/gate/db/migrate/20181016093315_create_saml_app_configs.rb:3:in `change'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:792:in `exec_migration'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:775:in `block in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:774:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:953:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1300:in `ddl_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1200:in `each'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1200:in `migrate_without_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1148:in `block in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1317:in `with_advisory_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1148:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1007:in `up'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:985:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/usr/local/rbenv/versions/2.4.3/bin/bundle:23:in `load'
/usr/local/rbenv/versions/2.4.3/bin/bundle:23:in `<main>'

Caused by:
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json, `organisation_id` int, `app_name` varchar(255), `created_at` datetime NOT ' at line 1
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `_query'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:120:in `block in query'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:119:in `handle_interrupt'
/tmp/gate/.local/ruby/2.4.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:119:in `query'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/tmp/gate/.local/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/mysql/database_statements.rb:26:in `execute'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:849:in `block in method_missing'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:818:in `block in say_with_time'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:818:in `say_with_time'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:838:in `method_missing'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration/compatibility.rb:45:in `create_table'
/tmp/gate/db/migrate/20181016093315_create_saml_app_configs.rb:3:in `change'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:792:in `exec_migration'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:775:in `block in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:774:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:953:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1300:in `ddl_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1200:in `each'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1200:in `migrate_without_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1148:in `block in migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1317:in `with_advisory_lock'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1148:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:1007:in `up'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/migration.rb:985:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
/tmp/gate/.local/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/usr/local/rbenv/versions/2.4.3/bin/bundle:23:in `load'
/usr/local/rbenv/versions/2.4.3/bin/bundle:23:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
rake aborted!
Command failed with status (1): [bundle exec rake db:drop db:create db:migr...]
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_utils.rb:67:in `block in create_shell_runner'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/file_utils.rb:57:in `sh'
/tmp/gate/lib/tasks/app.rake:11:in `block (2 levels) in <top (required)>'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/task.rb:273:in `block in execute'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/task.rb:273:in `each'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/task.rb:273:in `execute'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/task.rb:214:in `block in invoke_with_call_chain'
/usr/local/rbenv/versions/2.4.3/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/task.rb:194:in `invoke_with_call_chain'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/task.rb:183:in `invoke'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:160:in `invoke_task'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:116:in `each'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:116:in `block in top_level'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:125:in `run_with_threads'
/tmp/gate/.local/ruby/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:110:in `top_level'
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:83:in `block in run'
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:186:in `standard_exception_handling'
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/lib/rake/application.rb:80:in `run'
/usr/local/rbenv/versions/2.4.3/lib/ruby/gems/2.4.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/usr/local/rbenv/versions/2.4.3/bin/rake:23:in `load'
/usr/local/rbenv/versions/2.4.3/bin/rake:23:in `<main>'
Tasks: TOP => app:setup

Please let me know how to fix this.

ajeygore commented 5 years ago

Which ruby version are you running Gate on?

Rubueno commented 5 years ago

Ruby 2.4.3

ajeygore commented 5 years ago

And are you using MySQL or MongoDB?

Rubueno commented 5 years ago

This was set up with MySQL, thanks.

ajeygore commented 5 years ago

Please use MongoDB, this should get resolved.