Authentication Failure with pg_pconnect - Mailing list pgsql-php

From
Subject Authentication Failure with pg_pconnect
Date
Msg-id 34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com
Whole thread Raw
Responses Re: Authentication Failure with pg_pconnect
List pgsql-php
I'm trying to get phpBB (php Bulletin Board System) running on my website
but it's install program is having problems authenticating with
postgreSQL.  I've tried to find out why it won't work and have pretty much
narrowed things down to this one function in the install script.  If the
following function doesn't seem flawed in any way, does anyone know why
php my throw this error even though username and password is correct and
user is logging in from localhost:

----
 Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL 1: IDENT authentication failed for user
"postgres" . in /var/www/html/phpBB2/db/postgres7.php on line 79
phpBB : Critical Error

Could not connect to the database
----

The line 79 it refers to is the line with the pg_pconnect call in the
following function:

----
    var $db_connect_id;
    var $query_result;
    var $in_transaction = 0;
    var $row = array();
    var $rowset = array();
    var $rownum = array();
    var $num_queries = 0;

    //
    // Constructor
    //
    function sql_db($sqlserver, $sqluser, $sqlpassword, $database,
$persistency = true)
    {
        $this->connect_string = "";

        if( $sqluser )
        {
            $this->connect_string .= "user=$sqluser ";
        }

        if( $sqlpassword )
        {
            $this->connect_string .= "password=$sqlpassword ";
        }

        if( $sqlserver )
        {
            if( ereg(":", $sqlserver) )
            {
                list($sqlserver, $sqlport) = split(":", $sqlserver);
                $this->connect_string .= "host=$sqlserver port=$sqlport ";
            }
            else
            {
                if( $sqlserver != "localhost" )
                {
                    $this->connect_string .= "host=$sqlserver ";
                }
            }
        }

        if( $database )
        {
            $this->dbname = $database;
            $this->connect_string .= "dbname=$database";
        }

        $this->persistency = $persistency;

        $this->db_connect_id = ( $this->persistency ) ?
pg_pconnect($this->connect_string) : pg_connect($this->connect_string);

        return ( $this->db_connect_id ) ? $this->db_connect_id : false;
    }
---------


PLEASE give me a hand here, at least point me towards people who might
know more.  I need to figure this out.

A. Leigh
dash@rogue-penguin.com




pgsql-php by date:

Previous
From: Joe Nilson Zegarra Galvez
Date:
Subject: test
Next
From: "David Busby"
Date:
Subject: Re: Authentication Failure with pg_pconnect