Re: Help me

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 <chriskl@familyhealth.com.au>
To: Tran Anh Tu <trantu@vnu.edu.vn>
Cc: "Kent L. Nasveschuk" <kent@wareham.k12.ma.us>, <pgsql-
php@postgresql.org>
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" <kent@wareham.k12.ma.us>
> > To: Tran Anh Tu <trantu@vnu.edu.vn>
> > Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
> > 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 <kent@wareham.k12.ma.us>
> > > .
> >
> >
> > ---------------------------(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