Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 10 total
Thread settings for datasets when wanting to deploy to real server..
Sun, Mar 16 2014 1:03 AMPermanent Link

Bruno Larochelle

I'm new to EWB, but experienced with DBISAM, databases, and fairly comfortable with web servers etc.

Although I'm able to do local testing of a simple 1-table (dbisam) web application using EWB, I'm a little lost at the moment in trying to deploy a simple example on to a 'real' server (not 'localhost').

Server : I am using the EWB web server provided, and have installed and configured that on to my external machine. It is hooked up to the dataset which I call 'testdata' and I can see that the connection is fine and I can see my data on the 'preview' tab. I have configured and registered the server with the EWB IDE, and selected it as the web server to use (instead of the default local server).

Web app : this is where I'm a little confused, particularly in the 'connection properties' of the 'Editing dataset' form for my 'testdata'. Do I set this as a 'local' dataset, or a 'remote' dataset? If it is 'local', do I specify the settings local to the server? If it is 'remote'.. do I simply provide the hostname and the databasename? I have yet been able to 'preview' the data in the dataset configuration.. can't find the table etc etc.. I'm a tad confused here, as you can no doubt tell, would love a hint or two from those who have been down this path.

thanks

Bruno Larochelle
Sun, Mar 16 2014 11:08 AMPermanent Link

Uli Becker

Bruno,

> Server : I am using the EWB web server provided, and have installed and configured that on to my external machine. It is hooked up to the dataset which I call 'testdata' and I can see that the connection is fine and I can see my data on the 'preview' tab. I have configured and registered the server with the EWB IDE, and selected it as the web server to use (instead of the default local server).

Correct.

> Web app : this is where I'm a little confused, particularly in the 'connection properties' of the 'Editing dataset' form for my 'testdata'. Do I set this as a 'local' dataset, or a 'remote' dataset? If it is 'local', do I specify the settings local to the server? If it is 'remote'.. do I simply provide the hostname and the databasename? I have yet been able to 'preview' the data in the dataset configuration.. can't find the table etc etc.. I'm a tad confused here, as you can no doubt tell, would love a hint or two from those who have been down this path.

Actually the you *can* use the dataset manager in the EWB IDE, but you
don't *need* to use it when using a remote server. When you execute the
web app and connect to a remote server, the dataset settings of the
server are decisive.

If you don't use the dataset manager in the IDE, qou can drop a dataset
component on your form and fetch the columns from the remote server by
using a server request (right icon after having double clicked the
dataset component) like this:

http://MyServerIP/datasets?method=columns&dataset=TestData

That should import all columns of the dataset and you are all done.

Hope that helps.

Uli


Sun, Mar 16 2014 1:53 PMPermanent Link

Bruno Larochelle

Thanks Uli, that is helping me understand a few things

I followed as you said, and tried to tell the dataset to fetch it's columns from the remote server :

http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=columns&dataset=testdata

(that machine is running a live ewb server, test purposes)

..

