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 76A0CD1B8A2 for ; Mon, 18 Aug 2003 20:20:12 -0300 (ADT) 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 01274-10 for ; Mon, 18 Aug 2003 20:20:04 -0300 (ADT) Received: from seapdc01.PNTS (ip63.c216.blk1.bel.nwlink.com [209.20.216.63]) by svr1.postgresql.org (Postfix) with ESMTP id 0C51FD1B56B for ; Mon, 18 Aug 2003 20:19:58 -0300 (ADT) Received: from busbydev (BUSBY-DEV [10.0.0.17]) by seapdc01.PNTS with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id PRCQ98HC; Mon, 18 Aug 2003 16:37:10 -0700 Message-ID: <023901c365de$3f3419b0$1100000a@busbydev> Reply-To: "David Busby" From: "David Busby" To: , References: <34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com> Subject: Re: Authentication Failure with pg_pconnect Date: Mon, 18 Aug 2003 16:12:50 -0700 Organization: Pacific Northwest Ticket Service MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/69 X-Sequence-Number: 2246 this doc has something for you in the "notes" section. http://www.edoceo.com/liberum/?doc=postgresql ----- Original Message ----- From: To: Sent: Monday, August 18, 2003 10:30 Subject: [PHP] Authentication Failure with pg_pconnect > 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 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)