First a basic question - on a windows VPS can I have the IIS server and the EWB servrer running at the same time as long as they are listening on different ports?  IIS is on port 80 and I have EWB on port 8080?


Background:

I hvae set up a Windows VPS on Godaddy, installed EWB, and am able to run all of the example applications (including the database and login module exampes) from remote deskitop.  However, I cannot run any of the database or login module applications from my domanis.  For example, the panels example runs fine from:

http://p51web.com/panels.html

but the database example will not run from  http://p51web.com/databaseclient.html


Again, if I remote desktop to my Windows VPS, I can run the databaseclient example fine, but not when I try to access it as a website from the following link

http://p51web.com/databaseclient.html


Any help would be greatly appreciated.

p.s. Tim, with decades of experience in pascal/delphi programming, I love the concept of EWB - very easy to use given my background.  Exellent work, and I look forward to the applications which will be created using EWB.

On 1/26/2019 6:13 AM, DFL wrote:
> First a basic question - on a windows VPS can I have the IIS server and the EWB servrer running at the same time as long as they are listening on different ports?  IIS is on port 80 and I have EWB on port 8080?

Yes - they are in no way related so as long you have them on different
ports all is OK.

> I hvae set up a Windows VPS on Godaddy, installed EWB, and am able to run all of the example applications (including the database and login module exampes) from remote deskitop.  However, I cannot run any of the database or login module applications from my domanis.  For example, the panels example runs fine from:
>
> http://p51web.com/panels.html
>
> but the database example will not run from  http://p51web.com/databaseclient.html
>
>
> Again, if I remote desktop to my Windows VPS, I can run the databaseclient example fine, but not when I try to access it as a website from the following link
>
> http://p51web.com/databaseclient.html

Easiest way to start is to use browser debug tools (usually F12).

In this case the app is trying to access for data using this request:

http://p51web.com/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife

which returns "404 not found"  so that is the reason it does not work.

The way i would troubleshoot this is to take the app out of the picture
and see if you can access data first - it's just JSON so you can query
the URL app would use.

1. You mentioned EWB Web server is using port 8080 so should data
request should go to "http://p51web.com:8080/databasemodules...." ? (EWB
Server and not IIS)

2. However this URL not accessible at all so either it's not open to
internet (i.e. firewall blocking) or EWB server is not listening on
external interface (i.e. is it listening on 0.0.0.0 which would mean all
IPs or is it configured for 127.0.0.1 or such thus being accessible only
locally).

Would need some more info to comment further

Raul

Raul, thank you!  I will try working on this in the morning - David.


Raul wrote:

On 1/26/2019 6:13 AM, DFL wrote:
> First a basic question - on a windows VPS can I have the IIS server and the EWB servrer running at the same time as long as they are listening on different ports?  IIS is on port 80 and I have EWB on port 8080?

Yes - they are in no way related so as long you have them on different
ports all is OK.

> I hvae set up a Windows VPS on Godaddy, installed EWB, and am able to run all of the example applications (including the database and login module exampes) from remote deskitop.  However, I cannot run any of the database or login module applications from my domanis.  For example, the panels example runs fine from:
>
> http://p51web.com/panels.html
>
> but the database example will not run from  http://p51web.com/databaseclient.html
>
>
> Again, if I remote desktop to my Windows VPS, I can run the databaseclient example fine, but not when I try to access it as a website from the following link
>
> http://p51web.com/databaseclient.html

Easiest way to start is to use browser debug tools (usually F12).

In this case the app is trying to access for data using this request:

http://p51web.com/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife

which returns "404 not found"  so that is the reason it does not work.

The way i would troubleshoot this is to take the app out of the picture
and see if you can access data first - it's just JSON so you can query
the URL app would use.

1. You mentioned EWB Web server is using port 8080 so should data
request should go to "http://p51web.com:8080/databasemodules...." ? (EWB
Server and not IIS)

2. However this URL not accessible at all so either it's not open to
internet (i.e. firewall blocking) or EWB server is not listening on
external interface (i.e. is it listening on 0.0.0.0 which would mean all
IPs or is it configured for 127.0.0.1 or such thus being accessible only
locally).

Would need some more info to comment further

Raul

Raul, thank you.  You were correct, I needed to open the port 8080, which is now done and I can access the data directly as you suggested at the following link:

http://p51web.com:8080/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife


However, I am still not able to not able to access the data using the EWB server at the following link:


