phppgadmin-users — General phpPgAdmin topics for all user

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

[Sergio A. K. <ser...@ho...>]

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?

[ppa-users] Strange stuff...

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


Regards,
Stephen

[ppa-users] stdpass in 2.3.1

[Stephen <web...@we...>]

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

[ppa-users] Re: Problem in latest phpPgAdmin

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

Tedd,

Thanks for letting me know, however I do not encounter this bug.  Can you
give me more information....  versions (PHP mainly), OS, which file you
downloaded (tar/zip), and anything else you feel pertinent.

That would be helpful.

-Dan


: I love this program, and have been using it for
: over a year now.  The version you uploaded on
: October 30 (2.3.1) seems to have a problem when
: using advanced authentication.  There are two
: blank lines at the end of "config.inc.php" that
: cause a "cannot add to header, info already sent
: error."
:
: Erasing these blank lines fixes the problem.
:
: Thank you for your work on this project.  I'm glad
: to see it still going even after the economic
: shakeout.

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

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

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
:

Re: [ppa-users] getting phppgadmin working...at all

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

Ok... now you need to make sure your config settings are correct.

By the settings you indicated below, it looks like you need to set a couple
things first.

1. You need to be sure that your remote host is setup to accept connections
from your IP address.  This is done through the pg_hba.conf config file on
the remote server.  You can usually find it in your default postgresql data
directory ($PGDATA).  For details on the pg_hba.conf file, checkout:

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

2. You need to enter your port... even if it's the default port (5432), you
_must_ enter it in the config settings

3. You need to enter a username which has read-only access to the system
tables of your remote server (so just create any old user... they have this
access by default).  This should go in the stduser config setting.  You do
not need a password and this setting will be removed in the next release.
For information on creating a user:

http://www.postgresql.org/idocs/index.php?app-createuser.html
http://www.postgresql.org/idocs/index.php?sql-createuser.html

Once you get those items all set, you should be up and running.

-Dan


