phppgadmin-users — General phpPgAdmin topics for all user

Re: [ppa-users] random page errors and table errata

[Ben M. <bm...@sy...>]

Thanks for the quick reply.

I was just in the php.ini file looking for anything that was out of
place.

register_globals=3DOn

no sign of that variable in httpd.conf or .htaccess
I checked apache was using the php 4 module.

Any other quick thoughts would be great.=20

Ben

On Tue, May 07, 2002 at 11:57:58PM -0600, Dan Wilson wrote:
> This looks like an issue of register_globals being off.  Currently, phpPg=
Admin=20
> requires register_globals to be turned on.
>=20
> You can do this through php.ini, an apache directive in either the httpd.=
conf=20
> or a .htaccess file.
>=20
> Check the php site for instructions on setting this directive:=20
> http://www.php.net/manual/en/configuration.php#configuration.file
>=20
> -Dan
>=20
> Quoting Ben Moir <bm...@sy...>:
>=20
> > Hi folks,
> >=20
> > Don't see much activity on this list so not sure if anyone is out there.
> >=20
> > I recently installed phpPgAdmin 2.4-1
> > PostgreSQL 7.1.3
> > PHP 4.2
> > on a Redhat 7.2 (apache RPM)
> >=20
> > After a few hours battling with the login problems that other users see=
m to
> > be
> > having I got access to the database.=20
> > NOTE: I had to use adv_auth=3Dfalse or the login screen would reload wi=
th
> > no errors or explaination.
> >=20
> >=20
> > Now my joy disappeared quickly when I found errors on most pages.
> >=20
> > I couldn't create a table using the phpPgAdmin interface. Nothing seemed
> > to happen.
> >=20
> > Created a table on the command line.
> >=20
> > then in the phpPgAdmin when I click table>browse I get the following
> > error:
> >=20
> > Warning: Failed opening '' for inclusion
> > (include_path=3D'.:/usr/local/lib/php') in
> > /home/bmoir/public_html/phpPgAdmin/sql.php on line 130
> >=20
> >=20
> > If I try and insert into the new table I get this error:
> >=20
> > Error - /home/bmoir/public_html/phpPgAdmin/tbl_form.inc.php -- Line: 47
> > PostgreSQL said: ERROR: zero-length delimited identifier
> > Your query:
> > SELECT * FROM "" LIMIT 1
> > Back=20
> > Link: Resource id #1
> > DB: bmoir
> > Table:
> > Server: 1
> >=20
> >=20
> > It seems like the links are incorrect or there is something seriously
> > wrong with my php engine.
> >=20
> > Any ideas.
> > One theory is apache is using php3 to run .php files. how can I tell
> > which php version the interface is running on?
> >=20
> > Ben
> >=20
> > --=20
> >=20
>=20
>=20
>=20
>=20
> _______________________________________________________________
>=20
> Have big pipes? SourceForge.net is looking for download mirrors. We supply
> the hardware. You get the recognition. Email Us: ban...@so...
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users

--=20

Re: [ppa-users] random page errors and table errata

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

This looks like an issue of register_globals being off.  Currently, phpPgAdmin 
requires register_globals to be turned on.

You can do this through php.ini, an apache directive in either the httpd.conf 
or a .htaccess file.

Check the php site for instructions on setting this directive: 
http://www.php.net/manual/en/configuration.php#configuration.file

-Dan

Quoting Ben Moir <bm...@sy...>:

