Gentlemen
I need some help.
Full disclosure - I am not a php/angular developer. I am just a guy who has somehow ended up managing a project that is using this technology. So I am going to explain the issue in as much layman/quasi-tech language as possible and hope it makes enough sense to some of you who can then help me.
We have a bootstrap/angular.js application running on a webserver.
The UI calls a PHP script that sends a query to the sql server and returns the result of the query to the UI as a json object.
Here is how we deployed the application
1. Bootstrap UI with angular.js on the frontend server (serverFront)
2. PHPs deployed on middleware server (serverMiddle)
3. sql server running the database (serverDB)
There is a .js file on the front end that calls the php using the following code -
$http({
method: "POST",
data: {
data: current
}
The problem is -
ServerFront is in the DMZ exposed to the internet.
ServerMiddle is inside the firewall.
ServerFront can ping and access ServerMiddle
However - when we access the application from the internet (outside of our network), when the .js tries to send it to the php file on the middleware using the url =
https://serverMiddle/static/php/search1.php, we get an error saying ERR_NAME_NOT_RESOLVED ...probably because serverMiddle is not knows outsideour network ?
How can we make this three tier architecture work ....where the UI in the DMZ talks to the middleware server hosting the PHP files inside our firewall talking to the sql sserver insdie our network ?
thanks for any help you can render in this matter.