求助:macOS Sonoma14.6.1+XAMPP8.1.17下PHP sqlsrv连接失败问题
macOS下sqlsrv/pdo_sqlsrv驱动加载失败问题求助
我可在Windows和Ubuntu24.04系统上正常安装并使用微软的sqlsrv及pdo_sqlsrv驱动包,但在macOS环境下运行时始终无法加载连接驱动!即便在PHP文件中开启错误日志,页面也无法显示错误信息。
测试代码:
<?php ini_set('display_errors', 1); error_reporting(E_ALL); $serverName = '1nnnnn'; // Or your server name $connectionOptions = array( "Database" => 'Ifffffff', // Your database name 'Uid' => 'ddddddd', 'PWD' => 'passwoooord', ); //echo "???"; // when this two commented lines are uncommented the site shows ??? //exit(); // when this two commented lines are uncommented the site shows ??? $conn = sqlsrv_connect($serverName, $connectionOptions); if ($conn === false) { die(print_r(sqlsrv_errors(), true)); } echo "Connection successful!"; ?>
XAMPP/Apache运行其他PHP程序均正常,但调用sqlsrv_connect时浏览器显示'unable to open',php_error_log文件中的错误信息为:
dyld[8251]: Assertion failed: (this->magic == kMagic), function loadAddress, file Loader.cpp, line 163.
已完成的排查操作:
- 确认驱动文件位置正确:
@MacBook-Pro-von-Ha---en no-debug-non-zts-20210902 % ls opcache.so pdo_dblib.so pdo_sqlsrv.so pgsql.so sqlsrv.so - php.ini文件中已加载对应扩展:
extension=sqlsrv.so extension=pdo_sqlsrv.so - 权限设置正确:
-rwxr-xr-x@ 1 root admin 26720 6 Apr 2023 pdo_dblib.so -rwxr-xr-x@ 1 root admin 333216 11 Sep 15:42 pdo_sqlsrv.so -rwxr-xr-x@ 1 root admin 117680 6 Apr 2023 pgsql.so -rwxr-xr-x@ 1 root admin 336880 11 Sep 17:14 sqlsrv.so - 已安装ODBC:
g@MacBook-Pro-von-Ha---en no-debug-non-zts-20210902 % odbcinst -j unixODBC 2.3.12 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /Users/hjbeling/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8
请求各位提供解决方法!
内容的提问来源于stack exchange,提问作者Hans Beling
相关产品推荐
相关产品推荐

