search

mongodb / mongo-php-library

The Official MongoDB PHP library
https://mongodb.com/docs/php-library/current/
Apache License 2.0
1.6k stars 261 forks source link

MacOs M1 Cannot connect to Atlas After upgrade driver #1145

Closed samuelexyz closed 6 months ago

samuelexyz commented 1 year ago

Bug Report

When I try to connect no exception is raised but the php-fpm job is closed and I have a return status of 502 Bad Gateway

Environment

MacOs 13.4.1 (c) (22F770820d) Ventura
PHP 8.2.9 (cli) (built: Aug 16 2023 21:06:19) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.9, Copyright (c) Zend Technologies
    with Zend OPcache v8.2.9, Copyright (c), by Zend Technologies

nginx version: nginx/1.25.2

mongodb 1.16.2  stable

MONGODB
VERSION
5.0.20
REGION
AWS Ireland (eu-west-1)
CLUSTER TIER
M10 (General)
ENCRYPTED STORAGE
True

libbson bundled version => 1.24.3
libmongoc bundled version => 1.24.3
libmongoc SSL => enabled
libmongoc SSL library => Secure Transport
libmongoc crypto => enabled
libmongoc crypto library => Common Crypto
libmongoc crypto system profile => disabled
libmongoc SASL => enabled
libmongoc ICU => disabled
libmongoc compression => enabled
libmongoc compression snappy => disabled
libmongoc compression zlib => enabled
libmongoc compression zstd => enabled
libmongocrypt bundled version => 1.8.1
libmongocrypt crypto => enabled
libmongocrypt crypto library => Common Crypto
mongodb.debug => no value => no value

phpinfo()

System => Darwin MacBook-Pro-di-Samuele-3.local 22.5.0 Darwin Kernel Version 22.5.0: Thu Jun  8 22:22:20 PDT 2023; root:xnu-8796.121.3~7/RELEASE_ARM64_T6000 arm64
Build Date => Aug 16 2023 21:05:44
Build System => Darwin Ventura-arm64.local 22.4.0 Darwin Kernel Version 22.4.0: Mon Mar 6 20:55:35 PST 2023; root:xnu-8796.101.5~3/RELEASE_ARM64_VMAPPLE arm64
Configure Command =>  './configure'  '--prefix=/opt/homebrew/Cellar/php/8.2.9' '--localstatedir=/opt/homebrew/var' '--sysconfdir=/opt/homebrew/etc/php/8.2' '--with-config-file-path=/opt/homebrew/etc/php/8.2' '--with-config-file-scan-dir=/opt/homebrew/etc/php/8.2/conf.d' '--with-pear=/opt/homebrew/Cellar/php/8.2.9/share/php/pear' '--enable-bcmath' '--enable-calendar' '--enable-dba' '--enable-exif' '--enable-ftp' '--enable-fpm' '--enable-gd' '--enable-intl' '--enable-mbregex' '--enable-mbstring' '--enable-mysqlnd' '--enable-pcntl' '--enable-phpdbg' '--enable-phpdbg-readline' '--enable-shmop' '--enable-soap' '--enable-sockets' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--with-apxs2=/opt/homebrew/opt/httpd/bin/apxs' '--with-bz2=/Library/Developer/CommandLineTools/SDKs/MacOSX13.sdk/usr' '--with-curl' '--with-external-gd' '--with-external-pcre' '--with-ffi' '--with-fpm-user=_www' '--with-fpm-group=_www' '--with-gettext=/opt/homebrew/opt/gettext' '--with-gmp=/opt/homebrew/opt/gmp' '--with-iconv=/Library/Developer/CommandLineTools/SDKs/MacOSX13.sdk/usr' '--with-kerberos' '--with-layout=GNU' '--with-ldap=/opt/homebrew/opt/openldap' '--with-libxml' '--with-libedit' '--with-mhash=/Library/Developer/CommandLineTools/SDKs/MacOSX13.sdk/usr' '--with-mysql-sock=/tmp/mysql.sock' '--with-mysqli=mysqlnd' '--with-ndbm=/Library/Developer/CommandLineTools/SDKs/MacOSX13.sdk/usr' '--with-openssl' '--with-password-argon2=/opt/homebrew/opt/argon2' '--with-pdo-dblib=/opt/homebrew/opt/freetds' '--with-pdo-mysql=mysqlnd' '--with-pdo-odbc=unixODBC,/opt/homebrew/opt/unixodbc' '--with-pdo-pgsql=/opt/homebrew/opt/libpq' '--with-pdo-sqlite' '--with-pgsql=/opt/homebrew/opt/libpq' '--with-pic' '--with-pspell=/opt/homebrew/opt/aspell' '--with-sodium' '--with-sqlite3' '--with-tidy=/opt/homebrew/opt/tidy-html5' '--with-unixODBC' '--with-xsl' '--with-zip' '--with-zlib' '--enable-dtrace' '--with-ldap-sasl' '--with-os-sdkpath=/Library/Developer/CommandLineTools/SDKs/MacOSX13.sdk' 'PKG_CONFIG_PATH=/opt/homebrew/opt/apr/lib/pkgconfig:/opt/homebrew/opt/openssl@3/lib/pkgconfig:/opt/homebrew/opt/apr-util/lib/pkgconfig:/opt/homebrew/opt/argon2/lib/pkgconfig:/opt/homebrew/opt/brotli/lib/pkgconfig:/opt/homebrew/opt/libidn2/lib/pkgconfig:/opt/homebrew/opt/libnghttp2/lib/pkgconfig:/opt/homebrew/opt/libssh2/lib/pkgconfig:/opt/homebrew/opt/openldap/lib/pkgconfig:/opt/homebrew/opt/rtmpdump/lib/pkgconfig:/opt/homebrew/opt/lz4/lib/pkgconfig:/opt/homebrew/opt/xz/lib/pkgconfig:/opt/homebrew/opt/zstd/lib/pkgconfig:/opt/homebrew/opt/curl/lib/pkgconfig:/opt/homebrew/opt/unixodbc/lib/pkgconfig:/opt/homebrew/opt/libpng/lib/pkgconfig:/opt/homebrew/opt/freetype/lib/pkgconfig:/opt/homebrew/opt/fontconfig/lib/pkgconfig:/opt/homebrew/opt/jpeg-turbo/lib/pkgconfig:/opt/homebrew/opt/highway/lib/pkgconfig:/opt/homebrew/opt/imath/lib/pkgconfig:/opt/homebrew/opt/libtiff/lib/pkgconfig:/opt/homebrew/opt/little-cms2/lib/pkgconfig:/opt/homebrew/opt/openexr/lib/pkgconfig:/opt/homebrew/opt/webp/lib/pkgconfig:/opt/homebrew/opt/jpeg-xl/lib/pkgconfig:/opt/homebrew/opt/libvmaf/lib/pkgconfig:/opt/homebrew/opt/aom/lib/pkgconfig:/opt/homebrew/opt/libavif/lib/pkgconfig:/opt/homebrew/opt/gd/lib/pkgconfig:/opt/homebrew/opt/gmp/lib/pkgconfig:/opt/homebrew/opt/icu4c/lib/pkgconfig:/opt/homebrew/opt/krb5/lib/pkgconfig:/opt/homebrew/opt/libpq/lib/pkgconfig:/opt/homebrew/opt/libsodium/lib/pkgconfig:/opt/homebrew/opt/libzip/lib/pkgconfig:/opt/homebrew/opt/oniguruma/lib/pkgconfig:/opt/homebrew/opt/pcre2/lib/pkgconfig:/opt/homebrew/opt/readline/lib/pkgconfig:/opt/homebrew/opt/sqlite/lib/pkgconfig:/opt/homebrew/opt/tidy-html5/lib/pkgconfig' 'PKG_CONFIG_LIBDIR=/usr/lib/pkgconfig:/opt/homebrew/Library/Homebrew/os/mac/pkgconfig/13' 'KERBEROS_CFLAGS= ' 'SASL_CFLAGS=-I/Library/Developer/CommandLineTools/SDKs/MacOSX13.sdk/usr/include/sasl' 'SASL_LIBS=-lsasl2'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /opt/homebrew/etc/php/8.2
Loaded Configuration File => /opt/homebrew/etc/php/8.2/php.ini
Scan this dir for additional .ini files => /opt/homebrew/etc/php/8.2/conf.d
Additional .ini files parsed => /opt/homebrew/etc/php/8.2/conf.d/20-mongodb.ini,
/opt/homebrew/etc/php/8.2/conf.d/ext-opcache.ini