: Thanks Dan! I get a login page now.
: I still can\'t seem to connect, but I\'m working on it. I must be missing
: something. I don\'t quite have a grasp on the pgsql auth system yet. I\'m
really
: used to mysql\'s set up - different paradigm, totally.
:
: Thanks,
: Stephen
:
:
: Quoting Dan Wilson <kil...@us...>:
:
: > One of the first lines in lib.inc.php has a bug which affects
: > everything...
: >
: > Change:
: >
: > if (defined(\"LIB_INC\")) {
: >
: > to be:
: >
: > if (!defined(\"LIB_INC\")) {
: >
: > A new release should be coming soon with this bug corrected.
: >
: > -Dan
: >
: >
: >
: > : I don\\\'t know how busy this list is...but I\\\'m having trouble
: > getting
: > phppgadmin
: > : to work at all.
: > :
: > : Description:
: > :
: > : When I point my browser at <mydomain>/phpPgAdmin/index.php all I see
: > is
: > the two
: > : frames with the main frame containing four old links to the
: > greatbridge.org
: > : site and a link to postgresql.org.
: > :
: > : I assume this is the default if it doesn\\\'t get a connection to the
: > DB.
: > :
: > : In conf.inc.php I have:
: > :
: > : $cfgServers[1][\\\'local\\\']         = false;
: > : $cfgServers[1][\\\'host\\\']          = \\\'<myremotehost>\\\';
: > : $cfgServers[1][\\\'port\\\']          = \\\'\\\';
: > : $cfgServers[1][\\\'adv_auth\\\']      = true;
: > : $cfgServers[1][\\\'stduser\\\']       = \\\'\\\';
: > : $cfgServers[1][\\\'stdpass\\\']       = \\\'\\\';
: > : $cfgServers[1][\\\'user\\\']          = \\\'\\\';
: > : $cfgServers[1][\\\'password\\\']      = \\\'\\\';
: > : $cfgServers[1][\\\'only_db\\\']       = \\\'\\\';
: > :
: > : I\\\'ve tried putting \\\"postgres\\\" into the \\\'user\\\' field,
and I\\\'ve
: > put in
: > and taken
: > : out the \\\'port\\\' (default port).
: > :
: > : I\\\'ve made my own script that connect no problem:
: > :
: > : $connection = pg_connect(\\\"host=<myremotehost>
: > :                           dbname=test
: > :                           user=postgres
: > :                          \\\")
: > :         or die(\\\"Couldn\\\'t make connection.\\\");
: > :
: > : Please let me know how to get this working. This is a small step in a
: > huge
: > : project I\\\'m working on, and I don\\\'t want to set up the db server
on
: > the
: > command
: > : line, if I can avoid it.
: > :
: > : Thanks,
: > : Stephen
: > :
: > : _______________________________________________
: > : 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] Insert Line in Table with enpty fields: -> Parser Error

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

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

Re: [ppa-users] getting phppgadmin working...at all

[Stephen <web...@we...>]

Thanks Dan! I get a login page now.
I still can\'t seem to connect, but I\'m working on it. I must be missing 
something. I don\'t quite have a grasp on the pgsql auth system yet. I\'m really 
used to mysql\'s set up - different paradigm, totally.

Thanks,
Stephen


Quoting Dan Wilson <kil...@us...>:

> One of the first lines in lib.inc.php has a bug which affects
> everything...
> 
> Change:
> 
> if (defined(\"LIB_INC\")) {
> 
> to be:
> 
> if (!defined(\"LIB_INC\")) {
> 
> A new release should be coming soon with this bug corrected.
> 
> -Dan
> 
> 
> 
> : I don\\\'t know how busy this list is...but I\\\'m having trouble
> getting
> phppgadmin
> : to work at all.
> :
> : Description:
> :
> : When I point my browser at <mydomain>/phpPgAdmin/index.php all I see
> is
> the two
> : frames with the main frame containing four old links to the
> greatbridge.org
> : site and a link to postgresql.org.
> :
> : I assume this is the default if it doesn\\\'t get a connection to the
> DB.
> :
> : In conf.inc.php I have:
> :
> : $cfgServers[1][\\\'local\\\']         = false;
> : $cfgServers[1][\\\'host\\\']          = \\\'<myremotehost>\\\';
> : $cfgServers[1][\\\'port\\\']          = \\\'\\\';
> : $cfgServers[1][\\\'adv_auth\\\']      = true;
> : $cfgServers[1][\\\'stduser\\\']       = \\\'\\\';
> : $cfgServers[1][\\\'stdpass\\\']       = \\\'\\\';
> : $cfgServers[1][\\\'user\\\']          = \\\'\\\';
> : $cfgServers[1][\\\'password\\\']      = \\\'\\\';
> : $cfgServers[1][\\\'only_db\\\']       = \\\'\\\';
> :
> : I\\\'ve tried putting \\\"postgres\\\" into the \\\'user\\\' field, and I\\\'ve
> put in
> and taken
> : out the \\\'port\\\' (default port).
> :
> : I\\\'ve made my own script that connect no problem:
> :
> : $connection = pg_connect(\\\"host=<myremotehost>
> :                           dbname=test
> :                           user=postgres
> :                          \\\")
> :         or die(\\\"Couldn\\\'t make connection.\\\");
> :
> : Please let me know how to get this working. This is a small step in a
> huge
> : project I\\\'m working on, and I don\\\'t want to set up the db server on
> the
> command
> : line, if I can avoid it.
> :
> : Thanks,
> : Stephen
> :
> : _______________________________________________
> : 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] getting phppgadmin working...at all

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

One of the first lines in lib.inc.php has a bug which affects everything...

Change:

if (defined("LIB_INC")) {

to be:

if (!defined("LIB_INC")) {

A new release should be coming soon with this bug corrected.

-Dan



: I don\'t know how busy this list is...but I\'m having trouble getting
phppgadmin
: to work at all.
:
: Description:
:
: When I point my browser at <mydomain>/phpPgAdmin/index.php all I see is
the two
: frames with the main frame containing four old links to the
greatbridge.org
: site and a link to postgresql.org.
:
: I assume this is the default if it doesn\'t get a connection to the DB.
:
: In conf.inc.php I have:
:
: $cfgServers[1][\'local\']         = false;
: $cfgServers[1][\'host\']          = \'<myremotehost>\';
: $cfgServers[1][\'port\']          = \'\';
: $cfgServers[1][\'adv_auth\']      = true;
: $cfgServers[1][\'stduser\']       = \'\';
: $cfgServers[1][\'stdpass\']       = \'\';
: $cfgServers[1][\'user\']          = \'\';
: $cfgServers[1][\'password\']      = \'\';
: $cfgServers[1][\'only_db\']       = \'\';
:
: I\'ve tried putting \"postgres\" into the \'user\' field, and I\'ve put in
and taken
: out the \'port\' (default port).
:
: I\'ve made my own script that connect no problem:
:
: $connection = pg_connect(\"host=<myremotehost>
:                           dbname=test
:                           user=postgres
:                          \")
:         or die(\"Couldn\'t make connection.\");
:
: Please let me know how to get this working. This is a small step in a huge
: project I\'m working on, and I don\'t want to set up the db server on the
command
: line, if I can avoid it.
:
: Thanks,
: Stephen
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
:

[ppa-users] getting phppgadmin working...at all

[Stephen <web...@we...>]

I don\'t know how busy this list is...but I\'m having trouble getting phppgadmin 
to work at all.

Description:

When I point my browser at <mydomain>/phpPgAdmin/index.php all I see is the two 
frames with the main frame containing four old links to the greatbridge.org 
site and a link to postgresql.org.

I assume this is the default if it doesn\'t get a connection to the DB.

In conf.inc.php I have:

$cfgServers[1][\'local\']         = false;
$cfgServers[1][\'host\']          = \'<myremotehost>\';
$cfgServers[1][\'port\']          = \'\';
$cfgServers[1][\'adv_auth\']      = true;
$cfgServers[1][\'stduser\']       = \'\';
$cfgServers[1][\'stdpass\']       = \'\';
$cfgServers[1][\'user\']          = \'\';
$cfgServers[1][\'password\']      = \'\';
$cfgServers[1][\'only_db\']       = \'\'; 

I\'ve tried putting \"postgres\" into the \'user\' field, and I\'ve put in and taken 
out the \'port\' (default port).

I\'ve made my own script that connect no problem:

$connection = pg_connect(\"host=<myremotehost>
                          dbname=test
                          user=postgres
                         \")
        or die(\"Couldn\'t make connection.\");

Please let me know how to get this working. This is a small step in a huge 
project I\'m working on, and I don\'t want to set up the db server on the command 
line, if I can avoid it.

Thanks,
Stephen

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

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

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
:

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

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

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

Re: [ppa-users] reindex

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

On Jue 25 Oct 2001 21:59, Sergio A. Kessler wrote:
> it means that you should look at the code...
> (you already know php, so don't be lazy)

Nooo!!! It can't be!!!
For what the name says (reindex) I would suppose that it drops the index and 
then creates it again. But.....

> hi martin...   ;)

Hey, I'm on the ppa-lang list, if you want to help on the spanish version...

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

Re: [ppa-users] reindex

[Sergio A. K. <ser...@ho...>]

it means that you should look at the code...
(you already know php, so don't be lazy)

hi martin...   ;)

/sergio

----- Original Message -----
From: "Martín Marqués" <ma...@bu...>


> Well, if the mail gets to the right place (don't know where that place is)
> the cuestion is, what is the reindex option when I see the indexes on the
> webPg-cvs?
>
> Saludos... :-)
>
> --
> Porqué usar una base de datos relacional cualquiera,
> si podés usar PostgreSQL?

[ppa-users] reindex

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

Well, if the mail gets to the right place (don't know where that place is) 
the cuestion is, what is the reindex option when I see the indexes on the 
webPg-cvs?

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

Re: [ppa-users] problem getting started

[Sergio A. K. <ser...@ho...>]

you need the php-pgsql module...

/sak

----- Original Message -----
From: "Philipp Steinkrüger" <ph...@ob...>


> Zitiere "Sergio A. Kessler" <ser...@ho...>:
>
> > yup, 2.30 is broken...
> > (I've seen similar reports from others users)
>
> thanx. not it reports that pg_connect is unknown function. at least
> something :-). i am going to recompile if you dont tell me that
> there is a module or something around...
>
> thanx so far,
>
> regards,
> philipp

Re: [ppa-users] problem getting started

[Sergio A. K. <ser...@ho...>]

yup, 2.30 is broken...
(I've seen similar reports from others users)

install 2.21 and you will be fine, but I understand 2.21
has a security hole, so you may want to protect the
installation with a .htaccess file ...

[root@www sistemas]# cat .htaccess
Order deny,allow
Deny from All
Allow from 10.0.0.0/255.255.255.0
[root@www sistemas]#

I don't have time at the moment to investigate further,
this f* week come very complicated...

/sak

----- Original Message -----
From: "Philipp Steinkrüger" <ph...@ob...>


> Dear Users and Developers,
>
> i am having Problems getting started with phpPgAdmin. I am new
> to postgresql, though. I just installed the database with a Debian
> package an changed the port (debian starts the DB at 7200, i made it
> 5432 like i saw it in the manpage). I could connect using psql and
> i created a user and a database successfully. Now i wanted to set up
> phpPgAdmin, becaus i loved phpMyAdmin. The installation seemed to
> be very similar but when i try to start the admin with opera (or
> internet exploter - makes no diff) it just shows 4 lines in the
> right frame (Documentation,Mailinglist,Latest Code,....) and the left
> one is empty. There is no error message, even if i enable debug
> in the configfile. I am not sure if postgres is compiled in PHP (phpinfo
> does not show) but shouldnt it tell me that pg_connect is an unkown
> function ?
>
> Any help is appreciated...
>
> Best regards,
> Philipp Steinkrüger

[ppa-users] problem getting started

[<ph...@ob...>]

Dear Users and Developers,

i am having Problems getting started with phpPgAdmin. I am new
to postgresql, though. I just installed the database with a Debian
package an changed the port (debian starts the DB at 7200, i made it
5432 like i saw it in the manpage). I could connect using psql and
i created a user and a database successfully. Now i wanted to set up
phpPgAdmin, becaus i loved phpMyAdmin. The installation seemed to
be very similar but when i try to start the admin with opera (or
internet exploter - makes no diff) it just shows 4 lines in the
right frame (Documentation,Mailinglist,Latest Code,....) and the left
one is empty. There is no error message, even if i enable debug
in the configfile. I am not sure if postgres is compiled in PHP (phpinfo
does not show) but shouldnt it tell me that pg_connect is an unkown 
function ?

Any help is appreciated...

Best regards,
Philipp Steinkrüger

--------------
Philipp Steinkrüger
ste...@ob...
Technik Oberberg Online
Tel.: 02261 814240
Fax : 02261 814919
http://www.oberberg.net

[Phppgadmin-users] testing

[Sergio A. K. <ser...@ho...>]

testing, ignore please...