phppgadmin-users — General phpPgAdmin topics for all user

Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

So I remove the –i option from dbexport.php now it works

Old dbexport.php
// Build command for executing pg_dump.  '-i' means ignore version differences.
                $cmd = $exe . " -i";

New dbexport.php
// Build command for executing pg_dump.  '-i' means ignore version differences.
                $cmd = $exe . "";

On 8/17/16, 11:18 AM, "Wolf Schwurack" <wo...@ue...> wrote:

    Pg_dumpall for postgresql 9.5 invalid option –i  Getting this error in apache error.log
    
    [Wed Aug 17 11:15:57 2016] [error] [client 140.197.233.204] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/phppgadmin/classes/PluginManager.php on line 36, referer: https://webutil-pg.uen.org/phppgadmin/redirect.php?subject=server&server=pgdev-db.uen.org%3A5432%3Aallow
    /usr/lib/postgresql/9.5/bin/pg_dumpall: invalid option -- 'i'
    
    On 8/17/16, 11:00 AM, "Karl O. Pinc" <ko...@me...> wrote:
    
        On Wed, 17 Aug 2016 16:46:52 +0000
        Wolf Schwurack <wo...@ue...> wrote:
        
        > No resource limit issues during the export. No errors in syslog, It
        > just doesn’t work
        
        You looked at the webserver error logs and access logs?
        
        
        
        
        Karl <ko...@me...>
        Free Software:  "You don't pay back, you pay forward."
                         -- Robert A. Heinlein
        
    
    ------------------------------------------------------------------------------
    _______________________________________________
    phpPgAdmin-users mailing list
    php...@li...
    https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
    

Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

Pg_dumpall for postgresql 9.5 invalid option –i  Getting this error in apache error.log

[Wed Aug 17 11:15:57 2016] [error] [client 140.197.233.204] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/phppgadmin/classes/PluginManager.php on line 36, referer: https://webutil-pg.uen.org/phppgadmin/redirect.php?subject=server&server=pgdev-db.uen.org%3A5432%3Aallow
/usr/lib/postgresql/9.5/bin/pg_dumpall: invalid option -- 'i'

On 8/17/16, 11:00 AM, "Karl O. Pinc" <ko...@me...> wrote:

    On Wed, 17 Aug 2016 16:46:52 +0000
    Wolf Schwurack <wo...@ue...> wrote:
    
    > No resource limit issues during the export. No errors in syslog, It
    > just doesn’t work
    
    You looked at the webserver error logs and access logs?
    
    
    
    
    Karl <ko...@me...>
    Free Software:  "You don't pay back, you pay forward."
                     -- Robert A. Heinlein
    

Re: [ppa-users] Export fails

[Karl O. P. <ko...@me...>]

On Wed, 17 Aug 2016 16:46:52 +0000
Wolf Schwurack <wo...@ue...> wrote:

> No resource limit issues during the export. No errors in syslog, It
> just doesn’t work

You looked at the webserver error logs and access logs?




Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

No resource limit issues during the export. No errors in syslog, It just doesn’t work

Cpu(s):  0.0%us,  0.0%sy,  0.0%ni,98.5%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   1019392k total,   530968k used,   488424k free,   143964k buffers
Swap:  1046524k total,      280k used,  1046244k free,   147432k cached

On 8/17/16, 10:30 AM, "Karl O. Pinc" <ko...@me...> wrote:

    On Wed, 17 Aug 2016 15:16:03 +0000
    Wolf Schwurack <wo...@ue...> wrote:
    > 
    > From: Wolfgang Schwurack <wo...@ue...>
    > Date: Wednesday, August 17, 2016 at 8:11 AM
    > To: "php...@li..."
    > <php...@li...> Subject: Re: [ppa-users]
    > Export fails
    > 
    > So figure out that phpPgAdmin is looking at the path that installed
    > on the host that phpPgAdmin is installed on not the database host. I
    > installed postgresql 9.5 on the phpPgAdmin host. Now when I try to
    > export ad database I just get a blank screen. I checked the mailing
    > list said to check user’s permissions which the user I’m using has
    > superuser permissions. Anyone know why I’m getting a blank screen
    > when trying to export a database using phppgadmin?
    
    Look at your webserver logs.  Perhaps you're hitting a resource limit
    somewhere, like RAM allocated to php or something.
    
    Karl <ko...@me...>
    Free Software:  "You don't pay back, you pay forward."
                     -- Robert A. Heinlein
    

Re: [ppa-users] Export fails

[Karl O. P. <ko...@me...>]

On Wed, 17 Aug 2016 15:16:03 +0000
Wolf Schwurack <wo...@ue...> wrote:
> 
> From: Wolfgang Schwurack <wo...@ue...>
> Date: Wednesday, August 17, 2016 at 8:11 AM
> To: "php...@li..."
> <php...@li...> Subject: Re: [ppa-users]
> Export fails
> 
> So figure out that phpPgAdmin is looking at the path that installed
> on the host that phpPgAdmin is installed on not the database host. I
> installed postgresql 9.5 on the phpPgAdmin host. Now when I try to
> export ad database I just get a blank screen. I checked the mailing
> list said to check user’s permissions which the user I’m using has
> superuser permissions. Anyone know why I’m getting a blank screen
> when trying to export a database using phppgadmin?

Look at your webserver logs.  Perhaps you're hitting a resource limit
somewhere, like RAM allocated to php or something.

Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

I checked postgresql log file which show it is getting connections from web host when I executing ‘export’ from phppgadmin and from the command line. It doesn’t show any errors

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 9:16 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

I also tested pg_dumpall on the web host from the command line this works

$ /usr/lib/postgresql/9.5/bin/pg_dumpall -a -h pgdev-db -f all.sql

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 8:33 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

I tested pg_dump on phppgadmin host to database host using the command line which created the dump file but still fails using the web application.

$ /usr/lib/postgresql/9.5/bin/pg_dump -Ft -U wolf -h pgdev-db -d go -f go.sql

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 8:11 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

So figure out that phpPgAdmin is looking at the path that installed on the host that phpPgAdmin is installed on not the database host.
I installed postgresql 9.5 on the phpPgAdmin host. Now when I try to export ad database I just get a blank screen. I checked the mailing list said to check user’s permissions which the user I’m using has superuser permissions.
Anyone know why I’m getting a blank screen when trying to export a database using phppgadmin?

Thanks
Wolf

From: Wolfgang Schwurack <wo...@ue...>
Date: Tuesday, August 16, 2016 at 11:36 AM
To: "php...@li..." <php...@li...>
Subject: [ppa-users] Export fails

When I try export a database using phppgadmin 5.1 the export fails with

Export error: Failed to execute pg_dumpall (given path in your conf/config.inc.php : /usr/lib/postgresql/9.5/bin/pg_dumpall). Please, fix this path in your configuration and relax.

I have verified that the path is correct on the postgresql host and can be executed

postgres@pgdev-db:~$ which pg_dumpall
/usr/lib/postgresql/9.5/bin/pg_dumpall
postgres@pgdev-db:~$ ll /usr/lib/postgresql/9.5/bin/pg_dumpall
-rwxr-xr-x 1 postgres postgres 92K May 10 09:39 /usr/lib/postgresql/9.5/bin/pg_dumpall*

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wo...@ue...<mailto:wo...@ue...>

Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

I also tested pg_dumpall on the web host from the command line this works

$ /usr/lib/postgresql/9.5/bin/pg_dumpall -a -h pgdev-db -f all.sql

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 8:33 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

I tested pg_dump on phppgadmin host to database host using the command line which created the dump file but still fails using the web application.

$ /usr/lib/postgresql/9.5/bin/pg_dump -Ft -U wolf -h pgdev-db -d go -f go.sql

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 8:11 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

So figure out that phpPgAdmin is looking at the path that installed on the host that phpPgAdmin is installed on not the database host.
I installed postgresql 9.5 on the phpPgAdmin host. Now when I try to export ad database I just get a blank screen. I checked the mailing list said to check user’s permissions which the user I’m using has superuser permissions.
Anyone know why I’m getting a blank screen when trying to export a database using phppgadmin?

Thanks
Wolf

From: Wolfgang Schwurack <wo...@ue...>
Date: Tuesday, August 16, 2016 at 11:36 AM
To: "php...@li..." <php...@li...>
Subject: [ppa-users] Export fails

When I try export a database using phppgadmin 5.1 the export fails with

Export error: Failed to execute pg_dumpall (given path in your conf/config.inc.php : /usr/lib/postgresql/9.5/bin/pg_dumpall). Please, fix this path in your configuration and relax.

I have verified that the path is correct on the postgresql host and can be executed

postgres@pgdev-db:~$ which pg_dumpall
/usr/lib/postgresql/9.5/bin/pg_dumpall
postgres@pgdev-db:~$ ll /usr/lib/postgresql/9.5/bin/pg_dumpall
-rwxr-xr-x 1 postgres postgres 92K May 10 09:39 /usr/lib/postgresql/9.5/bin/pg_dumpall*

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wo...@ue...<mailto:wo...@ue...>

Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

I tested pg_dump on phppgadmin host to database host using the command line which created the dump file but still fails using the web application.

$ /usr/lib/postgresql/9.5/bin/pg_dump -Ft -U wolf -h pgdev-db -d go -f go.sql

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 8:11 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

So figure out that phpPgAdmin is looking at the path that installed on the host that phpPgAdmin is installed on not the database host.
I installed postgresql 9.5 on the phpPgAdmin host. Now when I try to export ad database I just get a blank screen. I checked the mailing list said to check user’s permissions which the user I’m using has superuser permissions.
Anyone know why I’m getting a blank screen when trying to export a database using phppgadmin?

Thanks
Wolf

From: Wolfgang Schwurack <wo...@ue...>
Date: Tuesday, August 16, 2016 at 11:36 AM
To: "php...@li..." <php...@li...>
Subject: [ppa-users] Export fails

When I try export a database using phppgadmin 5.1 the export fails with

Export error: Failed to execute pg_dumpall (given path in your conf/config.inc.php : /usr/lib/postgresql/9.5/bin/pg_dumpall). Please, fix this path in your configuration and relax.

I have verified that the path is correct on the postgresql host and can be executed

postgres@pgdev-db:~$ which pg_dumpall
/usr/lib/postgresql/9.5/bin/pg_dumpall
postgres@pgdev-db:~$ ll /usr/lib/postgresql/9.5/bin/pg_dumpall
-rwxr-xr-x 1 postgres postgres 92K May 10 09:39 /usr/lib/postgresql/9.5/bin/pg_dumpall*

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wo...@ue...<mailto:wo...@ue...>

Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

So figure out that phpPgAdmin is looking at the path that installed on the host that phpPgAdmin is installed on not the database host.
I installed postgresql 9.5 on the phpPgAdmin host. Now when I try to export ad database I just get a blank screen. I checked the mailing list said to check user’s permissions which the user I’m using has superuser permissions.
Anyone know why I’m getting a blank screen when trying to export a database using phppgadmin?

Thanks
Wolf

From: Wolfgang Schwurack <wo...@ue...>
Date: Tuesday, August 16, 2016 at 11:36 AM
To: "php...@li..." <php...@li...>
Subject: [ppa-users] Export fails

When I try export a database using phppgadmin 5.1 the export fails with

Export error: Failed to execute pg_dumpall (given path in your conf/config.inc.php : /usr/lib/postgresql/9.5/bin/pg_dumpall). Please, fix this path in your configuration and relax.

I have verified that the path is correct on the postgresql host and can be executed

postgres@pgdev-db:~$ which pg_dumpall
/usr/lib/postgresql/9.5/bin/pg_dumpall
postgres@pgdev-db:~$ ll /usr/lib/postgresql/9.5/bin/pg_dumpall
-rwxr-xr-x 1 postgres postgres 92K May 10 09:39 /usr/lib/postgresql/9.5/bin/pg_dumpall*

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wo...@ue...<mailto:wo...@ue...>

Re: [ppa-users] Export fails

[Karl O. P. <ko...@me...>]

On Tue, 16 Aug 2016 17:36:52 +0000
Wolf Schwurack <wo...@ue...> wrote:

> When I try export a database using phppgadmin 5.1 the export fails
> with
> 
> Export error: Failed to execute pg_dumpall (given path in your
> conf/config.inc.php : /usr/lib/postgresql/9.5/bin/pg_dumpall).
> Please, fix this path in your configuration and relax.
> 
> I have verified that the path is correct on the postgresql host and
> can be executed
> 
> postgres@pgdev-db:~$ which pg_dumpall
> /usr/lib/postgresql/9.5/bin/pg_dumpall
> postgres@pgdev-db:~$ ll /usr/lib/postgresql/9.5/bin/pg_dumpall
> -rwxr-xr-x 1 postgres postgres 92K May 10
> 09:39 /usr/lib/postgresql/9.5/bin/pg_dumpall*

Please check the mailing list archives for the answer.  I'm
pretty sure there is an answer already.



Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

[ppa-users] Export fails

[Wolf S. <wo...@ue...>]

When I try export a database using phppgadmin 5.1 the export fails with

Export error: Failed to execute pg_dumpall (given path in your conf/config.inc.php : /usr/lib/postgresql/9.5/bin/pg_dumpall). Please, fix this path in your configuration and relax.

I have verified that the path is correct on the postgresql host and can be executed

postgres@pgdev-db:~$ which pg_dumpall
/usr/lib/postgresql/9.5/bin/pg_dumpall
postgres@pgdev-db:~$ ll /usr/lib/postgresql/9.5/bin/pg_dumpall
-rwxr-xr-x 1 postgres postgres 92K May 10 09:39 /usr/lib/postgresql/9.5/bin/pg_dumpall*

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wo...@ue...<mailto:wo...@ue...>

[ppa-users] jquery.js permission

[<ad...@k6...>]

Is it right if I add an exception 
/etc/apache2/conf.d/phpPgAdmin.conf file, leaving closed 
directory "libraries"?

For older versions of Apache
<Directory/srv/www/htdocs/phpPgAdmin/libraries>
    Order allow, deny
    Deny from all
</Directory>
<Directory/srv/www/htdocs/phpPgAdmin/libraries/js>
    Order allow, deny
    Allow from all
</Directory>

For newer versions of apache 2.4 or higher
<Directory/srv/www/htdocs/phpPgAdmin/libraries>
Require all denied
</Directory>
<Directory/srv/www/htdocs/phpPgAdmin/libraries/js>
Require all granted
</Directory>

[ppa-users] (no subject)

[<ad...@k6...>]

Hi!
phppgadmin version 5.0 and 5.1. OpenSUSE 12.1 and 13.2.
I have a error strings in apache error.log
[authz_core:error] AH01630: client denied by server 
configuration: 
/srv/www/htdocs/phpPgAdmin/libraries/js/jquery.js, 
referer: http://addr.es/phpPgAdmin/
[authz_core:error] AH01630: client denied by server 
configuration: 
/srv/www/htdocs/phpPgAdmin/libraries/js/jquery.js, 
referer: http://addr.es/phpPgAdmin/intro.php
[authz_core:error] AH01630: client denied by server 
configuration: 
/srv/www/htdocs/phpPgAdmin/libraries/js/jquery.js, 
referer: http://addr.es/phpPgAdmin/browser.php

Because, by default, directory "libraries" is blocked in 
/etc/apache2/conf.d/phpPgAdmin.conf

<Directory /srv/www/htdocs/phpPgAdmin/libraries>
  Order allow,deny
  Deny from all
</Directory>

This access lock is correct?

Why directory "libraries" must be locked by default?

Re: [ppa-users] RES: RES: Error trying to do a Postgresql Export using phppgadmin interface

[Karl O. P. <ko...@me...>]

On Fri, 27 Mar 2015 20:37:36 -0300
"jovino Borret" <jo...@ue...> wrote:

> The problem is that I have to updated now php version, because newer
> versions don´t have safe mode option. Today I can´t let it in off
> mode because I will put de webserver in vulnerable state.

Well, safe_mode is a broken part of php's design, which is why
they got rid of it.  Upgrading to a version without safe_mode
will be about the same as turning safe_mode off in the
version of php you have.  You can turn safe_mode off in
various ways, in the webserver config, in php.ini, etc.
(There may or may not be other
bug/security fixes in an upgraded version of php, but that's another
matter.)


> Thanks again Karl.

You're welcome.



Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

[ppa-users] RES: RES: RES: Error trying to do a Postgresql Export using phppgadmin interface

[jovino B. <jo...@ue...>]

Karl: You are great! 

I have put safe mode off no php.ini, restarted httpd and backup function (pg_dump / pg_dumpall) worked fine.

The problem is that I have to updated now php version, because newer versions don´t
have safe mode option. Today I can´t let it in off mode because I will put de webserver
in vulnerable state.

I hope I will release backup function by phppgadmin as soon as possible.

Matter of fact, last wedsneday, I did a modification in php.ini (safe_mode_allowed_env_vars function),
because httpd didn´t let phppgadmin to work with some environmental variables with PG in front of, 
I mean at first.

I could´t realize that the problem was safe_mode option on.

Thanks again Karl.

 

-----Mensagem original-----
De: Karl O. Pinc [mailto:ko...@me...] 
Enviada em: sexta-feira, 27 de março de 2015 12:59
Para: jo...@ue...
Cc: php...@li...
Assunto: Re: [ppa-users] RES: RES: Error trying to do a Postgresql Export using phppgadmin interface

Do you have safe_mode enabled?  It can prevent program execution.

On Fri, 27 Mar 2015 12:14:21 -0300
"jovino Borret" <jo...@ue...> wrote:

> Hello Karl,
> 
>     Thank you very much for your prompt reply,
> 
>         Today I could understand that dbexport.php send error message 
> too when I try to command (by phppgadmin web interface) a backup of a 
> simple database.
>     In this case appears: 
> 
>               Export error: Failed to execute pg_dump (given path in 
> your conf/config.inc.php :
> /usr/bin/pg_dump). Please, fix this path in your configuration and 
> relog.
> 
> 	As I said yesterday, this /usr/bin/pg_dump command works fine in the 
> line command of Linux.
> 
> So, I am almost certain that there is no problem with /usr/bin/pg_dump 
> (or /pg_dumpall).
> 
> Thanks.
> 
> 
> 
>  
> 
> 
> -----Mensagem original-----
> De: Karl O. Pinc [mailto:ko...@me...] Enviada em: quinta-feira, 26 de 
> março de 2015 23:26
> Para: jo...@ue...
> Cc: php...@li...
> Assunto: Re: [ppa-users] RES: Error trying to do a Postgresql Export 
> using phppgadmin interface
> 
> On Thu, 26 Mar 2015 20:54:38 -0300
> "jovino Borret" <jo...@ue...> wrote:
> 
> >   So, phppgadmin shows, when I try to do a backup (with any options 
> > at the phppgadmin interface) :
> > 
> >             command is /usr/bin/pg_dumpall -i -a
> 
> Can you run the above command at the command line?
> 
> You tested that your webserver has a working pg_dump, but PPA is 
> executing pg_dumpall.  You need to see if pg_dumpall works on the 
> webserver.
> 
> (Or at least that's how I'd start.)
> 
> 
> 
> 
> Karl <ko...@me...>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> 
> ---
> Este email está limpo de vírus e malwares porque a proteção do avast!
> Antivírus está ativa. http://www.avast.com
> 
> 
> ----------------------------------------------------------------------
> -------- Dive into the World of Parallel Programming The Go Parallel 
> Website, sponsored by Intel and developed in partnership with Slashdot 
> Media, is your hub for all things parallel software development, from 
> weekly thought leadership blogs to news, videos, case studies, 
> tutorials and more. Take a look and join the conversation now.
> http://goparallel.sourceforge.net/
> _______________________________________________ phpPgAdmin-users 
> mailing list php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> 





Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein


---
Este email está limpo de vírus e malwares porque a proteção do avast! Antivírus está ativa.
http://www.avast.com

Re: [ppa-users] RES: RES: Error trying to do a Postgresql Export using phppgadmin interface

[Karl O. P. <ko...@me...>]

Do you have safe_mode enabled?  It can prevent
program execution.

On Fri, 27 Mar 2015 12:14:21 -0300
"jovino Borret" <jo...@ue...> wrote:

> Hello Karl,
> 
>     Thank you very much for your prompt reply,
> 
>         Today I could understand that dbexport.php send error message
> too when I try to command (by phppgadmin web interface) a backup of a
> simple database.
>     In this case appears: 
> 
>               Export error: Failed to execute pg_dump (given path in
> your conf/config.inc.php :
> /usr/bin/pg_dump). Please, fix this path in your configuration and
> relog.
> 
> 	As I said yesterday, this /usr/bin/pg_dump command works fine
> in the line command of Linux.
> 
> So, I am almost certain that there is no problem
> with /usr/bin/pg_dump (or /pg_dumpall).
> 
> Thanks.
> 
> 
> 
>  
> 
> 
> -----Mensagem original-----
> De: Karl O. Pinc [mailto:ko...@me...] 
> Enviada em: quinta-feira, 26 de março de 2015 23:26
> Para: jo...@ue...
> Cc: php...@li...
> Assunto: Re: [ppa-users] RES: Error trying to do a Postgresql Export
> using phppgadmin interface
> 
> On Thu, 26 Mar 2015 20:54:38 -0300
> "jovino Borret" <jo...@ue...> wrote:
> 
> >   So, phppgadmin shows, when I try to do a backup (with any options
> > at the phppgadmin interface) :
> > 
> >             command is /usr/bin/pg_dumpall -i -a
> 
> Can you run the above command at the command line?
> 
> You tested that your webserver has a working pg_dump, but PPA is
> executing pg_dumpall.  You need to see if pg_dumpall works on the
> webserver.
> 
> (Or at least that's how I'd start.)
> 
> 
> 
> 
> Karl <ko...@me...>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> 
> ---
> Este email está limpo de vírus e malwares porque a proteção do avast!
> Antivírus está ativa. http://www.avast.com
> 
> 
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media,
> is your hub for all things parallel software development, from weekly
> thought leadership blogs to news, videos, case studies, tutorials and
> more. Take a look and join the conversation now.
> http://goparallel.sourceforge.net/
> _______________________________________________ phpPgAdmin-users
> mailing list php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> 





Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

[ppa-users] RES: RES: Error trying to do a Postgresql Export using phppgadmin interface

[jovino B. <jo...@ue...>]

Hello Karl,

    Thank you very much for your prompt reply,

        Today I could understand that dbexport.php send error message too
    when I try to command (by phppgadmin web interface) a backup of a simple
database.
    In this case appears: 

              Export error: Failed to execute pg_dump (given path in your
conf/config.inc.php :
/usr/bin/pg_dump). Please, fix this path in your configuration and relog.

	As I said yesterday, this /usr/bin/pg_dump command works fine in the
line command of Linux.

So, I am almost certain that there is no problem with /usr/bin/pg_dump (or
/pg_dumpall).

Thanks.



 


-----Mensagem original-----
De: Karl O. Pinc [mailto:ko...@me...] 
Enviada em: quinta-feira, 26 de março de 2015 23:26
Para: jo...@ue...
Cc: php...@li...
Assunto: Re: [ppa-users] RES: Error trying to do a Postgresql Export using
phppgadmin interface

On Thu, 26 Mar 2015 20:54:38 -0300
"jovino Borret" <jo...@ue...> wrote:

>   So, phppgadmin shows, when I try to do a backup (with any options at 
> the phppgadmin interface) :
> 
>             command is /usr/bin/pg_dumpall -i -a

Can you run the above command at the command line?

You tested that your webserver has a working pg_dump, but PPA is executing
pg_dumpall.  You need to see if pg_dumpall works on the webserver.

(Or at least that's how I'd start.)




Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein


---
Este email está limpo de vírus e malwares porque a proteção do avast! Antivírus está ativa.
http://www.avast.com

Re: [ppa-users] RES: Error trying to do a Postgresql Export using phppgadmin interface

[Karl O. P. <ko...@me...>]

On Thu, 26 Mar 2015 20:54:38 -0300
"jovino Borret" <jo...@ue...> wrote:

>   So, phppgadmin shows, when I try to do a backup (with any options
> at the phppgadmin interface) :
> 
>             command is /usr/bin/pg_dumpall -i -a  

Can you run the above command at the command line?

You tested that your webserver has a working pg_dump,
but PPA is executing pg_dumpall.  You need to see if
pg_dumpall works on the webserver.

(Or at least that's how I'd start.)




Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

[ppa-users] RES: RES: Error trying to do a Postgresql Export using phppgadmin interface

[jovino B. <jo...@ue...>]

Hi again Karl, 

    After working in another project, finally I am 