http://p51web.com/databaseclient.html


Thoughts on how best to resolve?


Raul wrote:

On 1/26/2019 6:13 AM, DFL wrote:
> First a basic question - on a windows VPS can I have the IIS server and the EWB servrer running at the same time as long as they are listening on different ports?  IIS is on port 80 and I have EWB on port 8080?

Yes - they are in no way related so as long you have them on different
ports all is OK.

> I hvae set up a Windows VPS on Godaddy, installed EWB, and am able to run all of the example applications (including the database and login module exampes) from remote deskitop.  However, I cannot run any of the database or login module applications from my domanis.  For example, the panels example runs fine from:
>
> http://p51web.com/panels.html
>
> but the database example will not run from  http://p51web.com/databaseclient.html
>
>
> Again, if I remote desktop to my Windows VPS, I can run the databaseclient example fine, but not when I try to access it as a website from the following link
>
> http://p51web.com/databaseclient.html

Easiest way to start is to use browser debug tools (usually F12).

In this case the app is trying to access for data using this request:

http://p51web.com/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife

which returns "404 not found"  so that is the reason it does not work.

The way i would troubleshoot this is to take the app out of the picture
and see if you can access data first - it's just JSON so you can query
the URL app would use.

1. You mentioned EWB Web server is using port 8080 so should data
request should go to "http://p51web.com:8080/databasemodules...." ? (EWB
Server and not IIS)

2. However this URL not accessible at all so either it's not open to
internet (i.e. firewall blocking) or EWB server is not listening on
external interface (i.e. is it listening on 0.0.0.0 which would mean all
IPs or is it configured for 127.0.0.1 or such thus being accessible only
locally).

Would need some more info to comment further

Raul

On 2/24/2019 9:36 AM, DFL wrote:
> Raul, thank you.  You were correct, I needed to open the port 8080, which is now done and I can access the data directly as you suggested at the following link:
>
> http://p51web.com:8080/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife
>
> However, I am still not able to not able to access the data using the EWB server at the following link:
>
> http://p51web.com/databaseclient.html
>
> Thoughts on how best to resolve?
>

The issue is that the app is still trying to load data from:

http://p51web.com/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife

In fact the error message is IIS error page for 404 not found it seems.

Since you are running app and DB from different servers you need to make
sure your app knows where database is - this is done by database base
URL and by default it assumes data is on the same server as app.

In the startup of the app (like in form create, before you do any
dataset access) you need to override this.

You could try something like this :

Database.BaseURL:='http://p51web.com:8080/databasemodules/databasemodule';


and see if things start working

Raul

Raul, THANK YOU!!!!  I finally got the connection to the database to work at:

http://www.p51web.com/databaseclient.html


I had to go to my server settings and "enable cross origin resource sharing"  - is that ok?  or is their somethign else I shoudl be doing in my setup such that I do not need to enable cross origine resource sharing?



Raul wrote:

On 2/24/2019 9:36 AM, DFL wrote:
> Raul, thank you.  You were correct, I needed to open the port 8080, which is now done and I can access the data directly as you suggested at the following link:
>
> http://p51web.com:8080/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife
>
> However, I am still not able to not able to access the data using the EWB server at the following link:
>
> http://p51web.com/databaseclient.html
>
> Thoughts on how best to resolve?
>

The issue is that the app is still trying to load data from:

http://p51web.com/databasemodules/databasemodule?method=rows&database=Default&dataset=Biolife

In fact the error message is IIS error page for 404 not found it seems.

Since you are running app and DB from different servers you need to make
sure your app knows where database is - this is done by database base
URL and by default it assumes data is on the same server as app.

In the startup of the app (like in form create, before you do any
dataset access) you need to override this.

You could try something like this :

Database.BaseURL:='http://p51web.com:8080/databasemodules/databasemodule';


and see if things start working

Raul

On 3/8/2019 7:04 AM, DFL wrote:
> Raul, THANK YOU!!!!  I finally got the connection to the database to work at:

Great!

> I had to go to my server settings and "enable cross origin resource sharing"  - is that ok?  or is their somethign else I shoudl be doing in my setup such that I do not need to enable cross origine resource sharing?

Yes you would need this enabled in the scenario you are describing -
you're hosting app from one web server (IIS) and data from another (EWB)
so you do need to allow CORS. Only time it's not needed is when app and
data are hosted from the same server.

Raul