X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 077E5D1B58A for ; Mon, 18 Aug 2003 17:31:19 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 47445-01 for ; Mon, 18 Aug 2003 14:31:09 -0300 (ADT) Received: from melchior.rogue-penguin.com (rrcs-nys-24-213-130-185.biz.rr.com [24.213.130.185]) by svr1.postgresql.org (Postfix) with ESMTP id B5EF8D1B89C for ; Mon, 18 Aug 2003 14:30:52 -0300 (ADT) Received: by melchior.rogue-penguin.com (Postfix, from userid 72) id 2192F282DA; Mon, 18 Aug 2003 13:30:31 -0400 (EDT) Received: from 24.169.200.199 (SquirrelMail authenticated user dash) by rogue-penguin.com with HTTP; Mon, 18 Aug 2003 13:30:31 -0400 (EDT) Message-ID: <34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com> Date: Mon, 18 Aug 2003 13:30:31 -0400 (EDT) Subject: Authentication Failure with pg_pconnect From: To: X-Priority: 3 Importance: Normal X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/68 X-Sequence-Number: 2245 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