returning to operating systems again in my job. 

    Well, I am trying to resolve that
problem with phppgadmin 5.1 and Postgresql 8.4.20 (that run in differents servers).

   I have already understood that /usr/bin/pg_dump program is working fine in the webserver
because I have got a good backup after using this command at the shell line command,
doing it as a common user.

   Database server (Postgresql) receives the command, performs a backup and returns the file to the webserver,
at the home of the common user.

I have used a command like this at the shell: 

          /usr/bin/pg_dump -Ft -U  bduser  -h  "database server address"  -f  output.tar   db_input  

After putting the password of bduser, everything work fine.     
 

	After analyzing program  /var/www/html/phppgadmin.dinfo/paginas/dbexport.php I could understand
that it is sending that message:

      Export error: Failed to execute pg_dumpall (given path in your conf/config.inc.php :
/usr/bin/pg_dumpall). Please, fix this path in your configuration and relog.

because it can´t take the correct version of pg_dumps installed in the webserver.
File config.inc.php has the correct paths: 

$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';

A piece of dbexport.php program follows:

...................................................................
...................................................................
// Obtain the pg_dump version number and check if the path is good

                      
                $version = array();
                preg_match("/(\d+(?:\.\d+)?)(?:\.\d+)?.*$/", exec($exe . " --version"), $version);
       
                  if (empty($version)) {
                        if ($dumpall)
                                printf($lang['strbadpgdumpallpath'], $server_info['pg_dumpall_path']);
                        else
                                printf($lang['strbadpgdumppath'], $server_info['pg_dump_path']);
                        exit;
                   }
.........................................................................................................
.........................................................................................................

Strbadpgdumppath  has the message "Export error: Failed......"

Also, I have inserted command   $version = '8.4.20'  before the if (empty($version)) expression, in order to make this
program follow. Besides, at the end of this dbexport.php program, before the function  passthru($cmd),  I have put a command 

             echo "command is: ".$cmd;

in order to do the phppgadmin software show me at my browser, what the real command dbexport.php is assembling.

  So, phppgadmin shows, when I try to do a backup (with any options at the phppgadmin interface) :

            command is /usr/bin/pg_dumpall -i -a     

And no backup process occurs. Besides, at the database server nothing is logged in the postgresql logs.

I think there is a bug in dbexport.php but I am not sure. I know that $cmd is not complete (no address of dbserver, no
user, no db, etc.)

Any help will be appreciated.
Thank you a lot.

          


                   







  


-----Mensagem original-----
De: Karl .O Pinc [mailto:ko...@me...] 
Enviada em: sexta-feira, 28 de novembro de 2014 15:16
Para: jo...@ue...
Cc: php...@li...
Assunto: Re: [ppa-users] RES: Error trying to do a Postgresql Export using phppgadmin interface

Perhaps we are both not paying attention. I look at your log entry below and notice that it says pg_dumpall not pg_dump , but it is looking for pg_dump . Perhaps your config file is not correct?

On November 27, 2014 2:02:25 PM CST, jovino Borret <jo...@ue...> wrote:
>Hi Karl,
>
>  Thanks a lot for your attention.
>   
>  I have checked /usr/bin/pg_dumpall
>  and this program is installed ok in web page server  (in the 
> Postgresql database server, too).
>
>  I think phppgadmin from web server (I mean config.inc.php,  that has 
> the path for pg_dumpall) is not working fine in order  to pass the 
> correct link (name) of the database server (where  pg_dumpall must run 
> in order to do the backup).
>
>  I don't know why, because the other functions of phppagadmin       
> is running well (accessing database server and doing others requests).
>
>I have searched log of database server and there is no register of 
>backup attempts
>  from web server.
>
>Even so,
>thank you
>
>
>-----Mensagem original-----
>De: Karl O. Pinc [mailto:ko...@me...] 
>Enviada em: quarta-feira, 19 de novembro de 2014 18:59
>Para: jo...@ue...
>Cc: php...@li...
>Assunto: Re: [ppa-users] Error trying to do a Postgresql Export using
>phppgadmin interface
>
>On 11/19/2014 02:35:20 PM, jovino Borret wrote:
>> Hi all,
>> 
>>  
>> 
>>       I am trying to do an export of a Postgresql  data base table 
>> using
>> www.phppgadmin...   5.1  web interface
>> 
>>   and the system (web page server) returns the following message:
>> 
>>  
>> 
>>  
>> 
>> Export error: Failed to execute pg_dump (given path in your 
>> conf/config.inc.php :
>> /usr/bin/pg_dumpall). Please, fix this path in your configuration and
>
>> relog.
>> 
>>  
>> 
>>  
>> 
>>     We have two different servers (computers) installed:
>> 
>>  
>> 
>>      one of them is the web page server (CentOS, Apache, PHP, 
>> Phppgadmin 5.1);
>> 
>>     
>> 
>>      the other server runs Postgresql (CentOS, Postgresql 8.4.20).
>
>I suspect that you do not have pg_dump installed on your web server.
>
>Something like:
>
>  yum install postgresql
>
>should install the client programs, including pg_dump.
>
>
>Karl <ko...@me...>
>Free Software:  "You don't pay back, you pay forward."
>                 -- Robert A. Heinlein
>=
>
>
>---
>Este email está limpo de vírus e malwares porque a proteção do avast!
>Antivírus está ativa.
>http://www.avast.com
>
>
>------------------------------------------------------------------------------
>Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>from Actuate! Instantly Supercharge Your Business Reports and
>Dashboards
>with Interactivity, Sharing, Native Excel Exports, App Integration &
>more
>Get technology previously reserved for billion-dollar corporations,
>FREE
>http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
>_______________________________________________
>phpPgAdmin-users mailing list
>php...@li...
>https://lists.sourceforge.net/lists/listinfo/phppgadmin-users

