db:migrate fails
Added by Lee Hughes almost 14 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 Lee Hughes almost 14 years ago
This fixed it on my system:
vi /etc/ld.so.conf
(add /usr/local/pgsql/lib)
ldconfig