Обсуждение: 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
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.
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
Austin, TX 78757
www.journyx.com
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.
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?
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.
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>
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.
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.
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'tseem 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 temporaywith 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.