Hi,
When I try to run a controller that connects to my project’s sqlite
database, I get the following exception:
SQLite3::CantOpenException in PostController#index
could not open database
config/database.yml correctly points to my database, like so:
development:
adapter: sqlite3
database: db/dev.db
I’ve had Rails projects working with sqlite3 before (recently), but
starting any new projects has always lead to this error. I can’t figure
out what’s making the difference between the working and broken
projects…
Here is the full trace:
/usr/lib/ruby/1.8/sqlite3/errors.rb:94:in ‘check’
/usr/lib/ruby/1.8/sqlite3/database.rb:112:in ‘initialize’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/sqlite_adapter.rb:17:in
‘sqlite3_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in
‘connection_without_query_cache=’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:in
‘connection=’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in
‘retrieve_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
‘connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1046:in
‘add_limit!’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1017:in
‘construct_finder_sql’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:924:in
‘find_every’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:381:in
‘find’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/deprecated_finders.rb:37:in
‘find_all’
#{RAILS_ROOT}/app/controllers/post_controller.rb:4:in ‘index’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/base.rb:941:in
‘perform_action_without_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:368:in
‘perform_action_without_benchmark’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/benchmarking.rb:69:in
‘perform_action_without_rescue’
/usr/lib/ruby/1.8/benchmark.rb:293:in ‘measure’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/benchmarking.rb:69:in
‘perform_action_without_rescue’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/rescue.rb:82:in
‘perform_action’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/base.rb:408:in
‘process_without_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:377:in
‘process_without_session_management_support’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/session_management.rb:117:in
‘process’
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:38:in
‘dispatch’
/var/www/my-site/blog/dispatch.cgi:10
Other info:
Ruby 1.8.4
Rails 1.1.6
sqlite 3.3.5
sqlite3-ruby 1.1.0
Running on Apache 2.0.55, Ubuntu 6.10
Thanks,
Gavin