pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFailed to execute pg_dump
7+ messages / 4 participants
[nested] [flat]
* Failed to execute pg_dump
@ 2018-01-03 19:11 Dave Bolt <dave@davebolt.co.uk>
0 siblings, 1 reply; 7+ messages in thread
From: Dave Bolt @ 2018-01-03 19:11 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi Everyone
I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL 9.6.5
and phpPgAdmin 5.1
When I went to dump a database I received the following error:
Export error: Failed to execute pg_dump (given path in your
conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump). Please,
fix this path in your configuration and relog.
The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
I have checked the /user/share/phpPgAdmin/conf/config.inc.php which appears
to be the configuration file mentioned in the error message and I can't see
any obvious issues.
I searched this problem in the mailing list but could not find any recent
results. I did find an older result which said to correct the path in the
config file, but that looks right to me.
Any ideas?
Thanks
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Failed to execute pg_dump
@ 2018-01-03 19:14 Scott Whitney <scott@journyx.com>
parent: Dave Bolt <dave@davebolt.co.uk>
0 siblings, 1 reply; 7+ messages in thread
From: Scott Whitney @ 2018-01-03 19:14 UTC (permalink / raw)
To: Dave Bolt <dave@davebolt.co.uk>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
My immediate thought is always permissions.
As whom a phpPgAdmin running? Probably the Apache user who may or may not have rights to see pg_dump.
________________________________
From: Dave Bolt <dave@davebolt.co.uk>
Sent: Wednesday, January 3, 2018 1:11 PM
To: pgsql-admin@lists.postgresql.org
Subject: Failed to execute pg_dump
Hi Everyone
I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL 9.6.5 and phpPgAdmin 5.1
When I went to dump a database I received the following error:
Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump). Please, fix this path in your configuration and relog.
The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
I have checked the /user/share/phpPgAdmin/conf/config.inc.php which appears to be the configuration file mentioned in the error message and I can’t see any obvious issues.
I searched this problem in the mailing list but could not find any recent results. I did find an older result which said to correct the path in the config file, but that looks right to me.
Any ideas?
Thanks
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click here <http://journyx.com/communication-preferences; or visit http://journyx.com/communication-preferences to unsubscribe.
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Failed to execute pg_dump
@ 2018-01-03 20:29 Dave Bolt <dave@davebolt.co.uk>
parent: Scott Whitney <scott@journyx.com>
0 siblings, 1 reply; 7+ messages in thread
From: Dave Bolt @ 2018-01-03 20:29 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi Scot,
Permissions on the pg_dump file are:
-rwxr-xr-x for owner root, group root.
If I go to the directory and execute as my normal user it seems to be
working, at least for
pg_dump --help
From: Scott Whitney [mailto:scott@journyx.com]
Sent: 03 January 2018 19:15
To: Dave Bolt; pgsql-admin@lists.postgresql.org
Subject: Re: Failed to execute pg_dump
My immediate thought is always permissions.
As whom a phpPgAdmin running? Probably the Apache user who may or may not
have rights to see pg_dump.
_____
From: Dave Bolt <dave@davebolt.co.uk>
Sent: Wednesday, January 3, 2018 1:11 PM
To: pgsql-admin@lists.postgresql.org
Subject: Failed to execute pg_dump
Hi Everyone
I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL 9.6.5
and phpPgAdmin 5.1
When I went to dump a database I received the following error:
Export error: Failed to execute pg_dump (given path in your
conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump). Please,
fix this path in your configuration and relog.
The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
I have checked the /user/share/phpPgAdmin/conf/config.inc.php which appears
to be the configuration file mentioned in the error message and I can't see
any obvious issues.
I searched this problem in the mailing list but could not find any recent
results. I did find an older result which said to correct the path in the
config file, but that looks right to me.
Any ideas?
Thanks
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click here
<http://journyx.com/communication-preferences; or visit
http://journyx.com/communication-preferences to unsubscribe.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Failed to execute pg_dump
@ 2018-01-03 20:36 Scott Whitney <scott@journyx.com>
parent: Dave Bolt <dave@davebolt.co.uk>
0 siblings, 2 replies; 7+ messages in thread
From: Scott Whitney @ 2018-01-03 20:36 UTC (permalink / raw)
To: Dave Bolt <dave@davebolt.co.uk>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
It seems like the Apache user ought to be able to run it, then.
Can you enable that account, su to it and try it?
________________________________
From: Dave Bolt <dave@davebolt.co.uk>
Sent: Wednesday, January 3, 2018 2:29 PM
To: pgsql-admin@lists.postgresql.org
Subject: RE: Failed to execute pg_dump
Hi Scot,
Permissions on the pg_dump file are:
-rwxr-xr-x for owner root, group root.
If I go to the directory and execute as my normal user it seems to be working, at least for
pg_dump --help
From: Scott Whitney [mailto:scott@journyx.com]
Sent: 03 January 2018 19:15
To: Dave Bolt; pgsql-admin@lists.postgresql.org
Subject: Re: Failed to execute pg_dump
My immediate thought is always permissions.
As whom a phpPgAdmin running? Probably the Apache user who may or may not have rights to see pg_dump.
________________________________
From: Dave Bolt <dave@davebolt.co.uk<mailto:dave@davebolt.co.uk>>
Sent: Wednesday, January 3, 2018 1:11 PM
To: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>
Subject: Failed to execute pg_dump
Hi Everyone
I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL 9.6.5 and phpPgAdmin 5.1
When I went to dump a database I received the following error:
Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump). Please, fix this path in your configuration and relog.
The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
I have checked the /user/share/phpPgAdmin/conf/config.inc.php which appears to be the configuration file mentioned in the error message and I can’t see any obvious issues.
I searched this problem in the mailing list but could not find any recent results. I did find an older result which said to correct the path in the config file, but that looks right to me.
Any ideas?
Thanks
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com<http://www.journyx.com;
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click here <http://journyx.com/communication-preferences; or visit http://journyx.com/communication-preferences to unsubscribe.
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Failed to execute pg_dump
@ 2018-01-03 20:43 Hajek, Nick <Nick.Hajek@vishay.com>
parent: Scott Whitney <scott@journyx.com>
1 sibling, 0 replies; 7+ messages in thread
From: Hajek, Nick @ 2018-01-03 20:43 UTC (permalink / raw)
To: Scott Whitney <scott@journyx.com>; Dave Bolt <dave@davebolt.co.uk>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Unless Apache is running as root (highly unlikely), I don't believe it would be able to write to a file/directory with those permissions. Set permissions to 0x777 to allow Apache to write to it and see if that makes a difference.
From: Scott Whitney [mailto:scott@journyx.com]
Sent: Wednesday, January 03, 2018 2:36 PM
To: Dave Bolt <dave@davebolt.co.uk>; pgsql-admin@lists.postgresql.org
Subject: Re: Failed to execute pg_dump
It seems like the Apache user ought to be able to run it, then.
Can you enable that account, su to it and try it?
________________________________
From: Dave Bolt <dave@davebolt.co.uk<mailto:dave@davebolt.co.uk>>
Sent: Wednesday, January 3, 2018 2:29 PM
To: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>
Subject: RE: Failed to execute pg_dump
Hi Scot,
Permissions on the pg_dump file are:
-rwxr-xr-x for owner root, group root.
If I go to the directory and execute as my normal user it seems to be working, at least for
pg_dump --help
From: Scott Whitney [mailto:scott@journyx.com]
Sent: 03 January 2018 19:15
To: Dave Bolt; pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>
Subject: Re: Failed to execute pg_dump
My immediate thought is always permissions.
As whom a phpPgAdmin running? Probably the Apache user who may or may not have rights to see pg_dump.
________________________________
From: Dave Bolt <dave@davebolt.co.uk<mailto:dave@davebolt.co.uk>>
Sent: Wednesday, January 3, 2018 1:11 PM
To: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>
Subject: Failed to execute pg_dump
Hi Everyone
I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL 9.6.5 and phpPgAdmin 5.1
When I went to dump a database I received the following error:
Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump). Please, fix this path in your configuration and relog.
The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
I have checked the /user/share/phpPgAdmin/conf/config.inc.php which appears to be the configuration file mentioned in the error message and I can't see any obvious issues.
I searched this problem in the mailing list but could not find any recent results. I did find an older result which said to correct the path in the config file, but that looks right to me.
Any ideas?
Thanks
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com<http://www.journyx.com;
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click here <http://journyx.com/communication-preferences; or visit http://journyx.com/communication-preferences to unsubscribe.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Failed to execute pg_dump
@ 2018-01-03 20:44 Carlos Martinez <camarti@gmail.com>
parent: Scott Whitney <scott@journyx.com>
1 sibling, 1 reply; 7+ messages in thread
From: Carlos Martinez @ 2018-01-03 20:44 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi.
The problem can be caused by:
1) SELinux: may be you need set the options httpd_execmem or
httpd_can_network_connect_db. You can disable SELinux temporay with
setenfoce 0.
3) Review the option disable_functions on PHP: make sure that exec
family in not disabled.
Best regards.
Carlos M.
On Wed, Jan 3, 2018 at 3:36 PM, Scott Whitney <scott@journyx.com> wrote:
> It seems like the Apache user ought to be able to run it, then.
>
>
> Can you enable that account, su to it and try it?
>
>
>
> ________________________________
> From: Dave Bolt <dave@davebolt.co.uk>
> Sent: Wednesday, January 3, 2018 2:29 PM
> To: pgsql-admin@lists.postgresql.org
> Subject: RE: Failed to execute pg_dump
>
>
> Hi Scot,
>
> Permissions on the pg_dump file are:
>
> -rwxr-xr-x for owner root, group root.
>
> If I go to the directory and execute as my normal user it seems to be
> working, at least for
>
> pg_dump --help
>
>
>
>
>
> From: Scott Whitney [mailto:scott@journyx.com]
> Sent: 03 January 2018 19:15
> To: Dave Bolt; pgsql-admin@lists.postgresql.org
> Subject: Re: Failed to execute pg_dump
>
>
>
> My immediate thought is always permissions.
>
>
>
> As whom a phpPgAdmin running? Probably the Apache user who may or may not
> have rights to see pg_dump.
>
>
>
> ________________________________
>
> From: Dave Bolt <dave@davebolt.co.uk>
> Sent: Wednesday, January 3, 2018 1:11 PM
> To: pgsql-admin@lists.postgresql.org
> Subject: Failed to execute pg_dump
>
>
>
> Hi Everyone
>
>
>
> I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL 9.6.5
> and phpPgAdmin 5.1
>
> When I went to dump a database I received the following error:
>
>
>
> Export error: Failed to execute pg_dump (given path in your
> conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump). Please,
> fix this path in your configuration and relog.
>
>
>
> The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
>
>
>
> I have checked the /user/share/phpPgAdmin/conf/config.inc.php which appears
> to be the configuration file mentioned in the error message and I can’t see
> any obvious issues.
>
>
>
> I searched this problem in the mailing list but could not find any recent
> results. I did find an older result which said to correct the path in the
> config file, but that looks right to me.
>
>
>
> Any ideas?
>
> Thanks
>
>
>
>
>
> Journyx, Inc.
>
> 7600 Burnet Road #300
> Austin, TX 78757
> www.journyx.com
>
>
>
> p 512.834.8888
>
> f 512-834-8858
>
>
>
> Do you receive our promotional emails? Click here or visit
> http://journyx.com/communication-preferences to unsubscribe.
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Failed to execute pg_dump
@ 2018-01-04 13:25 Dave Bolt <dave@davebolt.co.uk>
parent: Carlos Martinez <camarti@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Dave Bolt @ 2018-01-04 13:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Apologies to Carlos for replying directly to him instead of to the list.
Both php.ini files on my system have
disable_functions =
I set the permissions to 0x777 on pg_dump but that has not made any difference.
I also set sudo to permissive, which also does not seem to have helped.
Unless I'm missing something, I think that covers all the suggestions from Carlos, Scott and Nick (who's message doesn't seem to be included below for some reason). Thanks for your suggestions, I'm learning things anyway :)
Dave
-----Original Message-----
From: Carlos Martinez [mailto:camarti@gmail.com]
Sent: 03 January 2018 20:44
To: pgsql-admin@lists.postgresql.org
Subject: Re: Failed to execute pg_dump
Hi.
The problem can be caused by:
1) SELinux: may be you need set the options httpd_execmem or httpd_can_network_connect_db. You can disable SELinux temporay with setenfoce 0.
3) Review the option disable_functions on PHP: make sure that exec family in not disabled.
Best regards.
Carlos M.
On Wed, Jan 3, 2018 at 3:36 PM, Scott Whitney <scott@journyx.com> wrote:
> It seems like the Apache user ought to be able to run it, then.
>
>
> Can you enable that account, su to it and try it?
>
>
>
> ________________________________
> From: Dave Bolt <dave@davebolt.co.uk>
> Sent: Wednesday, January 3, 2018 2:29 PM
> To: pgsql-admin@lists.postgresql.org
> Subject: RE: Failed to execute pg_dump
>
>
> Hi Scot,
>
> Permissions on the pg_dump file are:
>
> -rwxr-xr-x for owner root, group root.
>
> If I go to the directory and execute as my normal user it seems to be
> working, at least for
>
> pg_dump --help
>
>
>
>
>
> From: Scott Whitney [mailto:scott@journyx.com]
> Sent: 03 January 2018 19:15
> To: Dave Bolt; pgsql-admin@lists.postgresql.org
> Subject: Re: Failed to execute pg_dump
>
>
>
> My immediate thought is always permissions.
>
>
>
> As whom a phpPgAdmin running? Probably the Apache user who may or may
> not have rights to see pg_dump.
>
>
>
> ________________________________
>
> From: Dave Bolt <dave@davebolt.co.uk>
> Sent: Wednesday, January 3, 2018 1:11 PM
> To: pgsql-admin@lists.postgresql.org
> Subject: Failed to execute pg_dump
>
>
>
> Hi Everyone
>
>
>
> I have a test server which is running Centos7, PHP 7.1.13, PostgreSQL
> 9.6.5 and phpPgAdmin 5.1
>
> When I went to dump a database I received the following error:
>
>
>
> Export error: Failed to execute pg_dump (given path in your
> conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump).
> Please, fix this path in your configuration and relog.
>
>
>
> The path /opt/rh/rh-postgresql96/root/usr/bin/pg_dump is valid.
>
>
>
> I have checked the /user/share/phpPgAdmin/conf/config.inc.php which
> appears to be the configuration file mentioned in the error message
> and I can’t see any obvious issues.
>
>
>
> I searched this problem in the mailing list but could not find any
> recent results. I did find an older result which said to correct the
> path in the config file, but that looks right to me.
>
>
>
> Any ideas?
>
> Thanks
>
>
>
>
>
> Journyx, Inc.
>
> 7600 Burnet Road #300
> Austin, TX 78757
> www.journyx.com
>
>
>
> p 512.834.8888
>
> f 512-834-8858
>
>
>
> Do you receive our promotional emails? Click here or visit
> http://journyx.com/communication-preferences to unsubscribe.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2018-01-04 13:25 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-01-03 19:11 Failed to execute pg_dump Dave Bolt <dave@davebolt.co.uk>
2018-01-03 19:14 ` Scott Whitney <scott@journyx.com>
2018-01-03 20:29 ` Dave Bolt <dave@davebolt.co.uk>
2018-01-03 20:36 ` Scott Whitney <scott@journyx.com>
2018-01-03 20:43 ` Hajek, Nick <Nick.Hajek@vishay.com>
2018-01-03 20:44 ` Carlos Martinez <camarti@gmail.com>
2018-01-04 13:25 ` Dave Bolt <dave@davebolt.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox