[pgpool-general: 3599] Re: Wathcdog issue

[Mephysto]

Thank you very much Yugo.

I will try this method soon.

Regards.


Alessio

On 7 April 2015 at 09:04, Yugo Nagata <nagata at sraoss.co.jp> wrote:

> Hi Mephysto,
>
> On Tue, 7 Apr 2015 08:50:33 +0200
> Mephysto <mephystoonhell at gmail.com> wrote:
>
> > Hi there,
> > I am trying for the first time to configure watchdog for pgpool-II 3.4.1.
> > After doing some base settings in pgpool.conf, I tried to start pgpool,
> but
> > I received some errore messages and watchdog are not working done. This
> is
> > the log:
> >
> >
> >
> > 2015-04-05 18:32:35: pid 5094: DETAIL:  ping data: PING localhost
> > (127.0.0.1) 56(84) bytes of data.
> >
> >         --- localhost ping statistics ---
> >         3 packets transmitted, 3 received, 0% packet loss, time 1999ms
> >         rtt min/avg/max/mdev = 0.014/0.030/0.041/0.012 ms
> >
> > 2015-04-05 18:32:35: pid 5094: LOG:  failed to create watchdog sending
> > socket
> > 2015-04-05 18:32:35: pid 5094: DETAIL:  connect() reports failure
> > "Connection refused"
> > 2015-04-05 18:32:35: pid 5094: HINT:  You can safely ignore this while
> > starting up.
> > 2015-04-05 18:32:35: pid 5094: LOG:  watchdog sending packet for nodes
> > 2015-04-05 18:32:35: pid 5094: DETAIL:  packet for "postgres-2:9000" is
> > canceled
> > 2015-04-05 18:32:38: pid 5094: DEBUG:  watchdog executing ping
> > 2015-04-05 18:32:38: pid 5094: DETAIL:  failed to ping "192.168.56.249"
> > exit code: 1
> > 2015-04-05 18:32:38: pid 5094: LOG:  watchdog escalation
> > 2015-04-05 18:32:38: pid 5094: DETAIL:  escalating to master pgpool
> > SIOCSIFADDR: Permission denied
> > SIOCSIFFLAGS: Permission denied
> > SIOCSIFNETMASK: Permission denied
> >
> >
> > I'm using postgres user to run pgpool process, so I presume these errors
> > due to postgres user permission. I would not use root to run pgpool
> > process, so I ask you if exists a manner to run watchdog without using
> root
> > user.
>
> You can use setuid. This tutorial would be helpful. Alhough
> this is using apache user instead of postgres user, the manner
> is the almost the same.
>
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html#config_setuid
>
> >
> > Best reegards.
> >
> > Mephysto
>
>
> --
> Yugo Nagata <nagata at sraoss.co.jp>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150407/f121c337/attachment-0001.html>