Re: Authentication Failure with pg_pconnect

dash(at)www(dot)rogue-penguin(dot)com wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

have you tried echo $this->connect_string ?

--
--------------------------------------------------------
# Gerd Terlutter | Mueller+Blanck Software GmbH #
# gerd(at)MplusB(dot)de | Gutenbergring 38 #
# gerd(dot)terlutter(at)web(dot)de | D-22848 Noderstedt #
# tel:0171/6992579 | tel:+49 40 500 171-1 #
# Buero:040/500171-17 | fax:+49 40 500 171-71 #
--------------------------------------------------------