Would it be possible to release the PHP 8.2 extensions compiled for libstdc++ 3.4.25 (RHEL 8) as well?

[HenkPoley]

Technically currently you only need the newer _ZSt28__throw_bad_array_new_lengthv@GLIBCXX_3.4.29 (associated with throwing std::bad_array_new_length) from libstdc++ 3.4.29. An internal change. So I don't expect much issues.

PHP version
8.2.25

PHP SQLSRV or PDO_SQLSRV version
5.12.0

Microsoft ODBC Driver version

SQL Server version

Client operating system
RHEL 8.10

Table schema

Problem description
PDO_SQLSRV_8.2_NTS.so and SQLSRV_8.2_NTS.so doesn't load on RHEL 8.10, due to it running libstdc++ 3.4.25 and not 3.4.29.

Expected behavior and actual behavior
Probably that Red Hat in-support distros, are supported by third parties like Microsoft. But that a Microsoft policy decision 🤷‍♂️

Repro code or steps to reproduce

[stoica353]

+1 need help here...
RedHat 9 is not on supported matrix, and Redhat 8 cannot use libstdc++ 3.4.29 required by driver .. :|

[HenkPoley]

Meanwhile I compiled it myself.

Or you could fetch it from Remi's RPM repository, but that is probably a policy 'trust issue'.

Compiling the PHP sqlsrv Extension for Linux with RPM

For RHEL 8.10

Install AlmaLinux 8, for example in in WSL2. Update to “AlmaLinux release 8.10 (Cerulean Leopard)” in /etc/almalinux-release:

sudo dnf update
sudo dnf module install php:8.2
sudo dnf install clang
sudo dnf install autoconf automake libtool bison
sudo dnf install sqlite-devel httpd-devel libcurl-devel libpng-devel readline-devel

sudo dnf config-manager --set-enabled powertools
sudo dnf install re2c

Double-check that PHP 8.2.25 is still installed:

php --version

Then download the PHP 8.2.25 source code:

• https://www.php.net/downloads.php
• or alternatively: https://github.com/php/php-src/releases/tag/php-8.2.25

Download the sqlsrv driver from:

• https://learn.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver16
• or https://github.com/microsoft/msphpsql/releases/tag/v5.12.0
• or check for a newer release at: https://github.com/microsoft/msphpsql/releases/

The install-msodbc18.sh script to install msodbc18 on RPM-based Linux:

• https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=redhat18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline

On production, PHP uses the Apache 2.0 handler (--with-apxs2), which will be patched to work with non-thread-safe (NTS) builds. The message checking whether to enable thread-safety... is automatically set to yes when using apxs2. Expect that NTS affects sqlsrv, not apxs2. The =shared options ensure that the extensions/modules are compiled as shared modules rather than being built into PHP.

Compiling PHP 8.2.25

cd ~/Downloads
wget https://www.php.net/distributions/php-8.2.25.tar.gz
wget https://github.com/microsoft/msphpsql/archive/refs/tags/v5.12.0.tar.gz
tar -xzf php-8.2.25.tar.gz
tar -xzf v5.12.0.tar.gz

cat msphpsql-5.12.0/buildscripts/README.md

cp -r msphpsql-5.12.0/source/shared/ msphpsql-5.12.0/source/sqlsrv/shared/
cp -r msphpsql-5.12.0/source/shared/ msphpsql-5.12.0/source/pdo_sqlsrv/shared/
cp -r msphpsql-5.12.0/source/sqlsrv/ php-8.2.25/ext/sqlsrv/
cp -r msphpsql-5.12.0/source/pdo_sqlsrv/ php-8.2.25/ext/pdo_sqlsrv/

cd php-8.2.25
./buildconf --force
./configure --with-openssl --with-kerberos --with-curl --enable-gd --with-zlib --with-readline --disable-zts --enable-sqlsrv=shared --enable-pdo --with-pdo-sqlsrv=shared
make -j

Note: The tests mentioned at the end of make work with ~5GB files, so you might not want to run them.

Testing the Extensions

To test whether the extensions load, create a minimal-php.ini file. You can load it with:

php -c minimal-php.ini

Place the following in minimal-php.ini (note that the extension_dir path now uses “USER”):

extension_dir = "/home/USER/Downloads/php-8.2.25/modules"

extension = sqlsrv.so
extension = /usr/lib64/php/modules/pdo.so
extension = pdo_sqlsrv.so

We are using the pdo.so from the distro’s PHP installation. There may be a patch somewhere that re-enables --with-pdo=shared (see [this Debian thread](https://alioth-lists-archive.debian.net/pipermail/pkg-php-maint/2009-August/006109.html), which was disabled in PHP 5.1.x). By setting PHP_INI_SCAN_DIR= with only a space (i.e. nothing) after the equals sign, you ensure that no additional .ini files are loaded:

PHP_INI_SCAN_DIR= php -c minimal-php.ini -m

Check that under [PHP Modules] both sqlsrv and pdo_sqlsrv are listed, and that there are no warnings such as Warning: PHP Startup: Unable to load dynamic library:

[PHP Modules]
Core
date
filter
hash
json
libxml
openssl
pcntl
pcre
PDO
pdo_sqlsrv
random
readline
Reflection
session
SPL
sqlsrv
standard
zlib

[Zend Modules]

The modules are located in ~/Downloads/php-8.2.25/:

• ./modules/sqlsrv.so
• ./modules/pdo_sqlsrv.so

To put them them in a tarball:

cd modules
tar -czvf php_sqlsrv_extensions.tar.gz sqlsrv.so pdo_sqlsrv.so
cp php_sqlsrv_extensions.tar.gz /mnt/c/Users/$USER/Downloads/