Re: [ppa-users] phpPgAdmin problem with login

[Markus J. <mar...@ya...>]

On Mon, 2002-08-05 at 22:24, Dan Wilson wrote:
> This error could also indicate that your installation of postgresql is no=
t=20
> configured correctly.  There are a couple different possibilities here:
>=20
> 1. You are not accepting connections through TCP/IP.  Remove the localhos=
t=20
> setting in your 'host'.


thank you. now it works when I set host to ''
but can you explain why??
I thought this would be necessary to find the host where the postgresql
server is running?

how does this work now?
magic ?? :-)

markus


>=20
> 2. Your postgres user requires a password.  Login through psql and issue =
the=20
> command:
>=20
> ALTER USER "postgres" WITH PASSWORD '[enter_your_password]';
>=20
> For more information on this command, check goto:
>=20
> http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/sql-alteruser=
.html
>=20
> Try those two options and if that doesn't work, we can look at a couple o=
ther=20
> things.
>=20
> -Dan
>=20
> Quoting Markus Jais <mar...@ya...>:
>=20
> > hello
> >=20
> > I have a problem with phpPgAdmin_2-4-2
> > =20
> >  my config file looks like this:
> > =20
> >  $cfgServers[1]['local']         =3D true;
> >  $cfgServers[1]['host']          =3D 'localhost';
> >  $cfgServers[1]['port']          =3D '5432';
> >  $cfgServers[1]['adv_auth']      =3D true;
> > =20
> >  $cfgServers[1]['user']          =3D '';   // if you are not using
> > adv_auth, enter the username to connect all the time
> >  $cfgServers[1]['password']      =3D '';   // if you are not using
> > adv_auth and a password is required enter a password
> > $cfgServers[1]['only_db']       =3D '';   // if set to a db-name, only
> > this  db is accessible
> > =20
> > =20
> > when I set adv_auth to false and enter "postgres" as a user name
> > and no passwd I get this error
> >=20
> > Error - /var/www/html/phpPgAdmin/lib.inc.php -- Line: 303
> >=20
> > PostgreSQL said:
> > Your query:
> > Unable to connect with settings: host=3D'localhost' port=3D'5432'
> > dbname=3D'template1' user=3D'postgres' password=3D''=20
> >=20
> >=20
> > do I have to set an postgres password?
> > I read that I can set this in pg_shadow table but I can not find
> > this table within psql
> >=20
> >  what I am doing wrong ??
> >  I have
> >  postgresql-7.2.1
> >  php 4.2.1
> >  RedHat 7.3
> >  phpPgAdmin_2-4-2
> > =20
> >  markus
> > =20
> >=20
> > __________________________________________________________________
> >=20
> > Gesendet von Yahoo! Mail - http://mail.yahoo.de
> > M=F6chten Sie mit einem Gru=DF antworten? http://grusskarten.yahoo.de
> >=20
> >=20
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > phpPgAdmin-users mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
>=20
>=20
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users


__________________________________________________________________

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