Installation Issue - fe_sendauth: no password supplied about web-publisher HOT 4 CLOSED

Yep, it's pg_hba.conf configuration connected. Publisher can't connect to this database with provided credentials. This can help You: https://stackoverflow.com/questions/3278379/how-to-configure-postgresql-to-accept-all-incoming-connections

from web-publisher.

I used that stack overflow answer to change the pg_hba.conf to include:

# IPv4 local connections:
host    all             all             0.0.0.0/0               md5
# IPv6 local connections:
host    all             all             ::0/0                   md5

I added the listen_address = '*' to the postgresql.conf file, and I reloaded the configuration. I still get the same error though. I also tried using trust instead of md5, but still the same result.

from web-publisher.

For anyone facing the same issue, I figured it out. By coming back to it and mistakenly entering the second SQL command in the instructions, I got the error SQLSTATE[08006] : role "root" does not exist. I solved this with an answer from https://github.com/taigaio/taiga-back/issues/387 and added a user named "root" to postgres. Next, I upgraded the root user to a superuser. After that, everything worked just fine. I don't know why it was looking for a user named root instead of the one specified in parameters.yml.

Now, I have no idea if this was actually a secure way of installing this. I'm only testing right now, so I'm not super concerned, but @ahilles107 would you be able to give feedback about this?

from web-publisher.

I'm not sure how it should be done on postgres configuration. I never had to create root user - i always create new user and database for publisher instance.

from web-publisher.