PHPBB3

[Jerry Feldman]

On 12/09/2010 06:52 PM, John Abreau wrote:
> Did you add permissions to pg_hba.conf? By default, psql uses
> UNIX sockets, not TCP/IP, and ph_hba.conf (Host-Based Access)
> is where you set those permissions.
>
> On CentOS (and presumably RHEL and Fedora, too), the file is at
>
>      /usr/share/pgsql/pg_hba.conf
>
> On my home web server, I added the following to pg_hba.conf:
>
>     host    all         all         127.0.0.1/32          password
>
> This allows all users you define inside postgresql to connect from loca=
lhost.
>
>
On RHEL it is in /var/lib/pgsql/data/
/usr/share/pgsql/ contains sample files.
My pg_hba.conf contains:
local   all         all                               ident sameuser
host    all         all         127.0.0.1/32          ident sameuser

If I use UNIX domain sockets or TCP, I still get the same message from
PHPBB3 when I use either localhost or 127.0.0.1, but as I mentioned the
command line pgsql command did allow me to create the database.


In any case, I installed mysql and the system came right up.

--=20
Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org>
Boston Linux and Unix
PGP key id: 537C5846
PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB  CA3B 4607 4319 537C 5846