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@xxxxxxxxx] Sent: 03 January 2018 20:44 To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx> > Sent: Wednesday, January 3, 2018 2:29 PM > To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx > 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@xxxxxxxxxxx] > Sent: 03 January 2018 19:15 > To: Dave Bolt; pgsql-admin@xxxxxxxxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx> > Sent: Wednesday, January 3, 2018 1:11 PM > To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx > 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.
