X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id D5DD2D1C4DF for ; Mon, 21 Jul 2003 03:26:08 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 82043-06 for ; Mon, 21 Jul 2003 03:26:06 +0000 (GMT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id 40DD0D1C4DC for ; Mon, 21 Jul 2003 00:26:05 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h6L3PqLt032475; Mon, 21 Jul 2003 11:25:53 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <058c01c34f37$d1c2b560$2800a8c0@mars> From: "Christopher Kings-Lynne" To: "Salah Abdulla" , References: <015e01c34b76$f4a31b20$ca86a8c0@gaghalfrunt> Subject: Re: phpPgAdmin 2.4.2 Date: Mon, 21 Jul 2003 11:25:49 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0579_01C34F7A.D5EED770" 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: 200307/40 X-Sequence-Number: 2152 This is a multi-part message in MIME format. ------=_NextPart_000_0579_01C34F7A.D5EED770 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Don't use phpPgAdmin 2.4.2 with Postgres 7.3.x - you should be using phpPgA= dmin 3.0 Chris ----- Original Message -----=20 From: Salah Abdulla=20 To: pgsql-php@postgresql.org=20 Sent: Wednesday, July 16, 2003 4:47 PM Subject: [PHP] phpPgAdmin 2.4.2 Installed postgreql 7.3.3 and phpPgAdmin 2.4.2 in different machines. Def= ined password for postgres superuser. Entry is created in the pg_shadow tab= le for the same user. Keeping the access method in pg_hba.conf file as "tru= st", I do not have any problem. However when changed the access method to "= password" and tried managing the database using the phpPgAdmin tool I get= =20 Error - /var/www/pgadmin.intranet/htdocs/lib.inc.php -- Line: 303=20 PostgreSQL said:=20 Your query:=20 Unable to connect with settings: host=3Dhost_name' port=3D'post_num' dbna= me=3D'template1' user=3D'user_id' password=3D'xxxxx'=20 The pg_hpa.conf file has an entry "host all all ip_address ip_mask password" Any idea why this is happening. Regards, Salah ------=_NextPart_000_0579_01C34F7A.D5EED770 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Don't use phpPgAdmin 2.4.2 with Postgres 7.3.x - you sh= ould be=20 using phpPgAdmin 3.0
 
Chris
 
----- Original Message -----
Fro= m:=20 Salah= =20 Abdulla
To: pgsql-php@postgresql.org
Sent: Wednesday, July 16, 2003 4:4= 7=20 PM
Subject: [PHP] phpPgAdmin 2.4.2

Installed postgreql 7.3.3 and phpPgAdmin= 2.4.2 in=20 different machines. Defined password for postgres superuser. Entry is cre= ated=20 in the pg_shadow table for the same user. Keeping the access method in=20 pg_hba.conf file as "trust", I do not have any problem. However when chan= ged=20 the access method to "password"  and tried managing the database usi= ng=20 the phpPgAdmin tool I get
 
Error -=20 /var/www/pgadmin.intranet/htdocs/lib.inc.php -- Line: 303
PostgreSQL said:
Your query:
Una= ble to=20 connect with settings: host=3Dhost_name' port=3D'post_num' dbname=3D'temp= late1'=20 user=3D'user_id' password=3D'xxxxx'
 
The pg_hpa.conf file has an entry=
"host   =20 all        =20 all         ip_address = =20 ip_mask   password"
 
Any idea why this is happening.
 
Regards,
Salah
------=_NextPart_000_0579_01C34F7A.D5EED770--