I have error 'no password supplied' when switched to Postgres

[pmatsinopoulos]

I just moved from MySQL to Postgres.

Now I am getting the following error:

PG::ConnectionBad: fe_sendauth: no password supplied

Can you please help me?

My shippable.yml file is:

# language setting
language: ruby

# version numbers
rvm: 2.1.1

before_script:
  - mkdir -p shippable/testresults
  - psql -c 'create database "newleveltherapy_test";' -U postgres
  - rake db:migrate RAILS_ENV=test

env:
  - CI_REPORTS=shippable/testresults COVERAGE_REPORTS=shippable/codecoverage

script:
  - rspec -f RspecJunitFormatter -o shippable/testresults/results.xml

Where should I apply / give the password?

What value should the password have?

[rageshkrishna]

Your build appears to be failing at the rake step in before_script. The psql create database step succeeded, so we know for sure that postgres is working fine. I'm not sure what your connection string looks like for the db:migrate task. You need to ensure that it is set to use postgres as the user name and a blank password.

Unfortunately, I don't have a ruby + postgres sample but we're using this in our python + postgres sample:

conn_string = "host='127.0.0.1' dbname='test' user='postgres' password=''"

Something similar should work for your ruby project as well.

[J3RN]

I am also having this problem with authentication, and my shippable.yml is very simple:

# language setting
language: ruby

# version numbers
rvm: 2.1.1

before_script:
  - psql -c 'create database qb_test;' -U postgres

notifications:
  email:
    recipients:
      - jonarnett90@gmail.com

[Tobur]

@J3RN hello, are your solve this problem?