Posted by sgottenyc on 08/05/07 00:30

On Aug 4, 7:18 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> sgotte...@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.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

Thanks for the info,
I will look into it.

[Back to original message]