<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=ES link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span lang=EN-US>Hello everyone in the list, I am creating a
high availability cluster with Pgpool-II, Pgpool-HA and Heartbet. The monitor operation
fails if the authentication with the database use md5, but if the
authentication method is true, there isn’t problem. This is the
information logged in PostgreSQL and pgpool log file each one. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>The question is:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Allows pgpool-ha the md5 authentication
method??<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Postgres’s log<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: connection received:
host=pg_01.vnz.uci.cu port=60224<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: could not receive data from client:
Connection reset by peer<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: connection received:
host=pg_01.vnz.uci.cu port=60226<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: could not receive data from client:
Connection reset by peer<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: connection received:
host=pg_01.vnz.uci.cu port=60228<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: could not receive data from client:
Connection reset by peer<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: connection received:
host=pg_01.vnz.uci.cu port=60230<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: could not receive data from client:
Connection reset by peer<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: connection received:
host=pg_01.vnz.uci.cu port=60232<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: could not receive data from client:
Connection reset by peer<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: connection received:
host=pg_01.vnz.uci.cu port=60234<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>LOG: could not receive data from client:
Connection reset by peer<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Pgpool’s log<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 LOG: pid 4636:
connection received: host=localhost port=42143<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
Protocol Major: 1234 Minor: 5679 database: user: <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
SSLRequest from client<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
read_startup_packet: application_name: psql<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
Protocol Major: 3 Minor: 0 database: pgpool user: pgpool<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
new_connection: connecting 0 backend<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
new_connection: connecting 1 backend<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
new_connection: skipping slot 1 because backend_status = 3<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
pool_ssl: sending client->server SSL request<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
pool_ssl: client->server SSL response: S<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
pool_read_message_length: slot: 0 length: 12<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
pool_do_auth: auth kind:5<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636: trying
md5 authentication<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 ERROR: pid 4636:
pool_ssl: SSL_read: no SSL error reported<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 ERROR: pid 4636:
pool_read: read failed (Success)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
read_password_packet_password: failed to read password packet "p"<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
do_md5: read_password_packet failed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>2011-12-01 17:16:47 DEBUG: pid 4636:
do_md5failed in slot 0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Thank you very much for your time.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Regards.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</body>
</html>