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@xxxxxxxxxx ******************************************************* -----Original Message----- From: Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx> To: Tran Anh Tu <trantu@xxxxxxxxxx> Cc: "Kent L. Nasveschuk" <kent@xxxxxxxxxxxxxxxxx>, <pgsql- php@xxxxxxxxxxxxxx> 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@xxxxxxxxxx > > ******************************************************* > > > > > > -----Original Message----- > > From: "Kent L. Nasveschuk" <kent@xxxxxxxxxxxxxxxxx> > > To: Tran Anh Tu <trantu@xxxxxxxxxx> > > Cc: Postgres-Admin list <pgsql-admin@xxxxxxxxxxxxxx> > > 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@xxxxxxxxxx > > > > ******************************************************* > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > > TIP 5: Have you checked our extensive FAQ? > > > > > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > > -- > > > Kent L. Nasveschuk <kent@xxxxxxxxxxxxxxxxx> > > > . > > > > > > ---------------------------(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
