How to configure Postgresql with rails project?

Question

I am very new to ruby. I am trying to run BBYIDX and followed How to install BBYIDX on Windows?

When I try rake db:migrate it reproduces error as

(in /home/virinchy/BBYIDX-2/BBYIDX-master)  
DEPRECATION WARNING: Rake tasks in vendor/plugins/acts_as_tsearch/tasks,   vendor/plugins/acts_as_tsearch/tasks, vendor/plugins/delayed_job/tasks,   vendor/plugins/nested_scenarios/tasks, vendor/plugins/rails-authorization-plugin/tasks, and   vendor/plugins/rails_rcov/tasks are deprecated. Use lib/tasks instead. (called from /usr/local/rvm/gems/ruby-1.8.7-p371/gems/rails-2.3.11/lib/tasks/rails.rb:10)  
rake aborted!  
FATAL:  password authentication failed for user "bbyidx"  
FATAL:  password authentication failed for user "bbyidx"
Bundle install was succesful with message as:Your bundle is complete!  
Use `bundle show [gemname]` to see where a bundled gem is installed.

But rake db:migrate produces this error. I am running ubuntu 12.04, ruby-1.8.7, rails-2.3.11 and gem 1.5.3

How do i solve this? Thanks in advance.

mind.blank · Accepted Answer · 2013-04-23 15:16:41Z

4

Did you set a password for your postgres user?

In your config/database.yml you should have your databases set up properly:

development:
  adapter: postgresql
  encoding: unicode
  database: your_app_development # name your development app something
  host: localhost
  pool: 5
  username: your_username
  password: your_password # or leave blank if you didn't set a password

test:
  adapter: postgresql
  encoding: unicode
  database: your_app_test
  host: localhost
  pool: 5
  username: your_username
  password: your_password

answered Apr 23, 2013 at 15:16

mind.blank

4,8903 gold badges25 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

user2295369 Over a year ago

Here is my database.yml.# SQLite version 3.x adapter: postgresql database: bbyidx_dev username: bbyidx password: 123456 host: localhost

mind.blank Over a year ago

Did you try changing it like I've written? You can keep the names that you currently have obviously.

user2295369 Over a year ago

Thanks for suggestion.I have followed link to install postgresql in ubuntu12.04.

user2295369 Over a year ago

Here's my database.yml file.This Did n't make any change to it. link

mind.blank Over a year ago

Probably not, I've always had it though.

|

Collectives™ on Stack Overflow

How to configure Postgresql with rails project?

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related