phppgadmin-users — General phpPgAdmin topics for all user

[ppa-users] is there anybody out there ?

[stephane p. <ste...@pa...>]

Hi,

I've just subscribed the list yesterday, but i still haven't received 
any message... is the list dead ? sleepy ? full of activity ?... ;-)

regards
stephane

[ppa-users] can't connect with main user

[stephane p. <ste...@pa...>]

hi, i've just installed phppgadmin 3.00 on my server and i experience a 
"light"  trouble... I can connect with a "standard" user, but not with 
the user which is the postgres admin... is it normal ?...

i have this error :

Warning: pg_connect() [function.pg-connect 
<http://www.php.net/function.pg-connect>]: Unable to connect to 
PostgreSQL server: FATAL 1: Password authentication failed for user 
"my_pgsql_admin" . in 
/mypath/libraries/adodb/drivers/adodb-postgres64.inc.php on line 404


Any clues ?

TIA
Stephane

[ppa-users] schema

[Roger K. <r....@ni...>]

Hi all,

As far as I understand phppgadmin doesn't support schema... is this
correct? Okay to add this as feature request or will I get my head
bitten off?!

Cheers,

Roger

[ppa-users] Fwd: I don't want to sound too dumb about PhpPgAdmin, but ...

[Dan W. <kil...@us...>]

----- Forwarded message from mi...@su... -----
    Date: Mon, 24 Feb 2003 19:56:12 -0700
    From: Mike Robinson <mi...@su...>
Reply-To: mi...@su...
 Subject: I don't want to sound too dumb about PhpPgAdmin, but ...
      To: kil...@us...

... but I guess that I must admit that I'm fairly new to Postgres and that I 
really don't know _how_ to set up the user-id needed for "adv_auth."

The "Documentation.html" file simply doesn't say!

Help?


-- 
Sundial Services International Inc.
Arizona:  (480) 205-7102
http://www.sundialservices.com
"Innovative Solutions for Database & Data Management Situations"



----- End forwarded message -----

[ppa-users] primera duda

[<yme...@ya...>]

hola
alguien puede decirme para que es esta linea en el
fichero de configuracion:

// You should change the superuser if different from
postgres
//      This is just used to filter out the system
functions when listing
$cfgSuperUser   = "";

tengo esa variable en blanco y me sigo conectando al
server aun mas con cualquier cosa que ponga en esa
variable me puedo conectar al server.

Saludos y gracias de antemano

PD: estoy utilizando la version 2.4.2, no se si es la ultima

___________________________________________________
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito 
en http://moviles.yahoo.es

[ppa-users] Re: PostgreSQL 7.3.x

[Greg M. <gs...@dy...>]

I have found one main issue with 7.3.x and phpPgAdmin...

dumps of any kind.  I beleive this is due to some system table changes that
occured in the 7.3 releases.


Any plans to upgrade this code?

---

-Greg Militello
programming @ Dyrect Media Group
http://www.dyrectmedia.com

Re: [ppa-users] PostgreSQL 7.3.x

[A G. C. T. <ty...@wi...>]

On Sun, Dec 22, 2002 at 10:05:57PM -0600, Eric Renfro wrote:
> Hey, I was wondering if continued developement would be made for phpPgAdmin to 
> support PostgreSQL 7.3.x, as it's out now, up to 7.3.1, and phpPgAdmin will 
> not work with it hardly at all.
> 

        Interesting.. I have phpPgAdmin running perfectly with 2 copies of 
PostgreSQL, one with 7.3, the other with 7.3.1. Both are linux boxes, but I'm 
also going to be installing another copy onto a sparc (E-420R, Solaris 2.8). 
What problems do you seem to be having with it? BTW, it's phpPgAdmin 2.4.2 
that I'm using.

                                                        BL.
-- 
Brad Littlejohn                         | Email:        ty...@wi...
Unix Systems Administrator,             |           ty...@oz...
Web + NewsMaster, BOFH.. Smeghead! :)   |   http://www.wizard.com/~tyketto
  PGP: 1024D/E319F0BF 6980 AAD6 7329 E9E6 D569  F620 C819 199A E319 F0BF

[ppa-users] PostgreSQL 7.3.x

[Eric R. <psi...@my...>]

Hey, I was wondering if continued developement would be made for phpPgAdm=
in to=20
support PostgreSQL 7.3.x, as it's out now, up to 7.3.1, and phpPgAdmin wi=
ll=20
not work with it hardly at all.

--=20
Eric Renfro
Myrddin Computers & Designs - CEO/President

