<html><head></head><body>Software versions are the same on both systems:<br>PostgreSQL 12.2<br>Pgpool 4.1.3<br><br><div class="gmail_quote">On 18 September 2020 02:31:11 EEST, Anssi Kanninen <anssi@iki.fi> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">Hello,<br><br>My Pgpool doesn't work on RHEL 8.2.<br><br>Eveythins runs smoothly on my Centos 8.1.1911 virtual machines but when I <br>transfer the same Pgpool/PostgreSQL configuration to customer's RHEL 8.2, <br>I can not connect to Pgpool via TCP/IP.<br><br>Here is a clip of my log on Centos when I successfully fail to <br>authenticate (x.x.x.x is a wrong interface, so this error is expected).<br>So, "user" and "database" are show in the log.<br><br>Sep 16 16:04:35 centos8i1 pgpool[6616]: [33-1] pid 6616: ERROR: failed to authenticate<br>Sep 16 16:04:35 centos8i1 pgpool[6616]: [33-2] pid 6616: DETAIL: no pg_hba.conf entry for host "x.x.x.x", user "pgpool", database "postgres", SSL off<br><br>Here is log of successful connection. Protocol Major is 3 and Minor is 0.<br><br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [26-1] pid 27853: DEBUG: reading startup packet<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [26-2] pid 27853: DETAIL: application_name: psql<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [27-1] pid 27853: DEBUG: reading startup packet<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [27-2] pid 27853: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: pgpool<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [28-1] pid 27853: DEBUG: creating new connection to backend<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [28-2] pid 27853: DETAIL: connecting 0 backend<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [29-1] pid 27853: DEBUG: creating new connection to backend<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [29-2] pid 27853: DETAIL: connecting 1 backend<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [30-1] pid 27853: DEBUG: creating new connection to backend<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [30-2] pid 27853: DETAIL: connecting 2 backend<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [31-1] pid 27853: DEBUG: authentication backend<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [31-2] pid 27853: DETAIL: auth kind:10<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [32-1] pid 27853: DEBUG: authentication backend 0<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [32-2] pid 27853: DETAIL: trying SCRAM authentication<br>Sep 18 02:07:28 centos8i1 pgpool[27853]: [33-1] pid 27853: DEBUG: SCRAM authentication successful for backend 0<br><br>So, the above works.<br><br>But then I transfer the same configuration to the customer's RHEL 8.2, the <br>same connection attempt shows this:<br><br>Sep 18 01:48:31 haketikuqadb01 pgpool[348681]: [262-1] pid 348681: DEBUG: I am 348681 accept fd 8<br>Sep 18 01:48:31 haketikuqadb01 pgpool[348681]: [263-1] pid 348681: DEBUG: reading startup packet<br>Sep 18 01:48:31 haketikuqadb01 pgpool[348681]: [263-2] pid 348681: DETAIL: Protocol Major: 1234 Minor: 5680 database: user:<br>Sep 18 01:48:31 haketikuqadb01 pgpool[348681]: [264-1] pid 348681: FATAL: client authentication failed<br>Sep 18 01:48:31 haketikuqadb01 pgpool[348681]: [264-2] pid 348681: DETAIL: no pool_hba.conf entry for host "x.x.x.x", user "", database "", SSL off<br>Sep 18 01:48:31 haketikuqadb01 pgpool[348681]: [264-3] pid 348681: HINT: see pgpool log for details<br>Sep 18 01:48:31 haketikuqadb01 pgpool[348612]: [46-1] pid 348612: DEBUG: reaper handler<br>Sep 18 01:48:31 haketikuqadb01 pgpool[348612]: [47-1] pid 348612: LOG: child process with pid: 348681 exits with status 512<br><br>Protocol Major and Minor numbers look strange and why the database name <br>and user name are empty? Did it fail to read the incoming packet for some <br>reason? The connection was local but thru TCP/IP network interface. Linux <br>firewall was used but same ports were open on both clusters. SELinux is in <br>use.<br><br>Psql client responds like this:<br><br>psql: error: could not connect to server: server closed the connection unexpectedly<br> This propably means the server terminated abnormally<br> before or while processing the request.<br><br><br>Here is my pool_hba.conf:<br><br>local all all trust<br>host all all 127.0.0.1/32 trust<br>host all all ::1/128 trust<br>host all pgpool samenet scram-sha-256<br>host all postgres samenet scram-sha-256<br><br>My pool_passwd looks like this:<br><br>postgres:AESmyencryptedpassword==<br>pgpool:AESmyencryptedpassword==<br><br>The psql command was as follows and the password was correct:<br><br>$ psql -h x.x.x.x postgres pgpool -w<br><br>So, something is different on our RHEL but what?<br><br>Best regards,<br> Anssi<hr>pgpool-general mailing list<br>pgpool-general@pgpool.net<br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></pre></blockquote></div></body></html>