PHP API => 20220829
PHP Extension => 20220829
Zend Extension => 420220829
Zend Extension Build => API420220829,NTS
PHP Extension Build => API20220829,NTS
Debug Build => no
Thread Safety => disabled
Zend Signal Handling => enabled
Zend Memory Manager => enabled
Zend Multibyte Support => provided by mbstring
Zend Max Execution Timers => disabled
IPv6 Support => enabled
DTrace Support => available, disabled

Registered PHP Streams => https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters => zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, convert.*, consumed, dechunk

This program makes use of the Zend Scripting Language Engine:
Zend Engine v4.2.9, Copyright (c) Zend Technologies
    with Zend OPcache v8.2.9, Copyright (c), by Zend Technologies

 _______________________________________________________________________

Configuration

bcmath

BCMath support => enabled

Directive => Local Value => Master Value
bcmath.scale => 0 => 0

bz2

BZip2 Support => Enabled
Stream Wrapper support => compress.bzip2://
Stream Filter support => bzip2.decompress, bzip2.compress
BZip2 Version => 1.0.8, 13-Jul-2019

calendar

Calendar support => enabled

Core

PHP Version => 8.2.9

Directive => Local Value => Master Value
allow_url_fopen => On => On
allow_url_include => Off => Off
arg_separator.input => & => &
arg_separator.output => & => &
auto_append_file => no value => no value
auto_globals_jit => On => On
auto_prepend_file => no value => no value
browscap => no value => no value
default_charset => UTF-8 => UTF-8
default_mimetype => text/html => text/html
disable_classes => no value => no value
disable_functions => no value => no value
display_errors => STDOUT => STDOUT
display_startup_errors => On => On
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => Off => Off
enable_post_data_reading => On => On
error_append_string => no value => no value
error_log => no value => no value
error_log_mode => 0644 => 0644
error_prepend_string => no value => no value
error_reporting => 32767 => 32767
expose_php => On => On
extension_dir => /opt/homebrew/lib/php/pecl/20220829 => /opt/homebrew/lib/php/pecl/20220829
fiber.stack_size => no value => no value
file_uploads => On => On
hard_timeout => 2 => 2
highlight.comment => <font style="color: #FF8000">#FF8000</font> => <font style="color: #FF8000">#FF8000</font>
highlight.default => <font style="color: #0000BB">#0000BB</font> => <font style="color: #0000BB">#0000BB</font>
highlight.html => <font style="color: #000000">#000000</font> => <font style="color: #000000">#000000</font>
highlight.keyword => <font style="color: #007700">#007700</font> => <font style="color: #007700">#007700</font>
highlight.string => <font style="color: #DD0000">#DD0000</font> => <font style="color: #DD0000">#DD0000</font>
html_errors => Off => Off
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => On
include_path => .:/Users/samuelerenati/pear/share/pear => .:/Users/samuelerenati/pear/share/pear
input_encoding => no value => no value
internal_encoding => no value => no value
log_errors => On => On
mail.add_x_header => Off => Off
mail.force_extra_parameters => no value => no value
mail.log => no value => no value
mail.mixed_lf_and_crlf => Off => Off
max_execution_time => 0 => 0
max_file_uploads => 20 => 20
max_input_nesting_level => 64 => 64
max_input_time => -1 => -1
max_input_vars => 1000 => 1000
max_multipart_body_parts => -1 => -1
memory_limit => 128M => 128M
open_basedir => no value => no value
output_buffering => 0 => 0
output_encoding => no value => no value
output_handler => no value => no value
post_max_size => 8M => 8M
precision => 14 => 14
realpath_cache_size => 4096K => 4096K
realpath_cache_ttl => 120 => 120
register_argc_argv => On => On
report_memleaks => On => On
report_zend_debug => Off => Off
request_order => GP => GP
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i => /usr/sbin/sendmail -t -i
serialize_precision => -1 => -1
short_open_tag => Off => Off
SMTP => localhost => localhost
smtp_port => 25 => 25
sys_temp_dir => no value => no value
syslog.facility => LOG_USER => LOG_USER
syslog.filter => no-ctrl => no-ctrl
syslog.ident => php => php
unserialize_callback_func => no value => no value
upload_max_filesize => 2M => 2M
upload_tmp_dir => no value => no value
user_dir => no value => no value
user_ini.cache_ttl => 300 => 300
user_ini.filename => .user.ini => .user.ini
variables_order => GPCS => GPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
zend.assertions => 1 => 1
zend.detect_unicode => On => On
zend.enable_gc => On => On
zend.exception_ignore_args => Off => Off
zend.exception_string_param_max_len => 15 => 15
zend.multibyte => Off => Off
zend.script_encoding => no value => no value
zend.signal_check => Off => Off

ctype

ctype functions => enabled

curl

cURL support => enabled
cURL Information => 8.2.1
Age => 10
Features
AsynchDNS => Yes
CharConv => No
Debug => No
GSS-Negotiate => No
IDN => Yes
IPv6 => Yes
krb4 => No
Largefile => Yes
libz => Yes
NTLM => Yes
NTLMWB => Yes
SPNEGO => Yes
SSL => Yes
SSPI => No
TLS-SRP => Yes
HTTP2 => Yes
GSSAPI => Yes
KERBEROS5 => Yes
UNIX_SOCKETS => Yes
PSL => No
HTTPS_PROXY => Yes
MULTI_SSL => Yes
BROTLI => Yes
ALTSVC => Yes
HTTP3 => No
UNICODE => No
ZSTD => Yes
HSTS => Yes
GSASL => No
Protocols => dict, file, ftp, ftps, gopher, gophers, http, https, imap, imaps, ldap, ldaps, mqtt, pop3, pop3s, rtmp, rtmpe, rtmps, rtmpt, rtmpte, rtmpts, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp
Host => aarch64-apple-darwin22.4.0
SSL Version => (SecureTransport) OpenSSL/3.1.2
ZLib Version => 1.2.11
libSSH Version => libssh2/1.11.0

Directive => Local Value => Master Value
curl.cainfo => no value => no value

date

date/time support => enabled
timelib version => 2022.09
"Olson" Timezone Database Version => 2023.3
Timezone Database => internal
Default timezone => UTC

Directive => Local Value => Master Value
date.default_latitude => 31.7667 => 31.7667
date.default_longitude => 35.2333 => 35.2333
date.sunrise_zenith => 90.833333 => 90.833333
date.sunset_zenith => 90.833333 => 90.833333
date.timezone => UTC => UTC

dba

DBA support => enabled
Supported handlers => ndbm cdb cdb_make inifile flatfile 

Directive => Local Value => Master Value
dba.default_handler => flatfile => flatfile

