Skip site navigation (1) Skip section navigation (2)

Authentication Failure with pg_pconnect

From: <dash(at)www(dot)rogue-penguin(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Subject: Authentication Failure with pg_pconnect
Date: 2003-08-18 17:30:31
Message-ID: 34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com (view raw or flat)
Thread:
Lists: 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(at)rogue-penguin(dot)com




Responses

pgsql-php by date

Next:From: Joe Nilson Zegarra GalvezDate: 2003-08-18 19:54:18
Subject: test
Previous:From: Adam WitneyDate: 2003-08-16 12:21:53
Subject: Re: PHP and COPY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group