Final test: Web stack

Read the output

The service is running and the port is listening, yet the application cannot log in. At which check did the connection stop?

$ ss -tln 'sport = :5432'
LISTEN 0      200        127.0.0.1:5432      0.0.0.0:*
$ psql -h 127.0.0.1 -U shop -d shop -c 'SELECT 1'
psql: error: connection to server at "127.0.0.1", port 5432 failed: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "shop", database "shop", no encryption

• A At the password: ~/.pgpass holds a wrong password.
• B At the network: the connection did not reach the server.
• C At the rule: pg_hba.conf has no line for this role, database and address.
• D At the rights: shop has no access to the tables.