rake db:setup results in fe_sendauth no password supplied

Question

When I run: rake db:setup

i get:

fe_sendauth: no password supplied

Couldn't create database for {"adapter"=>"postfresql", "encoding"=>"unicode",
"host"=>"localhost", "pool"=>5, "username"=>"my_user", "password"=>nil,  
"database"=>"my_db_test"}

-- enable_extension("plpgqsl")
rake aborted


Tasks: TOP => db:schema:load

My database.yml:

connection: &connection
adapter: postgresql
encoding: unicode
host:     localhost
pool: 5
username: my_user
password:

development:
  <<: *connection
  database: my_db_development

test: &test
  <<: *connection
  database: my_db_test

Already change my pg_hba.conf like in this question: Trying to set up postgres for ror app, getting error - fe_sendauth: no password supplied But it not help at all.

i see `postfresql` as adaptor instead of `postresql`. is that a mistake ? could you please add the output of `ActiveRecord::Base.connection.instance_variable_get(:@config)` — Paritosh Piplewar, Aug 09 '14 at 10:29
are you able to connect to postgres through commandline or pgadmin? — Sachin Singh, Aug 12 '14 at 11:06
Try to connect specifying host: ```psql -U my_user -h localhost```. If it askes for password, then you should edit your ```pg_hba.conf``` again. — Timothy Kovalev, Aug 20 '15 at 16:45

score 3 · Answer 1 · edited May 23 '17 at 12:09

3

It's a database connectivity issue.

Try to connect directly with the database that ur using. If it is asking password then you should use same password in database.yml file.

Check this link http://guides.rubyonrails.org/configuring.html#configuring-a-postgresql-database and Ruby on Rails: How can i edit database.yml for postgresql?

Hoping this links help you

edited May 23 '17 at 12:09

Community

1
1

answered Aug 14 '14 at 13:42

KJ_kaka

241
3
10

score 3 · Answer 2 · answered Apr 21 '17 at 15:33

My friend, I was have the same problem. My solution was added the credentials for each environment and enable the host in th value localhost..

like this:

development:
<<: *default
database: SM_development
username: user
password: xxxx

host: localhost

test:
<<: *default
database: SM_test
username: user
password: xxxxxx

production:
<<: *default
database: SM_production
username: user
password: xxxxxx

score 2 · Answer 3 · answered Aug 09 '14 at 21:28

2

try specifying which rails environment you want to do this for, like:

RAILS_ENV=test rake db:setup

answered Aug 09 '14 at 21:28

ussferox

490
5
10

score 1 · Answer 4 · answered Aug 13 '14 at 16:19

no password supplied means you have not supplied password to posgresql server from your database.yml.

Try to connect to posgresql server form pgadmin or terminal. Add same password (that you have used to login through terminal/pgadmin) to your database.yml.

Now try:

RAILS_ENV=TEST bundle exec rake db:setup

score 0 · Answer 5 · answered Aug 06 '14 at 12:38

0

Try supplying "empty" password using quotes:

password: ""

answered Aug 06 '14 at 12:38

Luca B.

638
4
13

score 0 · Answer 6 · answered Aug 09 '14 at 07:52

0

no password supplied means that a password is required but you specified no password. Add the correct password to your database.yml file.

answered Aug 09 '14 at 07:52

infused

24,000
13
68
78

score 0 · Answer 7 · answered Aug 13 '14 at 04:48

0

if you don't want to specify authentication, try removing username: password: from the .yml file.

answered Aug 13 '14 at 04:48

Som Poddar

1,428
1
15
22

rake db:setup results in fe_sendauth no password supplied

7 Answers7