Project

General

Profile

db:migrate fails

Added by Lee Hughes about 13 years ago

Installing Redmine 1.1.1 with PostgreSQL 9.0.3 according to instructions. "RAILS_ENV=production rake db:migrate --trace" fails with

(in /usr/local/redmine-1.1.1)
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    Please install the postgresql adapter: `gem install activerecord-postgresql-adapter` (libpq.so.5: cannot open shared object file: No such file or directory - /usr/local/lib/ruby/gems/1.8/gems/pg-0.10.1/lib/pg_ext.so)
    /usr/local/redmine-1.1.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:76:in `establish_connection'
    /usr/local/redmine-1.1.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:60:in `establish_connection'
    /usr/local/redmine-1.1.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:55:in `establish_connection'
    /usr/local/redmine-1.1.1/config/../vendor/rails/railties/lib/initializer.rb:438:in `initialize_database'
    /usr/local/redmine-1.1.1/config/../vendor/rails/railties/lib/initializer.rb:141:in `process'
    /usr/local/redmine-1.1.1/config/../vendor/rails/railties/lib/initializer.rb:113:in `send'
    /usr/local/redmine-1.1.1/config/../vendor/rails/railties/lib/initializer.rb:113:in `run'
    /usr/local/redmine-1.1.1/config/environment.rb:32
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:29:in `gem_original_require'
    /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:29:in `require'
    /usr/local/redmine-1.1.1/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
    /usr/local/redmine-1.1.1/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
    /usr/local/redmine-1.1.1/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
    /usr/local/redmine-1.1.1/vendor/rails/railties/lib/tasks/misc.rake:4
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
    /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:607:in `invoke_prerequisites'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `invoke_prerequisites'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:596:in `invoke_with_call_chain'
    /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
    /usr/local/bin/rake:19:in `load'
    /usr/local/bin/rake:19

libpq.so.5 is in /usr/local/pgsql/lib, file and directories are all accessible by the world.
/usr/local/lib/ruby/gems/1.8/gems/pg-0.10.1/lib/pg_ext.so is there, file and directories are all accessible by the world.

Which file is it saying is missing or inaccessible? They're both there -- any ideas?

Thanks for any help.

Lee


Replies (2)

RE: db:migrate fails - Added by buhawi jack about 13 years ago

we have the same problem.. :(

RE: db:migrate fails - Added by Lee Hughes about 13 years ago

This fixed it on my system:

vi /etc/ld.so.conf
(add /usr/local/pgsql/lib)
ldconfig

    (1-2/2)