this however gives me error 12029 (can't connect, I searched the forum).

I decided to try running a local server, also on 8086, and doing the same thing :

http://localhost:8086/datasets?method=columns&dataset=testdata

and that worked fine.

I have checked the firewalls, antivirus etc.. I may be wrong but I think everything should be open for this.

I will continue fooling around, possibly trying on another server.

regards.. Bruno





Uli Becker wrote:

Bruno,

...

> to 'preview' the data in the dataset configuration.. can't find the table etc etc.. I'm a tad confused here, as you can > no doubt tell, would love a hint or two from those who have been down this path.

Actually the you *can* use the dataset manager in the EWB IDE, but you
don't *need* to use it when using a remote server. When you execute the
web app and connect to a remote server, the dataset settings of the
server are decisive.

If you don't use the dataset manager in the IDE, qou can drop a dataset
component on your form and fetch the columns from the remote server by
using a server request (right icon after having double clicked the
dataset component) like this:

http://MyServerIP/datasets?method=columns&dataset=TestData

That should import all columns of the dataset and you are all done.

Hope that helps.

Uli
Sun, Mar 16 2014 2:29 PMPermanent Link

Uli Becker

Bruno,

> I followed as you said, and tried to tell the dataset to fetch it's columns from the remote server :
> http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=columns&dataset=testdata
>
> (that machine is running a live ewb server, test purposes)
> this however gives me error 12029 (can't connect, I searched the forum).

Are you sure that the server is accessible regardless of the EWB Server
configuration? Just create a test.html and try.
I just tried the URL you posted and it's pending.

Also: you can get the rows of the dataset in JSON format using a similar
request:

http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=rows&dataset=testdata

From Tim:
<<
Do you have FireFox or Chrome ?  If so, then you can use the F12
developer tools window to debug what is getting sent "over the wire" via
the Network panel, and if there is any error occurring during the process.
>>

Uli

Sun, Mar 16 2014 3:00 PMPermanent Link

Bruno Larochelle

Uli.. thanks again for your time here

I created a small html doc, and still am UNable to see it :

http://vcmac.edm.ab.ec.gc.ca:8086/index.html
or
http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html

so it would appear something on that server is not letting me go through 8086

my configuration settings on the EWB server :

-> server -> domain .. '' (blank)
-> connections -> listening IP .. '' (blank)
-> content -> content folder .. location of my data, also location of 'index.html' (static content, as I understand it)
-> datasets -> 'testdata' which appears to properly connect to the data


I will try using Chrome, as suggested, to see what is getting hung up


regrads .. Bruno

///////////////////////////


Uli Becker wrote:

Bruno,

> I followed as you said, and tried to tell the dataset to fetch it's columns from the remote server :
> http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=columns&dataset=testdata
>
> (that machine is running a live ewb server, test purposes)
> this however gives me error 12029 (can't connect, I searched the forum).

Are you sure that the server is accessible regardless of the EWB Server
configuration? Just create a test.html and try.
I just tried the URL you posted and it's pending.

Also: you can get the rows of the dataset in JSON format using a similar
request:

http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=rows&dataset=testdata

From Tim:
<<
Do you have FireFox or Chrome ?  If so, then you can use the F12
developer tools window to debug what is getting sent "over the wire" via
the Network panel, and if there is any error occurring during the process.
>>

Uli
Sun, Mar 16 2014 4:10 PMPermanent Link

Raul

Team Elevate Team Elevate

On 3/16/2014 3:00 PM, Bruno Larochelle wrote:
> http://vcmac.edm.ab.ec.gc.ca:8086/index.html
> or
> http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html

Definitely unable to connect to those. Either firewall blocking i,
server listening on 8086 or server is not routing responses back.

EWB Server settings look right to me.

Generally you do not need to work against an internet facing production
server. Do the development on your dev machine ewb server but make sure
you use relative URLs in your code. Specifically for loading TDataSets
you can set the baseURL to something like this :

Database.baseURL := window.location.protocol + '//'+
window.location.host + '<your url>';

and for TServerRequests you can just modify the URL direct

myServerERquest.URL := window.location.protocol + '//'+ +
window.location.host+'<your url>';

At deployment time you host the EWB app from same server so if EWB app
can load you know the server is online ok and sonce you use relative
URLs no code changes are needed.

Datasets still need be to configured but that's easy to test as well
using the query as per prev posts.

Raul
Sun, Mar 16 2014 4:11 PMPermanent Link

Raul

Team Elevate Team Elevate

On 3/16/2014 4:10 PM, Raul wrote:
> On 3/16/2014 3:00 PM, Bruno Larochelle wrote:
>> http://vcmac.edm.ab.ec.gc.ca:8086/index.html
>> or
>> http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html
>
> Definitely unable to connect to those. Either firewall blocking i,
> server listening on 8086 or server is not routing responses back.

Sorry - meant "either fierall blocking it, server not listening on 8086
or server is not routing responses back"

Raul
Mon, Mar 17 2014 12:04 AMPermanent Link

Bruno Larochelle

Thank you Uli and Raul for your assistance/comments/tips - very helpful.

I've yet to find my blockage, but i'm now confident that it is indeed a firewall or routing issue, and I will be able to solve it. I'll advise when that is the case, to put some closure on it!

regards.. Bruno


Raul wrote:

On 3/16/2014 4:10 PM, Raul wrote:
> On 3/16/2014 3:00 PM, Bruno Larochelle wrote:
>> http://vcmac.edm.ab.ec.gc.ca:8086/index.html
>> or
>> http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html
>
> Definitely unable to connect to those. Either firewall blocking i,
> server listening on 8086 or server is not routing responses back.

Sorry - meant "either fierall blocking it, server not listening on 8086
or server is not routing responses back"

Raul
Wed, Mar 19 2014 11:42 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Bruno,

<< Server : I am using the EWB web server provided, and have installed and
configured that on to my external machine. It is hooked up to the dataset
which I call 'testdata' and I can see that the connection is fine and I can
see my data on the 'preview' tab. I have configured and registered the
server with the EWB IDE, and selected it as the web server to use (instead
of the default local server). >>

So, just to confirm: you configured a dataset called 'testdata' in the EWB
Web Server configuration dialog, correct ?

<< Web app : this is where I'm a little confused, particularly in the
'connection properties' of the 'Editing dataset' form for my 'testdata'. Do
I set this as a 'local' dataset, or a 'remote' dataset? If it is 'local', do
I specify the settings local to the server? If it is 'remote'.. do I simply
provide the hostname and the databasename? I have yet been able to 'preview'
the data in the dataset configuration.. can't find the table etc etc.. I'm a
tad confused here, as you can no doubt tell, would love a hint or two from
those who have been down this path. >>

Datasets are *always* configured relative to the location of the EWB Web
Server.  IOW, whatever machine is running the EWB Web Server is the
perspective from which all paths, IP addresses, etc. will be resolved.  As
to whether you use local or remote for the dataset, that is completely up to
you and your database configuration (I assume that you're using DBISAM).  If
you're using the DBISAM Database Server, then you'll want to use a remote
connection for the dataset definition.  If the DBISAM database is on the
same machine as the EWB Web Server, then you can get away with using a
direct local connection.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Sun, Mar 23 2014 2:46 PMPermanent Link

Bruno Larochelle

thank you Uli, Raul and Tim for your kind assistance and expertise

i have it working now, my problem was a firewall issue of which i had no control - went to another server to get this resolved

.. off topic ..

in the process, i've learned more on how this all works, and i'm now set to take over the world! sort of have the same feeling i had with Delphi 1 in 1995 .. many new open doors!

regards.. Bruno


"Tim Young [Elevate Software]" wrote:

Bruno,
Image