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 1tDDdc-00GpMY-5b for pgsql-odbc@arkaria.postgresql.org; Tue, 19 Nov 2024 02:06:44 +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 1tDDdZ-009dJa-4B for pgsql-odbc@arkaria.postgresql.org; Tue, 19 Nov 2024 02:06:41 +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 1tDDdY-009dJR-Nz for pgsql-odbc@lists.postgresql.org; Tue, 19 Nov 2024 02:06:41 +0000 Received: from mail-co1nam11on2139.outbound.protection.outlook.com ([40.107.220.139] helo=NAM11-CO1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDDdW-002fTF-CD for pgsql-odbc@lists.postgresql.org; Tue, 19 Nov 2024 02:06:40 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=Vr3IIah7lkT0WCndHhZkqyfkUKW2OFZJcZQAIJnJsUIn+pbEdbsr+Y5IAuq/Wvu0HmR6ChrOjzDtUfLt0c7iPW3fICTxpcYN/MjNzh5qtjSFM8Q1q6H2etJ5anHGQo1Gqa7bSIPEhc0U/m8rKb4Lx33SZUf+Kiq2qLq5emyT8EBzNATl/ZMy/ZhT1OJqut8kCi7Xyk1KVfo2fQKRWCuZUZ0/HGhhNgCzk4QAEABpdgW0qkrCkfPmk+n5HfJyACeHLMx/bLhvwAW5Ydzswi+KrJTQZ/4O776+K9DqYAf4Pn+hIwpQVjWxrY5zmV5erdShUwtGh8lOo49aRGzDaRKQdA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=9nnqpjGX0qL+Ad0LwgAtwHGZIHy8dS/tqliCymsOgZo=; b=esEMiZHQYAJclGgUidB7O6BjPsft7HRaqgaCKSDLpqn5O7o+O6xNZ1MwUuGygUVehIBfVcnqJnzgh0IQwYBB2b+fTEcT7JWFyh0dg7JJVHFcbNEV6Tn4dAtN+L9FGMbfIhhIS/Dzs0BUWXlr1OyMypFhd7J4wMTRj2nP3dOTYLxBFDsDofWWMaRjEwPmURJ2U9hrvCAFcaHsCRrBS/AhyL5yXCBN+9v896VPHpWZbed+4yDCkwrdRFnqLuxLnSI6FSTMadFJIp/Nuf5I2gq4vlPs4puk1NBOZnJKEzXrsQhBo+waI0iEhScaXKQndChVDEcChDAlD3MBaX0cIW9Atg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=spiralxllc.com; dmarc=pass action=none header.from=spiralxllc.com; dkim=pass header.d=spiralxllc.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=spiralxllc.onmicrosoft.com; s=selector1-spiralxllc-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=9nnqpjGX0qL+Ad0LwgAtwHGZIHy8dS/tqliCymsOgZo=; b=P4FzQ6qMLJGQEhlhZXJYVekbRdSvDan6cbUm/NImyh8DCWVl2froSrqyCvnHiPd1OcZY3aNUBaFrAXROlahpVWeVF3aVjQW+Wy8QDN5h1ArGW1366XftZWRDtP7ZNzuCSTbegfK/RV4Up8HnKk9anoM3pKuCI/O/RkvRyo18Clc= Received: from MW6PR11MB8310.namprd11.prod.outlook.com (2603:10b6:303:249::16) by PH8PR11MB6904.namprd11.prod.outlook.com (2603:10b6:510:227::5) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8158.22; Tue, 19 Nov 2024 02:06:32 +0000 Received: from MW6PR11MB8310.namprd11.prod.outlook.com ([fe80::8195:674:f84:46cf]) by MW6PR11MB8310.namprd11.prod.outlook.com ([fe80::8195:674:f84:46cf%4]) with mapi id 15.20.8158.021; Tue, 19 Nov 2024 02:06:32 +0000 From: Steven Adams To: "pgsql-odbc@lists.postgresql.org" Subject: Re: ODBC configuration problem Thread-Topic: ODBC configuration problem Thread-Index: AQHbOgjCZMjrF10evU60nfmredjfErK92yj6 Date: Tue, 19 Nov 2024 02:06:32 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=spiralxllc.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: MW6PR11MB8310:EE_|PH8PR11MB6904:EE_ x-ms-office365-filtering-correlation-id: 3ddab529-1819-46d2-e26a-08dd083ec9e1 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|8096899003|38070700018; x-microsoft-antispam-message-info: =?us-ascii?Q?homDLxDfg8/rr++M7XzrAeEwo8vjFi1fmbimqLKpx6PK+7CvN1VG4T6SoUdD?= =?us-ascii?Q?UzlQ0GQSvzDeof9FpZHooJGQ3C3EjsNG+A1/jvByB9vfPzbKWoqAqwGs7Mwt?= =?us-ascii?Q?i7hl6jNLMqJ/BvuAcfoK7ZqjytTQJIPy+239SohgjINmZ3jUwOrb0aKFFqGZ?= =?us-ascii?Q?b+YY3XO84WwJK9TcIJV2x23Du1CUIB4qN9NDqpyga1ssab+oRFPrrnJTsBEu?= =?us-ascii?Q?AbSX9m3u+HP6L21yWQpJO5LnzVBt7aoLB8DdOfBhk3sbLLVb89+OifqdTUri?= =?us-ascii?Q?pf3XYHUsF7mDiB019z5jtwDNwHR3kAafjq9cn3ZMaCdZPtz2LvmRpC1rWqFg?= =?us-ascii?Q?ZM5CLOo2chksUzj4Rfi4HmFXxtCHDSj29oUbkfkd/luKOQrNMiCWq5vgEqnT?= =?us-ascii?Q?GMTYjncqSRjuZ02UB4CgNLSEozj+RSAW53srcvbuSS74T5ulmmH7zOM3a6X3?= =?us-ascii?Q?5KE7m7DUVmsvId2USgG6ki5N8AsXvoBArS1Nb4xL3fC030/hY/nhmABcUAr8?= =?us-ascii?Q?F09FCvemNb319BefASxRyl/78zIGF1ykvIY9C7aOxO9diKNLktMhJ390wdGP?= =?us-ascii?Q?mlUVt7bdL3BYfZiLQ8FYLvmQor0OHZPCaseFs1ACZtfLvLfvdTnK3jfH+d/p?= =?us-ascii?Q?3/aWmExJKNeRZ2l8fvZ8fMZCRVzt/z307RyVzQytVW752NiV6H7JJClcl0mL?= =?us-ascii?Q?eMB6ziUNhrAj5R47+yJMTEWZCQFRXxCSGRZ6O2yY7runUAHRB3kNAh/Adgon?= =?us-ascii?Q?EGeE7yrWZhhaoNZWPRtLrjNLWPS7brXokiU0EjZPCLgpaH8RZGiK6Bpp33Va?= =?us-ascii?Q?J/c1WNP7OAyoR8e0Xn9dxZHGRePUj0WScYKDMr1gKTt6WoAfmudbqOGAPMe9?= =?us-ascii?Q?urxu0vkIYnb2ptBqIPksvSF5IOLLAef2g7rxZJXLV4uTVimPlpSDn6ToJ2Kn?= =?us-ascii?Q?WnHCTHkiXvJTQEzB0ObI4kedtbTsS261B//XHCozkMei/XOaOKiRo93mKw46?= =?us-ascii?Q?FQNyxje8LXwG6RGVmQ+T2xsnPLYj0YhcUPMDuxMl215k6eyjsurSjltARtnD?= =?us-ascii?Q?8JWYJLI/aQ/lp0TuWCCyT5aIku6rum9QMp5QTdp1DcxM69U7+JdrnQtNqvvq?= =?us-ascii?Q?O/3Fe1ooyiNMduAGsC5HaBXn6SV9PnDHDZdOdt45UrvXwZ0HGRVOm03DtO8I?= =?us-ascii?Q?QZuezZqq835LzmA6tZAFgqyfe8n63uJ2OqVKzP4coKMXWfCAu0nFWwW0Gvu1?= =?us-ascii?Q?R7IXVtHetf+36ppZacobcbxGNMzYmxRRuX62jZUwvnBYTm3IIa43rXOpFKTE?= =?us-ascii?Q?VoaTeFIAU4Uh+U26wBUwvHDjXO90DSHNR9fWCFPrdzGpJyTc8XzW/ixmQoTP?= =?us-ascii?Q?TACoYVM0KCGiRhksX1fh8c97H21P?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:MW6PR11MB8310.namprd11.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(8096899003)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?RkhjNYhZSxM3HkCHU4JSUjfFfwTynSFV05iUxPFe6Fpw0M1E/FzZhqmMfIaL?= =?us-ascii?Q?FtncRgUHLMnLUnOA5GQBfxYRI56XKqxw6f7IqmmFjreM9RMUOXzXe/vTM7o0?= =?us-ascii?Q?Zac3qKjYVdKXa3psLUuwGv3/iCX9ywKmCypUbRvqQFrC+yM7amApWSsUA5Mw?= =?us-ascii?Q?1xtvV6xdG+b9RRzljirzdW3jjrAmIrozOHmVyxy0a3Xfzw9cdntF8bszBJlA?= =?us-ascii?Q?7pF3c7xj8UQPH1e0doHwcNg0V5ArJFtTy4x80KK6naNFtHiTyD20g/Fnpg0t?= =?us-ascii?Q?qQWcwK0YevI0bazgPbVwrB6UQNhX30nXADL32VNzBGXZjAQdTJN4QJqrX6nO?= =?us-ascii?Q?bm+CPYJM3OEwQR0kPYHjEUqd4gLo8g325mwJr9rqErWKiTZFLLdWqzISK/R3?= =?us-ascii?Q?WHE7DVs6AwpnaKifCYx34El2mtjzsEpWME+URkEu2u1hO8tBVJMJR5rfOmov?= =?us-ascii?Q?RksscrNskEOfKPoYIRsIS4B+g3S9AjbGr9gPG93qQmdrGhTgi92ueA60myDz?= =?us-ascii?Q?kElFp50jJuL2FmPyuVTqASMVMp1Z713fR2B4a3fSRO0xDeviT2TEhr2bzwAh?= =?us-ascii?Q?FpQfNAcCDbGKlshfphycfUrsAjgwl+t1vg9mqVZ71S8Czqe8P+FDto4oxpAR?= =?us-ascii?Q?Hquq8oIuv40U6m6qXKHSOkRIXBFpLc9O2NCFwGQDvfq3PmP2SDlNf/+UuA0t?= =?us-ascii?Q?L65sipDawJbQybXkiZRUQJrFCJ0eT4AvnVnqxz/esnqYKn8H1VLlCBYbnWw+?= =?us-ascii?Q?UUC3iNxobfIY7/r1F6jS2eUmnHq6Ma+gnpqqKhTaae9KiFGZt58pOaGFG0hF?= =?us-ascii?Q?Qj1SoSIO9pLg7flrhQ8IdEEvWn+ILQHLxcdMRszVnFIsfIPiJVw4xsUB0I6d?= =?us-ascii?Q?pdaiN7se9B86tiIE2nud7UQId+O1c2//iSwKMeGlVAhTqgTTUD8JtHq6nv7T?= =?us-ascii?Q?5QW6kupwC8nnC0H+rwYremC8uVqp0OBvSmq9RBhU4j20B0l2Us+k9pXeVcz9?= =?us-ascii?Q?siUnLDahOOSckrqEcyXZiKYDEO3oM87lqXkVPwMy8V7pZd9Gym2Z7MrG0r+S?= =?us-ascii?Q?Gx0XZj7YUPcYPHPSHcvbtoc7L+nql4v3d3zNERKN2TaHIaOiW2lb//JUOyS8?= =?us-ascii?Q?hkSyZvMgU7ql8ZfTX6/G8lZLOvUgiQk6sf90Til/repu4AihCrnSNTFzz54y?= =?us-ascii?Q?A9bfLVCm0Ln5ilK+d7LnOKjg9R76UtYsdqg6EeaM/azZqvkVVUTJVNoCIkl/?= =?us-ascii?Q?UlMIUGk7CAEbN9fkvVZ+VUGQX86RjWoD8R2sWcoAJ7YkwzW0NkrJVnRXrivD?= =?us-ascii?Q?MviCNjgxz4dpkkaJnyyeZYulUkZTqcD7FF4o6QuJdVacpFw46aubxsZ1qPxi?= =?us-ascii?Q?2cHo0N19l3U07WPLZzccN+z44LOJMdw59u4JjuvIV1ZYDs0WpU8O3AePf0gx?= =?us-ascii?Q?+b/LaKdZM2JacKPSZPgCCg1v8ENCGPIZnxFd+YuMOx8nZmASjpRCelROma0F?= =?us-ascii?Q?lL7vY4/SMFE7IivLGvIdR45TXMIyefsu1C5QWz8BLQbwrOkfv4buA4qy7dVs?= =?us-ascii?Q?8EqHL6o4SnoqhswrQ9Q/BKQoBZ8GHjGAvsrnRqPW?= Content-Type: multipart/alternative; boundary="_000_MW6PR11MB83105E8EAD67FA889E3B6ECEDE202MW6PR11MB8310namp_" MIME-Version: 1.0 X-OriginatorOrg: spiralxllc.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: MW6PR11MB8310.namprd11.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 3ddab529-1819-46d2-e26a-08dd083ec9e1 X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Nov 2024 02:06:32.4293 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 4e3f5e01-32e9-4a96-bb55-9de831f28b26 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: qALPac1sRU2U+pixvWfPrb+qE8xOdi00UgcKmqMSvfKFnzEfvMf0/e6o/ZFQt5BOtQY22Q78m+PpyvXl79vncXxiGZhYMdDP2PPV1Q65PTM= X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH8PR11MB6904 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_MW6PR11MB83105E8EAD67FA889E3B6ECEDE202MW6PR11MB8310namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Okay, I posted about it on Github. ________________________________ From: Steven Adams Sent: Monday, November 18, 2024 4:27 PM To: pgsql-odbc@lists.postgresql.org Subject: ODBC configuration problem Hello, I'm trying to use MS Access with PostgreSQL and so want to configure an ODB= C file for this. Testing it resulted in a connection timeout, so I looked = at this to troubleshoot: https://odbc.postgresql.org/faq.html#3.3 Adding a "tcpip=3Dtrue" line to postgresql.conf and a line to permit a conn= ection from the computer running Access to pg_hba.conf and then restarting = PostgreSQL seemed to go without errors, but when I tried to run the psql co= mmand afterward, I got this error: psql: error: connection to server at "localhost" (127.0.0.1), port 5432 fai= led: Connection refused Is the server running on that host and accepting TCP/IP connections= ? The psql command worked again after I undid these changes, so I'm trying to= figure out how they caused this error. The line I added to pg_hba.conf wa= s as follows. host spiralxprime web_app 192.168.0.72 scram-sha-256 Any ideas as to why this is happening would be appreciated. Regards, Steven Adams --_000_MW6PR11MB83105E8EAD67FA889E3B6ECEDE202MW6PR11MB8310namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Okay, I posted about it on Github.
From: Steven Adams <stev= enadams@spiralxllc.com>
Sent: Monday, November 18, 2024 4:27 PM
To: pgsql-odbc@lists.postgresql.org <pgsql-odbc@lists.postgresql.= org>
Subject: ODBC configuration problem
 
Hello,

I'm trying to use MS Access with PostgreSQL and so want to configure an ODB= C file for this.  Testing it resulted in a connection timeout, so I lo= oked at this to troubleshoot:
Adding a "tcpip=3Dtrue" line to postgresql.conf and a line to per= mit a connection from the computer running Access to pg_hba.conf and then r= estarting PostgreSQL seemed to go without errors, but when I tried to run t= he psql command afterward, I got this error:
psql: error: connection to server at "localhost" (127.0.0.1), por= t 5432 failed: Connection refused
        Is the server running on that host and acceptin= g TCP/IP connections?

The psql command worked again after I undid these changes, so I'm trying to= figure out how they caused this error.  The line I added to pg_hba.co= nf was as follows.
host      spiralxprime     web_app  &nbs= p;  192.168.0.72     scram-sha-256

Any ideas as to why this is happening would be appreciated.

Regards,

Steven Adams

--_000_MW6PR11MB83105E8EAD67FA889E3B6ECEDE202MW6PR11MB8310namp_--