宝塔linux面板+php7.4安装pdo_sqlsrv和sqlsrv扩展包 sqlserver数据库 报错

第一步：安装odbc驱动程序

curl https://packages.microsoft.com/config/rhel/7/prod.repo | sudo tee /etc/yum.repos.d/mssql-release.repo
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y yum install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo yum install unixODBC-devel

报错：needed by msodbcsql-13.1.9.2-1.x86_64，

尝试rpm手动脱机安装

sudo yum install glibc e2fsprogs krb5-libs openssl unixODBC unixODBC-devel #install dependencies
sudo rpm -i  msodbcsql-13.1.X.X-X.x86_64.rpm #install the Driver

msodbcsql-13.1不行，装msodbcsql17可能new  pdo的时候报502错误，排查系统是openeuler，在centos7.9上测试是可以安装msodbcsql-13.1的

#RHEL 7 and Oracle Linux 7
curl https://packages.microsoft.com/config/rhel/7/prod.repo | sudo tee /etc/yum.repos.d/mssql-release.repo

sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install -y msodbcsql17
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y yum install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo yum install -y unixODBC-devel

第二步：安装php7.4对应的pdo_sqlsrv扩展包

wget http://pecl.php.net/get/sqlsrv-5.10.1.tgz
tar -zxvf sqlsrv-5.10.1.tgz
cd sqlsrv-5.10.1
/www/server/php/74/bin/phpize
./configure --with-php-config=/www/server/php/74/bin/php-config
make && make install
echo "extension = sqlsrv.so" >> /www/server/php/74/etc/php.ini

重启
php-fpm