[pgpool-general: 3163] Re: New CentOS 6.5 servers with pgpool 3.3.3-4 won't start

Muhammad Usama m.usama at gmail.com
Mon Sep 15 23:28:33 JST 2014

Hi Scalia

The location and 04755 permission on arping and ifconfig files doesn't
seems to have any issue, and pgpool-II should be able to startup

The error ".. has_setuid_bit: /home/apache/sbin/ifconfig: no such a
command" suggests that pgpool-II is not able to find the ifconfig file
at "/home/apache/sbin/ifconfig", This could be because of reasons
like, non existent file at the location or access permission of
/home/sbin directory for user executing the pgppol-II.

can you check if the pgpool-II user can read and execute the ifconfig
and arping files, on the system where pgpool is failing to startup
without any issues?

Kind Regards

On Wed, Sep 3, 2014 at 11:34 PM, John Scalia <jayknowsunix at gmail.com> wrote:
> I'd finally gotten approval to build a new postgresql 9.3.3 cluster using
> CentO/S 6.5. The cluster has 3 servers in it, 1 primary with 2 standbys.
> Each machine has had pgpool installed. I originally setup the primary server
> completely, then I copied the pgpool.conf file to the standbys. I then
> performed some minor editing on those standbys in the watchdog section to
> configure the correct host information.
> On each of the machines, I created a new directory under /home in order to
> place setuid versions of ifconfig and arping. Think of this as security
> through obfuscation. I mention this fact as this is what is preventing
> pgpool from starting on those standby servers. All the machines use the same
> location for ifconfig and arping, and each executable is set to mode 04755.
> On all machines, the directory contents looks like:
> -rwsr-xr-x    1    root    root    17888    Sep 3    17:27    arping
> -rwsr-xr-x    1    root    root    73936    Sep 3    17:27 ifconfig
> The primary server starts pgpool flawlessly, but both standby servers refuse
> to start reporting in their logs:
> 2014-09-13    17:28:02    ERROR: pid 1425  has_setuid_bit:
> /home/apache/sbin/ifconfig: no such a command
> Previous errors of a similar nature were caused by selinux being "on", but I
> have verified that it is disabled. I don't really understand why these won't
> start, anyone have any ideas?
> --
> Jay
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

More information about the pgpool-general mailing list