连接到ms sql 2005从php使用freetds在centos上

Question

我在从PHP连接到MS SQL 2005时出现问题。

我能够从壳连接，使用...

tsql -S 10.0.0.134 -p 1433 -U gareth 

输入一个简单的查询按预期工作...

1> SELECT @@VERSION AS MSSQL_VERSION 
2> go 
MSSQL_VERSION 
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) 
Nov 24 2008 13:01:59 
Copyright (c) 1988-2005 Microsoft Corporation 
Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1) 

但是，从PHP脚本试图这样做不工作...

$test = mssql_connect('10.0.0.134:1433', 'gareth', 'mypass'); 

...并产生一个mssql_connect（）[function.mssql-connect]：无法连接到服务器错误。

我可以在/ usr/lib/php/modules中看到mssql.so模块，phpinfo（）显示模块已加载。

我很乐意使用odbc_connect代替，如果有人能告诉我一个例子配置freetds.conf和odbc.conf

感谢

Answer 1

这是我能找到的关于PHP.net您的问题。也许它会帮助你解决它。

This might be obvious to some, but here is a quick tidbit that might save you some time if you are using FreeTDS in Linux: 
Be sure that you have these two lines in freetds.conf: 
dump file = /tmp/freetds.log 
dump file append = yes 

so you can tail -f it in the background of debugging the problem. This helped me find my issue on on CentOS Linux: 

1) tsql test works 

2) php-mssql connection in php also works WHEN RUN FROM THE SHELL 

3) running PHP through apache does NOT work. 

my /tmp/freetds.log file told me: 
net.c:168:Connecting to MYDBSERVER port MYDBPORT 
net.c:237:tds_open_socket: MYDBSERVER:MYDBPORT: Permission denied 

and the answer was my firewall/SELinux was denying the Apache processes access to connect to the remote MSSQL DB port, but my shell accounts were fine.