> Hi folks,
> 
> Don't see much activity on this list so not sure if anyone is out there.
> 
> I recently installed phpPgAdmin 2.4-1
> PostgreSQL 7.1.3
> PHP 4.2
> on a Redhat 7.2 (apache RPM)
> 
> After a few hours battling with the login problems that other users seem to
> be
> having I got access to the database. 
> NOTE: I had to use adv_auth=false or the login screen would reload with
> no errors or explaination.
> 
> 
> Now my joy disappeared quickly when I found errors on most pages.
> 
> I couldn't create a table using the phpPgAdmin interface. Nothing seemed
> to happen.
> 
> Created a table on the command line.
> 
> then in the phpPgAdmin when I click table>browse I get the following
> error:
> 
> Warning: Failed opening '' for inclusion
> (include_path='.:/usr/local/lib/php') in
> /home/bmoir/public_html/phpPgAdmin/sql.php on line 130
> 
> 
> If I try and insert into the new table I get this error:
> 
> Error - /home/bmoir/public_html/phpPgAdmin/tbl_form.inc.php -- Line: 47
> PostgreSQL said: ERROR: zero-length delimited identifier
> Your query:
> SELECT * FROM "" LIMIT 1
> Back 
> Link: Resource id #1
> DB: bmoir
> Table:
> Server: 1
> 
> 
> It seems like the links are incorrect or there is something seriously
> wrong with my php engine.
> 
> Any ideas.
> One theory is apache is using php3 to run .php files. how can I tell
> which php version the interface is running on?
> 
> Ben
> 
> -- 
> 

[ppa-users] random page errors and table errata

[Ben M. <bm...@sy...>]

Hi folks,

Don't see much activity on this list so not sure if anyone is out there.

I recently installed phpPgAdmin 2.4-1
PostgreSQL 7.1.3
PHP 4.2
on a Redhat 7.2 (apache RPM)

After a few hours battling with the login problems that other users seem to=
 be
having I got access to the database.=20
NOTE: I had to use adv_auth=3Dfalse or the login screen would reload with
no errors or explaination.


Now my joy disappeared quickly when I found errors on most pages.

I couldn't create a table using the phpPgAdmin interface. Nothing seemed
to happen.

Created a table on the command line.

then in the phpPgAdmin when I click table>browse I get the following
error:

Warning: Failed opening '' for inclusion (include_path=3D'.:/usr/local/lib/=
php') in /home/bmoir/public_html/phpPgAdmin/sql.php on line 130


If I try and insert into the new table I get this error:

Error - /home/bmoir/public_html/phpPgAdmin/tbl_form.inc.php -- Line: 47
PostgreSQL said: ERROR: zero-length delimited identifier
Your query:
SELECT * FROM "" LIMIT 1
Back=20
Link: Resource id #1
DB: bmoir
Table:
Server: 1


It seems like the links are incorrect or there is something seriously
wrong with my php engine.

Any ideas.
One theory is apache is using php3 to run .php files. how can I tell
which php version the interface is running on?

Ben

--=20

Re: [ppa-users] Future plans

[Francisco R. <li...@na...>]

On Tue, 9 Apr 2002, Dan Wilson wrote:

> I may have mis-understood what you were requesting.

Probably I didn't explain it well either.

>Were you wanting to simply read documentation on the new version,

Not documentation but whatever thoughts, emails, plans there are.


>or did you want developer access to the cvs?

No.


> If it's the documentation, we can't help you... there isn't much information
> regaurding the new version other than some emails intersperced in the -devel
> mailing list.

So does that mean that the new version is not actively been worked on?
What I had hoped for was to join the analysis phase of the new version and
be involved in the planning.

> If you want developer access to the cvs, then I would hope that all projects
> require some type of evidence that you are a capable developer before allowing
> access into the cvs.

Of course.

> This is a completely normal and sane requirement prior
> to allowing developer access.

Agree.

>I don't think I've ever been part of an open-
>source project where some type of contribution to the product was the key to
>being granted access into the code.

I think we had a communication problem. I totally agree with your stance
on access to CVS. However, I was not referring to that.

> If you have something to contribute to the project or have a list of other
> projects in which you have been involved, then we would be happy to have you
> aboard.  But until we know that, there is no real point.

I don't particularly want/care about CVS access. If I have something to
contribute I will post it on the list or on a web page. If and when I
produce so much code that it is too much work for others to commit it then
I will probably be given CVS access whether I want it or not. :-)

I guess I should join the development list.
How about creating a statement of what is desired of a new version?

Re: [ppa-users] Future plans

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

Francisco,

I may have mis-understood what you were requesting.  Were you wanting to 
simply read documentation on the new version, or did you want developer access 
to the cvs?