dom

DOM/XML => enabled
DOM/XML API Version => 20031129
libxml Version => 2.9.13
HTML Support => enabled
XPath Support => enabled
XPointer Support => enabled
Schema Support => enabled
RelaxNG Support => enabled

exif

EXIF Support => enabled
Supported EXIF Version => 0220
Supported filetypes => JPEG, TIFF
Multibyte decoding support using mbstring => enabled
Extended EXIF tag formats => Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson

Directive => Local Value => Master Value
exif.decode_jis_intel => JIS => JIS
exif.decode_jis_motorola => JIS => JIS
exif.decode_unicode_intel => UCS-2LE => UCS-2LE
exif.decode_unicode_motorola => UCS-2BE => UCS-2BE
exif.encode_jis => no value => no value
exif.encode_unicode => ISO-8859-15 => ISO-8859-15

FFI

FFI support => enabled

Directive => Local Value => Master Value
ffi.enable => preload => preload
ffi.preload => no value => no value

fileinfo

fileinfo support => enabled
libmagic => 540

filter

Input Validation and Filtering => enabled

Directive => Local Value => Master Value
filter.default => unsafe_raw => unsafe_raw
filter.default_flags => no value => no value

ftp

FTP support => enabled
FTPS support => enabled

gd

GD Support => enabled
GD headers Version => 2.3.3
GD library Version => 2.3.3
FreeType Support => enabled
FreeType Linkage => with freetype
GIF Read Support => enabled
GIF Create Support => enabled
JPEG Support => enabled
PNG Support => enabled
WBMP Support => enabled
XPM Support => enabled
XBM Support => enabled
WebP Support => enabled
BMP Support => enabled
AVIF Support => enabled
TGA Read Support => enabled

Directive => Local Value => Master Value
gd.jpeg_ignore_warning => On => On

gettext

GetText Support => enabled

gmp

gmp support => enabled
GMP version => 6.2.1

hash

hash support => enabled
Hashing Engines => md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 joaat murmur3a murmur3c murmur3f xxh32 xxh64 xxh3 xxh128 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 

MHASH support => Enabled
MHASH API Version => Emulated Support

iconv

iconv support => enabled
iconv implementation => unknown
iconv library version => unknown

Directive => Local Value => Master Value
iconv.input_encoding => no value => no value
iconv.internal_encoding => no value => no value
iconv.output_encoding => no value => no value

intl

Internationalization support => enabled
ICU version => 73.2
ICU Data version => 73.2
ICU TZData version => 2023c
ICU Unicode version => 15.0

Directive => Local Value => Master Value
intl.default_locale => no value => no value
intl.error_level => 0 => 0
intl.use_exceptions => Off => Off

json

json support => enabled

ldap

LDAP Support => enabled
Total Links => 0/unlimited
API Version => 3001
Vendor Name => OpenLDAP
Vendor Version => 20606
SASL Support => Enabled

Directive => Local Value => Master Value
ldap.max_links => Unlimited => Unlimited

libxml

libXML support => active
libXML Compiled Version => 2.9.13
libXML Loaded Version => 20913
libXML streams => enabled

mbstring

Multibyte Support => enabled
Multibyte string engine => libmbfl
HTTP input encoding translation => disabled
libmbfl version => 1.3.2

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support => enabled
Multibyte regex (oniguruma) version => 6.9.8

Directive => Local Value => Master Value
mbstring.detect_order => no value => no value
mbstring.encoding_translation => Off => Off
mbstring.http_input => no value => no value
mbstring.http_output => no value => no value
mbstring.http_output_conv_mimetypes => ^(text/|application/xhtml\+xml) => ^(text/|application/xhtml\+xml)
mbstring.internal_encoding => no value => no value
mbstring.language => neutral => neutral
mbstring.regex_retry_limit => 1000000 => 1000000
mbstring.regex_stack_limit => 100000 => 100000
mbstring.strict_detection => Off => Off
mbstring.substitute_character => no value => no value

mongodb

MongoDB support => enabled
MongoDB extension version => 1.16.2
MongoDB extension stability => stable
libbson bundled version => 1.24.3
libmongoc bundled version => 1.24.3
libmongoc SSL => enabled
libmongoc SSL library => Secure Transport
libmongoc crypto => enabled
libmongoc crypto library => Common Crypto
libmongoc crypto system profile => disabled
libmongoc SASL => enabled
libmongoc ICU => disabled
libmongoc compression => enabled
libmongoc compression snappy => disabled
libmongoc compression zlib => enabled
libmongoc compression zstd => enabled
libmongocrypt bundled version => 1.8.1
libmongocrypt crypto => enabled
libmongocrypt crypto library => Common Crypto
crypt_shared library version => unknown

Directive => Local Value => Master Value
mongodb.debug => no value => no value

mysqli

MysqlI Support => enabled
Client API library version => mysqlnd 8.2.9
Active Persistent Links => 0
Inactive Persistent Links => 0
Active Links => 0

Directive => Local Value => Master Value
mysqli.allow_local_infile => Off => Off
mysqli.allow_persistent => On => On
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => /tmp/mysql.sock => /tmp/mysql.sock
mysqli.default_user => no value => no value
mysqli.local_infile_directory => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
mysqli.rollback_on_cached_plink => Off => Off

mysqlnd

mysqlnd => enabled
Version => mysqlnd 8.2.9
Compression => supported
core SSL => supported
extended SSL => supported
Command buffer size => 4096
Read buffer size => 32768
Read timeout => 86400
Collecting statistics => Yes
Collecting memory statistics => Yes
Tracing => n/a
Loaded plugins => mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions => pdo_mysql,mysqli

odbc

ODBC Support => enabled
Active Persistent Links => 0
Active Links => 0
ODBC library => unixODBC
ODBCVER => 0x0380
ODBC_CFLAGS => -I/opt/homebrew/Cellar/unixodbc/2.3.12/include
ODBC_LFLAGS =>  
ODBC_LIBS => -L/opt/homebrew/Cellar/unixodbc/2.3.12/lib -lodbc

Directive => Local Value => Master Value
odbc.allow_persistent => On => On
odbc.check_persistent => On => On
odbc.default_cursortype => Static cursor => Static cursor
odbc.default_db => no value => no value
odbc.default_pw => no value => no value
odbc.default_user => no value => no value
odbc.defaultbinmode => return as is => return as is
odbc.defaultlrl => return up to 4096 bytes => return up to 4096 bytes
odbc.max_links => Unlimited => Unlimited
odbc.max_persistent => Unlimited => Unlimited

openssl

OpenSSL support => enabled
OpenSSL Library Version => OpenSSL 3.1.2 1 Aug 2023
OpenSSL Header Version => OpenSSL 3.1.2 1 Aug 2023
Openssl default config => /opt/homebrew/etc/openssl@3/openssl.cnf

Directive => Local Value => Master Value
openssl.cafile => /opt/homebrew/etc/openssl@3/cert.pem => /opt/homebrew/etc/openssl@3/cert.pem
openssl.capath => /opt/homebrew/etc/openssl@3/certs => /opt/homebrew/etc/openssl@3/certs

pcntl

pcntl support => enabled

pcre

PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 10.42 2022-12-11
PCRE Unicode Version => 14.0.0
PCRE JIT Support => enabled
PCRE JIT Target => ARM-64 64bit (little endian + unaligned)

Directive => Local Value => Master Value
pcre.backtrack_limit => 1000000 => 1000000
pcre.jit => On => On
pcre.recursion_limit => 100000 => 100000

PDO

PDO support => enabled
PDO drivers => dblib, mysql, odbc, pgsql, sqlite

