Authentication Failure with pg_pconnect

Поиск
Список
Период
Сортировка
От
Тема Authentication Failure with pg_pconnect
Дата
Msg-id 34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com
обсуждение исходный текст
Ответы Re: Authentication Failure with pg_pconnect
Список 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 по дате отправления:

Предыдущее
От: Joe Nilson Zegarra Galvez
Дата:
Сообщение: test
Следующее
От: "David Busby"
Дата:
Сообщение: Re: Authentication Failure with pg_pconnect