Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D43AA476CE7 for ; Wed, 18 Dec 2002 14:35:29 -0500 (EST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by postgresql.org (Postfix) with ESMTP id 62F61476CD7 for ; Wed, 18 Dec 2002 14:31:16 -0500 (EST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.6/8.12.6) with ESMTP id gBIJUfJb005932; Wed, 18 Dec 2002 12:30:41 -0700 (MST) Date: Wed, 18 Dec 2002 12:32:22 -0700 (MST) From: "scott.marlowe" To: Jesus Rios Cc: POSTGRESLQ-PHP Subject: Re: problems when i try to connect to my Databasse In-Reply-To: <200212181838.gBIIc3M0030993@smtp.wanadoo.es> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MailBodyFilter: Message body has not been filtered X-MailScanner: Found to be clean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/35 X-Sequence-Number: 1710 On Wed, 18 Dec 2002, Jesus Rios wrote: > > > > Hi........ > > Firts, sorry with my English. I am from Galician Country. > > My problem is : > i have only one user( in my postgresql) known as posgres. > # su postgres > #passwd ***** > > once , i am user postgres , i write : #psql mybd and it does not ask me for > the BD'pasword ( postgres is like a user root) > The problem comes when i am running a script php , where I try to connect to > my BD-----> $db=pg_connect("user=$user dbname=$dbname "). This refuse the > connection because I dont have the password.!!!!!. > > How can i get it?????????????????????? What do the last dozen or so lines from $PGDATA/pg_hba.conf say? What is the tcpip_socket set to in $PGDATA/postgresql.conf? Can you connect if you give a bogus password?