[ppa-users] Devel mailing list

[Jean-Michel P. <jm....@fr...>]

Dear all,

Is there a devel mailing list to collaborate?

Cheers,
Jean-Michel POURE

[ppa-users] WebDB development

[Jean-Michel P. <jm....@fr...>]

Dear all,

I just installed WebDB which looks very promissing. I would like to join =
the=20
project if you need my help.

My first impressions :

1) It is recommended to use require_once everywhere in=20
place of include_once, because require_once will cast an=20
error if the required file is not present.=20
=20
2) Also, the configuration file should be tested in index.html,=20
with file_exists(). If the file does not exist, please print a=20
message to explain that the user should copy the installation file.=20
=20
3) Last, the use of <? ?> and <?php ?> is not coherent. On my=20
RedHat 8.0 + Apache 2.0 + Php 4.2, <? ?> is not recognized=20
by http.conf. Of course, it can be configured, but for compatibility reas=
ons=20
with code editors, <?php ?> should always be used.=20

4) File paths should be defined using constants like in ADODB with absolu=
te=20
file paths.

5) I am quite worried about the melting of HTML + PHP code. There should =
be a=20
way to build a complete object oriented interface, without visible HTML c=
ode.=20
HTML code should be embedeed in PHP classes... Much cleaner and easier to=
=20
maintain.

6) Why use a javascript tree class viewer? On my Linux box, Javascript is=
=20
always disabled. Javascript can be replaced by PHP. So why not do it? It =
used=20
to be the case in PhpPgAdmin.

Great job and great idea to support several databases, this will help=20
migration to PostgreSQL.

Cheers,=20
Jean-Michel POURE

Re: [ppa-users] Re: problems setting up phpPgAdmin

[Ricardo C. P. <ri...@ig...>]

On Wed, Oct 30, 2002 at 01:25:03PM -0700, Dan Wilson wrote:
> This is not an issue with PHP 4.2.3... it's an issue with Apache 2.  Until PHP 
> officially supports Apache 2, we will keep the code as is because we don't 
> know what we will break in the final version of PHP that supports Apache 2.

Right. Yhis is not the first problem with Apache2 and PHP that I notice.

> 
> You will also notice other problems with running phpPgAdmin under Apache 2.  
> I'd suggest downgrading back to a PHP supported version of Apache.

But since the machine I use this setup is only for testing purposes,
there's no harm here.

I believe this one is a good advice for production servers, though.

Anyway, hank's

-- 
Ricardo Campos Passanezi -  Administrador de Rede
Chave PGP e GPG Pública em: http://www.ige.unicamp.br/~riccp
Instituto de Geociências -  http://www.ige.unicamp.br - UNICAMP

Re: [ppa-users] Re: problems setting up phpPgAdmin

[Dan W. <kil...@us...>]

This is not an issue with PHP 4.2.3... it's an issue with Apache 2.  Until PHP 
officially supports Apache 2, we will keep the code as is because we don't 
know what we will break in the final version of PHP that supports Apache 2.

You will also notice other problems with running phpPgAdmin under Apache 2.  
I'd suggest downgrading back to a PHP supported version of Apache.

-Dan

Quoting Ricardo Campos Passanezi <ri...@ig...>:

> >         Hey, everyone..
> >
> >         I'm having a bit of trouble setting up the latest version of
> > phpPgAdmin. I swear I'm following everything by the book (well,
> > Documentation.html), and I'm still getting the same error. My setup:
> >
> >         Apache 2.0.40
> >         PHP 4.2.3
> >         Slackware 8.0, kernel 2.4.19
> >         phpPgAdmin 2.4.2
> >         postgresql 7.2.2
> ...
> 
> I have a similar situation here. And I've got the same problem:
> phpPgAdmin not working with the error message "Configuration Error: You
> must rename/copy config.inc.php-dist to config.inc.php and set your
> appropriate settings".
> 
> Then I searched this list and found no solution.
> 
> After that, I looked into the PHP Documentation for the "file_exists"
> function - http://www.php.net/manual/en/function.file-exists.php:
> 
> (last user comment below)
> /*----------------------------------------------------------------------
> tom at tom420 dot com
> 24-Oct-2002 10:27
> 
> 
> I am using Linux Red Hat 7.2
> 
> I have just upgraded from
> Apache 1.3.x + PHP 4.2.1
> to
> Apache 2.0.43 + PHP 4.2.3
> and suddenly all my file_exists() started to fail. All I can say is
> adding getcwd() at the beginning makes it work again. Looks like
> something has changed in the way that file_exists() is working between
> 4.2.1 and 4.2.3.
> 
> So file_exists ($file) fails but file_exists (getcwd() ."/". $file)
> works as expected.
> ----------------------------------------------------------------------*/
> 
> After changing the file_exists line in the lib.inc.php, it worked well.
> 
> --
> Ricardo Campos Passanezi -  Administrador de Rede
> Chave PGP e GPG Pública em: http://www.ige.unicamp.br/~riccp
> Instituto de Geociências -  http://www.ige.unicamp.br - UNICAMP
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: Influence the future
> of Java(TM) technology. Join the Java Community
> Process(SM) (JCP(SM)) program now.
> http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> 