Karl <ko...@me...>
Free Software: "You don't pay back, you pay forward."
                -- Robert A. Heinlein


---
Este email está limpo de vírus e malwares porque a proteção do avast! Antivírus está ativa.
http://www.avast.com

Re: [ppa-users] RES: Error trying to do a Postgresql Export using phppgadmin interface

[Karl .O P. <ko...@me...>]

Perhaps we are both not paying attention. I look at your log entry below and notice that it says pg_dumpall not pg_dump , but it is looking for pg_dump . Perhaps your config file is not correct?

On November 27, 2014 2:02:25 PM CST, jovino Borret <jo...@ue...> wrote:
>Hi Karl,
>
>  Thanks a lot for your attention.
>   
>  I have checked /usr/bin/pg_dumpall
>  and this program is installed ok in web page server
>  (in the Postgresql database server, too).
>
>  I think phppgadmin from web server (I mean config.inc.php,
>  that has the path for pg_dumpall) is not working fine in order
>  to pass the correct link (name) of the database server (where
>  pg_dumpall must run in order to do the backup).
>
>  I don't know why, because the other functions of phppagadmin       
> is running well (accessing database server and doing others requests).
>
>I have searched log of database server and there is no register of
>backup
>attempts
>  from web server.
>
>Even so,
>thank you  
>
>
>-----Mensagem original-----
>De: Karl O. Pinc [mailto:ko...@me...] 
>Enviada em: quarta-feira, 19 de novembro de 2014 18:59
>Para: jo...@ue...
>Cc: php...@li...
>Assunto: Re: [ppa-users] Error trying to do a Postgresql Export using
>phppgadmin interface
>
>On 11/19/2014 02:35:20 PM, jovino Borret wrote:
>> Hi all,
>> 
>>  
>> 
>>       I am trying to do an export of a Postgresql  data base table 
>> using
>> www.phppgadmin...   5.1  web interface
>> 
>>   and the system (web page server) returns the following message:
>> 
>>  
>> 
>>  
>> 
>> Export error: Failed to execute pg_dump (given path in your 
>> conf/config.inc.php :
>> /usr/bin/pg_dumpall). Please, fix this path in your configuration and
>
>> relog.
>> 
>>  
>> 
>>  
>> 
>>     We have two different servers (computers) installed:
>> 
>>  
>> 
>>      one of them is the web page server (CentOS, Apache, PHP, 
>> Phppgadmin 5.1);
>> 
>>     
>> 
>>      the other server runs Postgresql (CentOS, Postgresql 8.4.20).
>
>I suspect that you do not have pg_dump installed on your web server.
>
>Something like:
>
>  yum install postgresql
>
>should install the client programs, including pg_dump.
>
>
>Karl <ko...@me...>
>Free Software:  "You don't pay back, you pay forward."
>                 -- Robert A. Heinlein
>=
>
>
>---
>Este email está limpo de vírus e malwares porque a proteção do avast!
>Antivírus está ativa.
>http://www.avast.com
>
>
>------------------------------------------------------------------------------
>Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>from Actuate! Instantly Supercharge Your Business Reports and
>Dashboards
>with Interactivity, Sharing, Native Excel Exports, App Integration &
>more
>Get technology previously reserved for billion-dollar corporations,
>FREE
>http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
>_______________________________________________
>phpPgAdmin-users mailing list
>php...@li...
>https://lists.sourceforge.net/lists/listinfo/phppgadmin-users

Karl <ko...@me...>
Free Software: "You don't pay back, you pay forward."
                -- Robert A. Heinlein

[ppa-users] RES: Error trying to do a Postgresql Export using phppgadmin interface

[jovino B. <jo...@ue...>]

Hi Karl,

  Thanks a lot for your attention.
   
  I have checked /usr/bin/pg_dumpall
  and this program is installed ok in web page server
  (in the Postgresql database server, too).

  I think phppgadmin from web server (I mean config.inc.php,
  that has the path for pg_dumpall) is not working fine in order
  to pass the correct link (name) of the database server (where
  pg_dumpall must run in order to do the backup).

  I don't know why, because the other functions of phppagadmin       
  is running well (accessing database server and doing others requests).

  I have searched log of database server and there is no register of backup
attempts
  from web server.

Even so,
thank you  


