<div dir="ltr"><div class="gmail_default" style="font-family:courier new,monospace"> The ^@ is actually a null character (ASCII Zero) [1].<br></div><div class="gmail_default" style="font-family:courier new,monospace"> As to why this character made appearance in the logs is an issue probably worth checking. Maybe you can share a line or two that contain the ^@ so that a better guess of what's happening can be done. It's possible, that you have problems with the resolver, since using TCP or loop-back (-h parameter) behaves differently than the UNIX Socket (without -h).<br><br> [1] <a href="https://en.wikipedia.org/wiki/%5E@">https://en.wikipedia.org/wiki/%5E@</a><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-11-02 20:03 GMT+02:00 Wolf Schwurack <span dir="ltr"><<a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" link="#0563C1" vlink="#954F72" lang="EN-US">
<div class="m_-2736946057812866758WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">So maybe my pgpool.conf was just corrupted I changed the parameter back ‘enable_pool_hba=on’ I’m no longer seeing any ‘^@’ in pgpool.log file. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><u></u> <u></u></span></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:black">From: </span></b><span style="color:black">"<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@<wbr>pgpool.net</a>" <<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@<wbr>pgpool.net</a>> on behalf of Wolfgang Schwurack <<a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a>><br>
<b>Date: </b>Wednesday, November 2, 2016 at 10:26 AM<br>
<b>To: </b>"'<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>'" <<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>><br>
<b>Subject: </b>[pgpool-general: 5098] Re: pgpool.log file<u></u><u></u></span></p>
</div><div><div class="h5">
<div>
<p class="MsoNormal"><span style="font-family:"Times New Roman""><u></u> <u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt">I found the issue</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">If “enable_pool_hba = on” in pgpool.conf then I get “^@” sign in pgool.log file when connecting. If “enable_pool_hba=off” I don’t get “^@” signs in pgpool.log file.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Is this how this should work? Having a bunch of “^@” in the pgpool.log file makes it hard to troubleshoot issues when trying read pgpool.log.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:black">From: </span></b><span style="color:black">"<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@<wbr>pgpool.net</a>" <<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@<wbr>pgpool.net</a>> on behalf of Wolfgang Schwurack <<a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a>><br>
<b>Date: </b>Wednesday, November 2, 2016 at 10:02 AM<br>
<b>To: </b>"'<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>'" <<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>><br>
<b>Subject: </b>[pgpool-general: 5097] Re: pgpool.log file</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Times New Roman""> </span><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt">I notice that ‘data’ pgpool.log contants ‘^@^@’ When I remove ‘^@^@’ from pgpool.log Then it shows the file as ASCII.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">We use watchdog on our pgpool servers</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">To recreate – When using psql with the watchdog connection command it puts ‘^@^@’ signs in pgpool.log file but if I psql on the postgresql host it doesn’t put the ‘^@’ sign in the log file.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">This only happens on my development and test hosts</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">All of our applications connect using watchdog connection command</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">From pgpool hosts connecting to postgres - I get ‘^@’ sign into pgpool.log file</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">$ psql –h wd-pgdev –p 9999 </span>
<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">From postgresql host connecting to postgres – no ‘^@” sign into pgpool.log file</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">$ psql </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Wolfgang Schwurack</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Database/System Administrator</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Utah Education Network</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt"><a href="tel:801-587-9444" value="+18015879444" target="_blank">801-587-9444</a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="mailto:wolf@uen.org" target="_blank"><span style="color:#0b4cb4">wolf@uen.org</span></a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:black">From: </span></b><span style="color:black">"<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@<wbr>pgpool.net</a>" <<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@<wbr>pgpool.net</a>> on behalf of Wolfgang Schwurack <<a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a>><br>
<b>Date: </b>Wednesday, November 2, 2016 at 9:11 AM<br>
<b>To: </b>"'<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>'" <<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>><br>
<b>Subject: </b>[pgpool-general: 5096] pgpool.log file</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Times New Roman""> </span><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt">My development pgpool server the pgpool.log file show that it’s a binary file but on my production pgpool server show the file as ASCII. Both servers are setup the same.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Anyone know why one file is binary and the other is ASCII?</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I use the same command on both to start pgpool</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">pgpool -n -D -f /usr/local/etc/pgpool.conf > /var/log/pgpool/pgpool.log</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Version</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">pgpool-II version 3.5.4 (ekieboshi)</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Host </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Ubuntu 14.04.5 LTS</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Production server</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"># file /var/log/pgpool/pgpool.log</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">/var/log/pgpool/pgpool.log: ASCII text</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Development server</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"># file /var/log/pgpool/pgpool.log</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt">/var/log/pgpool/pgpool.log: data</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Wolfgang Schwurack</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Database/System Administrator</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">Utah Education Network</span><u></u><u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt"><a href="tel:801-587-9444" value="+18015879444" target="_blank">801-587-9444</a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="mailto:wolf@uen.org" target="_blank"><span style="color:#0b4cb4">wolf@uen.org</span></a></span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div></div></div>
</div>
<br>______________________________<wbr>_________________<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/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>