rails db:create no password supplied (rails with postgresql)

Question

I am new to Rails. I am trying to start my first Rails project. I run on Windows 10 with PostGreSQL installed. Rail and Ruby versions are installed properly. I then run into the no password supplied error.

Here is my database.yml file

default: &default
adapter: postgresql
encoding: unicode

pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

development:
<<: *default
database: blog_development

test:
<<: *default
database: blog_test

production:
<<: *default
database: blog_production
username: blog
password: password
# old password: <%= ENV['BLOG_DATABASE_PASSWORD'] %>

Thanks guys!

No password supplied error

puneet18 · Accepted Answer · 2017-06-09 05:04:47Z

1

Following is the code of database.yml file for connect with postgres db:

default: &default
  adapter: postgresql
  pool: 5
  timeout: 5000
  username : username #username of db
  password : password #password of db, if no password then make it blank

development:
  <<: *default
  database: db_name

test:
  <<: *default
  database: db_name

production:
  <<: *default
  database: db_name

answered Jun 9, 2017 at 5:04

puneet18

4,4272 gold badges25 silver badges27 bronze badges

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

Comments

Rockwell Rice · Accepted Answer · 2017-05-27 13:25:29Z

0

Each of those blocks represents one environment. Right now if you look you see there is no password for development and test.

development:
<<: *default
database: blog_development

test:
<<: *default
database: blog_test

production:
<<: *default
database: blog_production
username: blog
password: password

I personally set the password and username in the default settings at the top so I only have to write it once. Here is an example.

default: &default
  adapter: postgresql
  encoding: unicode
  username: <%= ENV['DATABASE_USERNAME'] %>
  password: <%= ENV['DATABASE_PASSWORD'] %>
  # For details on connection pooling, see rails configuration guide
  # http://guides.rubyonrails.org/configuring.html#database-pooling
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

development:
  <<: *default
  database: DBName_Development

test:
  <<: *default
  database: DBName_Test

production:
  <<: *default
  database: DBName_Production
  username: username
  password: <%= ENV['DATABASE_PASSWORD'] %>

What happens is this line...

<<default

... includes those values in. So now my development and test databases have the username and passwords that I set in the default area. If you look back at yours now there is no username or password getting sent in for your development (and test) database. If you add those values to your default section it should work. In place of my env variables you could just put your values. The values (username and password) are what you use to log in to your database.

answered May 27, 2017 at 13:25

Rockwell Rice

3,4225 gold badges43 silver badges68 bronze badges

2 Comments

Freelensia Over a year ago

Thanks @Rockwell for the answer, I edited the database.yml file as you instructed, then ran the rails db:create command again, but I still got errors as below. fe_sendauth: no password supplied Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "username"=>nil, "password"=>nil, "pool"=>5, "database"=>"DBName_Development"} rails aborted! PG::ConnectionBad: fe_sendauth: no password supplied bin/rails:4:in require' bin/rails:4:in <main>' Tasks: TOP => db:create (See full trace by running task with --trace)

Rockwell Rice Over a year ago

can you post your updated database.yml file. If you used my code with the env variables you did set those correct?

Collectives™ on Stack Overflow

rails db:create no password supplied (rails with postgresql)

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related