ProstgreSQL authentication error

[angristan]

ProstgreSQL authentication error

[angristan]

Here:

POSTGRES=postgres
POSTGRES_USERNAME=feedbin
POSTGRES_USER=feedbin
POSTGRES_PASSWORD=password
DATABASE_URL=postgres://feedbin:feedbin@postgres/feedbin_production

Your password is password so the URI should be:

DATABASE_URL=postgres://feedbin:password@postgres/feedbin_production

[angristan]

Try to delete the postgres volume and try again.

[ldexterldesign]

Thanks for reply

Unfortunately same error:

feedbin-postgres_1 | 2020-03-26 00:01:12.728 UTC [119] FATAL: password authentication failed for user "feedbin"
feedbin-postgres_1 | 2020-03-26 00:01:12.728 UTC [119] DETAIL: Password does not match for user "feedbin".
feedbin-workers_1 | 00:01:12 worker_slow.1 | E, [2020-03-26T00:01:12.727131 #10] ERROR -- honeybadger: ** [Honeybadger] Unable to send error report: API key is missing. id=72978054-9d01-44d7-88e5-3871bfab0289 level=3 pid=10
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.729Z pid=10 tid=gsi1fzfdi class=FeedRefresherScheduler jid=bd0be77a411da2b66eccb15b INFO: start
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.740Z pid=10 tid=gsi1fthga class=FeedRefresherScheduler jid=99816eafabd224e15f3fc8b6 elapsed=0.034 INFO: fail
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.740Z pid=10 tid=gsi1fthga WARN: {"context":"Job raised exception","job":{"retry":true,"queue":"worker_slow_critical","class":"FeedRefresherScheduler","args":[],"jid":"99816eafabd224e15f3fc8b6","created_at":1585174842.0128543,"enqueued_at":1585180871.1999903,"error_message":"FATAL: password authentication failed for user \"feedbin\"\n","error_class":"PG::ConnectionBad","failed_at":1585174842.039284,"retry_count":7,"retried_at":1585177808.4826314},"jobstr":"{\"retry\":true,\"queue\":\"worker_slow_critical\",\"class\":\"FeedRefresherScheduler\",\"args\":[],\"jid\":\"99816eafabd224e15f3fc8b6\",\"created_at\":1585174842.0128543,\"enqueued_at\":1585180871.1999903,\"error_message\":\"FATAL: password authentication failed for user \\\"feedbin\\\"\\n\",\"error_class\":\"PG::ConnectionBad\",\"failed_at\":1585174842.039284,\"retry_count\":7,\"retried_at\":1585177808.4826314}"}
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.740Z pid=10 tid=gsi1fthga WARN: PG::ConnectionBad: FATAL: password authentication failed for user "feedbin"
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.740Z pid=10 tid=gsi1fthga WARN: /usr/local/bundle/gems/pg-1.2.3/lib/pg.rb:58:in `initialize'
feedbin-postgres_1 | 2020-03-26 00:01:12.745 UTC [120] FATAL: password authentication failed for user "feedbin"
feedbin-postgres_1 | 2020-03-26 00:01:12.745 UTC [120] DETAIL: Password does not match for user "feedbin".
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.747Z pid=10 tid=gsi1fzfdi class=FeedRefresherScheduler jid=bd0be77a411da2b66eccb15b elapsed=0.018 INFO: fail
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.747Z pid=10 tid=gsi1fzfdi WARN: {"context":"Job raised exception","job":{"retry":true,"queue":"worker_slow_critical","class":"FeedRefresherScheduler","args":[],"jid":"bd0be77a411da2b66eccb15b","created_at":1585138536.0046823,"enqueued_at":1585180871.2024183,"error_message":"FATAL: password authentication failed for user \"feedbin\"\n","error_class":"PG::ConnectionBad","failed_at":1585138536.013808,"retry_count":11,"retried_at":1585165373.687519},"jobstr":"{\"retry\":true,\"queue\":\"worker_slow_critical\",\"class\":\"FeedRefresherScheduler\",\"args\":[],\"jid\":\"bd0be77a411da2b66eccb15b\",\"created_at\":1585138536.0046823,\"enqueued_at\":1585180871.2024183,\"error_message\":\"FATAL: password authentication failed for user \\\"feedbin\\\"\\n\",\"error_class\":\"PG::ConnectionBad\",\"failed_at\":1585138536.013808,\"retry_count\":11,\"retried_at\":1585165373.687519}"}
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.748Z pid=10 tid=gsi1fzfdi WARN: PG::ConnectionBad: FATAL: password authentication failed for user "feedbin"
feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.748Z pid=10 tid=gsi1fzfdi WARN: /usr/local/bundle/gems/pg-1.2.3/lib/pg.rb:58:in `initialize'

Trying to dig in to postgres more to discover what's up but I'm new to postgres:

ldexterldesign@Lewiss-MacBook-Pro feedbin-docker % docker exec bb62b5f4d0a4 postgres pg_config
"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise.  See the documentation for
more information on how to properly start the server.
ldexterldesign@Lewiss-MacBook-Pro feedbin-docker % docker exec bb62b5f4d0a4 sudo -u postgres pg_config
OCI runtime exec failed: exec failed: container_linux.go:349: starting container process caused "exec: \"sudo\": executable file not found in $PATH": unknown

While I'm learning any additional troubleshooting pointers would be appreciated

Hope to hear back

Thanks

[ldexterldesign]

I updated my .env to:

POSTGRES_USERNAME=foobarbaz
POSTGRES_USER=foobarbaz
POSTGRES_PASSWORD=foobarbaz
DATABASE_URL=postgres://foobarbaz:foobarbaz@postgres/feedbin_production

... yet I still see the following error output:

feedbin-workers_1 | 00:01:12 worker_slow.1 | 2020-03-26T00:01:12.748Z pid=10 tid=gsi1fzfdi WARN: PG::ConnectionBad: FATAL: password authentication failed for user "feedbin"

Something somewhere must be cached or hardcoded, no?

Sincerely

[ldexterldesign]

Good thought

I just wiped everything and then ran docker system prune but this doesn't seem to include volumes:

ldexterldesign@Lewiss-MacBook-Pro feedbin-docker % docker system prune
WARNING! This will remove:
  - all stopped containers
  - all networks not used by at least one container
  - all dangling images
  - all dangling build cache

Are you sure you want to continue? [y/N]

Will report back

Thanks

[ldexterldesign]

#5 (comment) fixed it!

Kind thanks

[angristan]

Awesome!