Re: Connecting to postgres on OSX from Swift using PostgresClientKit

On 2022-08-01 04:06, Adrian Klaver 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

Hi Adrian,

you & Tom were correct - it was sandbox settings (which was turned
off??) in Xcode which caused the problems. In case anyone else has the
problem, the steps I took to fix the problem in XCode 13.3 were as
follows:

1. Go to the project explorer and select the project.
2. Select the Target under the list of Targets
3. Select the "Signing & Capabilities" Tab/Heading
4. Under the "App Sandbox" settings, select the "Outgoing connections
(client)" checkbox.
5. Note - the "Enable App Sandbox" under Build Settings seems to have no
effect!

Apologies for not finding this myself - This was purely a MacOS / XCode
problem - but many thanks to you all (Adrian, Tom, Rob) for proving yet
again that Postgresql support is the best.

Howard.