Problems to access sqlite database

Added by vincent mugnier about 1 month ago

Hello,

I need to migrate an existing old SQLite Redmine v1.0.2 on a new computer.

I've installed Redmine v1.0.2 and SQLite on windows.

Everything seems to be OK during this intall ... but, at the very end, http://localhost/redmine returns :

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request

Reason: Error reading from remote server

What can I check to find what's wrong ?

Thanks for your help.

Regards

Vincent

Replies (3)

RE: Problems to access sqlite database - Added by vincent mugnier about 1 month ago

I've just run the following command to see the result :

ruby script/server -e production
=> Booting Mongrel
=> Rails 2.3.5 application starting on http://0.0.0.0:3000
./script/../config/../vendor/rails/railties/lib/rails/gem_dependency.rb:119:Warning: Gem::Dependency#version_requirements is deprecated and will be removed on or after August 2010.  Use #requirement C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require': no such file to load -- sqlite3 (MissingSourceFile)
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/core_ext/kernel/requires.rb:7:in `require_library_or_gem'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/core_ext/kernel/reporting.rb:11:in `silence_warnings'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/core_ext/kernel/requires.rb:5:in `require_library_or_gem'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb:10:in `sqlite3_connection'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `send'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `new_connection'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in `checkout'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/1.8/monitor.rb:242:in `synchronize'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in `connection'
        from c:/Webserver/Redmine/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:217:in `quoted_left_column_name'
        from c:/Webserver/Redmine/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:93:in `acts_as_nested_set'
        from c:/Webserver/Redmine/app/models/issue.rb:35
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
        from c:/Webserver/Redmine/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:96:in `const_missing'
        from c:/Webserver/Redmine/app/models/project.rb:35
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
        from c:/Webserver/Redmine/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:96:in `const_missing'
        from c:/Webserver/Redmine/app/models/attachment.rb:36
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
        from c:/Webserver/Redmine/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:437:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/plugins/acts_as_attachable/lib/acts_as_attachable.rb:33:in `acts_as_attachable'
        from c:/Webserver/Redmine/app/models/message.rb:22
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:265:in `require_or_load_without_engine_additions'
        from c:/Webserver/Redmine/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:132:in `require_or_load'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:425:in `load_missing_constant'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:80:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:92:in `const_missing'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/inflector.rb:361:in `constantize'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/inflector.rb:360:in `each'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/inflector.rb:360:in `constantize'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/core_ext/string/inflections.rb:162:in `constantize'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/observer.rb:157:in `observed_class'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/observer.rb:183:in `observed_classes'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/observer.rb:166:in `initialize'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/1.8/singleton.rb:94:in `new'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/1.8/singleton.rb:94:in `instance'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/observer.rb:38:in `instantiate_observers'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/observer.rb:36:in `each'
        from c:/Webserver/Redmine/vendor/rails/activerecord/lib/active_record/observer.rb:36:in `instantiate_observers'
        from c:/Webserver/Redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:15:in `define_dispatcher_callbacks'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:182:in `call'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:182:in `evaluate_method'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `run'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `each'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `send'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:90:in `run'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
        from c:/Webserver/Redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:51:in `send'
        from c:/Webserver/Redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:51:in `run_prepare_callbacks'
        from ./script/../config/../vendor/rails/railties/lib/initializer.rb:631:in `prepare_dispatcher'
        from ./script/../config/../vendor/rails/railties/lib/initializer.rb:185:in `process'
        from ./script/../config/../vendor/rails/railties/lib/initializer.rb:113:in `send'
        from ./script/../config/../vendor/rails/railties/lib/initializer.rb:113:in `run'
        from c:/Webserver/Redmine/config/environment.rb:20
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
        from c:/Webserver/Redmine/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
        from c:/Webserver/Redmine/vendor/rails/railties/lib/commands/server.rb:84
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Webserver/Ruby/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from script/server:3

RE: Problems to access sqlite database - Added by Bernhard Rohloff about 1 month ago

Hi vincent,

seems to be a Windows specific problem. I've found something on Stackoverflow: https://stackoverflow.com/questions/17643897/cannot-load-such-file-sqlite3-sqlite3-native-loaderror-on-ruby-on-rails

kind regards,
Bernhard

RE: Problems to access sqlite database - Added by vincent mugnier about 1 month ago

Bernhard Rohloff wrote:

Hi vincent,

seems to be a Windows specific problem. I've found something on Stackoverflow: https://stackoverflow.com/questions/17643897/cannot-load-such-file-sqlite3-sqlite3-native-loaderror-on-ruby-on-rails

kind regards,
Bernhard

Thanks, I will take a look at that !
Regards
Vincent

(1-3/3)