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.