-----Mensagem original-----
De: Karl O. Pinc [mailto:ko...@me...] 
Enviada em: quarta-feira, 19 de novembro de 2014 18:59
Para: jo...@ue...
Cc: php...@li...
Assunto: Re: [ppa-users] Error trying to do a Postgresql Export using
phppgadmin interface

On 11/19/2014 02:35:20 PM, jovino Borret wrote:
> Hi all,
> 
>  
> 
>       I am trying to do an export of a Postgresql  data base table 
> using
> www.phppgadmin...   5.1  web interface
> 
>   and the system (web page server) returns the following message:
> 
>  
> 
>  
> 
> Export error: Failed to execute pg_dump (given path in your 
> conf/config.inc.php :
> /usr/bin/pg_dumpall). Please, fix this path in your configuration and 
> relog.
> 
>  
> 
>  
> 
>     We have two different servers (computers) installed:
> 
>  
> 
>      one of them is the web page server (CentOS, Apache, PHP, 
> Phppgadmin 5.1);
> 
>     
> 
>      the other server runs Postgresql (CentOS, Postgresql 8.4.20).

I suspect that you do not have pg_dump installed on your web server.

Something like:

  yum install postgresql

should install the client programs, including pg_dump.


Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein
=


---
Este email está limpo de vírus e malwares porque a proteção do avast! Antivírus está ativa.
http://www.avast.com

Re: [ppa-users] Error trying to do a Postgresql Export using phppgadmin interface

[Karl O. P. <ko...@me...>]

On 11/19/2014 02:35:20 PM, jovino Borret wrote:
> Hi all,
> 
>  
> 
>       I am trying to do an export of a Postgresql  data base table
> using
> www.phppgadmin...   5.1  web interface
> 
>   and the system (web page server) returns the following message:
> 
>  
> 
>  
> 
> Export error: Failed to execute pg_dump (given path in your
> conf/config.inc.php : 
> /usr/bin/pg_dumpall). Please, fix this path in your configuration and
> relog.
> 
>  
> 
>  
> 
>     We have two different servers (computers) installed:
> 
>  
> 
>      one of them is the web page server (CentOS, Apache, PHP,
> Phppgadmin
> 5.1);
> 
>     
> 
>      the other server runs Postgresql (CentOS, Postgresql 8.4.20).

I suspect that you do not have pg_dump installed on your
web server.

Something like:

  yum install postgresql

should install the client programs, including pg_dump.


Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

[ppa-users] Error trying to do a Postgresql Export using phppgadmin interface

[jovino B. <jo...@ue...>]

Hi all,

 

      I am trying to do an export of a Postgresql  data base table using
www.phppgadmin...   5.1  web interface

  and the system (web page server) returns the following message:

 

 

Export error: Failed to execute pg_dump (given path in your
conf/config.inc.php : 
/usr/bin/pg_dumpall). Please, fix this path in your configuration and relog.

 

 

    We have two different servers (computers) installed:

 

     one of them is the web page server (CentOS, Apache, PHP, Phppgadmin
5.1);

    

     the other server runs Postgresql (CentOS, Postgresql 8.4.20).

 

My config.inc.php (excerpt about dumps): 

 

       ……………………………………………………………………………………………………..

       // Specify the path to the database dump utilities for this server.

        // You can set these to ‘’ if no dumper is available.

        $conf[‘servers’][0][‘pg_dump_path’] = ‘/usr/bin/pg_dump’;

        $conf[‘servers’][0][‘pg_dumpall_path’] = ‘/usr/bin/pg_dumpall’;/

 

Could you give me some help? Maybe I have to change these entries but I
don´t know how.

 

Thanks a lot.

   



---
Este email está limpo de vírus e malwares porque a proteção do avast! Antivírus está ativa.
http://www.avast.com

Re: [ppa-users] support for Postgresql9.3.x?

[BIll C. <bi...@tx...>]

On 7/8/14 2:44 PM, Bill Christensen wrote:
> Hi folks,
>
> I'm working on upgrading a Postgresql8.4 install to 9.3.4 for a 
> client.  I noticed that phppgadmin says version 5.1 supports up to 
> Postgresql 9.2.x.
>
> Can anyone tell me if it'll do 9.3.4, if it requires some tweaking to 
> work (and if so, what are those tweaks), or if it'll just work out of 
> the box.
>
> Thanks.
Answering my own question....

I have had no problems using phppgadmin on postgresql9.3.4 other than 
that when running sql scripts (such as importing databases from a 
previous version) it throws an error if the Paginate Results checkbox is 
left checked as it is by default.  Uncheck that, and all worked fine for 
me so far.

[ppa-users] support for Postgresql9.3.x?

[Bill C. <bil...@gr...>]

Hi folks,

I'm working on upgrading a Postgresql8.4 install to 9.3.4 for a client.  
I noticed that phppgadmin says version 5.1 supports up to Postgresql 9.2.x.

Can anyone tell me if it'll do 9.3.4, if it requires some tweaking to 
work (and if so, what are those tweaks), or if it'll just work out of 
the box.

Thanks.