caturseptian
commented
9 months ago database postgresql, install using brew (brew install postgresql@14)
when using mysql, it works!
Closed caturseptian closed 9 months ago
caturseptian
commented
9 months ago database postgresql, install using brew (brew install postgresql@14)
when using mysql, it works!
drbyte
commented
9 months ago Duplicate of #1433
caturseptian
commented
9 months ago i've already downgrade to php@8.1 but didn't work
drbyte
commented
9 months ago It's not a factor of your PHP version. It's how/when it was compiled (eg: before vs after June 2023 when krb5 library was updated). Workarounds posted in #1433.
manuelpgs
commented
4 months ago I fix it by adding this variable in my .env:
PGGSSENCMODE=disable
More details and info at https://stackoverflow.com/questions/76812272/valet-php-fpm-and-nginx-errors-upstream-closed-connection-child-process-sigse
drbyte
commented
4 months ago The workaround/fix is already built-in to Valet since v4.6.0. See https://github.com/laravel/valet/pull/1452
Description
502 Bad Gateway nginx/1.25.2
[error] 8240#0: *1 upstream prematurely closed connection while reading response header from upstream, client: 127.0.0.1, server: .test, request: "POST /login HTTP/2.0", upstream: "fastcgi://unix:/Users//.config/valet/valet82.sock:", host: ".test", referrer: "https://.test/login"
Steps To Reproduce
Diagnosis
sw_vers
valet --version
cat ~/.config/valet/config.json
{ "tld": "test", "loopback": "127.0.0.1", "paths": [ "/Users/***/.config/valet/Sites", "/Users/***/Sites" ] }cat ~/.composer/composer.json
{ "require": { "laravel/installer": "^4.5", "laravel/valet": "^4.3" } }composer global diagnose
composer global outdated
ls -al /etc/sudoers.d/
brew config
brew services list
brew list --formula --versions | grep -E "(php|nginx|dnsmasq|mariadb|mysql|mailhog|openssl)(@\d\..*)?\s"
brew outdated
brew tap
php -v
PHP 8.2.10 (cli) (built: Aug 31 2023 18:52:55) (NTS) Copyright (c) The PHP Group Zend Engine v4.2.10, Copyright (c) Zend Technologies with Zend OPcache v8.2.10, Copyright (c), by Zend Technologieswhich -a php
php --ini
nginx -v
curl --version
php --ri curl
/opt/homebrew/bin/ngrok version
ls -al ~/.ngrok2
brew info nginx
==> nginx: stable 1.25.2 (bottled), HEAD HTTP(S) server and reverse proxy, and IMAP/POP3 proxy server https://nginx.org/ /opt/homebrew/Cellar/nginx/1.25.2 (26 files, 2.4MB) * Poured from bottle using the formulae.brew.sh API on 2023-09-26 at 05:48:26 From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/n/nginx.rb License: BSD-2-Clause ==> Dependencies Required: openssl@3, pcre2 ==> Options --HEAD Install HEAD version ==> Caveats Docroot is: /opt/homebrew/var/www The default port has been set in /opt/homebrew/etc/nginx/nginx.conf to 8080 so that nginx can run without sudo. nginx will load all files in /opt/homebrew/etc/nginx/servers/. To start nginx now and restart at login: brew services start nginx Or, if you don't want/need a background service you can just run: /opt/homebrew/opt/nginx/bin/nginx -g daemon\ off\; ==> Analytics install: 14,070 (30 days), 46,169 (90 days), 109,876 (365 days) install-on-request: 14,036 (30 days), 46,085 (90 days), 109,703 (365 days) build-error: 1 (30 days)brew info php
==> php: stable 8.2.10 (bottled), HEAD General-purpose scripting language https://www.php.net/ /opt/homebrew/Cellar/php/8.2.10 (521 files, 83.5MB) * Poured from bottle using the formulae.brew.sh API on 2023-09-26 at 05:49:15 From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/p/php.rb License: PHP-3.01 ==> Dependencies Build: httpd, pkg-config Required: apr, apr-util, argon2, aspell, autoconf, curl, freetds, gd, gettext, gmp, icu4c, krb5, libpq, libsodium, libzip, oniguruma, openldap, openssl@3, pcre2, sqlite, tidy-html5, unixodbc ==> Options --HEAD Install HEAD version ==> Caveats To enable PHP in Apache add the following to httpd.conf and restart Apache: LoadModule php_module /opt/homebrew/opt/php/lib/httpd/modules/libphp.so
SetHandler application/x-httpd-php
Finally, check DirectoryIndex includes index.php
DirectoryIndex index.php index.html
The php.ini and php-fpm.ini file can be found in:
/opt/homebrew/etc/php/8.2/
To start php now and restart at login:
brew services start php
Or, if you don't want/need a background service you can just run:
/opt/homebrew/opt/php/sbin/php-fpm --nodaemonize
==> Analytics
install: 57,073 (30 days), 149,262 (90 days), 326,665 (365 days)
install-on-request: 53,269 (30 days), 138,941 (90 days), 303,259 (365 days)
build-error: 31 (30 days)brew info openssl
openssl version -a
openssl ciphers
sudo nginx -t
which -a php-fpm
/opt/homebrew/opt/php/sbin/php-fpm -v
PHP 8.2.10 (fpm-fcgi) (built: Aug 31 2023 18:52:57) Copyright (c) The PHP Group Zend Engine v4.2.10, Copyright (c) Zend Technologies with Zend OPcache v8.2.10, Copyright (c), by Zend Technologiessudo /opt/homebrew/opt/php/sbin/php-fpm -y /opt/homebrew/etc/php/8.2/php-fpm.conf --test
ls -al ~/Library/LaunchAgents | grep homebrew
ls -al /Library/LaunchAgents | grep homebrew
ls -al /Library/LaunchDaemons | grep homebrew
ls -al /Library/LaunchDaemons | grep "com.laravel.valet."
ls -aln /etc/resolv.conf
cat /etc/resolv.conf
ifconfig lo0
sh -c 'echo "------\n/opt/homebrew/etc/nginx/valet/valet.conf\n---\n"; cat /opt/homebrew/etc/nginx/valet/valet.conf | grep -n "# valet loopback"; echo "\n------\n"'
sh -c 'for file in ~/.config/valet/dnsmasq.d/*; do echo "------\n~/.config/valet/dnsmasq.d/$(basename $file)\n---\n"; cat $file; echo "\n------\n"; done'
sh -c 'for file in ~/.config/valet/nginx/*; do echo "------\n~/.config/valet/nginx/$(basename $file)\n---\n"; cat $file | grep -n "# valet loopback"; echo "\n------\n"; done'