Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lcI8B-0000gD-Jb for pgsql-admin@arkaria.postgresql.org; Fri, 30 Apr 2021 01:39:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lcI8A-0004bd-HV for pgsql-admin@arkaria.postgresql.org; Fri, 30 Apr 2021 01:39:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lcI8A-0004bW-79 for pgsql-admin@lists.postgresql.org; Fri, 30 Apr 2021 01:39:46 +0000 Received: from sonic305-22.consmr.mail.ne1.yahoo.com ([66.163.185.148]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lcI87-0005Ku-Fe for pgsql-admin@lists.postgresql.org; Fri, 30 Apr 2021 01:39:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1619746779; bh=FwZSZZxJAqwK5t2cpwo+hyBix3EeP23LUCWHRpt9PRs=; h=Date:From:Reply-To:To:Subject:References:From:Subject:Reply-To; b=fESsuaB6KOYBRZAPNgubCDO6f90Lkp63d5KZMlC7zIxSI8WPIEj0wX3IOrMwGcdT/gm85OaCg8cDmvbjgg/7SqmT90MHdPMqTfu1OZcaviTbx0QfilfdNvu43qHHUrNkZuguyKtJxZ3X5WrawyzO/sk8UxWtQ+hxuqaKr1FfXMX2NGvdlf8Ll31UaOYPynLHWy8CYkrEjQY0L4GPBjm31xeVU31sY90C7+8x/iJLLkAwaE/awOyiDv3zN65+GEIlkYL3d+EGd/uP8u3OQRL7Yi9ZG9KSSis8XNX7BWPjiXnwHdmHG5ne91B7X4vQjQCtHzAI5qSxZ1cUdy6USBjN/Q== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1619746779; bh=lRtpY1TdS9UhO8AF1ON/RW5/xL1hmFqyl7vKGkcRz5j=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=F2zQicYPp+anDjEEro7i4pp3uxTEoZllHW2eTxTchuqNDw/EV2vTOx7w8ouwfcolIgNUKsPxNzNZp/hFY9MZwZXVJTSXROq6eyEPZBZ3hFHODc2z+HUgZHpAnqgI3RjFxQAdd7thUtt2OTLjr1nMjy7yzTur17UNgp0aSU5rOFzVTfzMTqIn2Jxe6wHAkcxYUjw8FJGRzTJeSRw9bV9xX48sSrOxBLLlgblcv1bQxoMwI4yVLzLacc4T3rfnVufeND+utAuAzeoU/eHBVlehEwWYoHdlQH5ogVjP/Oq7x/W/cTn4nPYbVxzGWZzj39OzXI4JHJq5+7RLQXZLdeaf5g== X-YMail-OSG: My7B2KsVM1nUNhYL92JPfCPEZ.Em1DcAAs7mrGojE.R_hmXGY6DNM33aJqbyPVK 8FM7609D7aqGL5WRFQLraacUcKCGgH.P0.FjY3hK6rA_0NMYEfPIHH3u2UiwU35SQrhuJkt23_m5 1gbxY8xlSC_Tm6OSpBMVaBxrqqmFzvm8soWe5ocD4lhR3Rd0cm1Tk7x00XqSG9NM5O_V2xIAcNu. 3DLQakRLbvZyx2654yJedfimbpJvEvlv3LEqXO4X_rV88PQk3.xeFIcjR9BkLM5tTZjUe76zvm6D rCOVi_.2ZI1je1CxnSRMx9sWzIYJX6Bg1mljcPxfKie41C0eZhdzeo5SlhiexQ6H_lxSsZMXCUyZ ou684WB.MGnE4lENfiTqZmprCtm0e1rQ0C0.TVE_6Qv.RQM4_if5EvF5KX1nXfiSNq9QOope1DWC smIvTOppbQDkJUS1.vXP3s1Pw4zTJL8yxZgQ7mLm1dl1uqH25qEnKQd8Ucrd8dnJkG75Ys1cye6V NSWKdZd9L8tf3.Up0HTsWBZkcPIrMcX0hMYvhOAB0k2XPVkrfCSM1R9qs85WzSsUKk8lUeSVrLcn GuqO0bm0LqDlNKvHFKPNfn41G0jZLI0uVXQe6b15Xv8ppoD9184UrfxMizMoHFSBF4vqqPiYBejM 2dDuS2XfkoB3rwLhessWmmhy5z96.liJZtjSdubWky.WySz.oX07wLeWgxqmkhwJzL11tA8pMhUO Z0x82Py6BP3AuUnpr7gyE6wXeHlXQFvGF9eMwEHTb7ZvyePiXEr641eUCoEW7P33hfzrOdyCHxn0 d6LAoVcNSl04165ZjK648b2weTrU.VrHBBU96W2XQvHZGpKwEs0PB7GFVTC5.ofQSsfD4O09EHoN RwUxv6bQlbDQbV2x7RRpBU8e4mWcB3pGodj9X5ADI_41LkWiFlOYm1MY5u7rUZuCYIBk_GyH1KA3 khAMbrixj7DDIAYT.4mki9iQ6IG0UdUbJyOoYSQVj52HZUspjEn_66d_wbR0kMRtsmXNEWw7vN7k bE6Trj45Eo1vuaVCcrRuws5iqiThUXDbE4rPbaenep6xAO2VMG2oefPZYsSxBH7Y8zPSu7kY3g6i kOe0HDlxCTSWTs20GraSfAJLunvIScCf32BqJOia4fTS0aqH672vxRLnyVB09wlcqdYRHxMemc1f 2vCgkHfY3PhkiOPkDRP4v0WLL3iI8NT44ahWJ4P86V0PEotEdr7bhZo9umFFkWE65TH0nRI9xILW 9r62yMURoKXy0FMN3V.laHjtLwpQKoAt3ylphDgZNEh31MWRFVt4UNKbxE0ABWaVSSUtIJHwtrUg WYOJqbj_2HaMlpy7svmT_w_GXb0iOpeTPN8MOqyb50Nbfb_CYU5tyqyw2LADn1ZjjAeiZEV7zlVY Y9wsREtALxs1_m0e_oR7rte1P_wyHieBB291wtn8Fwgp913ZDSnmD1Sma.CZN6x4GwLNvndrk7H6 By0ExayayXL_p0DDeyrJUQO7n9CtrjF3O0NoQEcxbqCN8PnPkofWVHyids5rydmoe7U5BrCy_vyU WtFKapfW3ROPk9RqQp1HorLWR2Fa2NaOZy5cStwW7JdZuEVCjJ.4UWhd.eoT180cPgDTQjYNWNFU unELGD7M2DfjMhT.12qbCwGv7dhGCCjBlfuzrNCJ9s1K5tisqTNTMx.F9IxS3fKJ8POA0MlxE.4x X8XIAxwwCfqc9d6ayhNnKBobFc4p9zP6ROFALu.xOcFcYMcJhuSxdaMTshCWIG92NXsyyyQukKfm H1P4hpnu.cGAXywI9ZIISu5MM8r.9eEF.iPHmQn2FNI8Zx_5yDYuvmmALz3oA3wW1pjDYmkRxc6p 7ArNePaB8CQU8MiahGXl2aD50LAI0hMupTvYxYz3wg.zVtzHl8Y1Z58VF9Tpc9Kc9PopfjdCd8uF fJQBK.wsBdUoUod_d5VrPQ_vAKLfEhS57fc.POPnXKzfyR4wHhF8Vjlmmkvc_gbYfY3wRVXZ6JGO 34rKe_GX1BOF.mESUXcijWy8.4Vve.Jo14h0y2YmPPXjQDNmAGq0pQko1955gQcjyJOmzo2ncgEc q9MTE2tGerx1i.WH7moV55TU_ApWNhPdcSgcYJa6JyR2LnW9PWh2wMd8u.qcMNpsUVlpnkDltP.z wpChUfmRSEbWc8qo7HKalnNEj8zcNCz2wMV.fIbqoh3U_RYTE_D18Xq9xETpX_mzXEGFgb9T8vq1 5.N4KT00tUTh6Jgzx4uMGcVB8MWhrCLLT2rt026cwtR6oq3knpjdAi_vyJWA6tiSad_gMNsO1V0. kARD7AD5AFJUgyLSpWcaIYzlPmImaVRMsQXJg338W8WHUWRkmEIfCdSYdmKxVMMPT8pidrSIetwb uQgVop4Qs275rHVf2csLn.Wcje6.LheGxuBn4ghbr2oSYpdXP3JYf_Q.EmuzEleWxPW1mWfj96dy .RGPccylB5_aJkPtDF0mQdETWyjs7w_NZB5JydZpTRi2TSdOetd92DcaGGCBdz96B3px8yOc7Dow WiEjvMXebAwSc66MZxD4sVaf4E_m4tii0NjhH9A7USlmw4g-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.ne1.yahoo.com with HTTP; Fri, 30 Apr 2021 01:39:39 +0000 Date: Fri, 30 Apr 2021 01:39:36 +0000 (UTC) From: james terris Reply-To: james terris To: "pgsql-admin@lists.postgresql.org" Message-ID: <1566938499.2834154.1619746776214@mail.yahoo.com> Subject: FATAL error in logs: no pb_hba.conf entry MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2834153_2019893340.1619746776213" References: <1566938499.2834154.1619746776214.ref@mail.yahoo.com> X-Mailer: WebService/1.1.18138 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36 Content-Length: 4745 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2834153_2019893340.1619746776213 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello,I have a postgres version 9.6 server running on and old Windows Serve= r 2008 R2 server. I noticed this message in the logs: FATAL: no pg_hba.conf entry for host "::1", user "APPSERVER$", database "po= stgres", SSL off It's true that I don't have a row for the the "APPSERVER$" user but I'm not= really sure where that user is coming from. It's the server name and it's = only trying to log in via IPv6 ? If someone could give me some more details about why is causing that log li= ne that would be great. I have other servers configured without that line i= n pg_hba.conf and they don't have that FATAL message. My pg_hba.conf looks like this: host=C2=A0 =C2=A0 all=C2=A0 =C2=A0postgres=C2=A0 =C2=A0 127.0.0.1/32=C2=A0 = =C2=A0md5host=C2=A0 =C2=A0 anotherDB=C2=A0 =C2=A0anotherUser=C2=A0 =C2=A0 1= 27.0.0.1/32=C2=A0 =C2=A0md5 host=C2=A0 =C2=A0 all=C2=A0 =C2=A0postgres=C2=A0 =C2=A0 ::1/128=C2=A0 =C2= =A0md5 host=C2=A0 =C2=A0 anotherDB=C2=A0 =C2=A0 anotherUser=C2=A0 =C2=A0=C2=A0::1/= 128=C2=A0 =C2=A0md5 thank you,james BTW, I'm new to this mailing list, if I have the wrong one please update me= . ------=_Part_2834153_2019893340.1619746776213 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,
I have a postgres version 9.6 server running on and old Windows Serv= er 2008 R2 server.

I noticed this message in the logs:

FATAL: no pg_hba.conf entry for host "::1", user "APPSERVER= $", database "postgres", SSL off


It's true that I don't have a row for the the "APP= SERVER$" user but I'm not really sure where that user is coming from. It's = the server name and it's only trying to log in via IPv6 ?

If someone could give me some more details about why is causing that log l= ine that would be great. I have other servers configured without that line = in pg_hba.conf and they don't have that FATAL message.

My= pg_hba.conf looks like this:
<= br>
host    all =  postgres    127.0.0.1/32   md5
host    anotherDB   anotherUser    12= 7.0.0.1/32   md5
host&= nbsp;   all   postgres    ::1/128   md5<= /span>
host    anotherDB    anotherUser    ::1/128   md5


thank you,
james

BTW, I'm ne= w to this mailing list, if I have the wrong one please update me.
------=_Part_2834153_2019893340.1619746776213--