Re: phpPgAdmin problem - Mailing list pgsql-general

From Robert Treat
Subject Re: phpPgAdmin problem
Date
Msg-id 1027970720.24083.36.camel@camel
Whole thread Raw
In response to Re: phpPgAdmin problem  (Markus Jais <markusjais@yahoo.de>)
List pgsql-general
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?



pgsql-general by date:

Previous
From: Markus Jais
Date:
Subject: Re: phpPgAdmin problem
Next
From: Patrick Nelson
Date:
Subject: Re: Importing data