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 C307BD1B514 for ; Sun, 14 Sep 2003 05:12:25 +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 52604-05 for ; Sun, 14 Sep 2003 02:12:15 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id EA8A7D1B504 for ; Sun, 14 Sep 2003 02:12:12 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 12-md50000000178.tmp for ; Sun, 14 Sep 2003 12:10:21 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Sun, 14 Sep 2003 12:10:20 +0700 Date: Sun, 14 Sep 2003 12:10:20 +0700 From: "Tran Anh Tu" To: Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Sun, 14 Sep 2003 12:10:21 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/42 X-Sequence-Number: 2319 I can't login to phpPgAdmin with the user: postgres. It is display a error :Login failed. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: Christopher Kings-Lynne To: Tran Anh Tu Cc: "Kent L. Nasveschuk" , Date: Sun, 14 Sep 2003 12:57:55 +0800 (WST) Subject: Re: [PHP] Help me > Login as the postgres user to phpPgAdmin user, and create a new user > for > yourself. > > Also, set a password for the postgres user. > > Then, edit your pg_hba.conf and set password access to 'md5', not > 'trust'. > > Chris > > > On Sun, 14 Sep 2003, Tran Anh Tu wrote: > > > If I type: psql waterdb I must login as postgres user. > > So what can I do to login using phpPgAdmin 3.0.1? > > ******************************************************* > > Tran Anh Tu > > Vien CNTT - DHQG Ha Noi > > Phone: 047680417-25 Email trantu@vnu.edu.vn > > ******************************************************* > > > > > > -----Original Message----- > > From: "Kent L. Nasveschuk" > > To: Tran Anh Tu > > Cc: Postgres-Admin list > > Date: 13 Sep 2003 21:27:39 -0400 > > Subject: Re: [PHP] Help me > > > > > Are you connecting on the local machine? If so try without the -U > and > > > -p > > > > > > ex.: psql waterdb > > > > > > You can also use telnet or ssh and connect from a remote machine > and do > > > the same. > > > > > > Kent N > > > > > > On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote: > > > > I started postgresql with command: > > > > /etc/init.d/postgresql start > > > > I created user 'trantu' with password 'hanoi' and this user have > > > > privileges fully to create database and create user. > > > > when I type a command: > > > > psql -U trantu -p hanoi > > > > or > > > > psql -U trantu -p hanoi waterdb > > > > have a same error: > > > > psql: could not connect to server: No such file or directory > > > > Is the server running locally and accepting > > > > connections on Unix domain socket "/tmp/.s.PGSQL.0"? > > > > > > > > With phpPgAdmin, apache and php are configured perfecly. > > > > Please help me to debug it. Thank you very much. > > > > ******************************************************* > > > > Tran Anh Tu > > > > Vien CNTT - DHQG Ha Noi > > > > Phone: 047680417-25 Email trantu@vnu.edu.vn > > > > ******************************************************* > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > > TIP 5: Have you checked our extensive FAQ? > > > > > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > > -- > > > Kent L. Nasveschuk > > > . > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend