<html 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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0in;
background:#D7D3B7;
font-size:10.5pt;
font-family:Menlo;
color:black;}
span.s1
{mso-style-name:s1;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Never mind I forgot to reload pool_passwd<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black">"pgpool-general-bounces@pgpool.net" <pgpool-general-bounces@pgpool.net> on behalf of Wolfgang Schwurack <wolf@uen.org><br>
<b>Date: </b>Friday, May 20, 2022 at 10:06 AM<br>
<b>To: </b>"pgpool-general@pgpool.net" <pgpool-general@pgpool.net><br>
<b>Subject: </b>[pgpool-general: 8168] md5 fails to find pool_passwd update<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">I added a new user to postgres and updated pool_passwd file with the new user but when I run the command to test the new user fails to find the user in pool_passwd file. If I grep for the user in pool_passwd file it find the user.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">PostgreSQL version = 13.6<o:p></o:p></p>
<p class="MsoNormal">PgPool version = pgpool-II-4.3.0<o:p></o:p></p>
<p class="MsoNormal">OS version = Ubuntu 20.04<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="p1"><span class="s1">postgres@pgprod-01:~$ psql -h wd-pgprod -p 9999 -U was -d lportal</span><o:p></o:p></p>
<p class="p1"><span class="s1">psql: error: connection to server at "wd-pgprod" , port 9999 failed: FATAL:</span><span class="apple-converted-space">
</span><span class="s1">md5 authentication failed</span><o:p></o:p></p>
<p class="p1"><span class="s1">DETAIL:</span><span class="apple-converted-space">
</span><span class="s1">pool_passwd file does not contain an entry for "was"</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I grep for the user<o:p></o:p></p>
<p class="p1"><span class="s1">postgres@pgprod-01:~$ grep was pool_passwd</span><o:p></o:p></p>
<p class="p1"><span class="s1">was:md525160d2ca30985214a68ad92b542a6ce</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I check for the user in postgres<o:p></o:p></p>
<p class="p1"><span class="s1">postgres=# select rolname,rolpassword from pg_authid;</span><o:p></o:p></p>
<p class="MsoNormal" style="background:#D7D3B7"><span style="font-size:10.5pt;font-family:Menlo;color:#D7D3B7;background:black">was</span><span style="font-size:10.5pt;font-family:Menlo;color:black"> | md525160d2ca30985214a68ad92b542a6ce<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In pgpool.conf<o:p></o:p></p>
<p class="MsoNormal" style="background:#D7D3B7"><span style="font-size:10.5pt;font-family:Menlo;color:#3200CA"># - Authentication -<o:p></o:p></span></p>
<p class="MsoNormal" style="background:#D7D3B7"><span style="font-size:10.5pt;font-family:Menlo;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:#D7D3B7"><span style="font-size:10.5pt;font-family:Menlo;color:black">enable_pool_hba = on<o:p></o:p></span></p>
<p class="MsoNormal" style="background:#D7D3B7"><span style="font-size:10.5pt;font-family:Menlo;color:black">pool_passwd =
</span><span style="font-size:10.5pt;font-family:Menlo;color:#9F1410">'pool_passwd'</span><span style="font-size:10.5pt;font-family:Menlo;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">pool_hba.conf file<o:p></o:p></p>
<p class="p1"><span class="s1">host</span><span class="apple-converted-space">
</span><span class="s1">lportal </span><span class="apple-converted-space">
</span><span class="s1">was </span><span class="apple-converted-space">
</span><span class="s1">10.11.6.214/32</span><span class="apple-converted-space">
</span><span class="s1">md5</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">List pool_passwd file<o:p></o:p></p>
<p class="p1"><span class="s1">postgres@pgprod-01:~$ ls -l pool_passwd</span><o:p></o:p></p>
<p class="p1"><span class="s1">lrwxrwxrwx 1 postgres postgres 26 Jul 28</span><span class="apple-converted-space">
</span><span class="s1">2020 pool_passwd -> /usr/local/etc/pool_passwd</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Wolf<o:p></o:p></p>
</div>
</body>
</html>