Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qadLQ-009wZe-3Z for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 14:35:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qadLP-00Cy4b-0p for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 14:35:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qa4z6-00E6Up-Gj for pgsql-general@lists.postgresql.org; Sun, 27 Aug 2023 01:54:36 +0000 Received: from mail-os0jpn01olkn2082d.outbound.protection.outlook.com ([2a01:111:f403:700c::82d] helo=JPN01-OS0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qa4z2-0019dw-Du for pgsql-general@lists.postgresql.org; Sun, 27 Aug 2023 01:54:34 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ZEVPrB2iRMoXk0MJ/O7URS3+f0uhLTG/KxCNMiykUhluShw7o2F9YSAD6jdbIpsYPxsoZftvFMiAp68UhpjXRGw1y1RBC/L7fR+39UT7Xq0U8efZx49LSooqERzkgiWJUb6ff31nYJLEZNKEXLx+KKvKUFBw8OeTjuqhWlK6OdyWWJLD7Seq5CFdAHdhSyQX9a4ns3PVRKvnTnwq+BTiLIHHn0WfisP5Jf/3nZKZM5IsvYtN5ZJTAxdqxZdXKdDaglSu8shLsUBs04k6bF+alFTzcomwzLRvNCAF+0ruA+Rfb0DuV/+JnEY3r6eA8GqBhTriF9oRIFC1yMzvwOte0g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=vHNlAyJMRSd3WTbHm2vpH+q7tHAoHCvsL+7t+X8sFhA=; b=KUy4+AI0IQPwzWhvL110HCmSvwZ/fsm7gzohiCdyayKP1uQyTQDpIpR9TucxxEQKjZtEqAm7FxWbu3Ihrm8+44aY5VEYnMh/DRbx+tKjTyOWbS8VJuNH2BVe1Ys6tOluPwp7M6xGSfv0ZxaY1Q2RS3P9KwpwlhlJDksk+IopVvzLBME8rEMy9fyX+2ZuwsH7wifbrDlqeQWnWGaaKTNnJ9bXUg7UJQH+MCRxvYy+PZ59n2jeXiHjoOI4CxAW4g6rjoZMnGHG+Q+g4OXhGoA1Zi7haXebiaK71pdn54xB1omwkcgGJPw1NCGwbGqoj3eZ8nKqWMm5O/JBNgm+gJBhFQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none Received: from OS3P286MB1933.JPNP286.PROD.OUTLOOK.COM (2603:1096:604:172::13) by TY3P286MB3692.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:3d3::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6745.12; Sun, 27 Aug 2023 01:54:25 +0000 Received: from OS3P286MB1933.JPNP286.PROD.OUTLOOK.COM ([fe80::d783:37c8:a9f1:a49e]) by OS3P286MB1933.JPNP286.PROD.OUTLOOK.COM ([fe80::d783:37c8:a9f1:a49e%3]) with mapi id 15.20.6745.011; Sun, 27 Aug 2023 01:54:25 +0000 From: pan snowave To: Alban Hertroys CC: "pgsql-general@lists.postgresql.org" Subject: =?gb2312?B?u9i4tDogaWRlbnQgYXV0aCBkb2VzIG5vdCB3b3JrcyBhcyAgdXN1YWw=?= Thread-Topic: ident auth does not works as usual Thread-Index: AQHZ1/8shiIPXKW4tkOIc0wYkrf9LK/8YuoAgADnYkY= Date: Sun, 27 Aug 2023 01:54:25 +0000 Message-ID: References: In-Reply-To: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [9WfNNYu/iJs2yw1HRpJWnaoQ8PvTPxXC7yUSvXE6Z6s=] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OS3P286MB1933:EE_|TY3P286MB3692:EE_ x-ms-office365-filtering-correlation-id: 77ccf5c4-5d53-43ca-84a1-08dba6a08ac9 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: +FTqn16OnLy1Al73dVhEqqXoQA5nZIkVqUThZa3sGriBcvISUx0Ezx7CPxXeivPrnhLwDkAxF3ScUAC4O+39oHdSPuwDYxB9/p+eT6kD1zng/0WWcwGJZUP+GHjxv3rH3Bo/EE4mIZCxLTgNnzwqB/N/JnuMw3m9HO3GEV+BWCiXcgdO47rmVekjcu4lRwaerVh3Jcc99YpAODq4KB0pRDvAoC7+IqJPw6bu5uPMJTQx2ruxoY7IHvZSkT7yGcELkLbiraJDqUpvgdVZTMiIbPn5uNLQ7caGJXQCnE/Nz30r05lE5XSmg0lw12b7Upw1/srNgPN3Wj+1TM1BFLJKxWUMF1hPWJY4831q0HLW75LgruXVsbFC3nXgaDRg7UoCQO5vTHzZ3ngW1TkfLtBS/kiFzWW8L3qYEbDK93bozOPVIvhtW/Cvn0s6wNk0S18TuQ6cZXWM5m4etX9jXxtGDCAihxZL6Q5dC+ZWVdGVbMpM2/iQfdUGYiQovsNhfzjVhfimkFfM+YJBNcjwavWmfIW3vriY9CVs6Jk5O1XTdrnPoQYG+uNKkaH1aSloc1XU x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?gb2312?B?RHorRXlVclhDZk1QZHRlQVF5TFVjbDBqb3UrWmloS0JZRUhyS0gyd0pIZThH?= =?gb2312?B?UFY2UXdEbHJ3K1J3algzRTZjTzhMRjZ6b3prb3l0NDFteDJrL2VWd25MZHRQ?= =?gb2312?B?RXhmZzUzNklFMUgyNitEeG1PU3lackRkOGIyd29xVG1IOVBtY3hsZ0JnRWxO?= =?gb2312?B?NnMrRTVUajBqV1pXZHM3SUhTRmNXaDZFdTFuNHJKT1l3akpGZFRWUXdtOHV5?= =?gb2312?B?YlhsNWNMbmtpRmxPRE9mNGRCY29VRkVrZHZKWjBKcWpWODNPYkE4WS9Ga2Za?= =?gb2312?B?bk1EdlRDUkZCVmdicFlDYTYxWDJ1dDZiSkJvMEoweFR3N0NMZ1ArcndYL2xN?= =?gb2312?B?YUVYV3JhTFNXTVFzY2dyckhCV3BjazBOVndtdVp5MFY3cE5wWTFsTEdRK0xo?= =?gb2312?B?dkRHZHhROVY5SjRCQXZjRm5mWHZSVUhsS29xd0dwMk5PQ0ViRTdmaVhmMDBj?= =?gb2312?B?UzJZdXJlbW5TRmthc0ZoUk1aaEpaUjIzK0pRV0NrdkMxUUQybmVxaHkvU2hZ?= =?gb2312?B?YVpFRUpvbGJJNC8yUjNJa3lyTFhCNFdOMjZXOS9PNmNvR2swQWNaODMvZWJI?= =?gb2312?B?dDJrdytCVDlhTldFc3VSeWczTTN3MitLTzk3bjMzeHNwbWlIc3diQW81N28x?= =?gb2312?B?T3U1aWY0L3VJekVOVmZRMW9TM1V4Zk5jNU53SGlGYnZkSWtNRjZhNjlNNzJy?= =?gb2312?B?LzVtTGZtNzZkakNhZTRKOXhMMWdkdFhmbkVZOVpwMlllRzBSWlZhSTFLM2tX?= =?gb2312?B?YTBIbjhSaTVtd0RGNnVwOE9ZSWt2dVBUdk81QVhWRUhYTkVuQ003dVl1Vmo1?= =?gb2312?B?MnJTU2V3Q3pYc28xSWFxL29JVGxWaGZ1dFBQYkVLT0FhdExHRXpOYk82MWVK?= =?gb2312?B?akFGQTVidlFXdVlTMDh3dlBEYklqQjVkZDVMaDRkUFlLN2Fob1daNTdITFRx?= =?gb2312?B?dmRZbUxQd3VDR1VabU1KUXJCdVpPbUNOc0wyZExjWmc1Q3IrWXJpb1UyNDRP?= =?gb2312?B?ZjhRaXRtRG9ubXY5VnNJSWd2aU9qT2U0dE1SKzdZUFJvY1JpdUZkZFR2QjFm?= =?gb2312?B?a2ZZRlpQemVQb1JhVFBSN0g1c3JPbkJSR3A4TG1VS1c0UXU5Y2NsUEVEbGdR?= =?gb2312?B?eFE2UDBHa3pKUGZ4TDg2QnBNM0NwOHRNZytObXo1cTJyc29Bd2FTWi94Mys0?= =?gb2312?B?N2xHeEV0TmFQbC9WeTZLTXBiRjhYTkFuUGRLL2luWGN2VlM5QU83eEVlR0t3?= =?gb2312?B?QnFYcGtHSk9xMGtVNkppQXhqZnB0NjRld2thU2w2UFQ2Wm5BRUxIc3NYZ2Vn?= =?gb2312?B?cmpQeFBMSFBwTVdUSXo5MnBLa1pIaWJGMmJTUW5iSW54L2xzSjYrYzNqN3FX?= =?gb2312?B?RXFIZ2tKRCs0cVo0c3YxVmhvc1dTNGozS0pheDNNRDU4d1pveklJNWNjcW1E?= =?gb2312?B?L1FHWmdyTDBwY21tNU4vNWc2OWZabUdGRnNzeXNqd1BoU0hab00zMzlaTVhy?= =?gb2312?B?Qm1vLzJTWXhnT3o3L1I2RGVzMnpzb1p4cEgvRUtNUndoMnpuQUJZVFRkQVJI?= =?gb2312?Q?GjL2KwVzLtHZd8Di8oBaeW79Qr3tmXKDyDk6UustzktuQR?= Content-Type: multipart/alternative; boundary="_000_OS3P286MB193327FB105CD72F695D0946D3E1AOS3P286MB1933JPNP_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-05f45.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS3P286MB1933.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 77ccf5c4-5d53-43ca-84a1-08dba6a08ac9 X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Aug 2023 01:54:25.6476 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY3P286MB3692 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_OS3P286MB193327FB105CD72F695D0946D3E1AOS3P286MB1933JPNP_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 SGksDQoNClNvcnJ5LCAgIHRoZSBuYW1lIG9mIGlkZW50IGZpbGUgIHRoYXQgaSB1c2VkICBpcyB3 cm9uZywgIGl0IGlzIHBnX2lkZW50LmNvbmYgKHRoZSBzYW1lIGFzIHlvdSBzYXlzo6kNCg0KQW5k LCBJIGZvdW5kICBwZ19pZGVudC5jb25mIHdvcmtzLCBiZWNhdXNlICBpIGNhbiBmb3VuZCBpZGVu dCBlbnRyeSBpbiBwZyB2aWV3cyAsDQoNCiBsaW5lX251bWJlciB8IG1hcF9uYW1lIHwgc3lzX25h bWUgfCBwZ191c2VybmFtZSB8IGVycm9yDQotLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0t LS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0NCiAgICAgICAgICA0MyB8IHRlc3QgICAgIHwgcm9v dCAgICAgfCBjY2UgICAgICAgICB8DQoNCkJ1dCB3aGVuIGkgY29ubmVjdCB0byBwc3NlcnZlciBi eSB1c2luZyBvcyB1c2VyIHJvb3QNCi91c3IvbG9jYWwvcGdzcWwvYmluL3BzcWwgICAtcDU0MzIg LWQgZGIxICAgICAtaDEyNy4wLjAuMQ0KcHNxbDogZXJyb3I6IGNvbm5lY3Rpb24gdG8gc2VydmVy IGF0ICIxMjcuMC4wLjEiLCBwb3J0IDU0MzIgZmFpbGVkOiBGQVRBTDogIElkZW50IGF1dGhlbnRp Y2F0aW9uIGZhaWxlZCBmb3IgdXNlciAicm9vdCINCg0KSSBoYXZlIGNoZWNrICBjb25maWcgZmls ZXMgbWFueSB0aW1lcywgIGV2ZXJ5dGhpbmcgaXMgcmlnaHQsIGFuZCBoYmEgY29uZmlnIGZpbGUg Y29udGVudCBpczoNCg0KIyAibG9jYWwiIGlzIGZvciBVbml4IGRvbWFpbiBzb2NrZXQgY29ubmVj dGlvbnMgb25seQ0KbG9jYWwgICBhbGwgICAgICAgICAgICAgYWxsICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIHBlZXINCiMgSVB2NCBsb2NhbCBjb25uZWN0aW9uczoNCmhvc3Qg ICAgYWxsICAgICAgICAgICAgIHJvb3QgICAgICAgICAgICAgMTI3LjAuMC4xLzMyICAgICAgICAg ICBpZGVudCAgICBtYXA9dGVzdA0KaG9zdCAgICBhbGwgICAgICAgICAgICAgYWxsICAgICAgICAg ICAgIDEyNy4wLjAuMS8zMiAgICAgICAgICAgIHRydXN0DQojIElQdjYgbG9jYWwgY29ubmVjdGlv bnM6DQpob3N0ICAgIGFsbCAgICAgICAgICAgICBhbGwgICAgICAgICAgICAgOjoxLzEyOCAgICAg ICAgICAgICAgICAgbWQ1DQojIEFsbG93IHJlcGxpY2F0aW9uIGNvbm5lY3Rpb25zIGZyb20gbG9j YWxob3N0LCBieSBhIHVzZXIgd2l0aCB0aGUNCiMgcmVwbGljYXRpb24gcHJpdmlsZWdlLg0KbG9j YWwgICByZXBsaWNhdGlvbiAgICAgYWxsICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIHRydXN0DQpob3N0ICAgIHJlcGxpY2F0aW9uICAgICBhbGwgICAgICAgICAgICAgMTI3LjAu MC4xLzMyICAgICAgICAgICAgdHJ1c3QNCmhvc3QgICAgcmVwbGljYXRpb24gICAgIGFsbCAgICAg ICAgICAgICA6OjEvMTI4ICAgICAgICAgICAgICAgICB0cnVzdA0KDQoNClRoYW5rcy4NCg0KX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCreivP7IyzogQWxiYW4gSGVydHJveXMgPGhh cmFtcmFlQGdtYWlsLmNvbT4NCreiy83KsbzkOiAyMDIzxOo41MIyNsjVIDEwOjM4DQrK1bz+yMs6 IHBhbiBzbm93YXZlIDx3aW5keHBATElWRS5DTj4NCrOty806IHBnc3FsLWdlbmVyYWxAbGlzdHMu cG9zdGdyZXNxbC5vcmcgPHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+DQrW98zi OiBSZTogaWRlbnQgYXV0aCBkb2VzIG5vdCB3b3JrcyBhcyB1c3VhbA0KDQoNCj4gT24gMjYgQXVn IDIwMjMsIGF0IDExOjMxLCBwYW4gc25vd2F2ZSA8d2luZHhwQExJVkUuQ04+IHdyb3RlOg0KDQoo oa0pDQoNCj4gcGdfaW5kZW50LmNvbmYNCj4NCj4gdGVzdCAgIHJvb3QgICAgY2NlDQoNCklmIHRo YXQgaXMgaW5kZWVkIHRoZSBuYW1lIG9mIHRoZSBmaWxlLCB0aGF0IHdvdWxkIGV4cGxhaW4geW91 ciBwcm9ibGVtLiBObyBkb3VidCB0aGF0IGl0IHNob3VsZCBiZSBuYW1lZCBwZ19pZGVudC5jb25m IGluc3RlYWQsIHdpdGhvdXQgdGhlIKGvbicuDQoNCkFsYmFuIEhlcnRyb3lzDQotLQ0KSWYgeW91 IGNhbid0IHNlZSB0aGUgZm9yZXN0IGZvciB0aGUgdHJlZXMsDQpjdXQgdGhlIHRyZWVzIGFuZCB5 b3UnbGwgZmluZCB0aGVyZSBpcyBubyBmb3Jlc3QuDQoNCg== --_000_OS3P286MB193327FB105CD72F695D0946D3E1AOS3P286MB1933JPNP_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable
Hi, 

Sorry,   the name of ident file  that i used  is wrong,=   it is pg_ident.conf (the same as you says=A3=A9

And, I found  pg_ident.conf works, because  i can found ident entry in pg views ,

 line_number | map_name | sys_name | pg_= username | error
-------------+----------+----------+---------= ----+-------
          43 | test     | root   &n= bsp; | cce         |

But when i connect to psserver by using os user root  
/usr/local/pgsql/bin/psql   -p5432 -d db1     -h127.0.0.1  
psql: error: connection to server at "127.0.0.1", port 5432 faile= d: FATAL:  Ident authentication failed for user "root"

I have check  config files many times,  everything is right, a= nd hba config file content is:

# "local" is for Unix domain socket c= onnections only
local   all         =     all                 &= nbsp;                   peer
# IPv4 local connections:
host    all       &n= bsp;     root             127.0.0.1= /32           ident    map=3Dtest
host    all       &n= bsp;     all             127.0.0.1/= 32            trust
# IPv6 local connections:
host    all       &n= bsp;     all             ::1/128 &n= bsp;               md5
# Allow replication connections from localhos= t, by a user with the
# replication privilege.
local   replication     all &n= bsp;                     =               trust
host    replication     a= ll             127.0.0.1/32     &nb= sp;      trust
host    replication     all        =     ::1/128               &nb= sp; trust


Thanks.


=B7=A2=BC=FE=C8=CB: Al= ban Hertroys <haramrae@gmail.com>
=B7=A2=CB=CD=CA=B1=BC=E4: 2023=C4=EA8=D4=C226=C8=D5 10:38
=CA=D5=BC=FE=C8=CB: pan snowave <windxp@LIVE.CN>
=B3=AD=CB=CD: pgsql-general@lists.postgresql.org <pgsql-general@l= ists.postgresql.org>
=D6=F7=CC=E2: Re: ident auth does not works as usual
 

> On 26 Aug 2023, at 11:31, pan snowave <windxp@LIVE.CN> wrote:
(=A1=AD)

> pg_indent.conf
>
> test   root    cce

If that is indeed the name of the file, that would explain your problem. No= doubt that it should be named pg_ident.conf instead, without the =A1=AFn'.=

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.

--_000_OS3P286MB193327FB105CD72F695D0946D3E1AOS3P286MB1933JPNP_--