Documentation on how to setup access on the postgresql is incomplete / missing

Bug #1883099 reported by Wouter van Bommel on 2020-06-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Snap Store Server
Undecided
Unassigned

Bug Description

In the documentation there is some talk about that a postgresql database is required and that accounts have to be created.

What is lacking in the documentation, is that various roles are used, which is important if the database is running on a different machine, and thus needs some care in the pg_hba.conf to work.

I ended up adding the following lines to the pg_hba.conf to make all the services work successfully.

host snapproxy-db snapproxy-user 10.192.64.1/32 md5
host snapproxy-db snaprevs 10.192.64.1/32 md5
host snapproxy-db snapauth 10.192.64.1/32 md5
host snapproxy-db snapident 10.192.64.1/32 md5
host snapproxy-db snapassert 10.192.64.1/32 md5

The username / role name varies, while they all access the same database.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers