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 1qZpuS-007Id3-Ek for pgsql-general@arkaria.postgresql.org; Sat, 26 Aug 2023 09:48:48 +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 1qZpuR-008onw-7d for pgsql-general@arkaria.postgresql.org; Sat, 26 Aug 2023 09:48:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZpe9-008jms-EP for pgsql-general@lists.postgresql.org; Sat, 26 Aug 2023 09:31:57 +0000 Received: from mail-tycjpn01olkn2022.outbound.protection.outlook.com ([40.92.99.22] helo=JPN01-TYC-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZpe0-0018JJ-Kq for pgsql-general@lists.postgresql.org; Sat, 26 Aug 2023 09:31:55 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Q4FIlwbV2pTVK0rO6xbLbAOgKxrn0/+pbW3KIvAIfyGHvZAoM196Wl0QtAgGNJbJYG4TEXNLcIS+xKnE8dOCSb8Q3S+lIE3sTt2kBJYtjCOmI/ihJWzgrz0m6oo6+NWLke5RkCxEFMNFgFmfYEqwcrZS0MFcXzUpsdBKb605BZ4FCp0tExB51KSTNclLcl1jM9wKWznm7y3JByW3H4WbiRVOHvvXAWajjSz6iU2HGp8p7KaCU0iPqyFlLDg3bTEpKJ7DnFTy7UlCI9YE3TVyVjuTmuu+jj5Pzt6lh2Bk7lZD5ufPkD5QbXUeAMNUHNJCCp9sF0QnQYe+kFRC6VbGzg== 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=xLHEw7rYbnvBSNoPC/pYqHtKDBVlbq6bMN/zfdb/Dx4=; b=ELRE8CfT5Zcxa4NlhiXEEVT8FPX4S+K40XiFEX7JmeTZQY4p0Y6oMoel+gnX8DA32/36Sa639Y/+mqnBkBNOfk+lxxZpDepdJG/XUBjwVFju8jIhKrwsubyNamQCGBlMsxj+IpfwytBPIu22dIS1ihhSBZDQcPeCJlCixhxSxVzDHpv1Y7xhNyuEnxGtCohuAJkw/xqpV8578GJxrZZmzD4EP2sfhtaOYR5NMqc6SMSmABiFZ2yR7yjPvMaKaARQy65scCwzqpTcLQol21jgSw9S8oJ/VHv4iRBD3r8k/BwtDk68xjYBPMXWH2apF5fzhRIvnwS8sZVVlOIYzHlWPg== 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 TYCP286MB2534.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:208::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6745.12; Sat, 26 Aug 2023 09:31:42 +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; Sat, 26 Aug 2023 09:31:42 +0000 From: pan snowave To: "pgsql-general@lists.postgresql.org" Subject: ident auth does not works as usual Thread-Topic: ident auth does not works as usual Thread-Index: AQHZ1/8shiIPXKW4tkOIc0wYkrf9LA== Date: Sat, 26 Aug 2023 09:31:42 +0000 Message-ID: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-tmn: [cEb4fCNvoLgjLVYbKDO2FUFuZlwioQRX] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OS3P286MB1933:EE_|TYCP286MB2534:EE_ x-ms-office365-filtering-correlation-id: 47f6344e-050b-45bc-0710-08dba61741d2 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: rilm2mtGNJGOqWFxhdkyIv8lvzisdKSlPP6mjElyQytb2H3NQEr32ZKvd2gi9RfXgCJ1AdiiiZxPckliwN8LCzC896MmjtKPNaEOL/C4RePStHqGGm7YKeZmPQJYVme+aJIu8VSNtLnY0rdF4Vqq5bxnSUmTSAZB1QhcRrEgzbAqsSC5nRss0hFYI9v5CI1KeryZpiNw97UOzJqxvIHQBcpkJcYczjamExQl6zlXfMC1mWQm2+8Re/m7UbcHDU+9vzGHraXat818jWbIYqHifOm4Cb+KE77NtJIpxkNswPQEb/m9T8xNMjCBlr9nij9+yEghAECMD74zrHuzRI9cbi+E1KwVRdV36Qd/5GuTMuedWSrSi1plWdNPq1eheqBxqt9LNjMJDTgcl6eEh2cT5eaeMSmk2ohImw1fn2yhLWqNV3lkpPzRoXPX+j5hyU2lQJZP/c/Xj2VzEJsZOd3Ae0S3VwXEweH5VNPuGLJ1pfhIiEKDe7wO9cGyNlo6GF1IWeyEOY/L/V3y5R6+MC8uiBmS1hIlmAYl5pW1lbODxSNfHBgNvSgkAXDhp1nD56WJ x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?gb2312?B?ekRUN0svWEU3ZzBycWdOZlpLQ3hKQUdNWnZLNzMxeWVKMERkNnFzYlRPTUUr?= =?gb2312?B?MUoySlNFUlhjeVB6QlhFcisrdGtKK2RSMmFCYnpJMVhpdStWSW5BMjkyWldH?= =?gb2312?B?T2ovelQ0c3NHVUZJNzVhdXVDWWRQbkhZWklkczAzZTNjMUg0a0F5M0pDMDhU?= =?gb2312?B?NmNzL0c2b3lVRk90MTJHYlBzb1hnOHNnV3RBRkhxMDd5blNyV0pjcFFsSXlC?= =?gb2312?B?aTZVQ2pjM1lxaW0xS0pXK0lIbUlEdm5JR0NxS0hvbFpoN25adGF0MUxhZzI3?= =?gb2312?B?eWVKcWZmUVplTm84eFVLMzNCSEFjWUJWVlIrYlhtYXdOSzI1SDdQNXdPS0xv?= =?gb2312?B?cDJ3dWxEdUJiK1NmTkVxaXJTWEpwNzJwdmt2WkZmbHM0ZWl3NHlrS1JQakpT?= =?gb2312?B?RjNBZlZlVVJVdmw0ZkEyRHRTaUF3eEt6RG9ZTWNOQXkrMFBncG9uRDk3QU9i?= =?gb2312?B?WW01cGVwVzVWTVMzTThJTFp1eHRoc3BRTGdnTnR3MytlTnNycTFyR0UrcFFX?= =?gb2312?B?a3RmRzVwMlcvSDBsYUd6V3o4MjVrZVZiRVRkcmt1djEzNW1maEhXRnZMakho?= =?gb2312?B?bDB6bWczVEJsZDc0OHJrOVdIOFIrdVdpdHJ3VVNVZ3U5ZHFPUE5nOFB6VE5G?= =?gb2312?B?VWhqbUxidWMwRnpVTUxNcGtjL1VFbkpPSHlIQldkTnhkeStTbWFjcHZrdk9F?= =?gb2312?B?cXB1dGhtbHFvenI3M1hhV3BFOFJFOE4yM3RlQzFVSkxybWNDYkczTElZN1RZ?= =?gb2312?B?dXB1T09hL2IxS0NTa1ZaN25ibDB4cVJMdVIwdGtJWWtzdU9YVXhobW1VRlBv?= =?gb2312?B?SklOcVBlRlJjM282YnZEMDJhVldtZnFTYzhiSWZBeHFkZ0FqbGw5aEE0cTVT?= =?gb2312?B?MzRLOVpKL3NEeUZpcHgrQncxV3BWTFlIN2lTY0xtNkpib1kwaEhpcmlDaFYx?= =?gb2312?B?RDFiNU0xclgxWWloQWI3NGpRTTNIaXNMSmFWaVB4U0k1WFYvcmNhUitVMGZ3?= =?gb2312?B?U1U5K0dDemM5UHBZYnVpVGFsZjdERVRoL0lGekpWRC96dEhkTUpnRDJUc1c1?= =?gb2312?B?OGxkRDV1WWZmbWxHdFphbkRmd1ZTMndpY1ErOFQrdHlUYTZWaXBteWJTL3Rs?= =?gb2312?B?Qkd0dWhiL3JmU3owZEhzNHVBQVhocWZiN3JsY3ZmWkNuMW5IQXZqSXh4YnVy?= =?gb2312?B?N2JxcXlYNExnbHJKZ3J1anN6UzdJYkxqN1RLc0ZndVZ4NGhiZDhmZ2REWkZX?= =?gb2312?B?aXJtSWl0eFZLRHk3Q2tUZmtGYzFZUzZPKyt1Z1h6ZGV1ZEtabDA1THpMdEkv?= =?gb2312?B?RWREUzJ5Y002OW9GWDVYVXNrY1BlTjZZVXlLSTBOVnJybjV2UUd5UHFhcFJD?= =?gb2312?B?by9sdnhmUWFpMnQxaFRuWFpPNmcwbURxRzQ4ODFQMDZQR3FHNXpxVU9jQlBh?= =?gb2312?B?R1VFdkY3dlh6MkJ1QnF6U3phYVNqaWd3Z09ud3FwWmRhZ3VBU3hKUXUwYXBx?= =?gb2312?B?SmtqQkxaUGZObHZ5YUtyVC9QeTVMNDRSakJCc3hsNzBxUkNiVDJWMnY1NE5q?= =?gb2312?Q?VWimSru8hI7IcEfUK9N+LEeA4b4vXH+oE+z4L6E8Fgp92e?= Content-Type: multipart/alternative; boundary="_000_OS3P286MB1933B415C59DC5C600DC0983D3E2AOS3P286MB1933JPNP_" 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: 47f6344e-050b-45bc-0710-08dba61741d2 X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Aug 2023 09:31:42.1616 (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: TYCP286MB2534 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_OS3P286MB1933B415C59DC5C600DC0983D3E2AOS3P286MB1933JPNP_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 V2VsbCAgLCBkZXNjcmliZSBhcyBmb2xsb3dzOg0KDQpwZ19wYmEuY29uZg0KaG9zdCAgICBhbGwg ICAgICAgICAgICAgcm9vdCAgICAgICAgICAgICAxMjcuMC4wLjEvMzIgICAgICAgICAgIGlkZW50 ICAgIG1hcD10ZXN0DQpob3N0ICAgIGFsbCAgICAgICAgICAgICBhbGwgICAgICAgICAgICAgMTI3 LjAuMC4xLzMyICAgICAgICAgICAgdHJ1c3QNCg0KDQpwZ19pbmRlbnQuY29uZg0KDQp0ZXN0ICAg cm9vdCAgICBjY2UNCg0KDQphbmQgIGxvZ2luIHBnICB2aWEgIHJvb3QgIHVzZXIgLCBpdCBkb2Vz bnQgd29yaw0KDQplcnJvciBpbmZvIGlzDQoNCjIwMjMtMDgtMjYgMTY6NTY6MjkuNDg0IENTVCBb MTgzNDldIExPRzogIG5vIG1hdGNoIGluIHVzZXJtYXAgInRlc3QiIGZvciB1c2VyICJyb290IiBh dXRoZW50aWNhdGVkIGFzICJyb290Ig0KMjAyMy0wOC0yNiAxNjo1NjoyOS40ODQgQ1NUIFsxODM0 OV0gRkFUQUw6ICBJZGVudCBhdXRoZW50aWNhdGlvbiBmYWlsZWQgZm9yIHVzZXIgInJvb3QiDQoy MDIzLTA4LTI2IDE2OjU2OjI5LjQ4NCBDU1QgWzE4MzQ5XSBERVRBSUw6ICBDb25uZWN0aW9uIG1h dGNoZWQgcGdfaGJhLmNvbmYgbGluZSA5MTogImhvc3QgICAgYWxsICAgICAgICAgICAgIHJvb3Qg ICAgICAgICAgICAgMTI3LjAuMC4xLzMyICAgICAgICAgICBpZGVudCAgICBtYXA9dGVzdCINCg0K DQppIGNoZWNrZWQgY29uZmlnIGZpbGUgIG1hbnkgdGltZXMsIGFuZCBjb3VsZCBub3QgZmluZCAg YW55IHJlYXNvbiAgb2YgdGhpcyBlcnJvci4NCg0KcGxzIGhlbHAgbWUuDQoNCnRoYW5rcy4NCg0K DQoNCg== --_000_OS3P286MB1933B415C59DC5C600DC0983D3E2AOS3P286MB1933JPNP_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable
Well  , describe as follows:

pg_pba.conf
host    all             root  =           127.0.0.1/32        = ;   ident    map=3Dtest
host    all       &n= bsp;     all             127.0.0.1/= 32            trust


pg_indent.conf

test   root    cce


and  login pg  via  root  user , it doesnt work

error info is 

2023-08-26 16:56:29.484 CST [18349] LOG: &nbs= p;no match in usermap "test" for user "root" authentica= ted as "root"
2023-08-26 16:56:29.484 CST [18349] FATAL: &n= bsp;Ident authentication failed for user "root"
2023-08-26 16:56:29.484 CST [18349] DETAIL: &= nbsp;Connection matched pg_hba.conf line 91: "host    all &n= bsp;           root         &n= bsp;   127.0.0.1/32           ident   &n= bsp;map=3Dtest"


i checked config file  many times, and could not find  any reason=   of this error.

pls help me.  

thanks.



--_000_OS3P286MB1933B415C59DC5C600DC0983D3E2AOS3P286MB1933JPNP_--