PHPBB3

[John Abreau]

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 localhost.





On Thu, Dec 9, 2010 at 5:11 PM, Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org> wrote:
> I am having some difficulty installing phpbb3. Essentially, the only
> database that is recognized is postgresql even though I have sqlite
> installed, but not the module. In any case, woith postgresql I have
> successfully created a database, phpbb3, and I can run other psql
> commands on it logged in as the postgresql user. But, when I enter the
> Install tab on phpbb3, I enter localhost as the Database Server name (or
> the actual server URL where I am installing phpbb3), phpbb3 as the
> database name, in this specific case postgres and the user name, and the
> postgres user's password, although this will change in the future, the
> issue now is I want to get this up and running quickly.
>
> The message I get back is:
> **Could not connect to the database, see error message below.
> No error message given.
>
> Most of the time, I am *running on another server on our cluster, but I
> have even tried running firefox on the same host. While I have not
> double checked, I do not have SELinux or IPtables running. Any clues.
> *
>
> --
> 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
>
>
>
> _______________________________________________
> Discuss mailing list
> Discuss-mNDKBlG2WHs at public.gmane.org
> http://lists.blu.org/mailman/listinfo/discuss
>
>



-- 
John Abreau / Executive Director, Boston Linux & Unix
AIM abreauj / JABBER jabr-iMZfmuK6BGBxLiRVyXs8+g at public.gmane.org / YAHOO abreauj / SKYPE zusa_it_mgr
Email jabr-mNDKBlG2WHs at public.gmane.org / WWW http://www.abreau.net / PGP-Key-ID 0xD5C7B5D9
PGP-Key-Fingerprint 72 FB 39 4F 3C 3B D6 5B E0 C8 5A 6E F1 2C BE 99