If it's the documentation, we can't help you... there isn't much information 
regaurding the new version other than some emails intersperced in the -devel 
mailing list.

If you want developer access to the cvs, then I would hope that all projects 
require some type of evidence that you are a capable developer before allowing 
access into the cvs.  This is a completely normal and sane requirement prior 
to allowing developer access.  I don't think I've ever been part of an open-
source project where some type of contribution to the product was the key to 
being granted access into the code.

If you have something to contribute to the project or have a list of other 
projects in which you have been involved, then we would be happy to have you 
aboard.  But until we know that, there is no real point.

-Dan

Quoting Francisco Reyes <li...@na...>:

> On Mon, 8 Apr 2002, Dan Wilson wrote:
> 
> > Nope... it's not being developed by just one individual...  If you want
> to
> > help, we really need some kind of evidence that you will benefit the
> team.

> This is a very strange way to "invite" people to join your project.
> Given your "selectivity" I guess I am better off forking the source and
> doing my own thing or simply doing a new project from scratch.
> 
> It is your project so you can do whatever you want with it, however I find
> it very strange that you would not let people subscribe/read only to your
> development list and that you would ask for people to prove their "worth"
> before letting them give you any input.
> 
> Wish you best of luck with your project. I already saw enough of your
> management style to not want to be part of this.
> 
> 

Re: [ppa-users] Future plans

[Francisco R. <li...@na...>]

On Mon, 8 Apr 2002, Dan Wilson wrote:

> Nope... it's not being developed by just one individual...  If you want to
> help, we really need some kind of evidence that you will benefit the team.


This is a very strange way to "invite" people to join your project.
Given your "selectivity" I guess I am better off forking the source and
doing my own thing or simply doing a new project from scratch.

It is your project so you can do whatever you want with it, however I find
it very strange that you would not let people subscribe/read only to your
development list and that you would ask for people to prove their "worth"
before letting them give you any input.

Wish you best of luck with your project. I already saw enough of your
management style to not want to be part of this.

[ppa-users] Fw: myPGadmin problems

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

Vikas,

These types of questions need to go to the mailing list
[php...@li...].

-Dan

----- Original Message -----
From: "Vikas Madhavan Alathur" <vm...@em...>
To: <kil...@us...>
Sent: Sunday, April 07, 2002 8:45 AM
Subject: myPGadmin problems


: Hi Dan,
:
: I use postgresql-6.5.3-26 running on a Debian 2.2r4
:
: After untarring the contents to /var/www, I tried to
: look at the homepage. There I get a login screen. I
: enter "root" and the corresponding password and I get
: "Wrong username/password. Access denied." error.
:
: I try psql -u, and enter username (root) and password,
: and everything works fine.
:
: Here is some data:
:
: ---------
: /etc/postgresql/pg_hba.conf
:
: local        all password
: host         all         127.0.0.1     255.255.255.255 password
: ---------
:
: No luck with "password" replaced by "trust"
:
: --------------
: config.inc.php
:
:
: $cfgServers[1]['local']         = false;
: $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
: ---------------
:
: What will I need to do?
:
: I find postgresql a lot more complicated than mysql
: mainly due to lack of good newbie documentation.
:
: Thanks,
: Vikas.
:
:
:
:
:

Re: [ppa-users] Future plans

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

: On Thu, 4 Apr 2002, Dan Wilson wrote:
:
: > Currently, there is no public information regarding version 3.  You will
: > just have to wait for more information as it is released.
: >
: > : I read on the web site about a planned Version 3.
: > : Where can I read up on the plans?
:
: I was hoping to see what were the plans and possibly help.
: Does it mean that this is been done by ONE individual?
: If it is a team, how would one go about joining?

Nope... it's not being developed by just one individual...  If you want to
help, we really need some kind of evidence that you will benefit the team.

Some type of patch of something for the current version of phpPgAdmin or if
you are a sourceforge member, perhaps you are involved with other projects.

-Dan

Re: [ppa-users] Future plans

[Francisco R. <li...@na...>]

On Thu, 4 Apr 2002, Dan Wilson wrote:

> Currently, there is no public information regarding version 3.  You will
> just have to wait for more information as it is released.
>
> : I read on the web site about a planned Version 3.
> : Where can I read up on the plans?

I was hoping to see what were the plans and possibly help.
Does it mean that this is been done by ONE individual?
If it is a team, how would one go about joining?

Re: [ppa-users] Future plans

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

Currently, there is no public information regarding version 3.  You will
just have to wait for more information as it is released.

-Dan

: I read on the web site about a planned Version 3.
: Where can I read up on the plans?
:

[ppa-users] Future plans

[Francisco R. <li...@na...>]

I read on the web site about a planned Version 3.
Where can I read up on the plans?

Re: [ppa-users] Php-4.1.1 and phpPgAdmin-2.4.1

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

This is a known bug that just hasn't been fixed yet.

Could you submit a bug report on sourceforge?

Thanks,
-Dan

Quoting Joseph Rajkumar <raj...@te...>:

> Hi Folks
> 
> 	When editing a row and then saving it
> I get a message like this.
> 
> 	It is trying to do file_exist() on line
> 79 in tbl_replace.pl, where $goto is actually 
> a query
> =============================================================
> Warning: stat failed for
> ./sql.php?server=1&db=balletpetite&pos=0&sql_query=SELECT+%22location_id%22%
2C+%22location_name%22%2C+%22st_addr1%22%2C+%22st_addr2%22%2C+%22city%22%2C+%
22state%22%2C+%22notes%22+FROM+%22location%22&sql_order=+ORDER+BY+%
22location_id%22+ASC&table=location&goto=db_details.php
> (errno=36 - File name too long) in
> /home/jrajkumar/phpPgAdmin/tbl_replace.php
> on line 79
> 
> Warning: Cannot add header information - headers already sent by (output
> started at
> /home/jrajkumar/phpPgAdmin/tbl_replace.php:79) in
> /home/jrajkumar/phpPgAdmin/tbl_replace.php on line 84
> ============================================================
> 
> Regards
> Joseph Rajkumar
> 
> -- 
> email: raj...@te...
> 
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> 

Re: [ppa-users] security hole

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

This depends on how you've setup your security.  The default security that is 
setup on postgres could cause problems in phpPgAdmin if you aren't careful.

If you have setup phpPgAdmin to connect through the local connection (rather 
than TCP), then most likely you have a security hole.  

The default authentication does not require a password... it's set to "trust" 
if it's through the local connection, so all they need is a valid username.  
Which of course almost all pgsql installs have the postgres account as a 
superuser.

There's your hole.... to fix it, you should either connect through the tcp 
connection (by indicating a host and switching local to false in your 
config.inc.php) or change your pg_hba.conf file to not use the "trust" 
authentication.

A couple things to keep in mind: 

1. In order to connect through tcp, you must start your postmaster with the -i 
option.  
2. If you change your pg_hba.conf authentication from trust on a local 
connection, you will run into problems when doing a pg_dumpall.

-Dan

Quoting web...@lo...:

> Hi, 
> Is there a known security hole. I seem to have a growing number of users in
> my 
> user admin list. Some with createdb priveleges. Is the breach here?
> 
> Thanks,
> Great Tool.
> 
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> 

Re: [ppa-users] adv_auth config question

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

This is actually a problem on the postgres side of things...  

First off... postgres does not allow you to setup permissions on databases 
themselves... only the objects within the database (tables, views, etc).  So 
there are no permissions directly attached to the database other than those 
associated with who is the owner/creator of the database.

You probably have your pg_hba.conf file set with "sameuser" authentication.  
This only allows the user to connect to a database with the same exact 
username with which they are logged in.  In addition, you have cfgUserDatabase 
set to true in phpPgAdmin's config.inc.php. This makes it so the databases 
listed on the left side will only be the databases that the user can connect 
to.

You can correct it by changing the phpPgAdmin setting, or by changing your 
authentication in pg_hba.conf.

-Dan

Quoting Andrew Neuschwander <an...@nt...>:

> Using adv_auth, I can't get databases which are not owned by a user to show
> 
> up on their menu even when they have privileges on that database.
> 
> I have a database owned by the postgres user. I then grant 
> select/update/insert privileges to a group. I then add several users to that
> 
> group. These users don't see the database. Does phpPgAdmin lack this
> ability?
> 
> Thanks in Advance,
> -Andrew
> -- 
> Andrew A. Neuschwander - an...@nt...
> UNIX/Linux Systems, NASA Science Compute Facility
> NTSG, School of Forestry, The University of Montana
> http://www.ntsg.umt.edu - (406) 243 - 6310
> 
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> 

[ppa-users] security hole

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

Hi, 
Is there a known security hole. I seem to have a growing number of users in my 
user admin list. Some with createdb priveleges. Is the breach here?

Thanks,
Great Tool.

[ppa-users] Php-4.1.1 and phpPgAdmin-2.4.1

[Joseph R. <raj...@te...>]

Hi Folks

	When editing a row and then saving it
I get a message like this.

	It is trying to do file_exist() on line
79 in tbl_replace.pl, where $goto is actually 
a query
=============================================================
Warning: stat failed for
./sql.php?server=1&db=balletpetite&pos=0&sql_query=SELECT+%22location_id%22%2C+%22location_name%22%2C+%22st_addr1%22%2C+%22st_addr2%22%2C+%22city%22%2C+%22state%22%2C+%22notes%22+FROM+%22location%22&sql_order=+ORDER+BY+%22location_id%22+ASC&table=location&goto=db_details.php
(errno=36 - File name too long) in
/home/jrajkumar/phpPgAdmin/tbl_replace.php
on line 79

Warning: Cannot add header information - headers already sent by (output
started at
/home/jrajkumar/phpPgAdmin/tbl_replace.php:79) in
/home/jrajkumar/phpPgAdmin/tbl_replace.php on line 84
============================================================

Regards
Joseph Rajkumar

-- 
email: raj...@te...

[ppa-users] adv_auth config question

[Andrew N. <an...@nt...>]

Using adv_auth, I can't get databases which are not owned by a user to show 
up on their menu even when they have privileges on that database.

I have a database owned by the postgres user. I then grant 
select/update/insert privileges to a group. I then add several users to that 
group. These users don't see the database. Does phpPgAdmin lack this ability?

Thanks in Advance,
-Andrew
-- 
Andrew A. Neuschwander - an...@nt...
UNIX/Linux Systems, NASA Science Compute Facility
NTSG, School of Forestry, The University of Montana
http://www.ntsg.umt.edu - (406) 243 - 6310

[ppa-users] Re: phpPgAdmin

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

If you are on PHP 4.1.x, use the following function at the top of the
lib.inc.php file.  It will fix your problem.

http://www.php.net/manual/en/function.import-request-variables.php

-Dan


: I just had minor issue with phpPgAdmin.  The server that i am using for
hosting had register_globals turned off in the configs.  This seems to cause
problems with variables.  I am in process on trying to track down all
variables to correct this problem.  I could send you the changed code if you
like when finished, but i am sure you are alot more famliar with the code
than i am so probably be easier for you change this as well.  Just a minor
suggestion nothing important.
:
: Dennis Mangini

[ppa-users] Re: Online Contact Form

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

Pam,

It looks like you haven't edited config.inc.php correctly.

Are you using adv_auth?  Also, which version of phpPgAdmin are you using?  

-Dan

Quoting Pam Wampler <pam...@ta...>:

> 
> I am trying to install & use PHPpgadmin.
> I am getting this error --What do I need to change?
> Thank you in advance for your time!
> 
> Warning: Unable to connect to PostgreSQL server: FATAL 1: user "password="
> does not exist in /usr/local/www/data.default/phpPgAdmin/lib.inc.php on line
> 196
> Error - /usr/local/www/data.default/phpPgAdmin/lib.inc.php -- Line: 224
> PostgreSQL said: Unable to connect to server
> 
> 
> 
> Sent via Contact Form on phppgadmin.sourceforge.net

[ppa-users] Re: Online Contact Form

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

