Menu
▾
▴
phppgadmin-users
|
From: jovino B. <jo...@ue...> - 2014-11-19 20:52:52
|
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
|
|
From: Karl O. P. <ko...@me...> - 2014-11-19 20:58:57
|
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
|
|
From: jovino B. <jo...@ue...> - 2014-11-27 20:03:02
|
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
|
|
From: Karl .O P. <ko...@me...> - 2014-11-28 17:16:35
|
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 |
|
From: jovino B. <jo...@ue...> - 2015-03-27 00:11:14
|
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
|
|
From: Karl O. P. <ko...@me...> - 2015-03-27 02:26:21
|
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
|
|
From: jovino B. <jo...@ue...> - 2015-03-27 15:14:35
|
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
|
|
From: Karl O. P. <ko...@me...> - 2015-03-27 15:59:30
|
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 |
|
From: jovino B. <jo...@ue...> - 2015-03-27 23:37:48
|
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 |
|
From: Karl O. P. <ko...@me...> - 2015-03-28 01:21:55
|
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
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X