phppgadmin-users — General phpPgAdmin topics for all user

Re: [ppa-users] (no subject)

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

phpPgAdmin can be used for users as well as DBAs.

What is the result when they login?  Does it give an error or does it just
not let them in?

If they can get in from psql and not through phpPgAdmin, then there is a
permissions issue, however it might not be in the pg_hba.conf file.  That is
one possibility, the other is with the actual permissions (ownership) on the
databases.

We need more details in order to help...  your server settings (are you
connecting local or through tcp), do you have cfgUserDatabases = true, etc.

-Dan

: Hi all!
:
: I really love this sw!
:
: but there's a little problem:
:
: I want to use phppgadmin for web interface for a db.
: a user would be able to select,insert,update some tables, others just
: select.
:
: this user cannot login via the web interface. but can log in with
: psql-client.
: when I give my permissions to him, he can do the same as I.
:
: Is there any php based psql web interfaces for users? just like an sql
: client?
:
: thanks
: - -------------------------
: Narancs v1
: IT Security Administrator
: Warning: This is a really short .sig! Vigyazat: ez egy nagyon rovid szig!
:
: -----BEGIN PGP SIGNATURE-----
: Version: GnuPG v1.0.6 (GNU/Linux)
: Comment: For info see http://www.gnupg.org
:
: iEYEARECAAYFAjxzlRYACgkQGp+ylEhMCIUkLgCfc9yU/GxgnO+gADFNpLRxdN9x
: PpwAn2dSMcOFQVYqTcNkAo+WBXllP71t
: =OIgY
: -----END PGP SIGNATURE-----
:
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users

Re: [ppa-users] (no subject)

[<ma...@bu...>]

On Mié 20 Feb 2002 09:22, you wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all!
>
> I really love this sw!
>
> but there's a little problem:
>
> I want to use phppgadmin for web interface for a db.
> a user would be able to select,insert,update some tables, others just
> select.
>
> this user cannot login via the web interface. but can log in with
> psql-client.
> when I give my permissions to him, he can do the same as I.
>
> Is there any php based psql web interfaces for users? just like an sql
> client?

You certainly have a permission problem. Check your pg_hba.conf file, and 
doble check the permissions you have on the objects that this user can't 
access.

saludos... ;-)

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mma...@un...
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

[ppa-users] (no subject)

[Narancs v1 <na...@na...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all!

I really love this sw!

but there's a little problem:

I want to use phppgadmin for web interface for a db.
a user would be able to select,insert,update some tables, others just
select.

this user cannot login via the web interface. but can log in with
psql-client.
when I give my permissions to him, he can do the same as I.

Is there any php based psql web interfaces for users? just like an sql
client?

thanks
- -------------------------
Narancs v1
IT Security Administrator
Warning: This is a really short .sig! Vigyazat: ez egy nagyon rovid szig!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjxzlRYACgkQGp+ylEhMCIUkLgCfc9yU/GxgnO+gADFNpLRxdN9x
PpwAn2dSMcOFQVYqTcNkAo+WBXllP71t
=OIgY
-----END PGP SIGNATURE-----

Re: [ppa-users] delete individual table entries

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

In order to get the edit and delete functionality, phpPgAdmin must be able
to uniquely identify the row you wish to edit.  In order to do this, it
looks for primary keys and any unique indices.

So a simple answer... you need to create a unique index on your table, or
build your table with a primary key (which is a good idea and good db
design).

-Dan


: Hi,
:
: Perhaps this is a newbie Postgres question. Is there a reason why there is
: seemingly no feature to delete entries at the row level as their is in
: phpMyadmin? When I browse a table, I don't get the option to modify or
delete
: entries that I was used to getting back when I used MySQL :^)
:
: Thanks,
:
: Matt Terenzio
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users

[ppa-users] delete individual table entries

[<web...@lo...>]

Hi,

Perhaps this is a newbie Postgres question. Is there a reason why there is 
seemingly no feature to delete entries at the row level as their is in 
phpMyadmin? When I browse a table, I don't get the option to modify or delete 
entries that I was used to getting back when I used MySQL :^)

Thanks,

Matt Terenzio

[ppa-users] Re: Bug report in phppgadmin

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

This is usually caused by incorrect cookie settings.  If you are not
accepting cookies, then it will not work.

In the future, please post your questions to the
php...@li... mailing list.

-Dan


