From: "Dave Bolt" <dave@davebolt.co.uk>
To: <pgsql-admin@lists.postgresql.org>
References: <007a01d384c6$9d594260$d80bc720$@co.uk>
 <CY4PR11MB1575526BB540A62AD11C3AD0A71E0@CY4PR11MB1575.namprd11.prod.outlook.com>
 <009101d384d1$8128c380$837a4a80$@co.uk>
 <CY4PR11MB1575247E250C49DD3E0095CDA71E0@CY4PR11MB1575.namprd11.prod.outlook.com>
 <CA+Mn-Vbv0ThCe6qwZu5k_6WOPL0F1v8d2u+p8BPULAzF41sxNw@mail.gmail.com>
In-Reply-To: 
 <CA+Mn-Vbv0ThCe6qwZu5k_6WOPL0F1v8d2u+p8BPULAzF41sxNw@mail.gmail.com>
Subject: RE: Failed to execute pg_dump
Date: Thu, 4 Jan 2018 13:25:09 -0000
Message-ID: <007501d3855f$71cffdc0$556ff940$@co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AdOE09H/njdNQnbrTtm1QL/xQAXkngAD+IOA
Content-Language: en-gb
Precedence: bulk

Apologies to Carlos for replying directly to him instead of to the list.

Both php.ini files on my system have
disable_functions =3D

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]=20
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=20
> 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=20
> 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=20
> 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=20
> conf/config.inc.php : /opt/rh/rh-postgresql96/root/usr/bin/pg_dump).=20
> 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=20
> appears to be the configuration file mentioned in the error message=20
> and I can=E2=80=99t see any obvious issues.
>
>
>
> I searched this problem in the mailing list but could not find any=20
> recent results. I did find an older result which said to correct the=20
> 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=20
> http://journyx.com/communication-preferences to unsubscribe.