|
|
Posted by Jerry Stuckle on 08/05/07 00:18
sgottenyc@yahoo.com wrote:
> On Aug 4, 6:51 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> sgotte...@yahoo.com wrote:
>>> Hello,
>>> If you could assist me with the following situation, I would be very
>>> grateful.
>>> In my current position, we have to use a non-traditional server setup
>>> to serve PHP-generated web pages.
>>> Instead of the classic web server->database server setup, what they
>>> have at my workplace instead is:
>>> Apache on a frontend server -> needing to connect to IIS on a backend
>>> server -> needing to connect to SQL Server on the same backend
>>> server. This setup was used, according to my understanding, for
>>> security reasons.
>>> Throughout my PHP scripts, I use connection code similar to the
>>> following, which has worked fine for me on a
>>> web server->database server test system:
>>> $myServer = "testservername";
>>> $myUser = "testuser";
>>> $myPass = "testuserspassword";
>>> $myDB = "dbName";
>>> $conn = mssql_connect($myServer, $myUser, $myPass)
>>> or die("Couldn't connect to Server.");
>>> mssql_select_db($myDB, $conn)
>>> or die("Couldn't connect to Server database.");
>>> I have changed this code to something like the following for the
>>> production system:
>>> $myServer = "backendservername";
>>> $myUser = "testuser";
>>> $myPass = "testuserspassword";
>>> $myDB = "dbName";
>>> $conn = mssql_connect($myServer, $myUser, $myPass)
>>> or die("Could not connect to Server.");
>>> mssql_select_db($myDB, $conn)
>>> or die("Couldn't connect to server database.");
>>> The problem is that we are receiving the "Could not connect to Server"
>>> error. I.e., Apache is not switching over the processing of the PHP
>>> page to the IIS server once the '$myServer = "backendservername";'
>>> code is encountered. (Both the IIS and Apache have the same PHP codes
>>> in their respective directories.)
>>> My questions:
>>> 1) Is this sort of setup workable? Has anyone successfully used a
>>> similar setup to this in the past?
>>> 2) If so, how to do it? Can Apache be instructed to switch over
>>> processing of PHP pages to the IIS on the other server via some sort
>>> of Apache command? Is it instead some sort of programming issue that
>>> I can fix by tweaking my code?
>>> Thanks again for your assistance. I very much appreciate it,
>>> Simon Gottesman
>> THe only way processing will switch to the IIS server is if you load a
>> page containing PHP code on the IIS server or otherwise specifically
>> call PHP code on that other server. For that you need to be using
>> networking functions. Exactly which ones depend on your setup, and
>> every one is different.
>>
>> Just setting a variable doesn't do a thing - other than set the variable.
>>
>> And your connection is trying to connect to the mssql server at
>> "backendserver", not execute PHP code on that server.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> Thanks for the reply Jerry.
> Do you mean using PHP sockets?
>
>
If your system is set up to use sockets, yes. But there could be a lot
of other ways to set it up, also - web pages on the IIS server and RPC
are two of them.
You need to find out how the admins set up this network before you can
get your code working.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|