Thread: phpPgAdmin problem

phpPgAdmin problem

From
Markus Jais
Date:
hello

I have a problem with phpPgAdmin_2-4-2

my config file looks like this:

$cfgServers[1]['local']         = true;
$cfgServers[1]['host']          = 'localhost';
$cfgServers[1]['port']          = '5432';
$cfgServers[1]['adv_auth']      = true;

$cfgServers[1]['user']          = '';   // if you are not using adv_auth, e
nter the username to connect all the time
$cfgServers[1]['password']      = '';   // if you are not using adv_auth
and a password is required enter a password
$cfgServers[1]['only_db']       = '';   // if set to a db-name, only this
 db is accessible


they say that I should not enter a username if I use adv_auth
but I can not connect. even when I enter a username and a password
nothing happens

what I am doing wrong ??
I have
postgresql-7.2.1
php 4.2.1
RedHat 7.3
phpPgAdmin_2-4-2

markus

Re: phpPgAdmin problem

From
Robert Treat
Date:
a couple of questions,

which version of apache are you using?
which browser are you using?
are any error messages reported back on the screen?
what error message is produced in your postgres log files?

also you might want to grab an update from the cvs if possible.

Robert Treat
phpPgAdmin team


On Fri, 2002-07-26 at 16:33, Markus Jais wrote:
> hello
>
> I have a problem with phpPgAdmin_2-4-2
>
> my config file looks like this:
>
> $cfgServers[1]['local']         = true;
> $cfgServers[1]['host']          = 'localhost';
> $cfgServers[1]['port']          = '5432';
> $cfgServers[1]['adv_auth']      = true;
>
> $cfgServers[1]['user']          = '';   // if you are not using adv_auth, e
> nter the username to connect all the time
> $cfgServers[1]['password']      = '';   // if you are not using adv_auth
> and a password is required enter a password
> $cfgServers[1]['only_db']       = '';   // if set to a db-name, only this
>  db is accessible
>
>
> they say that I should not enter a username if I use adv_auth
> but I can not connect. even when I enter a username and a password
> nothing happens
>
> what I am doing wrong ??
> I have
> postgresql-7.2.1
> php 4.2.1
> RedHat 7.3
> phpPgAdmin_2-4-2
>
> markus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org




Re: phpPgAdmin problem

From
Markus Jais
Date:
Hello

I am using apache-1.3.23
the browsers are Konqueror 3.0.0 and Mozilla 1 RC3

the logfile seems to be empty or I checked the wrong one.
I am new to postgresql. I will check my book

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

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

markus


On Mon, 2002-07-29 at 19:54, Robert Treat wrote:
> a couple of questions,
>
> which version of apache are you using?
> which browser are you using?
> are any error messages reported back on the screen?
> what error message is produced in your postgres log files?
>
> also you might want to grab an update from the cvs if possible.
>
> Robert Treat
> phpPgAdmin team
>
>
> On Fri, 2002-07-26 at 16:33, Markus Jais wrote:
> > hello
> >
> > I have a problem with phpPgAdmin_2-4-2
> >
> > my config file looks like this:
> >
> > $cfgServers[1]['local']         = true;
> > $cfgServers[1]['host']          = 'localhost';
> > $cfgServers[1]['port']          = '5432';
> > $cfgServers[1]['adv_auth']      = true;
> >
> > $cfgServers[1]['user']          = '';   // if you are not using adv_auth, e
> > nter the username to connect all the time
> > $cfgServers[1]['password']      = '';   // if you are not using adv_auth
> > and a password is required enter a password
> > $cfgServers[1]['only_db']       = '';   // if set to a db-name, only this
> >  db is accessible
> >
> >
> > they say that I should not enter a username if I use adv_auth
> > but I can not connect. even when I enter a username and a password
> > nothing happens
> >
> > what I am doing wrong ??
> > I have
> > postgresql-7.2.1
> > php 4.2.1
> > RedHat 7.3
> > phpPgAdmin_2-4-2
> >
> > markus
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
M�chten Sie mit einem Gru� antworten? http://grusskarten.yahoo.de

Re: phpPgAdmin problem

From
Robert Treat
Date:
Advanced authentication means you will be prompted for a user name and
password by phppgadmin. You would then enter a standard
username/password combination like with psql or any other app, however
you need to make sure that your pg_hba.conf file is configured correctly
to allow that user to login. (this is how the configuation information
is set below)