[ppa-users] Re: problems setting up phpPgAdmin

[Ricardo C. P. <ri...@ig...>]

>         Hey, everyone..
>
>         I'm having a bit of trouble setting up the latest version of
> phpPgAdmin. I swear I'm following everything by the book (well,
> Documentation.html), and I'm still getting the same error. My setup:
>
>         Apache 2.0.40
>         PHP 4.2.3
>         Slackware 8.0, kernel 2.4.19
>         phpPgAdmin 2.4.2
>         postgresql 7.2.2
...

I have a similar situation here. And I've got the same problem:
phpPgAdmin not working with the error message "Configuration Error: You
must rename/copy config.inc.php-dist to config.inc.php and set your
appropriate settings".

Then I searched this list and found no solution.

After that, I looked into the PHP Documentation for the "file_exists"
function - http://www.php.net/manual/en/function.file-exists.php:

(last user comment below)
/*----------------------------------------------------------------------
tom at tom420 dot com
24-Oct-2002 10:27


I am using Linux Red Hat 7.2

I have just upgraded from
Apache 1.3.x + PHP 4.2.1
to
Apache 2.0.43 + PHP 4.2.3
and suddenly all my file_exists() started to fail. All I can say is
adding getcwd() at the beginning makes it work again. Looks like
something has changed in the way that file_exists() is working between
4.2.1 and 4.2.3.

So file_exists ($file) fails but file_exists (getcwd() ."/". $file)
works as expected.
----------------------------------------------------------------------*/

After changing the file_exists line in the lib.inc.php, it worked well.

-- 
Ricardo Campos Passanezi -  Administrador de Rede
Chave PGP e GPG Pública em: http://www.ige.unicamp.br/~riccp
Instituto de Geociências -  http://www.ige.unicamp.br - UNICAMP

Re: [ppa-users] problems setting up phpPgAdmin

[Dan W. <kil...@us...>]

I'm at a loss... there is no reason it should not find that file if you have 
copied it and renamed it.

But this issue is definitely in your php configuration.  A few things to try:

1. Verify that the file is readable by the server.
2. Create a test PHP script and see if it can include a file in the same 
directory

-Dan

Quoting Brad Littlejohn <at...@us...>:

> On Tue, Sep 10, 2002 at 10:41:29AM -0600, Dan Wilson wrote:
> > For some reason it's not finding your config file.  The only reason I can
> see
> > is that your include_path directive in your php.ini file does now include
> the
> > current directory.  It should look something like this: ".:/php/includes"
> >
> > The beginning dot tells it to check the current directory first.
> >
> > That's really the only reason I can see that it wouldn't work.  Unless
> > permissions are messed up on that file... but that looks correct as well.
> >
> > -Dan
> 
>         Hmm.. I've given this a try, by doing the following:
> 
> ;;;;;;;;;;;;;;;;;;;;;;;;;
> ; Paths and Directories ;
> ;;;;;;;;;;;;;;;;;;;;;;;;;
> 
> ; UNIX: "/path1:/path2"
> include_path = ".:/php/includes"
> ;
> 
>         This gave me the same result. I also tried copying in an old php.ini
> file from php 4.2.1 and php 4.1.2, which neither worked as well.. Anything
> else you could think of? In a previous version of phpPgAdmin, this had
> worked..
> 
>                                                         BL.
> --
> Brad Littlejohn                         | Email:        ty...@wi...
> Unix Systems Administrator,             |           ty...@oz...
> Web + NewsMaster, BOFH.. Smeghead! :)   |   http://www.wizard.com/~tyketto
>   PGP: 1024D/E319F0BF 6980 AAD6 7329 E9E6 D569  F620 C819 199A E319 F0BF

Re: [ppa-users] problems setting up phpPgAdmin

[Dan W. <kil...@us...>]

For some reason it's not finding your config file.  The only reason I can see 
is that your include_path directive in your php.ini file does now include the 
current directory.  It should look something like this: ".:/php/includes"

The beginning dot tells it to check the current directory first.

That's really the only reason I can see that it wouldn't work.  Unless 
permissions are messed up on that file... but that looks correct as well.

-Dan

Quoting Brad Littlejoh <at...@us...>:

> 
>         Hey, everyone..
> 
>         I'm having a bit of trouble setting up the latest version of
> phpPgAdmin. I swear I'm following everything by the book (well,
> Documentation.html), and I'm still getting the same error. My setup:
> 
>         Apache 2.0.40
>         PHP 4.2.3
>         Slackware 8.0, kernel 2.4.19
>         phpPgAdmin 2.4.2
>         postgresql 7.2.2
> 
>         config.inc.php has the following (comments left out to shorten):
> 
> $cfgProgName    = "phpPgAdmin";
> $cfgVersion     = "2.4.2";
> $cfgDefaultDB   = "template1";
> $cfgSuperUser   = "postgres";
> $cfgSysTables   = true;
> $cfgUserAdmin   = true;
> $cfgReports             = true;
> $cfgDebug               = false;
> $cfgQuotes              = true;
> $cfgMaxPages    = 9;
> $cfgServers[1]['local']         = true;
> $cfgServers[1]['host']          = '';
> $cfgServers[1]['port']          = '5432';
> $cfgServers[1]['adv_auth']      = true;
> 
>         PostgreSQL is being started with the following, as the postgres user
> I
> have made:
> 
> pg_ctl -D /usr/local/pgsql/data -l postgres.log -o "-i -l" start
> 
>         the error I'm getting, is:
> 
>    Configuration Error: You must rename/copy config.inc.php-dist to
>    config.inc.php and set your appropriate settings
> 
> However...
> bradl@bellicha:~> ls -alF /usr/local/apache2/htdocs/phpPgAdmin/config.inc.php
> -rw-r--r--    1 root     root         5259 Sep  7 02:24
> /usr/local/apache2/htdocs/phpPgAdmin/config.inc.php
> 
>         what am I missing? does this have anything to do with
> register_globals
> defaulting to Off in PHP >= 4.2.2?

[ppa-users] problems setting up phpPgAdmin

[Brad L. <at...@us...>]

        Hey, everyone..

        I'm having a bit of trouble setting up the latest version of 
phpPgAdmin. I swear I'm following everything by the book (well, 
Documentation.html), and I'm still getting the same error. My setup:

        Apache 2.0.40
        PHP 4.2.3
        Slackware 8.0, kernel 2.4.19
        phpPgAdmin 2.4.2
        postgresql 7.2.2

        config.inc.php has the following (comments left out to shorten):

$cfgProgName    = "phpPgAdmin";
$cfgVersion     = "2.4.2";
$cfgDefaultDB   = "template1";
$cfgSuperUser   = "postgres";
$cfgSysTables   = true;
$cfgUserAdmin   = true;
$cfgReports             = true;
$cfgDebug               = false;
$cfgQuotes              = true; 
$cfgMaxPages    = 9;
$cfgServers[1]['local']         = true;
$cfgServers[1]['host']          = '';
$cfgServers[1]['port']          = '5432';
$cfgServers[1]['adv_auth']      = true;

        PostgreSQL is being started with the following, as the postgres user I 
have made:

pg_ctl -D /usr/local/pgsql/data -l postgres.log -o "-i -l" start

        the error I'm getting, is:

   Configuration Error: You must rename/copy config.inc.php-dist to
   config.inc.php and set your appropriate settings

However...
bradl@bellicha:~> ls -alF /usr/local/apache2/htdocs/phpPgAdmin/config.inc.php 
-rw-r--r--    1 root     root         5259 Sep  7 02:24 
/usr/local/apache2/htdocs/phpPgAdmin/config.inc.php

        what am I missing? does this have anything to do with register_globals 
defaulting to Off in PHP >= 4.2.2?

                                                        BL.
-- 
Brad Littlejohn                         | Email:        ty...@wi...
Unix Systems Administrator,             |           ty...@oz...
Web + NewsMaster, BOFH.. Smeghead! :)   |   http://www.wizard.com/~tyketto
  PGP: 1024D/E319F0BF 6980 AAD6 7329 E9E6 D569  F620 C819 199A E319 F0BF

[ppa-users] Re: [ppa-dev] Online Contact Form