: Hello,
: I am using Debian/testing, updated, and
:  package phppgadmin.
:
: I found a bug in phppgadmin.
: If I configure the file config.inc.php, to use adv_auth,
: It does not work: the Netscape 4.75 and Netscape 6 (under nt4)
: page repaints and I obtain two frames with the question
: user/password.
:
: After some testings, I found that :
: - With client IE5: it works
:
: Thanks for your work
:

[ppa-users] Re: Total blank page

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

Ah... there's your answer.  We are aware of problems with Mozilla and the
left nav.  The system tables does need expanding, and for some reason we
didn't make it a main link (so you can click the database name like the
others).  If you want to hack the code to make it clickable, go ahead.  Just
use the same link that is with the other databases.

We do have one of the developers working on the mozilla compatibility
issues.

-Dan

:
: > The cfgSysTables also works off of the super user... obviously it should
: > work with postgres.  Are you also not seeing the "Reports" link of the
"User
: > Admin" link?  If you are not, it's possible that there is a PHP parse
error
: > happening in the navigation menu that is not being show because of the
: > layers.  View source on that left frame and check.
:
: Actually I think its part of the navigation problems, I am useing
: Galeon, a mozilla based web browser so the little + signs to expand a
: database do not work, is the "systems tables" treated as a normal
: databse or does it need expanding ?
:
: --
:
:   Rob Brown-Bayliss
:  ---======o======---

Re: [ppa-users] blank passwords

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

Currently, no.  You cannot use a blank password.  The reason is partly just
because that's how it was built, but in addition to that, it's a security
issue... even when you are behind a firewall.  You should always set a
password for your postgres users.

It's quite easy to allow this in the code, although I suggest against it.

-Dan


: guys,
:   is it possible to use blank passwords with phppgadmin?  i have not tried
: the new configuration in the beta yet, but i was just wondering.  btw, i
: searched forever on the internet for a good web interface to postgres,
: thanks for all the hard work.
:
: jason
:
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users

[ppa-users] blank passwords

[Jason H. <jho...@cs...>]

guys,
  is it possible to use blank passwords with phppgadmin?  i have not tried 
the new configuration in the beta yet, but i was just wondering.  btw, i 
searched forever on the internet for a good web interface to postgres, 
thanks for all the hard work.

jason

Re: [ppa-users] WebPg 3.0 alpha no longer supported

[<ma...@bu...>]

On Sáb 19 Ene 2002 06:01, Dan Wilson wrote:
> Due to some design issues that were discovered in the WebPg 3.0 alpha code,
> it has been decided that the phpPgAdmin team will no longer support this
> alpha release.
>
> We will however begin a re-write of phpPgAdmin.  The new version will
> eventually have support for plug-in modules which will allow administration
> of multiple types of database systems.  Initial support will only be for
> PostgreSQL, but the infrastructure will exist for additional support.
>
> We will continue to maintain and support the 2.x version of phpPgAdmin.

