<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div>Hi,</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">Thanks for the tip, indeed that is the problem. My linux-headers are at version 3.9 and my kernel at 3.7.</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">I`ll recompile the kernel in order to use the heartbeat functionality.</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color:
rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">Thanks again for the precious tips.<br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span></span></div><div> </div><div>Regards,<br>Adrian Videanu</div><div><br></div> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Yugo Nagata <nagata@sraoss.co.jp><br> <b><span style="font-weight: bold;">To:</span></b> Videanu Adrian
<videanuadrian@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> "pgpool-general@pgpool.net" <pgpool-general@pgpool.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, November 6, 2013 11:41 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 2226] pgpoll 3.3.1 watchdog<br> </font> </div> <div class="y_msg_container"><br>Hi,<br clear="none"><br clear="none">Sorry for responding late.<br clear="none"><br clear="none">pgpool doesn't use Heartbeat (Pacemacer), so you don't have to install<br clear="none">Heartbeat package on your system.<br clear="none"><br clear="none">pgpool uses SO_REUSEPORT functionality of socket if this is defined in linux<br clear="none">header file. SO_REUSEPORT is introduced in Linux kernel 3.9 and the error<br clear="none">occurs in old kernel. <br clear="none"><br clear="none">We assume SO_REUSEPORT is not defined in old kernel's header. However,
for<br clear="none">some reason, your Gentoo has the 3.9 linux headers installed, but is still<br clear="none">running an older kernel.<br clear="none"><br clear="none">So, if you update kernal to 3.9 and run, this error would be resolved.<br clear="none"><br clear="none">In other way as a workaroud, you can try editing config.h before compiling<br clear="none">pgpool for undefining SOREUSEPORT .<br clear="none"><br clear="none">$ ./configure<br clear="none">$ vi config.h<br clear="none"><br clear="none">add the following line at last of config.h.<br clear="none"> #undef SO_REUSEPORT<br clear="none"><br clear="none">$ make install<br clear="none"><div class="yqt1856648017" id="yqtfd87185"><br clear="none">On Wed, 30 Oct 2013 03:49:39 -0700 (PDT)<br clear="none">Videanu Adrian <<a shape="rect" ymailto="mailto:videanuadrian@yahoo.com" href="mailto:videanuadrian@yahoo.com">videanuadrian@yahoo.com</a>> wrote:<br clear="none"><br clear="none">> Hi
all,<br clear="none">> I`m trying to setup two HA instances of pgpool on 2 Gentoo boxes.<br clear="none">> When i start each instance i get : <br clear="none">> <br clear="none">> <br clear="none">> 2013-10-30 12:46:50 LOG: pid 28656: wd_chk_setuid all commands have setuid bit<br clear="none">> 2013-10-30 12:46:50 LOG: pid 28656: watchdog might call network commands which using setuid bit.<br clear="none">> 2013-10-30 12:46:53 LOG: pid 28656: wd_escalation: escalating to master pgpool<br clear="none">> 2013-10-30 12:46:55 LOG: pid 28656: wd_escalation: escalated to master pgpool successfully<br clear="none">> 2013-10-30 12:46:55 LOG: pid 28656: wd_init: start watchdog<br clear="none">> 2013-10-30 12:46:55 LOG: pid 28656: pgpool-II successfully started. version 3.3.1 (tokakiboshi)<br clear="none">> 2013-10-30 12:46:56 ERROR: pid 28662:
wd_create_hb_recv_socket: setsockopt(SO_REUSEPORT) failed. reason: Protocol not available<br clear="none">> 2013-10-30 12:46:56 ERROR: pid 28662: wd_hb_receiver: socket create failed<br clear="none">> 2013-10-30 12:46:56 ERROR: pid 28663: wd_create_hb_send_socket: setsockopt(SO_REUSEPORT) failed. reason: Protocol not available<br clear="none">> 2013-10-30 12:46:56 ERROR: pid 28663: wd_hb_sender: socket create failed<br clear="none">> <br clear="none">> <br clear="none">> I`m using heartbeat as monitor method.<br clear="none">> <br clear="none">> Do i have to install heartbeat package on my system ?<br clear="none">> I have installed corosync but still got the same error.<br clear="none">> <br clear="none">> <br clear="none">> <br clear="none">> Regards,<br clear="none">> Adrian Videanu</div><br clear="none"><br clear="none"><br clear="none">-- <br clear="none">Yugo Nagata <<a shape="rect"
ymailto="mailto:nagata@sraoss.co.jp" href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a><div class="yqt1856648017" id="yqtfd74764">></div><br><br></div> </div> </div> </div></body></html>