if you don't use advance authentication, you will need to supply a user
name and password that you will always use to connect with. In this case
you will not be prompted by phpPgAdmin for login information, but you
still need to make sure your pg_hba.conf is configured properly to allow
that user to log in.

in either case, your database should be producing a connection error
message that is hopefully being written to a log file somewhere, this
will help you figure out why it wont let you authenticate.

Robert Treat
phpPgAdmin team

On Mon, 2002-07-29 at 14:43, Markus Jais wrote:
> Hello
>
> I am using apache-1.3.23
> the browsers are Konqueror 3.0.0 and Mozilla 1 RC3
>
> the logfile seems to be empty or I checked the wrong one.
> I am new to postgresql. I will check my book
>
> I get a login screen prompting for username and password
> I entered postgres and the linux postword for postgres
> but that didn't work
>
> I thought that I shouldn't get a login screen at all.
>
> markus
>
>
> On Mon, 2002-07-29 at 19:54, Robert Treat wrote:
> > a couple of questions,
> >
> > which version of apache are you using?
> > which browser are you using?
> > are any error messages reported back on the screen?
> > what error message is produced in your postgres log files?
> >
> > also you might want to grab an update from the cvs if possible.
> >
> > Robert Treat
> > phpPgAdmin team
> >
> >
> > On Fri, 2002-07-26 at 16:33, Markus Jais wrote:
> > > hello
> > >
> > > I have a problem with phpPgAdmin_2-4-2
> > >
> > > my config file looks like this:
> > >
> > > $cfgServers[1]['local']         = true;
> > > $cfgServers[1]['host']          = 'localhost';
> > > $cfgServers[1]['port']          = '5432';
> > > $cfgServers[1]['adv_auth']      = true;
> > >
> > > $cfgServers[1]['user']          = '';   // if you are not using adv_auth, e
> > > nter the username to connect all the time
> > > $cfgServers[1]['password']      = '';   // if you are not using adv_auth
> > > and a password is required enter a password
> > > $cfgServers[1]['only_db']       = '';   // if set to a db-name, only this
> > >  db is accessible
> > >
> > >
> > > they say that I should not enter a username if I use adv_auth
> > > but I can not connect. even when I enter a username and a password
> > > nothing happens
> > >
> > > what I am doing wrong ??
> > > I have
> > > postgresql-7.2.1
> > > php 4.2.1
> > > RedHat 7.3
> > > phpPgAdmin_2-4-2
> > >
> > > markus
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> TIP 6: Have you searched our list archives?



Re: phpPgAdmin problem

From
Devrim GUNDUZ
Date:
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
-------------------------------------





Re: phpPgAdmin problem

From
Markus Jais
Date:
Hello

I am using apache-1.3.23
the browsers are Konqueror 3.0.0 and Mozilla 1 RC3

the logfile seems to be empty or I checked the wrong one.
I am new to postgresql. I will check my book

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

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

markus

Robert Treat wrote:

> a couple of questions,
>
> which version of apache are you using?
> which browser are you using?
> are any error messages reported back on the screen?
> what error message is produced in your postgres log files?
>
> also you might want to grab an update from the cvs if possible.
>
> Robert Treat
> phpPgAdmin team
>
>
> On Fri, 2002-07-26 at 16:33, Markus Jais wrote:
>> hello
>>
>> I have a problem with phpPgAdmin_2-4-2
>>
>> my config file looks like this:
>>
>> $cfgServers[1]['local']         = true;
>> $cfgServers[1]['host']          = 'localhost';
>> $cfgServers[1]['port']          = '5432';
>> $cfgServers[1]['adv_auth']      = true;
>>
>> $cfgServers[1]['user']          = '';   // if you are not using adv_auth,
>> e nter the username to connect all the time
>> $cfgServers[1]['password']      = '';   // if you are not using adv_auth
>> and a password is required enter a password
>> $cfgServers[1]['only_db']       = '';   // if set to a db-name, only this
>>  db is accessible
>>
>>
>> they say that I should not enter a username if I use adv_auth
>> but I can not connect. even when I enter a username and a password
>> nothing happens
>>
>> what I am doing wrong ??
>> I have
>> postgresql-7.2.1
>> php 4.2.1
>> RedHat 7.3
>> phpPgAdmin_2-4-2
>>
>> markus
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster