shivammathur/homebrew-php

pg_connect crash when connecting to PostgreSQL

ataklychev opened this issue · 2 comments

ataklychev commented

Describe the bug
PHP-FPM crash when connecting to PostgreSQL

PHP versions
8.3.1

To Reproduce
On MacOS sonoma 14.2.1
brew install postgresql@16 ( create test db )
brew services start postgresql@16
brew install shivammathur/php/php@8.3
brew services start php
brew install nginx ( configure simple server with fastcgi_pass 127.0.0.1:9000 )
brew services start nginx

In console mode, pg_connect work perfectly. In fpm mode pg_connect crashes and nginx return 502.

I found similar issue Homebrew/homebrew-core#155651 , and try to downgraded openssl to 3.1.4.

But when i install php [brew install shivammathur/php/php@8.3], openssl 3.2 installed force again and php use openssl 3.2.

How can i downgrade openssl to 3.1.4 in php ?

shivammathur commented

@ataklychev

This was patched on Homebrew's side to work with openssl 3.2.0, Please reinstall your postgresql@16 and libpq formulae.

brew update
brew reinstall libpq postgresql@16
ataklychev commented

@ataklychev

This was patched on Homebrew's side to work with openssl 3.2.0, Please reinstall your postgresql@16 and libpq formulae.

brew update
brew reinstall libpq postgresql@16

It did not help