:-(

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mma...@un...
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

RE: [ppa-users] Parse error: parse error in lib.inc.php on line 4 48

[Gary S. <ga...@am...>]

That's it. I must have missed the PHP4 requirement. I will upgrade. 

Thanks,
Gary

-----Original Message-----
From: Dan Wilson [mailto:kil...@us...] 
Sent: Monday, January 21, 2002 5:20 PM
To: Gary Strauss
Cc: (php...@li...)
Subject: Re: [ppa-users] Parse error: parse error in lib.inc.php on line 448

What version of PHP are you running?  It looks like you are still running
PHP3.

We made some changes in the latest release that breaks our compatibility
with 
PHP3.  You will need to upgrade to PHP4 in order to use phpPgAdmin.

Documentation needs to be updated as well.

-Dan

Quoting Gary Strauss <ga...@am...>:

: I installed and configured phpPgAdmin 2.4. When I try to access it in my
: browser I get the following:
:  
: Parse error: parse error in lib.inc.php on line 448
:  
: What am I overlooking?
:  
: Gary C. Strauss
: American Megacom Inc.
: Phone:  734.779.4826
: Mobile:  734.812.5592
: Fax:      734.464.8828
:  
: 

Re: [ppa-users] Parse error: parse error in lib.inc.php on line 448

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

What version of PHP are you running?  It looks like you are still running PHP3.

We made some changes in the latest release that breaks our compatibility with 
PHP3.  You will need to upgrade to PHP4 in order to use phpPgAdmin.

Documentation needs to be updated as well.

-Dan

Quoting Gary Strauss <ga...@am...>:

: I installed and configured phpPgAdmin 2.4. When I try to access it in my
: browser I get the following:
:  
: Parse error: parse error in lib.inc.php on line 448
:  
: What am I overlooking?
:  
: Gary C. Strauss
: American Megacom Inc.
: Phone:  734.779.4826
: Mobile:  734.812.5592
: Fax:      734.464.8828
:  
: 

[ppa-users] Parse error: parse error in lib.inc.php on line 448

[Gary S. <ga...@am...>]

I installed and configured phpPgAdmin 2.4. When I try to access it in my
browser I get the following:
 
Parse error: parse error in lib.inc.php on line 448
 
What am I overlooking?
 
Gary C. Strauss
American Megacom Inc.
Phone:  734.779.4826
Mobile:  734.812.5592
Fax:      734.464.8828
 

[ppa-users] WebPg 3.0 alpha no longer supported

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

Due to some design issues that were discovered in the WebPg 3.0 alpha code,
it has been decided that the phpPgAdmin team will no longer support this
alpha release.

We will however begin a re-write of phpPgAdmin.  The new version will
eventually have support for plug-in modules which will allow administration
of multiple types of database systems.  Initial support will only be for
PostgreSQL, but the infrastructure will exist for additional support.

We will continue to maintain and support the 2.x version of phpPgAdmin.

-Dan Wilson
phpPgAdmin Team

[ppa-users] phpPgAdmin 2.4 Release -- Enhances Security

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

phpPgAdmin 2.4 Release Enhances Security

The phpPgAdmin Development team is pleased to announce the release of
version 2.4. A major security issue was resolved with the implementation of
a new authorization scheme that places all security in the hands of
PostgreSQL itself.

In addition to security updates, the new version contains various bug fixes
and a few new minor features.

Download version 2.4 at http://sourceforge.net/projects/phppgadmin

About phpPgAdmin:
phpPgAdmin was originally a port from phpMyAdmin. The PostgreSQL feature set
pushed the development of phpPgAdmin into different areas of administration
of the DBMS. phpPgAdmin now includes the ability to administer not only
tables, but triggers, functions (stored procedures), views, operators,
indices, and sequences.

Additional features provide user and group administration, multiple servers
support as well as other critical features such as browsing table data,
editing and deleting rows, primary and unique key administration and a
reports utility to keep your most commonly used queries handy.

-Dan Wilson
and the phpPgAdmin Development Team

[ppa-users] Re: Online Contact Form

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

JC,

Your first issue will not be resolved in the current code branch, however, we 
are eliminating the left-hand nav in the 3.x branch.

The second issue needs more consideration.  Can give more details?  Just 
telling us it doesn't work doesn't help much.  Please indicate the steps you 
are taking to determine that it doesn't work.

Hint: When connecting to a remote db.... the usual mistake is not editing the 
remote pg_hba.conf to allow access from the phpPgAdmin (web server) IP.

-Dan

Quoting jc <jc...@nu...>:
: hi,
: 
: i have 2 problems with the latest version of phppgadmin :
: the dbs do not expand under mozilla 
: 
: it does not work with a remote db 
: 
: Sent via Contact Form on phppgadmin.sourceforge.net

[ppa-users] Re: como configurar?

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

I do not know Portuguese, so I cannot help you.  I have forwarded this to
the mailing list however and so hopefully someone can help you.

-Dan


----- Original Message -----
From: "Aloisio J=FAnior." <al...@wi...>
To: <php...@ac...>
Sent: Friday, December 21, 2001 11:01 AM
Subject: como configurar?


    Ol=E1,

   eu sou novo na programa=E7=E3o e n=E3o estou consseguindo usar o phpga=
dimin com
o apache, vc pode me ajudar como configurar config.inc.php para usar com =
o
pache?

Obrigado.

[ppa-users] Security Enhanced phpPgAdmin 2.4-beta-1

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

Sorry about the slow posting of this to the list...

Available for immediate download, the first beta of phpPgAdmin 2.4 contains
a few minor bug fixes and one major new feature. Enhancing security,
phpPgAdmin no longer requires a username and password contained in the
configuration file.

However, due to differences in system configurations, this new feature
requires wide-spread testing. Please help us out by downloading the new
version (be sure to copy the new config.inc.php-dist to config.inc.php) and
test the new authentication scheme with your configuration.

http://sourceforge.net/project/showfiles.php?group_id=37132

-Dan Wilson (and Team)
phpPgAdmin Development

Re: [ppa-users] Cannot login

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

Chris,

That looks like it should be fine.  I can't really show you my directives,
because I have those setting server-wide.

Are you getting an error?  If you are not getting an error, have you looked
at the bug that was reported in that forum?

If you give me more information, I can help a lot better.

-Dan


: Dear Dan,
:
: Can you show me your php config by phpinfo (Directive only)?
:
: I am not sure if the following directive is enough.
:
: php_flag php_magic_quotes_gpc on
: php_flag register_globals on
:
: Regards,
: Chris
:
:
: > -----Original Message-----
: > From: Dan Wilson [mailto:kil...@us...]
: > Sent: Tuesday, November 13, 2001 11:26 PM
: > To: Chris Lee; php...@li...
: > Subject: Re: [ppa-users] Cannot login
: >
: >
: > What error are you getting?  Is this v 2.3 or 2.3.1?  If it's
: > the latter,
: > there was a problem in the config file that would make it so
: > you couldn't
: > login under certain configurations.
: >
: > You can view the Help forum
: > [https://sourceforge.net/forum/forum.php?thread_id=153995&foru
: > m_id=115884]
: > to determine if this is the same as your problem or not.
: >
: > -Dan
: >
: > : Dear Sir,
: > :
: > : Just d/l and install v2.3 and cannot login.
: > :
: > : I already follow INSTALL doc and insert the php_flag
: > php_magic_quotes_gpc
: > on
: > : in httpd.conf, but still don't work.
: > :
: > : <VirtualHost 10.1.10.202>
: > : DocumentRoot /home/www/cch/beta/htdocs
: > : ServerName beta.cch.com.hk
: > : ErrorLog /var/log/apache/cch/beta/error_log
: > : LogFormat "combined"
: > : CustomLog /var/log/apache/cch/beta/access_log "combined"
: > : <Directory "/phpPgAdmin">
: > : php_flag php_magic_quotes_gpc on
: > : php_flag register_globals on
: > : </Directory>
: > : </VirtualHost>
: > :
: > : Did I make something wrong?
: > :
: > : ---
: > : Regards,
: > : Chris Lee
: > : Assistant MIS Manager
: > : Century City Holdings Limited
: > :
: > :
: > : _______________________________________________
: > : phpPgAdmin-users mailing list
: > : php...@li...
: > : https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
: > :
: >
:

[ppa-users] Cannot login

[Chris L. <Chr...@ce...>]

Dear Sir,

Just d/l and install v2.3 and cannot login.

I already follow INSTALL doc and insert the php_flag php_magic_quotes_gpc on
in httpd.conf, but still don't work.

<VirtualHost 10.1.10.202>
DocumentRoot /home/www/cch/beta/htdocs
ServerName beta.cch.com.hk
ErrorLog /var/log/apache/cch/beta/error_log
LogFormat "combined"
CustomLog /var/log/apache/cch/beta/access_log "combined"
<Directory "/phpPgAdmin">
php_flag php_magic_quotes_gpc on
php_flag register_globals on
</Directory>
</VirtualHost>

Did I make something wrong? 

---
Regards,
Chris Lee
Assistant MIS Manager
Century City Holdings Limited

Re: [ppa-users] Insert Line in Table with enpty fields: -> Parser Error

[Christian S. <ch...@ar...>]

Yes, that's it!
Thank you for helping,

		Christian


On Wed, 31 Oct 2001, Dan Wilson wrote:

> I just fixed this bug in the 2.4-dev code.  It is available in the cvs, you
> can wait for the next release or you can make the following change:
> 
> tbl_replace.php - line 33 -- should be the following now:
>    if (eregi("char|date|bool|time|inet", $field_type[$key])) {
> 
> (just add "inet" to the list of column types)
> 
> -Dan
> 
> 
> 
> : Hi,
> : aha, the problem is that if you have a field from type INET and you dont't
> : put a value in it, pgpPgAdmin shows a parse-Error.
> :
> : The solution to the problem is, that I'm writing NULL in it. So it is like
> : empty. Hence the next step was, that i extend the INET-fields with DEFAULT
> : NULL so I don't have to type it every time when i insert data in a line.
> : Hmm, but DEFAULT NULL don't make sense and is not stored in a dumpfile.
> :
> : So I have to type NULL in every empty INET-field when I insert data.
> : But I think this is a phpPgAdmin-problem, because the frontend WEBMIN
> : doen't show this problem. (of course, it has other disadvantages.)
> :
> : Regards,
> :
> : Chris
> :
> :
> :
> :
> : On Mon, 29 Oct 2001, Dan Wilson wrote:
> :
> : > Whether you can insert a null into a field depends on whether the column
> is
> : > defined as NOT NULL or not.
> : >
> : > The error that you are getting doesn't look like a NULL value problem
> : > though.  Postgres is seeing a parse error....though I can't see a syntax
> : > error.  Is this your exact query?
> : >
> : > If not, show us your exact query and we might be able to figure it out.
> : >
> : > -Dan
> : >
> : > : Hi,
> : > : i am new and I hope I am right here.
> : > :
> : > : Is it possible to insert a line to a table, which has some empty
> fields ?
> : > : (e.g INSERT INTO "db" ("name", "adress") VALUES ('hugo', '');
> : > : phpPgAdmin says   ERROR: could not parse  ""
> : > : "" ... are the empty fields, but why is here a parse error ?
> : > : Do I have to fill up every fild ? (it is NOT declared as "not null")
> : > :
> : > : Is there a solution to my problem ?
> : > :
> : > : Thanks for you help,
> : > :
> : > : Christian
> : > :
> : > :
> : > :
> : > : _______________________________________________
> : > : phpPgAdmin-users mailing list
> : > : php...@li...
> : > : https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> : > :
> : >
> :
> :
> : _______________________________________________
> : phpPgAdmin-users mailing list
> : php...@li...
> : https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> :
> 
> 
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> 

Re: [ppa-users] Strange stuff...

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

Correct...  in order to have postgres actually verify your password, you
must change your pg_hba.conf file to check it.  By default, if you are
connecting through the local unix socket, it automatically trusts the user.
You can either change your config file to not be a local connection
[$cfgServer[1][local] = false] or you can change your pg_hba.conf file to
require a password through the local connection (which could cause problems
when doing pg_dump[all] stuff on the comand-line).

pg_hba.conf details:
http://www.us.postgresql.org/users-lounge/docs/7.1/admin/client-authenticati
on.html#PG-HBA.CONF

-Dan


: revise your pg_hba.conf
:
: /sak
:
: ----- Original Message -----
: From: "Stephen" <web...@we...>
:
: > It doesn't matter what I put in the stdpass line. I can put 'asdf' and
: when I
: > log in it doesn't matter what pass I use either, it logs me in. It
doesn't
: work
: > at all if I leave the stdpass line blank.
: > Any thoughts?
:
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
:

Re: [ppa-users] postgres user is not listed

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

The postgres user is filtered out (we should probably make this a config
setting).

There are a few ways you can fix this... you can search through
user_admin.php and remove and reference to $cfgSuperUser.  You should
probably go through tbl_priviledge.php and db_privilege.php as well and
remove $cfgSuperUser in those files as well.

Please submit a Feature Request so we can keep track of this and implement
it in the future....
https://sourceforge.net/tracker/?func=add&group_id=37132&atid=418983

-Dan

: Hi everybody,
: I was using phpPgAdmin for quite a while and it seems to work great.
: However, a couple of days ago I restored my pg database instance from a
: dump file and it screwed up user permissions on some tables.
: Right now, user postgres has permissions on some tables and is not
: listed in Privileges in other tables. When I go to User Admin, postgres
: is NOT listed there, however, this user is present in pg_user table!!!
: I want to have user postgres granted permissions on all the tables in
: the database, but I can't add it to the Privileges list, because
: phpPgAdmin doesn't see it for some reason.
: Please help.
: thanks,
:
: Oleg
:
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
:

Re: [ppa-users] stdpass in 2.3.1

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

Can you give us details on your specific configuration?

All cfgServer settings and your version on PHP and Postgres should do it.

-Dan


: It seems I can't get a connection to the server without the stdpass line
in
: config.inc.php in v. 2.3.1
:
: Works fine now that I added it.
:
: Regards,
: Stephen
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
:

[ppa-users] postgres user is not listed

[Oleg L. <ole...@wa...>]

Hi everybody,
I was using phpPgAdmin for quite a while and it seems to work great.
However, a couple of days ago I restored my pg database instance from a
dump file and it screwed up user permissions on some tables.
Right now, user postgres has permissions on some tables and is not
listed in Privileges in other tables. When I go to User Admin, postgres
is NOT listed there, however, this user is present in pg_user table!!!
I want to have user postgres granted permissions on all the tables in
the database, but I can't add it to the Privileges list, because
phpPgAdmin doesn't see it for some reason.
Please help.
thanks,

Oleg