Re: phpPgAdmin problem - Mailing list pgsql-general

From Devrim GUNDUZ
Subject Re: phpPgAdmin problem
Date
Msg-id Pine.LNX.4.44.0207301300490.25267-100000@oper.metu.edu.tr
Whole thread Raw
In response to Re: phpPgAdmin problem  (Markus Jais <markusjais@yahoo.de>)
List 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@oper.metu.edu.tr
devrim.gunduz@linux.org.tr

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





pgsql-general by date:

Previous
From: "frank_lupo"
Date:
Subject: Re: Execute vacuum postgresql crash
Next
From: Ewald Geschwinde
Date:
Subject: Re: advanced book ?