pdo_dblib

PDO Driver for FreeTDS/Sybase DB-lib => enabled
Flavour => freetds

pdo_mysql

PDO Driver for MySQL => enabled
Client API version => mysqlnd 8.2.9

Directive => Local Value => Master Value
pdo_mysql.default_socket => /tmp/mysql.sock => /tmp/mysql.sock

PDO_ODBC

PDO Driver for ODBC (unixODBC) => enabled
ODBC Connection Pooling => Enabled, strict matching

pdo_pgsql

PDO Driver for PostgreSQL => enabled
PostgreSQL(libpq) Version => 15.4

pdo_sqlite

PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.42.0

pgsql

PostgreSQL Support => enabled
PostgreSQL (libpq) Version => 15.4
Multibyte character support => enabled
Active Persistent Links => 0
Active Links => 0

Directive => Local Value => Master Value
pgsql.allow_persistent => On => On
pgsql.auto_reset_persistent => Off => Off
pgsql.ignore_notice => Off => Off
pgsql.log_notice => Off => Off
pgsql.max_links => Unlimited => Unlimited
pgsql.max_persistent => Unlimited => Unlimited

Phar

Phar: PHP Archive support => enabled
Phar API version => 1.1.1
Phar-based phar archives => enabled
Tar-based phar archives => enabled
ZIP-based phar archives => enabled
gzip compression => enabled
bzip2 compression => enabled
Native OpenSSL support => enabled

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
Directive => Local Value => Master Value
phar.cache_list => no value => no value
phar.readonly => On => On
phar.require_hash => On => On

posix

POSIX support => enabled

pspell

PSpell Support => enabled

random

Version => 8.2.9

readline

Readline Support => enabled
Readline library => EditLine wrapper

Directive => Local Value => Master Value
cli.pager => no value => no value
cli.prompt => \b \>  => \b \> 

Reflection

Reflection => enabled

session

Session Support => enabled
Registered save handlers => files user 
Registered serializer handlers => php_serialize php php_binary 

Directive => Local Value => Master Value
session.auto_start => Off => Off
session.cache_expire => 180 => 180
session.cache_limiter => nocache => nocache
session.cookie_domain => no value => no value
session.cookie_httponly => Off => Off
session.cookie_lifetime => 0 => 0
session.cookie_path => / => /
session.cookie_samesite => no value => no value
session.cookie_secure => Off => Off
session.gc_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 1 => 1
session.lazy_write => On => On
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => no value => no value
session.serialize_handler => php => php
session.sid_bits_per_character => 5 => 5
session.sid_length => 26 => 26
session.upload_progress.cleanup => On => On
session.upload_progress.enabled => On => On
session.upload_progress.freq => 1% => 1%
session.upload_progress.min_freq => 1 => 1
session.upload_progress.name => PHP_SESSION_UPLOAD_PROGRESS => PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix => upload_progress_ => upload_progress_
session.use_cookies => On => On
session.use_only_cookies => On => On
session.use_strict_mode => Off => Off
session.use_trans_sid => Off => Off

shmop

shmop support => enabled

SimpleXML

SimpleXML support => enabled
Schema support => enabled

soap

Soap Client => enabled
Soap Server => enabled

Directive => Local Value => Master Value
soap.wsdl_cache => 1 => 1
soap.wsdl_cache_dir => /tmp => /tmp
soap.wsdl_cache_enabled => On => On
soap.wsdl_cache_limit => 5 => 5
soap.wsdl_cache_ttl => 86400 => 86400

sockets

Sockets Support => enabled

sodium

sodium support => enabled
libsodium headers version => 1.0.18
libsodium library version => 1.0.18

SPL

SPL support => enabled
Interfaces => OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

sqlite3

SQLite3 support => enabled
SQLite Library => 3.42.0

Directive => Local Value => Master Value
sqlite3.defensive => On => On
sqlite3.extension_dir => no value => no value

standard

Dynamic Library Support => enabled
Path to sendmail => /usr/sbin/sendmail -t -i

Directive => Local Value => Master Value
assert.active => On => On
assert.bail => Off => Off
assert.callback => no value => no value
assert.exception => On => On
assert.warning => On => On
auto_detect_line_endings => Off => Off
default_socket_timeout => 60 => 60
from => no value => no value
session.trans_sid_hosts => no value => no value
session.trans_sid_tags => a=href,area=href,frame=src,form= => a=href,area=href,frame=src,form=
unserialize_max_depth => 4096 => 4096
url_rewriter.hosts => no value => no value
url_rewriter.tags => form= => form=
user_agent => no value => no value

sysvmsg

sysvmsg support => enabled

sysvsem

sysvsem support => enabled

sysvshm

sysvshm support => enabled

tidy

Tidy support => enabled
libTidy Version => 5.8.0
libTidy Release => 2021/07/10

Directive => Local Value => Master Value
tidy.clean_output => Off => Off
tidy.default_config => no value => no value

tokenizer

Tokenizer Support => enabled

xml

XML Support => active
XML Namespace Support => active
libxml2 Version => 2.9.13

xmlreader

XMLReader => enabled

xmlwriter

XMLWriter => enabled

xsl

XSL => enabled
libxslt Version => 1.1.35
libxslt compiled against libxml Version => 2.9.13
EXSLT => enabled
libexslt Version => 0.8.20

Zend OPcache

Opcode Caching => Disabled
Optimization => Disabled
SHM Cache => Enabled
File Cache => Disabled
JIT => On
Startup Failed => Opcode Caching is disabled for CLI

Directive => Local Value => Master Value
opcache.blacklist_filename => no value => no value
opcache.consistency_checks => 0 => 0
opcache.dups_fix => Off => Off
opcache.enable => On => On
opcache.enable_cli => Off => Off
opcache.enable_file_override => Off => Off
opcache.error_log => no value => no value
opcache.file_cache => no value => no value
opcache.file_cache_consistency_checks => On => On
opcache.file_cache_only => Off => Off
opcache.file_update_protection => 2 => 2
opcache.force_restart_timeout => 180 => 180
opcache.huge_code_pages => Off => Off
opcache.interned_strings_buffer => 8 => 8
opcache.jit => tracing => tracing
opcache.jit_bisect_limit => 0 => 0
opcache.jit_blacklist_root_trace => 16 => 16
opcache.jit_blacklist_side_trace => 8 => 8
opcache.jit_buffer_size => 0 => 0
opcache.jit_debug => 0 => 0
opcache.jit_hot_func => 127 => 127
opcache.jit_hot_loop => 64 => 64
opcache.jit_hot_return => 8 => 8
opcache.jit_hot_side_exit => 8 => 8
opcache.jit_max_exit_counters => 8192 => 8192
opcache.jit_max_loop_unrolls => 8 => 8
opcache.jit_max_polymorphic_calls => 2 => 2
opcache.jit_max_recursive_calls => 2 => 2
opcache.jit_max_recursive_returns => 2 => 2
opcache.jit_max_root_traces => 1024 => 1024
opcache.jit_max_side_traces => 128 => 128
opcache.jit_prof_threshold => 0.005 => 0.005
opcache.lockfile_path => /tmp => /tmp
opcache.log_verbosity_level => 1 => 1
opcache.max_accelerated_files => 10000 => 10000
opcache.max_file_size => 0 => 0
opcache.max_wasted_percentage => 5 => 5
opcache.memory_consumption => 128 => 128
opcache.opt_debug_level => 0 => 0
opcache.optimization_level => 0x7FFEBFFF => 0x7FFEBFFF
opcache.preferred_memory_model => no value => no value
opcache.preload => no value => no value
opcache.preload_user => no value => no value
opcache.protect_memory => Off => Off
opcache.record_warnings => Off => Off
opcache.restrict_api => no value => no value
opcache.revalidate_freq => 2 => 2
opcache.revalidate_path => Off => Off
opcache.save_comments => On => On
opcache.use_cwd => On => On
opcache.validate_permission => Off => Off
opcache.validate_root => Off => Off
opcache.validate_timestamps => On => On

