Re: phpPgAdmin problem

From: Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr>
To: Markus Jais <markusjais(at)yahoo(dot)de>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: phpPgAdmin problem
Date: 2002-07-30 10:58:18
Message-ID: Pine.LNX.4.44.0207301300490.25267-100000@oper.metu.edu.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

On 29 Jul 2002, Markus Jais wrote:

> I get a login screen prompting for username and password
> I entered postgres and the linux postword for postgres
> but that didn't work

Well, you must use the password that you assigned to "postgres" user using
pg_passwd.

In etc/shadow, you could have an entry as below:

postgres:!!:11723:0:99999:7:::

This means that, postgres user will NOT accept ANY password. IMHO, maybe
this is a better security issue than assigning a passwd to postgres user.
You could disable the password by using passwd command with -l parameter.
This option is used to lock the specified account and it is available to
root only.

> I thought that I shouldn't get a login screen at all.

If so, anyone could access you db :)

Regards and best wished.

--

Devrim GUNDUZ

devrim(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr

Web : http://devrim.oper.metu.edu.tr
-------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ewald Geschwinde 2002-07-30 11:25:31 Re: advanced book ?
Previous Message valerie 2002-07-30 07:11:00 Top N Records Per Group