[Dan W. <kil...@us...>]

This is corrected in development... Just one more type that we/I didn't know 
needed quoting (I'm sure there are plenty more). In order to fix it on your 
side, you should change line 46 in tbl_replace.php.

You will find something link the following:

if (eregi("char|date|bool|time|inet|text|cidr", $field_type[$key])) {

This should be changed to include macaddr in the list of types that require 
quoting. So it should look like:

if (eregi("char|date|bool|time|inet|text|cidr|macaddr", $field_type[$key])) {

-Dan


Quoting Matthew Wild <M....@rl...>:

> 
> I have a table of MAC addresses and am using the type macaddr. Unfortunately
> I can't get phpPgAdmin to insert values into the table. It keep passing ...
> values (405,aa-aa-aa-aa-aa-aa) rather than ... values
> (405,'aa-aa-aa-aa-aa-aa) to postgres.
> I've tried quoting, but they just get preserved and postgres barfs over them.
> 
> How do I enter values for fields such as these?

[ppa-users] problem loging in

[<rd...@st...>]

Hello phppgadmin-users,

When I access  phppgadmin it opens up fine except there is nothing in
the left frame at all. I have tried many deferent was of setting up the
conf file but no mater what I do it just stays blank.

My conf file looks the 1st conf below but I have also tried the 2nd
conf
No mater what I do it does not change the way I log in with the
browser. With Adv_auth on it does not ask me for a username and
password.
It seams if the conf file is set wrong it should at least give me
errors.
I can access the postgress  database with PHP using this
pg_pconnect ("host=127.0.0.1 port=5901 dbname=eproperty user=eprop
password=b0gu5");

So what is the problem with  phppgadmin

1ST CONF
$cfgServers[1]['local']         = true;
$cfgServers[1]['host']          = '127.0.0.1';
$cfgServers[1]['port']          = '5901';
$cfgServers[1]['adv_auth']      = false;

$cfgServer[1]['user']          = 'eprop';      // if you are not using adv_auth, enter the username to
connect all the time
$cfgServers[1]['password']      = 'b0gu5';      // 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




2ND CONF
$cfgServers[1]['local']         = true;
$cfgServers[1]['host']          = 'localhost';
$cfgServers[1]['port']          = '5901';
$cfgServers[1]['adv_auth']      = true;

$cfgServers[1]['user']          = '';      // if you are not using adv_auth, enter 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


  

-- 
Best regards,
 rdkurth                          mailto:rd...@st...

[ppa-users] SourceForge Switching To DB2

[Robert T. <xz...@us...>]

http://www.vasoftware.com/news/press.php/2002/1070.html

Re: [ppa-users] Login ok = 2 new login frames !!!!

[Dan W. <kil...@us...>]

This is an issue with Apache 2 and PHP.  It's a problem with the way multiple 
cookies are written.

Hopefully in the near future, we will have a patch or new minor release which 
will fix this issue with a work-around, but it's actually a bug in PHP working 
with Apache 2.

-Dan

Quoting Jean-Luc OMS <Jea...@li...>:

> I've read about this problem .... but I can't find any solution working
> for me.
> 
> I use on a Solaris 8 host :
> 
> 	- Apache 2.0.39
> 	- php 4.2.2
> 
> I get the same result at login with versions 2.4.2 / 2.4.1 / CVS tree
> 
> If I don't use adv_auth, phpPgAdmin works fine.
> 
> On my installation phpMyAdmin(2.3.0-rc4) works fine using the http
> authentification mode ....
> 
> Thanks for help
> 
> 
> -- 
> 
> __________________________________________________________________________
> 
>  Jean-Luc Oms                                    tel 33 (0)4 67 41 85 93 
>  LIRMM                                           fax 33 (0)4 67 41 85 00
> __________________________________________________________________________

[ppa-users] Login ok = 2 new login frames !!!!

[Jean-Luc O. <Jea...@li...>]

I've read about this problem .... but I can't find any solution working
for me.

I use on a Solaris 8 host :

	- Apache 2.0.39
	- php 4.2.2

I get the same result at login with versions 2.4.2 / 2.4.1 / CVS tree

If I don't use adv_auth, phpPgAdmin works fine.

On my installation phpMyAdmin(2.3.0-rc4) works fine using the http
authentification mode ....

Thanks for help


-- 

__________________________________________________________________________

 Jean-Luc Oms                                    tel 33 (0)4 67 41 85 93 
 LIRMM                                           fax 33 (0)4 67 41 85 00
__________________________________________________________________________

Re: [ppa-users] phpPgAdmin problem with login

[Dan W. <dw...@mi...>]

Because you have your $cfgServers[1]['local'] set to true, it looks for a 
local connection rather than the tcp/ip socket.

If you want to use the tcp/ip socket then you should change your configuration 
in $PGDATA/postgresql.conf and then restart the postmaster.

-Dan

Quoting Markus Jais <mar...@ya...>:

> On Mon, 2002-08-05 at 22:24, Dan Wilson wrote:
> > This error could also indicate that your installation of postgresql is not 
> > configured correctly.  There are a couple different possibilities here:
> > 
> > 1. You are not accepting connections through TCP/IP.  Remove the localhost 
> > 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
> 
> 
> > 
> > 2. Your postgres user requires a password.  Login through psql and issue
> the 
> > command:
> > 
> > ALTER USER "postgres" WITH PASSWORD '[enter_your_password]';
> > 
> > For more information on this command, check goto:
> > 
> >
> http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/sql-
alteruser.html
> > 
> > Try those two options and if that doesn't work, we can look at a couple
> other 
> > things.
> > 
> > -Dan
> > 
> > Quoting Markus Jais <mar...@ya...>:
> > 
> > > 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, enter 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
> > >  
> > >  
> > > when I set adv_auth to false and enter "postgres" as a user name
> > > and no passwd I get this error
> > > 
> > > Error - /var/www/html/phpPgAdmin/lib.inc.php -- Line: 303
> > > 
> > > PostgreSQL said:
> > > Your query:
> > > Unable to connect with settings: host='localhost' port='5432'
> > > dbname='template1' user='postgres' password='' 
> > > 
> > > 
> > > 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
> > > 
> > >  what I am doing wrong ??
> > >  I have
> > >  postgresql-7.2.1
> > >  php 4.2.1
> > >  RedHat 7.3
> > >  phpPgAdmin_2-4-2
> > >  
> > >  markus
> > >  
> > > 
> > > __________________________________________________________________
> > > 
> > > Gesendet von Yahoo! Mail - http://mail.yahoo.de
> > > Möchten Sie mit einem Gruß antworten? http://grusskarten.yahoo.de
> > > 
> > > 
> > > -------------------------------------------------------
> > > 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
> > 
> > 
> > -------------------------------------------------------
> > 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
> 
> 
> -------------------------------------------------------
> 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


-- 

Dan Wilson [dw...@mi...]
LDS Mission Network (sm)
The mission home of the World Wide Web.(sm)
http://www.mission.net * http://www.ldsmissions.net

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

Re: [ppa-users] phpPgAdmin problem with login

[Dan W. <kil...@us...>]

This error could also indicate that your installation of postgresql is not 
configured correctly.  There are a couple different possibilities here:

1. You are not accepting connections through TCP/IP.  Remove the localhost 
setting in your 'host'.

2. Your postgres user requires a password.  Login through psql and issue the 
command:

ALTER USER "postgres" WITH PASSWORD '[enter_your_password]';

For more information on this command, check goto:

http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/sql-alteruser.html

Try those two options and if that doesn't work, we can look at a couple other 
things.

-Dan

Quoting Markus Jais <mar...@ya...>:

> 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, enter 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
>  
>  
> when I set adv_auth to false and enter "postgres" as a user name
> and no passwd I get this error
> 
> Error - /var/www/html/phpPgAdmin/lib.inc.php -- Line: 303
> 
> PostgreSQL said:
> Your query:
> Unable to connect with settings: host='localhost' port='5432'
> dbname='template1' user='postgres' password='' 
> 
> 
> 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
> 
>  what I am doing wrong ??
>  I have
>  postgresql-7.2.1
>  php 4.2.1
>  RedHat 7.3
>  phpPgAdmin_2-4-2
>  
>  markus
>  
> 
> __________________________________________________________________
> 
> Gesendet von Yahoo! Mail - http://mail.yahoo.de
> Möchten Sie mit einem Gruß antworten? http://grusskarten.yahoo.de
> 
> 
> -------------------------------------------------------
> 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

[ppa-users] phpPgAdmin problem with login

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

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, enter 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
 
 
when I set adv_auth to false and enter "postgres" as a user name
and no passwd I get this error

Error - /var/www/html/phpPgAdmin/lib.inc.php -- Line: 303

PostgreSQL said:
Your query:
Unable to connect with settings: host='localhost' port='5432'
dbname='template1' user='postgres' password='' 


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

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

__________________________________________________________________

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