note 85676 added to function.mssql-connect

From: 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

« previous php.notes (#144345) next »