search

pgpool / pgpool2

This is the official mirror of git://git.postgresql.org/git/pgpool2.git. Note that this is just a *mirror* - we don't work with pull requests on github. Please subscribe to pgpool-hackers mailing list from our website and submit your patch to this mailing list.
https://www.pgpool.net
Other
305 stars 87 forks source link

sudo ip add/del ; sudo arping command do not work #3

Open tozhu opened 7 years ago

tozhu commented 7 years ago

due to security reason, the system doesn't allow root user to run pgpool, but allow the pgpool user to run with sudo permission, can do 'sudo ip' and 'sudo arping' command

but the issue is 'sudo' does not work due to something is HARD coded in the source. my configis following:

delegate_IP = '10.249.7.228' if_cmd_path = '/sbin' if_up_cmd = 'ip addr add 10.249.7.228/26 dev bond45 label bond45:0' if_down_cmd = 'ip addr del 10.249.7.228/26 dev bond45' arping_path = '/usr/sbin' arping_cmd = 'sudo arping -U 10.249.7.228 -w 1'

but get following error when start up:

postgres@testsrv002$ pgpool -f /etc/pgpool-II-94/pgpool.conf -F /etc/pgpool-II-94/pcp.conf -x 2016-07-05 18:05:01: pid 17733: FATAL: has_setuid_bit: command '/sbin/sudo' not found

tatsuo-ishii commented 7 years ago

Which version of pgpool-II?

I suspect your config is not updated? For example, it is actually "if_up_cmd = sudo 'ip addr add ...", rather than "if_up_cmd = 'ip addr add"