This looks like the problem with we were having with the pgsql extension not
being installed correctly. Did you recompile PHP after you installed the new
pgsql? It is probably not finding the correct libraries.

To check this, remove the @ from before the $connect function call on (or
around) line #234 in lib.inc.php and try to login again.  It should give you
a detailed error or warning message.

You may need to recompile PHP so it can include the new versions of the
libraries.

If that doesn't work, send us the output from when you removed the @
(warning suppression).

-Dan


: Hi,
:
: I am using IE 5.5 to reach PHP 4.0.6 w/ register_globals=on on Apache
: 1.3.22. phpPgAdmin was working when I had PG 7.1.3 installed, but I
upgraded
: to 7.2 and now I get nothing. The login screen shows up but when I hit
: submit, it just goes to a blank page. No errors, just vanishes from the
: screen.
:
: Any ideas?
:
: Thanks.
: - Phil
:
:
: > -----Original Message-----
: > From: Dan Wilson [mailto:kil...@us...]
: > Sent: Sunday, February 24, 2002 10:51
: > To: Phil; ppa-users
: > Subject: Re: Online Contact Form
: >
: >
: > Could you give us more details?  What is the behavior you are
: > seeing?  Also,
: > what version of PHP are you running and on what server?
: >
: > We have verified that phpPgAdmin works with 7.2, however, PHP 4.1.1
comes
: > with register_globals set to off by default and that causes problems in
: > phpPgAdmin.
: >
: > Thanks,
: > -Dan
: >
: >
: > :
: > : I just installed PG 7.2 and phpPgAdmin doesn't work anymore. Is this a
: > known bug?
: > :
: > : Thanks.
: > :
: > : Sent via Contact Form on phppgadmin.sourceforge.net
: > :
: >
:

Re: [ppa-users] ".. ri_fkey_check_ins() does not exist."

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

: After setting up a 4 table database I attempted to recreate it on another
: postgresql installation.  To do this I ran the output of phpPgAdmin 2.4's
"View
: dump (schema) of database  Structure only" on the other postgresql dbms
(via the
: same phpPgAdmin installation) by using the "Run SQL query/queries on
database
: test ... location of textfile" functionality.
:
: The table creations worked fine until the final section was reached.  It
choked
: on the first command:
:
: CREATE CONSTRAINT TRIGGER RI_ConstraintTrigger_19979 AFTER INSERT OR
UPDATE ON
: queues NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE
: RI_FKey_check_ins ('<unnamed>', 'queues', 'titles', 'UNSPECIFIED', 'tid',
'tid');
:
: The error message is: "Error - /home/httpd/html/phpPgAdmin/sql.php --
Line: 112
: PostgreSQL said: ERROR:  CreateTrigger: function ri_fkey_check_ins() does
not
: exist."
:
: PostgreSQL's version is "PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled
by gcc
: 2.96" on both of my dbmses. My PHP version is "Linux 2.2.14-5.0 #1 Tue Mar
7
: 21:07:39 EST 2000 i686".  My linux is RedHat 7.1.
:
: I upgraded to phpPgAdmin 2.4a and reran both steps (sql file creation and
: execution). Outcome is the same. Might postgresql 7.0.3 just be missing
this
: function?  If yes, can i install that function w/o upgrading the whole
dbms?

This sure sounds like a version issue, but AFAIK, that function (used with
referential integrity -- foreign keys, etc) was part of the 7.0.3 release.
It's possible that it went through some changes that altered it's parameter
lists though.

This issue however, is not a phpPgAdmin issue, it is a postgresql issue and
should be addressed to the postgres-general list.  You might want to check
to see if you can dump the database through psql and import it with psql as
well.  If that works, then it might be a problem in phpPgAdmin which we need
to address.

But unless that is the case, you will probably get better support for this
issue in the -general mailing list.

: george
:
: p.s. In phpPgAdmin's db_details.php file, I had to delete the enctype
option to
: the FORM tag to get the browser to send any data to the "action" file. The
line
: was: <form method="POST" action="file_sql.php"
enctype="multipart/form-data">.
: This was with Opera 6.0 tp2. Mozilla 0.9.7 had no response at all to my
clicks
: on "Go".

You just removed the ability to upload dump files.  I'm not sure why Mozilla
and Opera had problems with the enctype.  I guess we need to look into this
issue.

: p.p.s. phpPgAdmin is Cool software.

Thanks...  we continually try to make it better.

-Dan

[ppa-users] ".. ri_fkey_check_ins() does not exist."

[George H. <gh...@sn...>]

After setting up a 4 table database I attempted to recreate it on another 
postgresql installation.  To do this I ran the output of phpPgAdmin 2.4's "View 
dump (schema) of database  Structure only" on the other postgresql dbms (via the 
same phpPgAdmin installation) by using the "Run SQL query/queries on database 
test ... location of textfile" functionality.

The table creations worked fine until the final section was reached.  It choked 
on the first command:

CREATE CONSTRAINT TRIGGER RI_ConstraintTrigger_19979 AFTER INSERT OR UPDATE ON 
queues NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE 
RI_FKey_check_ins ('<unnamed>', 'queues', 'titles', 'UNSPECIFIED', 'tid', 'tid');

The error message is: "Error - /home/httpd/html/phpPgAdmin/sql.php -- Line: 112
PostgreSQL said: ERROR:  CreateTrigger: function ri_fkey_check_ins() does not 
exist."

PostgreSQL's version is "PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 
2.96" on both of my dbmses. My PHP version is "Linux 2.2.14-5.0 #1 Tue Mar 7 
21:07:39 EST 2000 i686".  My linux is RedHat 7.1.

I upgraded to phpPgAdmin 2.4a and reran both steps (sql file creation and 
execution). Outcome is the same. Might postgresql 7.0.3 just be missing this 
function?  If yes, can i install that function w/o upgrading the whole dbms?

george

p.s. In phpPgAdmin's db_details.php file, I had to delete the enctype option to 
the FORM tag to get the browser to send any data to the "action" file. The line 
was: <form method="POST" action="file_sql.php" enctype="multipart/form-data">.
This was with Opera 6.0 tp2. Mozilla 0.9.7 had no response at all to my clicks 
on "Go".

p.p.s. phpPgAdmin is Cool software.

[ppa-users] Re: Online Contact Form

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

Could you give us more details?  What is the behavior you are seeing?  Also,
what version of PHP are you running and on what server?

We have verified that phpPgAdmin works with 7.2, however, PHP 4.1.1 comes
with register_globals set to off by default and that causes problems in
phpPgAdmin.

Thanks,
-Dan


:
: I just installed PG 7.2 and phpPgAdmin doesn't work anymore. Is this a
known bug?
:
: Thanks.
:
: Sent via Contact Form on phppgadmin.sourceforge.net
:

Re: [ppa-users] (no subject)

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

: On Wed, 20 Feb 2002, Dan Wilson wrote:
:
: > What is the result when they login?  Does it give an error or does it
just
: > not let them in?
:
: the result is that they see no databases at all
:
: >
: > 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.
:
: yes, database is created and owned by my user, not postgres
:
: shall I change?

Depends... when you men "my user" do you mean your super-user account, or
the user account which is having the permissions problem?

If it's the former, then yes, you need to change the owner of the db... with
the settings you have, in order for the user to see their database, they
have to be the owner.  The best way to do this is by logging in as the user
in question and create the database under their account.  You must give them
create_db permissions, but can remove them after the database is created.

-Dan

Re: [ppa-users] (no subject)

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

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

On Wed, 20 Feb 2002, Dan Wilson wrote:

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

the result is that they see no databases at all

>
> 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.

yes, database is created and owned by my user, not postgres

shall I change?


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

tcp 127.0.0.1, defaultport, crypt passwd

userdatab.=true

thanks for the help!

- -------------------------
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

iEYEARECAAYFAjx0oHMACgkQGp+ylEhMCIWP6ACgjw6Ysd1vAPL94Ma7WFnl5o2A
XTkAnR1KAwbdSynB6J8ElG8heMDLUqTr
=uO4f
-----END PGP SIGNATURE-----