zip

Zip => enabled
Zip version => 1.21.1
Libzip version => 1.10.0
BZIP2 compression => Yes
XZ compression => Yes
ZSTD compression => Yes
AES-128 encryption => Yes
AES-192 encryption => Yes
AES-256 encryption => Yes

zlib

ZLib Support => enabled
Stream Wrapper => compress.zlib://
Stream Filter => zlib.inflate, zlib.deflate
Compiled Version => 1.2.11
Linked Version => 1.2.11

Directive => Local Value => Master Value
zlib.output_compression => Off => Off
zlib.output_compression_level => -1 => -1
zlib.output_handler => no value => no value

Additional Modules

Module Name

Environment

Variable => Value
TERM_PROGRAM => Apple_Terminal
SHELL => /bin/zsh
TERM => xterm-256color
TMPDIR => /var/folders/d1/tw29lx9n6q5923xvcld4ssx40000gn/T/
TERM_PROGRAM_VERSION => 447
TERM_SESSION_ID => 03A528FC-E961-417E-B7C2-04D8889370B7
USER => samuelerenati
SSH_AUTH_SOCK => /private/tmp/com.apple.launchd.pr5h4cUAuh/Listeners
PATH => /Users/samuelerenati/.sdkman/candidates/java/current/bin:/opt/homebrew/Cellar/node@14/bin:/Users/samuelerenati/miniforge3/bin:/opt/homebrew/bin:/Library/Frameworks/Python.framework/Versions/2.7/bin:/opt/homebrew/bin:/opt/homebrew/sbin:/usr/local/bin:/System/Cryptexes/App/usr/bin:/usr/bin:/bin:/usr/sbin:/sbin:/opt/X11/bin:/Library/Apple/usr/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/local/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/appleinternal/bin
LaunchInstanceID => 484613A8-E2E4-4D38-9FCA-A51A8876DFC5
__CFBundleIdentifier => com.apple.Terminal
PWD => /var/tmp
XPC_FLAGS => 0x0
XPC_SERVICE_NAME => 0
SHLVL => 1
HOME => /Users/samuelerenati
LOGNAME => samuelerenati
DISPLAY => /private/tmp/com.apple.launchd.e7eyNLbIB9/org.macosforge.xquartz:0
SECURITYSESSIONID => 186b4
OLDPWD => /var/tmp
HOMEBREW_PREFIX => /opt/homebrew
HOMEBREW_CELLAR => /opt/homebrew/Cellar
HOMEBREW_REPOSITORY => /opt/homebrew
MANPATH => /opt/homebrew/share/man::
INFOPATH => /opt/homebrew/share/info:
JAVA_HOME => /Users/samuelerenati/.sdkman/candidates/java/current
SDKMAN_DIR => /Users/samuelerenati/.sdkman
SDKMAN_VERSION => 5.17.0
SDKMAN_CANDIDATES_API => https://api.sdkman.io/2
SDKMAN_PLATFORM => darwinarm64
SDKMAN_CANDIDATES_DIR => /Users/samuelerenati/.sdkman/candidates
LANG => it_IT.UTF-8
_ => /opt/homebrew/bin/php
__CF_USER_TEXT_ENCODING => 0x1F5:0x0:0x4

PHP Variables

Variable => Value
$_SERVER['TERM_PROGRAM'] => Apple_Terminal
$_SERVER['SHELL'] => /bin/zsh
$_SERVER['TERM'] => xterm-256color
$_SERVER['TMPDIR'] => /var/folders/d1/tw29lx9n6q5923xvcld4ssx40000gn/T/
$_SERVER['TERM_PROGRAM_VERSION'] => 447
$_SERVER['TERM_SESSION_ID'] => 03A528FC-E961-417E-B7C2-04D8889370B7
$_SERVER['USER'] => samuelerenati
$_SERVER['SSH_AUTH_SOCK'] => /private/tmp/com.apple.launchd.pr5h4cUAuh/Listeners
$_SERVER['PATH'] => /Users/samuelerenati/.sdkman/candidates/java/current/bin:/opt/homebrew/Cellar/node@14/bin:/Users/samuelerenati/miniforge3/bin:/opt/homebrew/bin:/Library/Frameworks/Python.framework/Versions/2.7/bin:/opt/homebrew/bin:/opt/homebrew/sbin:/usr/local/bin:/System/Cryptexes/App/usr/bin:/usr/bin:/bin:/usr/sbin:/sbin:/opt/X11/bin:/Library/Apple/usr/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/local/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/appleinternal/bin
$_SERVER['LaunchInstanceID'] => 484613A8-E2E4-4D38-9FCA-A51A8876DFC5
$_SERVER['__CFBundleIdentifier'] => com.apple.Terminal
$_SERVER['PWD'] => /var/tmp
$_SERVER['XPC_FLAGS'] => 0x0
$_SERVER['XPC_SERVICE_NAME'] => 0
$_SERVER['SHLVL'] => 1
$_SERVER['HOME'] => /Users/samuelerenati
$_SERVER['LOGNAME'] => samuelerenati
$_SERVER['DISPLAY'] => /private/tmp/com.apple.launchd.e7eyNLbIB9/org.macosforge.xquartz:0
$_SERVER['SECURITYSESSIONID'] => 186b4
$_SERVER['OLDPWD'] => /var/tmp
$_SERVER['HOMEBREW_PREFIX'] => /opt/homebrew
$_SERVER['HOMEBREW_CELLAR'] => /opt/homebrew/Cellar
$_SERVER['HOMEBREW_REPOSITORY'] => /opt/homebrew
$_SERVER['MANPATH'] => /opt/homebrew/share/man::
$_SERVER['INFOPATH'] => /opt/homebrew/share/info:
$_SERVER['JAVA_HOME'] => /Users/samuelerenati/.sdkman/candidates/java/current
$_SERVER['SDKMAN_DIR'] => /Users/samuelerenati/.sdkman
$_SERVER['SDKMAN_VERSION'] => 5.17.0
$_SERVER['SDKMAN_CANDIDATES_API'] => https://api.sdkman.io/2
$_SERVER['SDKMAN_PLATFORM'] => darwinarm64
$_SERVER['SDKMAN_CANDIDATES_DIR'] => /Users/samuelerenati/.sdkman/candidates
$_SERVER['LANG'] => it_IT.UTF-8
$_SERVER['_'] => /opt/homebrew/bin/php
$_SERVER['__CF_USER_TEXT_ENCODING'] => 0x1F5:0x0:0x4
$_SERVER['PHP_SELF'] => 
$_SERVER['SCRIPT_NAME'] => 
$_SERVER['SCRIPT_FILENAME'] => 
$_SERVER['PATH_TRANSLATED'] => 
$_SERVER['DOCUMENT_ROOT'] => 
$_SERVER['REQUEST_TIME_FLOAT'] => 1692632962.8035
$_SERVER['REQUEST_TIME'] => 1692632962
$_SERVER['argv'] => Array
(
)

$_SERVER['argc'] => 0

