note 85676 added to function.mssql-connect
| From: | Anonymous at osu1 dot php dot net | Date: | Thu, 11 Sep 2008 20:18:05 +0000 |
| Subject: | note 85676 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-144345@lists.php.net to get a copy of this message | ||
This might be obvious to some, but here is a quick tidbit that might save you some time if
you're 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.
----
Server IP: 209.41.74.194
Probable Submitter: 66.63.145.114
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/85676
Del: integrated -- https://master.php.net/note/delete/85676/integrated
Del: useless -- https://master.php.net/note/delete/85676/useless
Del: bad code -- https://master.php.net/note/delete/85676/bad+code
Del: spam -- https://master.php.net/note/delete/85676/spam
Del: non-english -- https://master.php.net/note/delete/85676/non-english
Del: in docs -- https://master.php.net/note/delete/85676/in+docs
Del: other reasons-- https://master.php.net/note/delete/85676
Reject -- https://master.php.net/note/reject/85676
Search -- https://master.php.net/manage/user-notes.php