Re: Connecting to postgres on OSX from Swift using PostgresClientKit

On 7/31/22 17:27, howardnews(at)selestial(dot)com wrote:
> On 2022-08-01 01:04, Adrian Klaver wrote:
>> On 7/31/22 16:53, howardnews(at)selestial(dot)com wrote:
>>> On 2022-07-31 23:42, Rob Sargent wrote:

> 2022-08-01T00:20:18.530Z Connection-1 finer] Created socket
> [2022-08-01T00:20:18.532Z Connection-1 fine] Opening connection to port
> 5432 on host localhost
> 2022-08-01 01:20:18.534308+0100 TestPostgres[10654:120173]
> dnssd_clientstub ConnectToServer: connect() failed

A search on above error message found:

https://github.com/firebase/firebase-ios-sdk/issues/3033

https://developer.apple.com/forums/thread/67792

https://github.com/emqx/CocoaMQTT/issues/202

all of which point to what Tom Lane mentioned, sandboxing.

> path:/var/run/mDNSResponder Socket:13 Err:-1 Errno:1 Operation not
> permitted
> 2022-08-01 01:20:18.535617+0100 TestPostgres[10654:120173]
> [si_destination_compare] socket(PF_SYSTEM, SOCK_DGRAM, SYSPROTO_CONTROL)
> failed: Operation not permitted
> 2022-08-01 01:20:18.535694+0100 TestPostgres[10654:120173]
> [si_destination_compare] socket(PF_SYSTEM, SOCK_DGRAM, SYSPROTO_CONTROL)
> failed: Operation not permitted
> [2022-08-01T00:20:18.537Z Connection-1 severe] Unable to connect socket:
> Error code: -9989(0x-2705), Operation not permitted
> [2022-08-01T00:20:18.537Z Connection-1 finer] Closing socket

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com