[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dba
dom
exif
FFI
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
intl
json
ldap
libxml
mbstring
mongodb
mysqli
mysqlnd
odbc
openssl
pcntl
pcre
PDO
pdo_dblib
pdo_mysql
PDO_ODBC
pdo_pgsql
pdo_sqlite
pgsql
Phar
posix
pspell
random
readline
Reflection
session
shmop
SimpleXML
soap
sockets
sodium
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tidy
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache
name     : mongodb/mongodb
descrip. : MongoDB driver library
keywords : database, driver, mongodb, persistence
versions : * 1.16.0
type     : library
license  : Apache License 2.0 (Apache-2.0) (OSI approved) https://spdx.org/licenses/Apache-2.0.html#licenseText
homepage : https://jira.mongodb.org/browse/PHPLIB
source   : [git] https://github.com/mongodb/mongo-php-library.git d4cdf057a67cb99a32db8984a16959bfa7ca7eb5
dist     : [zip] https://api.github.com/repos/mongodb/mongo-php-library/zipball/d4cdf057a67cb99a32db8984a16959bfa7ca7eb5 d4cdf057a67cb99a32db8984a16959bfa7ca7eb5
path     : /Users/samuelerenati/Documents/ProgettiPhp/satorinforma.dev/vendor/mongodb/mongodb
names    : mongodb/mongodb

support
issues : https://github.com/mongodb/mongo-php-library/issues
source : https://github.com/mongodb/mongo-php-library/tree/1.16.0

autoload
files
psr-4
MongoDB\ => src/

requires
ext-hash *
ext-json *
ext-mongodb ^1.16.0
jean85/pretty-package-versions ^2.0.1
php ^7.2 || ^8.0
symfony/polyfill-php73 ^1.27
symfony/polyfill-php80 ^1.27
symfony/polyfill-php81 ^1.27

requires (dev)
doctrine/coding-standard ^11.1
rector/rector ^0.16.0
squizlabs/php_codesniffer ^3.7
symfony/phpunit-bridge ^5.2
vimeo/psalm ^4.28

Test Script

use Exception;
use MongoDB\Client;
use MongoDB\Driver\ServerApi;
$uri = mongodb+srv://<url>/?retryWrites=true&w=majority;
// Specify Stable API version 1
$apiVersion = new ServerApi(ServerApi::V1);
// Create a new client and connect to the server
$client = new MongoDB\Client($uri, [], ['serverApi' => $apiVersion]);
try {
    // Send a ping to confirm a successful connection
    $client->selectDatabase('admin')->command(['ping' => 1]);
    echo "Pinged your deployment. You successfully connected to MongoDB!\n";
} catch (Exception $e) {
    printf($e->getMessage());
}

Expected and Actual Behavior

Expect to connect and query without error 502

Debug Log

[2023-08-21T15:54:56.567881+00:00]     PHONGO: DEBUG   > Connection string: 'mongodb://<url>authSource=admin&retryWrites=true&w=majority'
[2023-08-21T15:54:56.568185+00:00]     PHONGO: DEBUG   > Creating Manager, phongo-1.16.2[stable] - mongoc-1.24.3(bundled), libbson-1.24.3(bundled), php-8.2.9
[2023-08-21T15:54:56.568209+00:00]     PHONGO: DEBUG   > Setting driver handshake data: { name: 'ext-mongodb:PHP / PHPLIB ', version: '1.16.2 / 1.16.0 ', platform: 'PHP 8.2.9 ' }
[2023-08-21T15:54:56.568250+00:00]     client: TRACE   > ENTRY: mongoc_client_new_from_uri_with_error():1076
[2023-08-21T15:54:56.568277+00:00]     mongoc: TRACE   > ENTRY: mongoc_topology_description_init():80
[2023-08-21T15:54:56.568317+00:00]     mongoc: TRACE   >  EXIT: mongoc_topology_description_init():99
[2023-08-21T15:54:56.568358+00:00]     mongoc: TRACE   > ENTRY: mongoc_server_description_init():124
[2023-08-21T15:54:56.568381+00:00]     mongoc: TRACE   >  EXIT: mongoc_server_description_init():152
[2023-08-21T15:54:56.568399+00:00]     mongoc: TRACE   > ENTRY: mongoc_server_description_init():124
[2023-08-21T15:54:56.568411+00:00]     mongoc: TRACE   >  EXIT: mongoc_server_description_init():152
[2023-08-21T15:54:56.568424+00:00]     mongoc: TRACE   > ENTRY: mongoc_server_description_init():124
[2023-08-21T15:54:56.568435+00:00]     mongoc: TRACE   >  EXIT: mongoc_server_description_init():152
[2023-08-21T15:54:56.568464+00:00]    cluster: TRACE   > ENTRY: mongoc_cluster_init():2725
[2023-08-21T15:54:56.568487+00:00]    cluster: TRACE   >  EXIT: mongoc_cluster_init():2752
[2023-08-21T15:54:56.568501+00:00]     client: TRACE   >  EXIT: mongoc_client_new_from_uri_with_error():1106
[2023-08-21T15:54:56.568521+00:00]     PHONGO: DEBUG   > Created client with hash: a:4:{s:3:"pid";i:10002;s:3:"uri";s:276:"mongodb://<url>authSource=admin&retryWrites=true&w=majority";s:7:"options";a:0:{}s:13:"driverOptions";a:1:{s:6:"driver";a:2:{s:4:"name";s:6:"PHPLIB";s:7:"version";s:6:"1.16.0";}}}
[2023-08-21T15:54:56.568534+00:00]     PHONGO: DEBUG   > Stored persistent client with hash: a:4:{s:3:"pid";i:10002;s:3:"uri";s:276:"mongodb://<url>authSource=admin&retryWrites=true&w=majority";s:7:"options";a:0:{}s:13:"driverOptions";a:1:{s:6:"driver";a:2:{s:4:"name";s:6:"PHPLIB";s:7:"version";s:6:"1.16.0";}}}
[2023-08-21T15:54:56.733686+00:00] PHONGO-BSON: TRACE   > encoding document
[2023-08-21T15:54:56.733763+00:00] PHONGO-BSON: TRACE   > encoding document
[2023-08-21T15:54:56.733776+00:00] PHONGO-BSON: TRACE   > encoding document
[2023-08-21T15:54:56.733881+00:00]     PHONGO: DEBUG   > Connection string: 'mongodb://<url>authSource=admin&retryWrites=true&w=majority'
[2023-08-21T15:54:56.733902+00:00]     PHONGO: DEBUG   > Creating Manager, phongo-1.16.2[stable] - mongoc-1.24.3(bundled), libbson-1.24.3(bundled), php-8.2.9
[2023-08-21T15:54:56.733915+00:00]     PHONGO: DEBUG   > Setting driver handshake data: { name: 'ext-mongodb:PHP ', version: '1.16.2 ', platform: 'PHP 8.2.9 ' }
[2023-08-21T15:54:56.733938+00:00]     client: TRACE   > ENTRY: mongoc_client_new_from_uri_with_error():1076
[2023-08-21T15:54:56.733969+00:00]     mongoc: TRACE   > ENTRY: mongoc_topology_description_init():80
[2023-08-21T15:54:56.734021+00:00]     mongoc: TRACE   >  EXIT: mongoc_topology_description_init():99
[2023-08-21T15:54:56.734074+00:00]     mongoc: TRACE   > ENTRY: mongoc_server_description_init():124
[2023-08-21T15:54:56.734086+00:00]     mongoc: TRACE   >  EXIT: mongoc_server_description_init():152
[2023-08-21T15:54:56.734097+00:00]     mongoc: TRACE   > ENTRY: mongoc_server_description_init():124
[2023-08-21T15:54:56.734106+00:00]     mongoc: TRACE   >  EXIT: mongoc_server_description_init():152
[2023-08-21T15:54:56.734153+00:00]     mongoc: TRACE   > ENTRY: mongoc_server_description_init():124
[2023-08-21T15:54:56.734170+00:00]     mongoc: TRACE   >  EXIT: mongoc_server_description_init():152
[2023-08-21T15:54:56.734184+00:00]    cluster: TRACE   > ENTRY: mongoc_cluster_init():2725
[2023-08-21T15:54:56.734204+00:00]    cluster: TRACE   >  EXIT: mongoc_cluster_init():2752
[2023-08-21T15:54:56.734216+00:00]     client: TRACE   >  EXIT: mongoc_client_new_from_uri_with_error():1106
[2023-08-21T15:54:56.734226+00:00]     PHONGO: DEBUG   > Created client with hash: a:4:{s:3:"pid";i:10002;s:3:"uri";s:276:"mongodb://<url>authSource=admin&retryWrites=true&w=majority";s:7:"options";a:0:{}s:13:"driverOptions";a:0:{}}
[2023-08-21T15:54:56.734235+00:00]     PHONGO: DEBUG   > Stored persistent client with hash: a:4:{s:3:"pid";i:10002;s:3:"uri";s:276:"mongodb://<url>authSource=admin&retryWrites=true&w=majority";s:7:"options";a:0:{}s:13:"driverOptions";a:0:{}}
[2023-08-21T15:54:56.734253+00:00]     mongoc: TRACE   > ENTRY: mongoc_topology_description_init():80
[2023-08-21T15:54:56.734262+00:00]     mongoc: TRACE   >  EXIT: mongoc_topology_description_init():99
[2023-08-21T15:54:56.734279+00:00]     mongoc: TRACE   > ENTRY: mongoc_topology_description_cleanup():221
[2023-08-21T15:54:56.734287+00:00]     mongoc: TRACE   >  EXIT: mongoc_topology_description_cleanup():235
[2023-08-21T15:54:56.734306+00:00] topology_scanner: TRACE   > ENTRY: mongoc_topology_scanner_node_setup_tcp():930
[2023-08-21T15:54:56.771487+00:00] topology_scanner: TRACE   >  EXIT: mongoc_topology_scanner_node_setup_tcp():988
[2023-08-21T15:54:56.771571+00:00] topology_scanner: TRACE   > ENTRY: mongoc_topology_scanner_node_setup_tcp():930
[2023-08-21T15:54:56.815018+00:00] topology_scanner: TRACE   >  EXIT: mongoc_topology_scanner_node_setup_tcp():988
[2023-08-21T15:54:56.815148+00:00] topology_scanner: TRACE   > ENTRY: mongoc_topology_scanner_node_setup_tcp():930
[2023-08-21T15:54:56.839137+00:00] topology_scanner: TRACE   >  EXIT: mongoc_topology_scanner_node_setup_tcp():988
[2023-08-21T15:54:56.839261+00:00]     socket: TRACE   > ENTRY: mongoc_socket_new():999
[2023-08-21T15:54:56.839360+00:00]     socket: TRACE   > ENTRY: _mongoc_socket_setnodelay():569
[2023-08-21T15:54:56.839394+00:00]     socket: TRACE   >  EXIT: _mongoc_socket_setnodelay():581
[2023-08-21T15:54:56.839412+00:00]     socket: TRACE   > ENTRY: _mongoc_socket_setkeepalive():534
[2023-08-21T15:54:56.839435+00:00]     socket: TRACE   > TRACE: _mongoc_socket_setkeepalive():538 Setting SO_KEEPALIVE
[2023-08-21T15:54:56.839463+00:00]     socket: TRACE   > TRACE: _mongoc_socket_set_sockopt_if_less():481 'TCP_KEEPALIVE' is 7200, target value is 120
[2023-08-21T15:54:56.839486+00:00]     socket: TRACE   > TRACE: _mongoc_socket_set_sockopt_if_less():492 'TCP_KEEPALIVE' value changed to 120
[2023-08-21T15:54:56.839508+00:00]     socket: TRACE   > TRACE: _mongoc_socket_set_sockopt_if_less():481 'TCP_KEEPINTVL' is 75, target value is 10
[2023-08-21T15:54:56.839530+00:00]     socket: TRACE   > TRACE: _mongoc_socket_set_sockopt_if_less():492 'TCP_KEEPINTVL' value changed to 10
[2023-08-21T15:54:56.839552+00:00]     socket: TRACE   > TRACE: _mongoc_socket_set_sockopt_if_less():481 'TCP_KEEPCNT' is 8, target value is 9
[2023-08-21T15:54:56.839660+00:00]     socket: TRACE   >  EXIT: _mongoc_socket_setkeepalive():550
[2023-08-21T15:54:56.839681+00:00]     socket: TRACE   >  EXIT: mongoc_socket_new():1037
[2023-08-21T15:54:56.839699+00:00]     socket: TRACE   > ENTRY: mongoc_socket_connect():859
[2023-08-21T15:54:56.840179+00:00]     socket: TRACE   > TRACE: _mongoc_socket_capture_errno():68 setting errno: 36 Operation now in progress
[2023-08-21T15:54:56.840208+00:00]     socket: TRACE   > TRACE: _mongoc_socket_errno_is_again():630 errno is: 36
[2023-08-21T15:54:56.840224+00:00]     socket: TRACE   > ENTRY: _mongoc_socket_wait():161
[2023-08-21T15:54:56.840279+00:00]     socket: TRACE   >  EXIT: _mongoc_socket_wait():254
[2023-08-21T15:54:56.840300+00:00]     socket: TRACE   >  EXIT: mongoc_socket_connect():889
[2023-08-21T15:54:56.840340+00:00] stream-tls-secure_transport: TRACE   > ENTRY: mongoc_stream_tls_secure_transport_new():666
alcaeus commented 1 year ago

Thank you for reporting the issue and including a debug log from the driver. From it, I can see two connection attempts (both starting with the "Connection String [...]" line. The first one abruptly ends while encoding a document, but the second attempt starts right after that, so I assume the server was still alive. This second attempt continues further, and then abruptly stops when creating the TLS stream. Can you confirm that the time of that last log entry is consistent with when the php-fpm process crashes?

Also, it would be helpful if you could try to reproduce it in the command-line. I ran a quick test with an Atlas cluster on my M1 Pro but couldn't reproduce a crash.

samuelexyz commented 1 year ago

Of course this is the test code:

<?php

require __DIR__ . '/vendor/autoload.php';

use MongoDB\Client;
use MongoDB\Driver\ServerApi;

ini_set('mongodb.debug', '1');

$uri ="mongodb+srv://<url>/?retryWrites=true&w=majority;";
// Specify Stable API version 1
$apiVersion = new ServerApi(ServerApi::V1);
// Create a new client and connect to the server
$client = new MongoDB\Client($uri, [], ['serverApi' => $apiVersion]);
try {
    // Send a ping to confirm a successful connection
    $client->selectDatabase('admin')->command(['ping' => 1]);
    echo "Pinged your deployment. You successfully connected to MongoDB!\n";
} catch (Exception $e) {
    printf($e->getMessage());
}
?>

FROM COMMAND LINE:

commandline.log

IT'S WORKING

FROM WEB:

CREATE TWO LOGS

web1.log

AND THIS ONE

web2.log

php error log :

2023/08/22 15:18:34 [error] 32206#0: *1 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /index.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083"
2023/08/22 15:18:34 [error] 32206#0: *1 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083", referrer: "http://localhost:8083/index.php"
2023/08/22 15:18:35 [error] 32206#0: *1 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /index.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083"
2023/08/22 15:18:35 [error] 32206#0: *1 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083", referrer: "http://localhost:8083/index.php"
2023/08/22 15:18:37 [error] 32206#0: *7 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083"
2023/08/22 15:18:38 [error] 32206#0: *7 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083", referrer: "http://localhost:8083/"
2023/08/22 15:22:14 [error] 32206#0: *11 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083"
2023/08/22 15:22:14 [error] 32206#0: *11 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083", referrer: "http://localhost:8083/"
2023/08/22 15:23:05 [error] 32206#0: *19 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083"
2023/08/22 15:23:06 [error] 32206#0: *19 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083", referrer: "http://localhost:8083/"
2023/08/22 15:23:13 [error] 32206#0: *23 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083"
2023/08/22 15:23:13 [error] 32206#0: *23 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083", referrer: "http://localhost:8083/"
2023/08/22 15:23:46 [error] 32206#0: *27 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083"
2023/08/22 15:23:47 [error] 32206#0: *27 kevent() reported about an closed connection (54: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost:8083", referrer: "http://localhost:8083/"

PHP FPM LOG

[22-Aug-2023 15:17:37] WARNING: [pool www] child 31673 exited on signal 11 (SIGSEGV) after 28.652821 seconds from start
[22-Aug-2023 15:17:37] NOTICE: [pool www] child 31901 started
[22-Aug-2023 15:17:37] WARNING: [pool www] child 31674 exited on signal 11 (SIGSEGV) after 28.955554 seconds from start
[22-Aug-2023 15:17:37] NOTICE: [pool www] child 31902 started
[22-Aug-2023 15:17:39] WARNING: [pool www] child 31901 exited on signal 11 (SIGSEGV) after 2.173381 seconds from start
[22-Aug-2023 15:17:39] NOTICE: [pool www] child 31906 started
[22-Aug-2023 15:17:39] WARNING: [pool www] child 31902 exited on signal 11 (SIGSEGV) after 2.000508 seconds from start
[22-Aug-2023 15:17:39] NOTICE: [pool www] child 31907 started
[22-Aug-2023 15:17:46] WARNING: [pool www] child 31906 exited on signal 11 (SIGSEGV) after 6.970074 seconds from start
[22-Aug-2023 15:17:46] NOTICE: [pool www] child 31919 started
[22-Aug-2023 15:17:46] WARNING: [pool www] child 31907 exited on signal 11 (SIGSEGV) after 6.955088 seconds from start
[22-Aug-2023 15:17:46] NOTICE: [pool www] child 31920 started
[22-Aug-2023 15:18:34] WARNING: [pool www] child 31919 exited on signal 11 (SIGSEGV) after 47.763101 seconds from start
[22-Aug-2023 15:18:34] NOTICE: [pool www] child 32371 started
[22-Aug-2023 15:18:34] WARNING: [pool www] child 31920 exited on signal 11 (SIGSEGV) after 47.779048 seconds from start
[22-Aug-2023 15:18:34] NOTICE: [pool www] child 32374 started
[22-Aug-2023 15:18:35] WARNING: [pool www] child 32371 exited on signal 11 (SIGSEGV) after 0.979081 seconds from start
[22-Aug-2023 15:18:35] NOTICE: [pool www] child 32376 started
[22-Aug-2023 15:18:35] WARNING: [pool www] child 32374 exited on signal 11 (SIGSEGV) after 0.980579 seconds from start
[22-Aug-2023 15:18:35] NOTICE: [pool www] child 32377 started
[22-Aug-2023 15:18:37] WARNING: [pool www] child 32376 exited on signal 11 (SIGSEGV) after 2.492545 seconds from start
[22-Aug-2023 15:18:37] NOTICE: [pool www] child 32380 started
[22-Aug-2023 15:18:38] WARNING: [pool www] child 32377 exited on signal 11 (SIGSEGV) after 2.481370 seconds from start
[22-Aug-2023 15:18:38] NOTICE: [pool www] child 32381 started
[22-Aug-2023 15:22:14] WARNING: [pool www] child 32380 exited on signal 11 (SIGSEGV) after 216.656886 seconds from start
[22-Aug-2023 15:22:14] NOTICE: [pool www] child 32736 started
[22-Aug-2023 15:22:14] WARNING: [pool www] child 32381 exited on signal 11 (SIGSEGV) after 216.660919 seconds from start
[22-Aug-2023 15:22:14] NOTICE: [pool www] child 32738 started
[22-Aug-2023 15:23:05] WARNING: [pool www] child 32736 exited on signal 11 (SIGSEGV) after 51.378758 seconds from start
[22-Aug-2023 15:23:05] NOTICE: [pool www] child 32907 started
[22-Aug-2023 15:23:06] WARNING: [pool www] child 32738 exited on signal 11 (SIGSEGV) after 51.418109 seconds from start
[22-Aug-2023 15:23:06] NOTICE: [pool www] child 32910 started
[22-Aug-2023 15:23:13] WARNING: [pool www] child 32907 exited on signal 11 (SIGSEGV) after 7.557748 seconds from start
[22-Aug-2023 15:23:13] NOTICE: [pool www] child 32924 started
[22-Aug-2023 15:23:13] WARNING: [pool www] child 32910 exited on signal 11 (SIGSEGV) after 7.534901 seconds from start
[22-Aug-2023 15:23:13] NOTICE: [pool www] child 32925 started
[22-Aug-2023 15:23:46] WARNING: [pool www] child 32924 exited on signal 11 (SIGSEGV) after 33.374329 seconds from start
[22-Aug-2023 15:23:46] NOTICE: [pool www] child 32987 started
[22-Aug-2023 15:23:47] WARNING: [pool www] child 32925 exited on signal 11 (SIGSEGV) after 33.375672 seconds from start
[22-Aug-2023 15:23:47] NOTICE: [pool www] child 32990 started

if you need anything else just ask me

web2.log web1.log commandline.log

alcaeus commented 1 year ago

Hi @samuelexyz, sorry for the lack of reply. I managed to reproduce the issue on my machine and have created PHPC-2280 to track this internally. I'm still investigating why the crash happens, as it is somewhere within system libraries and only triggered when connecting through FPM, but not through the CLI SAPI.

samuelexyz commented 1 year ago

Hi @alcaeus Thank you i will follow PHPC-2280

alcaeus commented 1 year ago

Hi @samuelexyz, the segmentation fault happens due to the driver being compiled with Secure Transport as SSL library but php-fpm being compiled with OpenSSL. Compiling the driver using OpenSSL fixes the issue. Please note that until we get to PHPC-1017, specifying these options when running pecl install is impossible, so you'll have to configure the driver manually. Instructions for this can be found in the installation docs. Please note that due to an issue with homebrew (which I haven't been able to work around; see https://github.com/mongodb/mongo-php-driver/issues/1405), you also need to specify the homebrew include directory using CFLAGS. I used the following configure call in my tests:

CFLAGS=-I/opt/homebrew/include ./configure --enable-mongodb-developer-flags --with-mongodb-ssl=openssl

I've created https://github.com/mongodb/mongo-php-driver/pull/1463, which targets the v1.16 branch and will be released in an upcoming patch release. With the steps above, you should be able to work around the issue in the meantime; the changes merely change the detection mechanism to prefer OpenSSL over Secure Transport.

alcaeus commented 1 year ago

Just a minor update: we're releasing the fix in the 1.17 version of the driver. After consideration, we decided that this was too big a change for a 1.16 patch release. I expect 1.17 to be released in the near future, but in the meantime you can use the instructions above to work around the issue.

alcaeus commented 6 months ago

Closing as this has been released in 1.17.0.