<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
h3
{margin-right:0in;
margin-left:0in;
font-size:13.5pt;
font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
span.Heading3Char
{font-family:"Cambria","serif";
color:#4F81BD;
font-weight:bold}
span.mw-headline
{}
span.BalloonTextChar
{font-family:"Tahoma","sans-serif"}
span.EmailStyle21
{font-family:"Calibri","sans-serif";
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
ol
{margin-bottom:0in}
ul
{margin-bottom:0in}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Hi,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">I think it is not the same case. To avoid situations like that, I did not provide any path (let it take everything from default locations). I was running
in –n option when I got this error. A couple of observations – </span></p>
<p class="MsoListParagraph" style="text-indent:-.25in"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"><span style="">1)<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">If I give the name of a non-existing file in pool_passwd, pgpool creates that file and continues running (a 0 byte file). The authentication fails.</span></p>
<p class="MsoListParagraph" style="text-indent:-.25in"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"><span style="">2)<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">If I give the absolute path and name (‘/usr/local/etc/pool_passwd’), and run pgpool with –n option, it prefixes more paths to the file name and errors –
</span></p>
<p class="MsoListParagraph"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Value in file - pool_passwd = '/usr/local/etc/xyz'</span></p>
<p class="MsoListParagraph"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Error - pool_init_pool_passwd: couldn't open
<b>/usr/local/etc/</b>/usr/local/etc/xyz.</span></p>
<p class="MsoListParagraph"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">If I execute it without the –n option, it picks up the file.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Regards,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Jayadevan</span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> David Kerr [mailto:web@mr-paradox.net]
<br>
<b>Sent:</b> Thursday, May 09, 2013 8:33 AM<br>
<b>To:</b> Jayadevan M<br>
<b>Cc:</b> 'Tatsuo Ishii'; pgpool-general@pgpool.net<br>
<b>Subject:</b> Re: [pgpool-general: 1706] Re: pgpool - issue with md5</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">sounds smilier to the problem i had the solution was:</p>
<div>
<p class="MsoNormal"><a href="http://www.pgpool.net/mediawiki/index.php/FAQ">http://www.pgpool.net/mediawiki/index.php/FAQ</a></p>
</div>
<div>
<h3 style="margin-right:0in; margin-bottom:.05in; margin-left:0in; line-height:14.4pt; background:white; overflow:hidden">
<span class="mw-headline"><span style="font-size:13.0pt; font-family:"Arial","sans-serif"">I cannot use MD5 authentication if start pgpool without -n option. Why?</span></span><span style="font-size:13.0pt; font-family:"Arial","sans-serif""></span></h3>
<p class="MsoNormal" style="margin-right:0in; margin-bottom:1.2pt; margin-left:.5in; line-height:18.0pt; background:white">
<span style="font-size:10.0pt; font-family:"Arial","sans-serif"">You must have given -f option as a relative path: i.e. "-f pgpool.conf", rather than full path: i.e. "-f /usr/local/etc/pgpool.conf". Pgpool tries to locate the full path of pool_passwd (which
is neccesary for MD5 auth) from pgpool.conf path. This is fine with -n option. However if pgpool starts without -n option, it changes current directory to "/", which is neccessary processs for daemonizing. As a result, pgpool tries to open "/pool_passwd",
which will not successs.</span></p>
<div>
<p class="MsoNormal" style="margin-left:24.0pt; line-height:14.4pt; background:white">
<span style="font-size:10.0pt; font-family:"Arial","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:24.0pt; line-height:14.4pt; background:white">
<span style="font-size:10.0pt; font-family:"Arial","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:24.0pt; line-height:14.4pt; background:white">
<span style="font-size:10.0pt; font-family:"Arial","sans-serif""> </span></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:24.0pt">On May 8, 2013, at 8:00 PM, Jayadevan M <<a href="mailto:jayadevan.maymala@ibsplc.com">jayadevan.maymala@ibsplc.com</a>> wrote:</p>
</div>
<p class="MsoNormal" style="margin-left:24.0pt"><br>
<br>
</p>
<p class="MsoNormal" style="margin-left:24.0pt">Hi,<br>
Though the password I am supplying is the same and I have not made any changes to the pgpol password, the values in the error message change. Is that how it should be?<br>
<br>
2013-05-08 18:23:48 DEBUG: pid 3301: password does not match: frontend:md57a15dc0847a23d5def2b5c7941d8460d pgpool:md5f51e3de26a7f16dbc7ff99b582e882ab<br>
2013-05-08 18:23:51 DEBUG: pid 3317: password does not match: frontend:md54d973dd3805852de6ef2a9d15a46346d pgpool:md554da49b85b7f3f2ebb9bc676182f9d69<br>
<br>
Regards,<br>
Jayadevan<br>
-----Original Message-----<br>
From: Tatsuo Ishii [mailto:ishii@<a href="http://postgresql.org">postgresql.org</a>]<br>
Sent: Thursday, May 09, 2013 4:29 AM<br>
To: Jayadevan M<br>
Cc: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
Subject: Re: pgpool - issue with md5<br>
<br>
<br>
</p>
<p class="MsoNormal" style="margin-left:24.0pt">Hi,<br>
I have been trying to get md5 authentication work with pgpool and keep running into issues (pgpool not picking the right pool_passwd file and so on). Right now, all that seems to be solved, but I am getting a "psql: FATAL: password authentication failed for
user "hbsi"" error. I am attaching the debug output from pgpool. It looks like the password from the frontend and the one in pgpool config keeps changing.<br>
An error</p>
<p class="MsoNormal" style="margin-left:24.0pt"><br>
It seems the cause of the error is apparent: you supplied wrong password.<br>
<br>
2013-05-08 18:23:51 DEBUG: pid 3317: password does not match: frontend:md54d973dd3805852de6ef2a9d15a46346d pgpool:md554da49b85b7f3f2ebb9bc676182f9d69<br>
<br>
Are you sure to give pgpool same password which is used when you created pool_passwd entry?<br>
<br>
<br>
</p>
<p class="MsoNormal" style="margin-left:24.0pt">read_password_packet_password: failed to read password packet "p"<br>
is also present.</p>
<p class="MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:24.0pt">
<br>
This is normal. psql tries to connect to pgpool with no auth and pgpool rejects it with the message, then psql retry with md5 auth.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a><br>
<br>
<br>
DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy
all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a></p>
</div>
<p class="MsoNormal" style="margin-left:24.0pt"> </p>
</div>
</div>
<br>
<br>
DISCLAIMER: <font color="#999999" size="1" face="Tahoma">"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in
error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not
liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."</font><br>
<font size="1"></font>
</body>
</html>