我的目标是使用 PHP 连接到 MS SQL Server 2005。我已经安装了 PHP 和 ODBC。我运行的是CentOS7。
PHP Version => 5.4.16
....(来自 php -i)....
odbc
ODBC Support => enabled
在尝试安装 freetds 和 php-mssql 扩展时,我遇到了 2 个依赖性问题。 (见下文)
[root@localhost freetds-dev.0.92.377]# yum install php-mssql freetds
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirror.supremebytes.com
* epel: mirror.sfo12.us.leaseweb.net
* extras: mirrors.cat.pdx.edu
* rpmforge: mirror.hmc.edu
* updates: ftp.osuosl.org
Resolving Dependencies
--> Running transaction check
---> Package freetds.x86_64 0:0.91-2.el6 will be installed
--> Processing Dependency: libgnutls.so.26(GNUTLS_1_4)(64bit) for package: freetds-0.91-2.el6.x86_64
--> Processing Dependency: libgnutls.so.26()(64bit) for package: freetds-0.91-2.el6.x86_64
---> Package php-mssql.x86_64 0:5.3.3-3.el6 will be installed
--> Processing Dependency: php(zend-abi) = 20090626 for package: php-mssql-5.3.3-3.el6.x86_64
--> Processing Dependency: php(api) = 20090626 for package: php-mssql-5.3.3-3.el6.x86_64
--> Finished Dependency Resolution
Error: Package: freetds-0.91-2.el6.x86_64 (epel)
Requires: libgnutls.so.26()(64bit)
Error: Package: php-mssql-5.3.3-3.el6.x86_64 (epel)
Requires: php(api) = 20090626
Installed: php-common-5.4.16-23.el7_0.3.x86_64 (@updates)
php(api) = 20100412-64
Available: php-common-5.4.16-21.el7.x86_64 (base)
php(api) = 20100412-64
Available: php-common-5.4.16-23.el7_0.x86_64 (updates)
php(api) = 20100412-64
Available: php-common-5.4.16-23.el7_0.1.x86_64 (updates)
php(api) = 20100412-64
Error: Package: freetds-0.91-2.el6.x86_64 (epel)
Requires: libgnutls.so.26(GNUTLS_1_4)(64bit)
Error: Package: php-mssql-5.3.3-3.el6.x86_64 (epel)
Requires: php(zend-abi) = 20090626
Installed: php-common-5.4.16-23.el7_0.3.x86_64 (@updates)
php(zend-abi) = 20100525-64
Available: php-common-5.4.16-21.el7.x86_64 (base)
php(zend-abi) = 20100525-64
Available: php-common-5.4.16-23.el7_0.x86_64 (updates)
php(zend-abi) = 20100525-64
Available: php-common-5.4.16-23.el7_0.1.x86_64 (updates)
php(zend-abi) = 20100525-64
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
我有 libgnutls.so 版本 28
/usr/lib64/libgnutls.so.28
/usr/lib64/libgnutls.so.28.20.4
答案1
您尝试安装的软件包el6
在版本中,表明它适用于 CentOS 6,而不是 7。看来您为错误的 CentOS 版本添加了 EPEL 存储库。您应该删除yum
EPEL6 的配置并添加 7 的配置。您可以使用以下命令添加 7 的配置:
rpm -Uvh http://mirror.oss.ou.edu/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
答案2
我正在努力解决同样的问题,并且我知道我使用的是 OS 7。
我应该尝试单独安装 freetds 吗?
Red Hat Enterprise Linux Server release 7.3 (Maipo)
Installed:
epel-release.noarch 0:7-9
Error: Package: freetds-0.91-2.el6.x86_64 (epel)
Requires: libgnutls.so.26(GNUTLS_1_4)(64bit)
/usr/lib64/.libgnutls.so.28.41.16.hmac
/usr/lib64/.libgnutls.so.28.hmac
/usr/lib64/libgnutls.so.28
/usr/lib64/libgnutls.so.28.41.16