347067 - Instructions in section 2.2.2.2.2 should be augmented

Status: RESOLVED INVALID

(Bugzilla :: Documentation, defect)

Description

[Adrian Hall]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.5) Gecko/20060719 Firefox/1.5.0.5
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.5) Gecko/20060719 Firefox/1.5.0.5

In section 2.2.2.2.2, the instructions tell you to add a line to pg_hba.conf.  However, the single line is incomplete (you need two lines) and the lines need to be added in a certain place (not at the end) in order for it to work.

Suggest the following:

Now, you will need to edit pg_hba.conf which is usually located in /var/lib/pgsql/data/. In this file, you will need to add two new lines to it as follows:

local all bugs md5
host all bugs 127.0.0.1 255.255.255.255 md5

This means allow connections 'all' databases on this server from the 'bugs' user, and use password authentication (md5) for that user.  Note that these lines must be added before any lines which indicate "ident" authentication, and are best added at the beginning of the file.  

Reproducible: Always

Comment 1

[Max Kanat-Alexander]

Actually, those instructions are incorrect. That first line will cause PostgreSQL to accept local-socket connections, which we don't use. We use TCP connections. Perhaps you modified your Bugzilla somehow?

They do need to be added at the beginning of the file, though, you're right about that...