<p dir="ltr">Hello<br>
You can check pgpool log and postgresql log when you run that psql command.<br>
Regards.</p>
<div class="gmail_quote">On Apr 6, 2016 8:30 PM, "Daniel Gallo" <<a href="mailto:danielito.gallo@gmail.com">danielito.gallo@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial">Dear I'm trying to run
the following and I get the following error and I can not figure out what the
problem is , I could help ?</span><span lang="EN-US" style="font-family:Arial,sans-serif;background-image:initial;background-repeat:initial"></span></p>
<p class="MsoNormal"><span lang="EN-US"><br>
</span><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial">Any information that need be notified
me and sent them</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial">Thanks a lots!!!!!</span><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal">-bash-4.2$ psql -h localhost -U postgres -p 5432</p>
<p class="MsoNormal">psql (9.4.4)</p>
<p class="MsoNormal">Digite «help» para obtener ayuda.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span lang="EN-US">postgres=#</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US">-bash-4.2$
psql -h localhost -U postgres -p 9999</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US">psql:
ERROR: unable to read message length</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US">DETALLE:
message length (12) in slot 1 does not match with slot 0(8)</span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal">Any idea?</p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><u>pg_hba.conf</u></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># TYPE DATABASE USER
ADDRESS
METHOD</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># "local" is for Unix domain socket connections
only</p>
<p class="MsoNormal">local all
all
md5</p>
<p class="MsoNormal"># IPv4 local connections:</p>
<p class="MsoNormal">host all
all <a href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a>
md5</p>
<p class="MsoNormal">host all
all <a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a>
md5</p>
<p class="MsoNormal"># IPv6 local connections:</p>
<p class="MsoNormal"># Allow replication connections from localhost, by a user
with the</p>
<p class="MsoNormal"># replication privilege.</p>
<p class="MsoNormal">local replication postgres
trust</p>
<p class="MsoNormal">host replication replication
<a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a>
trust</p>
<p class="MsoNormal">#host replication postgres
::1/128
trust</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-rwxrw-r--. 1 apache apache 33283 abr 1 15:49
pgpool.conf</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><u>pgpool.conf</u></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># - Authentication -</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">enable_pool_hba = on</p>
<p class="MsoNormal">
# Use
pool_hba.conf for client authentication</p>
<p class="MsoNormal">pool_passwd = 'pool_passwd'</p>
<p class="MsoNormal">
# File
name of pool_passwd for md5 authentication.</p>
<p class="MsoNormal">
#
"" disables pool_passwd.</p>
<p class="MsoNormal">
# (change
requires restart)</p>
<p class="MsoNormal">authentication_timeout = 60</p>
<p class="MsoNormal">
# Delay in
seconds to complete client authentication</p>
<p class="MsoNormal">
# 0 means
no timeout.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">
</p>
<p class="MsoNormal">-rw-r--r--. 1 apache root 42 feb 29
18:28 pool_passwd</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">postgres:5c0435eee0f211f150e980e459151xxx</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-rwxrw-r--. 1 root root 3295 mar 3
18:19 pool_hba.conf</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># TYPE DATABASE USER
CIDR-ADDRESS METHOD</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># "local" is for Unix domain socket connections
only</p>
<p class="MsoNormal">local all all
md5</p>
<p class="MsoNormal"># IPv4 local connections:</p>
<p class="MsoNormal">host all all
<a href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a>
md5</p>
<p class="MsoNormal">host all all
<a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a>
md5</p>
<p class="MsoNormal">#host all all
::1/128
trust</p></div>
<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" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div>